Advertisement
Guest User

Untitled

a guest
May 3rd, 2018
107
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 1.20 KB | None | 0 0
  1. Connection connection=null;
  2.          try{
  3.              connection=DriverManager.getConnection("jdbc:mysql://localhost:3306/emenu?zeroDateTimeBehavior=convertToNull","root","");        
  4.             if(connection!=null){
  5.                 System.out.printf("Database Connected");
  6.             }
  7.             else
  8.             {
  9.                 System.out.printf("Database NOT Connected");
  10.             }
  11.             String name=username_field.getText();
  12.             String pass=password_field.getText();
  13.             String email=email_field.getText();
  14.             String contact=contact_field.getText();  
  15.            // String query="UPDATE emenu_user SET username=?,password=?,email=?,contact=?";
  16.             String query="INSERT INTO emenu_user (username,password,email,contact) VALUES (?,?,?,?)";    
  17.             PreparedStatement statement=connection.prepareStatement(query);
  18.             statement.setString(1,name);
  19.             statement.setString(2,pass);
  20.             statement.setString(3,email);
  21.             statement.setString(4,contact);  
  22.             statement.executeUpdate();
  23.      
  24.         } catch(SQLException e){
  25.                 JOptionPane.showMessageDialog(null,"SQL ERROR");
  26.        }
  27.     }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement