createStatement(ResultSet.TYPE_SCROLL_IN
SENSITIVE,
ResultSet.CONCUR_READ_ONLY);
String catalogID = (String)inputText1.getValue();
String query =
7.6 Processing an Ajax Request 153
???SELECT * from Catalog WHERE CATALOGID=??? + ?????™??? +
catalogID +
?????™???;
rs = stmt.executeQuery(query);
if (rs.next()) {
inputText2.setValue(rs.getString(2));
inputText3.setValue(rs.getString(3));
inputText4.setValue(rs.getString(4));
inputText5.setValue(rs.getString(5));
inputText6.setValue(rs.getString(6));
outputText1.setValue(new String(???Catalog Id is not
Valid???));
commandButton1.setDisabled(true);
} else {
inputText2.setValue(new String());
inputText3.setValue(new String());
inputText4.setValue(new String());
inputText5.setValue(new String());
inputText6.setValue(new String());
outputText1.setValue(new String(???Catalog Id is
Valid???));
commandButton1.setDisabled(false);
}
} catch (SQLException e) {
System.out.println(e.getMessage());
} catch (javax.naming.NamingException e) {
System.out.println(e.getMessage());
}
return null;
}
public String commandButton_action() {
try {
//Obtain Connection
InitialContext initialContext = new
InitialContext();
javax.sql.DataSource ds =
(javax.sql.DataSource)initialContext.lookup(???java:com
p/env/jdbc/Ajax4JSFConnectionDS???);
java.sql.Connection conn =
ds.getConnection();
String catalogId = (String)inputText1.getValue();
String journal = (String)inputText2.
Pages:
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144