Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- String user=new String(tf1.getText());
- String pass=new String(pf1.getPassword());
- String mb=new String(tf2.getText());
- String email=new String(tf3.getText());
- String query="INSERT into user_info (username,password,email_id,mobile number) VALUES('"+user+"','"+pass+"','"+email+"','"+mb+"')";
- try {
- Connection myConn=DriverManager.getConnection("jdbc:mysql://localhost:3306/javaproject","root","noor1032");
- System.out.println("databse connected");
- PreparedStatement myStat=myConn.prepareStatement(query);
- System.out.println("statement prepapred");
- myStat.setString(1, user);
- myStat.setString(2, pass);
- myStat.setString(3, email);
- myStat.setString(4, mb);
- myStat.executeUpdate();
- System.out.println("query executed");
- myConn.close();
- JOptionPane.showMessageDialog(null, "saved");
- }
- catch(Exception f)
- {
- System.err.println("Got an exception!");
- System.err.println(f.getMessage());
- }
- myStat.setString(1, user);
- myStat.setString(2, pass);
- myStat.setString(3, email);
- myStat.setString(4, mb);
- String query="INSERT into user_info (username,password,email_id,mobile number) VALUES(?,?,?,?)";
Add Comment
Please, Sign In to add comment