solve this problem

I typed this program and compiled.The program is compiled but when i eneterd url in tomcat server. Its not giving error but only blank page is coming the text is not displaying and row is also inserted in table please tell me the solution for thid problem

import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;

public class DataInsertion extends HttpServlet{
  public void doGet(HttpServletRequest request, HttpServletResponse response)throws 
                               ServletException, IOException{ <br />
    response.setContentType("text/html");
    PrintWriter out = response.getWriter();
    String url = "jdbc:mysql://localhost/zulfiqar?user=root&amp;password=admin";
    Connection conn;
    ResultSet rs;
    try{
      Class.forName("org.gjt.mm.mysql.Driver");
      conn = DriverManager.getConnection(url);
      Statement statement = conn.createStatement();
      String query = "insert into emp_sal values('zulfiqar', 15000)";
      int i = statement.executeUpdate(query);
      if(i!=0){
        out.println("The record has been inserted");
      }
      else{
        out.println("Sorry! Failure");
      }
      rs = statement.executeQuery("select * from emp_sal");
      while(rs.next()){
        out.println("<p><table>" + rs.getString(1) + " " + rs.getInt(2) + "</p></table>");
      }
      rs.close();
      statement.close();
    }
    catch (Exception e){
      System.out.println(e);
    }
  }
}

XML File for this program
<?xml version="1.0" encoding="ISO-8859-1"?>
<!--<!DOCTYPE web-app
 PUBLIC "-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN"
 "http://java.sun.com/dtd/web-app_2_3.dtd"> -->

<web-app>
 <servlet>
  <servlet-name>Hello</servlet-name>
  <servlet-class>DataInsertion</servlet-class>
 </servlet>
 <servlet-mapping>
 <servlet-name>Hello</servlet-name>
 <url-pattern>/DataInsertion</url-pattern>
 </servlet-mapping>
</web-app>

January 21, 2011 at 12:33 PM

Hello Friend,

Here is our code. Check it.

import java.io.*;
import java.sql.*;
import javax.servlet.*; 
import javax.servlet.http.*;

public class DataInsertion extends HttpServlet{
    public void doGet(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException{

response.setContentType("text/html"); 
PrintWriter out = response.getWriter();
String url = "jdbc:mysql://localhost/test?user=root&password=root";
Connection conn; 
ResultSet rs; 
try{ 
    Class.forName("com.mysql.jdbc.Driver"); 
    conn = DriverManager.getConnection(url);
    Statement statement = conn.createStatement();
    String query = "insert into emp(EMP_NAME,SALARY) values('roseindia', 10000)";
    int i = statement.executeUpdate(query);
    if(i!=0){
        out.println("The record has been inserted<br>"); 
        } 
        else{
            out.println("Sorry! Failure");
            } 
            rs = statement.executeQuery("select * from emp"); 
            while(rs.next()){
                out.println(""+rs.getString("EMP_NAME") + " " + rs.getInt("SALARY") + "<br>"); 
                } 
                rs.close();
                statement.close();
                }
                catch (Exception e){
                    System.out.println(e); 
                    }
                    }
                    }

In web.xml:

     <servlet>
        <servlet-name>DataInsertion</servlet-name>
        <servlet-class>DataInsertion</servlet-class>
    </servlet>

     <servlet-mapping>
        <servlet-name>DataInsertion</servlet-name>
        <url-pattern>/DataInsertion</url-pattern>
    </servlet-mapping>