Parikshit86

error

Aug 11th, 2017
52
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 4.28 KB | None | 0 0
  1. package controller;
  2.  
  3. import java.io.IOException;
  4. import javax.servlet.ServletException;
  5. import javax.servlet.http.HttpServlet;
  6. import javax.servlet.http.HttpServletRequest;
  7. import javax.servlet.http.HttpServletResponse;
  8.  
  9. import java.io.PrintWriter;
  10. import java.sql.Connection;
  11. import java.sql.DriverManager;
  12. import java.sql.ResultSet;
  13. import java.sql.SQLException;
  14. import java.sql.Statement;
  15.  
  16.  
  17.  
  18. /**
  19.  * Servlet implementation class Password
  20.  */
  21. public class Password extends HttpServlet {
  22.     private static final long serialVersionUID = 1L;
  23.        
  24.     /**
  25.      * @see HttpServlet#HttpServlet()
  26.      */
  27.     public Password() {
  28.         super();
  29.         // TODO Auto-generated constructor stub
  30.     }
  31.  
  32.     protected void processRequest(HttpServletRequest request, HttpServletResponse response)
  33.             throws ServletException, IOException
  34. {
  35.         response.setContentType("text/html;charset=UTF-8");
  36.         try (PrintWriter out = response.getWriter()) {
  37.             /* TODO output your page here. You may use following sample code. */
  38.            String voter_card_number = request.getParameter("voter_card_number");
  39.            
  40.            try {
  41.                 Class.forName("com.mysql.jdbc.Driver");
  42.                 System.out.println("Driver laoded");      
  43.          
  44.           }
  45.           catch(Exception e)
  46.             {
  47.                 System.out.println("Exception" +e.getMessage());
  48.             }
  49.           try
  50.           {
  51.            
  52.             Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/voating","root","manager");
  53.            
  54.                  Statement stmt=con.createStatement();
  55.                
  56.                 //stmt.executeUpdate("insert into temp_voter_card_number(voter_card_number)values('"+voter_card_number+"')");
  57.                // out.println("grt");
  58.                ResultSet rs1= stmt.executeQuery("select voter_card_number from temp_voter_card_number where voter_card_number = '"+voter_card_number+"'");
  59.                // out.println("grt");
  60.                if(rs1.next()){
  61.                  response.sendRedirect("votercheck.jsp?name="+voter_card_number);
  62.                out.println("You already voted........"+rs1.getString("voter_card_number"));
  63.                }else{
  64.                
  65.                 ResultSet rs =   stmt.executeQuery("select uid,contact from voter_register where voter_card_number = '"+voter_card_number+"'");
  66.                //out.println(voter_card_number);
  67.                 if(rs.next()){
  68.                     String contact = rs.getString("contact");
  69.                     response.sendRedirect("password.jsp?con="+contact);
  70.                     out.println(contact);
  71.                 }else{
  72.                     out.println("Please enter valid card number");
  73.                 }
  74.                }
  75.             }  catch(SQLException e )
  76.             {
  77.                
  78.                 System.out.println("SQLException" +e.getMessage());
  79.  
  80.            
  81.            }
  82.            
  83.            
  84.            
  85.          
  86.         }
  87.     }
  88.  
  89.     // <editor-fold defaultstate="collapsed" desc="HttpServlet methods. Click on the + sign on the left to edit the code.">
  90.     /**
  91.      * Handles the HTTP <code>GET</code> method.
  92.      *
  93.      * @param request servlet request
  94.      * @param response servlet response
  95.      * @throws ServletException if a servlet-specific error occurs
  96.      * @throws IOException if an I/O error occurs
  97.      */
  98.     @Override
  99.     protected void doGet(HttpServletRequest request, HttpServletResponse response)
  100.             throws ServletException, IOException {
  101.         processRequest(request, response);
  102.     }
  103.  
  104.     /**
  105.      * Handles the HTTP <code>POST</code> method.
  106.      *
  107.      * @param request servlet request
  108.      * @param response servlet response
  109.      * @throws ServletException if a servlet-specific error occurs
  110.      * @throws IOException if an I/O error occurs
  111.      */
  112.     @Override
  113.     protected void doPost(HttpServletRequest request, HttpServletResponse response)
  114.             throws ServletException, IOException {
  115.         processRequest(request, response);
  116.     }
  117.  
  118.     /**
  119.      * Returns a short description of the servlet.
  120.      *
  121.      * @return a String containing servlet description
  122.      */
  123.     @Override
  124.     public String getServletInfo() {
  125.         return "Short description";
  126.     }// </editor-fold>
  127.  
  128. }
Add Comment
Please, Sign In to add comment