If the
ResultSet object has data, the catalogId value is already defined in
the database, therefore, the catalogId field value is not valid. The
business logic to define a valid Catalog Id may be customized. The
Catalog Id input may be matched to a pattern using regular expressions
API available in the java.util.regex package. We have used the
business logic that if a catalog id is not defined in the database it is valid.
If a catalog entry is already defined for the catalogId value include the
field values of the different fields in the input form in the XML DOM
object. The XML DOM object is required to have a root element. In the
example application, the XML DOM object has a
element that specifies the validity of the Catalog Id field value.
if (rs.next()) {
out.println(???
??? + ???false??? +
?????? +
rs.getString(2) + ?????? + ?????? +
rs.getString(3) + ?????? + ?????? +
rs.getString(4) + ?????? + ?????? +<br>rs.getString(5) + ?????? + ?????? +
rs.getString(6) + ?????? + ??????);
} else {
out.println(???
true???);
}
If the catalogId field value is not defined in the database, a catalog
entry may be added for the catalogId value by obtaining a JDBC
connection to the database, and adding a catalog entry with an SQL
INSERT statement.
Pages:
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52