Servlets

when i am compiling the follow program it gives the error.so help me to resolve the problem

import java.io.*;
import javax.Servlet.*;
import javax.Servlet.http.*;
import java.sql.*;
import java.sql.connection .*;

public class LoginServlet extends HttpServlet
{

  public void Service(HttpServletRequest req,HttpServletResponse res)throws ServletException,IOException
{
      String FirstName=req.getParameter("FirstName");
      String LastName=req.getParameter("LastName");
      String Email=req.getParameter("Email");
      String password=req.getParameter("Password");
      String ConformPassword=req.getparameter("ConformPassword");
      int Dateofbirth=req.getParameter("Dateofbirth");
      int Age=req.getparameter("Age");
      String Gender=req.getParameter("Gender");
      String Address=req.getParameter("Address");
      String Country=req.getParameter("Country");
      String State=req.getParameter("State");
      String City=req.getParameter("City");
      int Telephone=req.getParameter("Telephone");
      int Mobile=req.getParameter("Mobile");
      String Howdidyouhear=req.getParameter("Howdidyouhear");
      PrintWriter out=res.geWriter();
      Connection con=null;
      PreparedStatement pstm=null;
      Resultset  rs=null;


           try{
                 Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver ");
                 String connectionUrl = ("jdbc:sqlserver://localhost:1433;database=sree;integratedSecurity=true");
                 Connection con = DriverManager.getConnection(connectionUrl);
                 datasource.setServerName(PRATAP);
                 datasource.setDatabaseName(sree);


                          pstm=con.PrepareStatement("insert into stureg(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)"); 
                          pstm.setString(1,FirstName);
                          pstm.setString(2,LastName);
                          pstm.setString(3,Email);
                          pstm.setString(4,Password);
                          pstm.setString(5,ConformPassword);
                          pstm.setInt(6,Dateofbirth);
                          pstm.setInt(7,Age);
                          pstm.setString(8,Gender);
                          pstm.setString(9,Address);
                          pstm.setString(10,Country);
                          pstm.setString(11,State);
                          pstm.setString(12,City);
                          pstm.setInt(13,Telephone);
                          pstm.setInt(14,Mobile);
                          pstm.setString(15,Howdidyouhear);
                          int i=pstm.executeUpdate();
              }

                    if(i==1)
                            {
                               System.out.print("insert");
                             }                      
                               else
                             {

                               System.out.print("not insert");
                              }



                   catch(Exception e);
                       {
                          e.pstm();
                       }
}
      }



   }
 the errors are as follow:

LoginServlet.java:33: 'try' without 'catch' or 'finally'
           try{
           ^
LoginServlet.java:72: 'catch' without 'try'
                   catch(Exception e);
                   ^
LoginServlet.java:72: ';' expected
                   catch(Exception e);
                                    ^
LoginServlet.java:77: class, interface, or enum expected
      }
      ^
4 errors
so help me to solve this problem.is it correct program to insert and update the database table record

May 3, 2011 at 12:27 PM

We have modified your code.

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

public class InsertServlet extends HttpServlet{ 
    public void doPost(HttpServletRequest req,HttpServletResponse res) throws ServletException,IOException {
        res.setContentType("text/html");
        int count=0;
        PrintWriter out = res.getWriter();
    String FirstName=req.getParameter("FirstName");
    String LastName=req.getParameter("LastName");
    String Email=req.getParameter("Email"); 
    String Password=req.getParameter("Password"); 
    String ConformPassword=req.getParameter("ConformPassword");
    String Dateofbirth=req.getParameter("Dateofbirth");
    int Age=Integer.parseInt(req.getParameter("Age")); 
    String Gender=req.getParameter("Gender");
    String Address=req.getParameter("Address"); 
    String Country=req.getParameter("Country"); 
    String State=req.getParameter("State");
    String City=req.getParameter("City"); 
    int Telephone=Integer.parseInt(req.getParameter("Telephone"));
    int Mobile=Integer.parseInt(req.getParameter("Mobile"));
    String Howdidyouhear=req.getParameter("Howdidyouhear");

    PreparedStatement pstm=null; 

      try{
             Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver ");
             String connectionUrl = ("jdbc:sqlserver://localhost:1433;database=sree;integratedSecurity=true");
             Connection con = DriverManager.getConnection(connectionUrl);
                      pstm=con.prepareStatement("insert into stureg(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)"); 
                      pstm.setString(1,FirstName);
                      pstm.setString(2,LastName);
                      pstm.setString(3,Email);
                      pstm.setString(4,Password);
                      pstm.setString(5,ConformPassword);
                      pstm.setString(6,Dateofbirth);
                      pstm.setInt(7,Age);
                      pstm.setString(8,Gender);
                      pstm.setString(9,Address);
                      pstm.setString(10,Country);
                      pstm.setString(11,State);
                      pstm.setString(12,City);
                      pstm.setInt(13,Telephone);
                      pstm.setInt(14,Mobile);
                      pstm.setString(15,Howdidyouhear);
                      int i=pstm.executeUpdate();
                         if(i==1){
                           System.out.print("insert");
                         }                      
                         else{
                           System.out.print("not insert");
                          }
                       }
                       catch(Exception e){
                       e.getMessage();
                       }
                    }
                }

The above code insert the values to database.