Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public class reg extends HttpServlet {
- static String name;
- static String password;
- static String age;
- static String login;
- Connection connection;
- PreparedStatement pst;
- static String pass = "1234";
- static String root = "root";
- static String connectionURL="jdbc:mysql://localhost:3306/mysql";
- @Override
- protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
- name=req.getParameter("name");
- password=req.getParameter("password");
- age=req.getParameter("age");
- login=req.getParameter("login");
- System.out.println(name);
- System.out.println(age);
- System.out.println(login);
- System.out.println(password);
- try{
- //Class.forName("com.mysql.jdbc.Driver");
- DriverManager.registerDriver(new com.mysql.jdbc.Driver());
- connection= DriverManager.getConnection(connectionURL, root,pass);
- pst=connection.prepareStatement("INSERT INTO users (NAME, AGE, LOGIN, PASSWORD) VALUES (?,?,?,?)");
- pst.setString(1, name);
- pst.setString(2,age);
- pst.setString(3,login);
- pst.setString(4,password);
- pst.execute();
- }
- catch (Exception e){e.printStackTrace();System.out.println("Ooops!");}
- }
Add Comment
Please, Sign In to add comment