Guest User

Untitled

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