Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Syntax error on token-"driver",VariableDeclaratorId expected after this token.
- package Servlets;
- import java.io.IOException;
- import java.sql.*;
- import javax.servlet.ServletException;
- import javax.servlet.http.HttpServlet;
- import javax.servlet.http.HttpServletRequest;
- import javax.servlet.http.HttpServletResponse;
- public class LoginServlet extends HttpServlet
- {
- private static final long serialVersionUID = 1L;
- public LoginServlet()
- {
- super();
- }
- Connection con = null;
- String url = "jdbc:mysql://localhost:3306/";
- String db = "abc";
- String driver = "com.mysql.jdbc.Driver";
- Class.forName(driver);
- protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException
- {
- }
- protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException
- {
- String username= request.getParameter("username");
- String password= request.getParameter("password");
- con = DriverManager.getConnection("url+db","root","root");
- Statement st = con.createStatement();
- int val = st.executeUpdate("INSERT login values("+username+","+password+")");
- System.out.println("1 row affected");
- response.sendRedirect("login.jsp");
- }
- }
- Class.forName("com.mysql.jdbc.Driver").newInstance();
- con = DriverManager.getConnection("url+db","root","root");
- Connection con = null;
- try {
- if(con != null)
- con.close();
- } catch(SQLException e) {}
- package Servlets;
- import java.io.IOException;
- import java.sql.*;
- import javax.servlet.ServletException;
- import javax.servlet.http.HttpServlet;
- import javax.servlet.http.HttpServletRequest;
- import javax.servlet.http.HttpServletResponse;
- public class LoginServlet extends HttpServlet
- {
- private static final long serialVersionUID = 1L;
- public LoginServlet()
- {
- super();
- }
- String url = "jdbc:mysql://localhost:3306/";
- String db = "abc";
- String driver = "com.mysql.jdbc.Driver";
- protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException
- {
- }
- protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException
- {
- try{
- Connection con = null;
- String username= request.getParameter("username");
- String password= request.getParameter("password");
- Class.forName(driver).newInstance();
- con = DriverManager.getConnection("url+db","root","root");
- Statement st = con.createStatement();
- int val = st.executeUpdate("INSERT login values("+username+","+password+")");
- System.out.println("1 row affected");
- response.sendRedirect("login.jsp");
- }catch(SQLException e){}
- finally{
- try {
- if(con != null)
- con.close();con=null;
- } catch(SQLException e) {}
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement