Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Connection connection=null;
- try{
- connection=DriverManager.getConnection("jdbc:mysql://localhost:3306/emenu?zeroDateTimeBehavior=convertToNull","root","");
- if(connection!=null){
- System.out.printf("Database Connected");
- }
- else
- {
- System.out.printf("Database NOT Connected");
- }
- String name=username_field.getText();
- String pass=password_field.getText();
- String email=email_field.getText();
- String contact=contact_field.getText();
- // String query="UPDATE emenu_user SET username=?,password=?,email=?,contact=?";
- String query="INSERT INTO emenu_user (username,password,email,contact) VALUES (?,?,?,?)";
- PreparedStatement statement=connection.prepareStatement(query);
- statement.setString(1,name);
- statement.setString(2,pass);
- statement.setString(3,email);
- statement.setString(4,contact);
- statement.executeUpdate();
- } catch(SQLException e){
- JOptionPane.showMessageDialog(null,"SQL ERROR");
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement