Advertisement
Guest User

Untitled

a guest
May 12th, 2013
275
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.83 KB | None | 0 0
  1. Syntax error on token-"driver",VariableDeclaratorId expected after this token.
  2.  
  3. package Servlets;
  4.  
  5. import java.io.IOException;
  6. import java.sql.*;
  7.  
  8. import javax.servlet.ServletException;
  9.  
  10. import javax.servlet.http.HttpServlet;
  11.  
  12. import javax.servlet.http.HttpServletRequest;
  13.  
  14. import javax.servlet.http.HttpServletResponse;
  15.  
  16. public class LoginServlet extends HttpServlet
  17. {
  18.  
  19. private static final long serialVersionUID = 1L;
  20.  
  21. public LoginServlet()
  22. {
  23. super();
  24. }
  25. Connection con = null;
  26.  
  27. String url = "jdbc:mysql://localhost:3306/";
  28.  
  29. String db = "abc";
  30.  
  31. String driver = "com.mysql.jdbc.Driver";
  32.  
  33. Class.forName(driver);
  34.  
  35.  
  36. protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException
  37. {
  38. }
  39. protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException
  40.  
  41. {
  42. String username= request.getParameter("username");
  43. String password= request.getParameter("password");
  44. con = DriverManager.getConnection("url+db","root","root");
  45. Statement st = con.createStatement();
  46. int val = st.executeUpdate("INSERT login values("+username+","+password+")");
  47. System.out.println("1 row affected");
  48.  
  49. response.sendRedirect("login.jsp");
  50.  
  51. }
  52.  
  53. }
  54.  
  55. Class.forName("com.mysql.jdbc.Driver").newInstance();
  56.  
  57. con = DriverManager.getConnection("url+db","root","root");
  58.  
  59. Connection con = null;
  60.  
  61. try {
  62. if(con != null)
  63. con.close();
  64. } catch(SQLException e) {}
  65.  
  66. package Servlets;
  67.  
  68. import java.io.IOException;
  69. import java.sql.*;
  70. import javax.servlet.ServletException;
  71. import javax.servlet.http.HttpServlet;
  72. import javax.servlet.http.HttpServletRequest;
  73. import javax.servlet.http.HttpServletResponse;
  74.  
  75. public class LoginServlet extends HttpServlet
  76. {
  77.  
  78. private static final long serialVersionUID = 1L;
  79.  
  80. public LoginServlet()
  81. {
  82. super();
  83. }
  84.  
  85. String url = "jdbc:mysql://localhost:3306/";
  86. String db = "abc";
  87. String driver = "com.mysql.jdbc.Driver";
  88.  
  89. protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException
  90. {
  91. }
  92. protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException
  93.  
  94. {
  95. try{
  96. Connection con = null;
  97. String username= request.getParameter("username");
  98. String password= request.getParameter("password");
  99. Class.forName(driver).newInstance();
  100. con = DriverManager.getConnection("url+db","root","root");
  101. Statement st = con.createStatement();
  102. int val = st.executeUpdate("INSERT login values("+username+","+password+")");
  103. System.out.println("1 row affected");
  104.  
  105. response.sendRedirect("login.jsp");
  106. }catch(SQLException e){}
  107. finally{
  108. try {
  109. if(con != null)
  110. con.close();con=null;
  111. } catch(SQLException e) {}
  112. }
  113.  
  114. }
  115. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement