XML : How to parse XML generated by a servlet

this is my simple Java servlet which generate XML code retreiving it from a simple database:

  import java.io.IOException;  import javax.servlet.ServletException;  import javax.servlet.annotation.WebServlet;  import javax.servlet.http.HttpServlet;  import javax.servlet.http.HttpServletRequest;  import javax.servlet.http.HttpServletResponse;  import java.sql.*;  import java.io.*    @WebServlet("/XML")  public class XML extends HttpServlet {     private static final long serialVersionUID = 1L;        public XML() {          super();      }        protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {  }    /**   * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)   */  protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {      Connection connection;      Statement statement;        response.setContentType("application/xml");      PrintWriter printwriter = response.getWriter();        printwriter.println("<?xml version=\"1.0\"?>");      printwriter.println("<document>");        try {          Class.forName("com.mysql.jdbc.Driver").newInstance();          connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/AppDB", "***", "****");            statement = connection.createStatement();            String SQL = "SELECT first_name, last_name FROM contacts";          ResultSet resultset = statement.executeQuery(SQL);            while(resultset.next()) {              printwriter.println("<first> " +  resultset.getString("first_name") + " </first>");              printwriter.println("<last> " +  resultset.getString("last_name") + " </last>");          }          resultset.close();          statement.close();          connection.close();      }      catch (Exception e) {      }      printwriter.println("</document>");      printwriter.close();  }    }    

Now, I want to parse it on client-side for displaying data but I don't know how to do that. I have tried to use a JSP file with the SAX parser but when the server give me a error when I put the following Servlet URL:

  Document doc = docBuilder.parse("http://localhost:8080/Example/XML");    

Could anyone please help me giving me some advice to solve the problem? And could anyone know a possible alternative way to do the same thing? What about JQuery or Ajax? (Even if I have just read a few thing about it, but I don't know them very well)

No comments:

Post a Comment