Copy the FormValidationServlet, which is
2.4 Processing an Ajax Request on the Server Side 33
listed below, to FormValidationServlet.java file in the Ajax
project.
package ajax;
import java.io.*;
import java.sql.*;
import javax.naming.InitialContext;
import javax.servlet.*;
import javax.servlet.http.*;
public class FormValidationServlet extends
HttpServlet {
public void doGet(HttpServletRequest request,
HttpServletResponse response)
throws ServletException, IOException {
try {
//Obtain value of Catalog Id field to ve
validated.
String catalogId =
request.getParameter(???catalogId???);
//Obtain Connection
InitialContext initialContext = new
InitialContext();
javax.sql.DataSource ds = (javax.sql.DataSource)
initialContext.lookup(
???java:comp/env/jdbc/AjaxConnectionDS???);
java.sql.Connection conn = ds.getConnection();
//Obtain result set
Statement stmt = conn.createStatement();
String query = ???SELECT * from OE.Catalog WHERE
catalogId=??? + ?????™??? +catalogId + ?????™???;
ResultSet rs = stmt.executeQuery(query);
// set headers before accessing the
Writer
response.setContentType(???text/xml???);
response.setHeader(???Cache-Control???, ???no-cache???);
PrintWriter out = response.getWriter();
// then write the response
//If result set is empty set valid element to
true
if (rs.next()) {
out.println(???
??? +
???false??? + ?????? +
rs.
Pages:
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53