Advertisement
patrykszczur

Untitled

May 31st, 2016
132
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.88 KB | None | 0 0
  1. public void insertUser (String Name , String Surname , String Password , int Sex , String Mail , String Address , int Phone_Number ) throws Exception {
  2.  
  3. Connection conn = (Connection) getConnection() ;
  4. try {
  5. PreparedStatement insertStatement = (PreparedStatement) conn.prepareStatement("INSERT INTO user (Name,Surname,Password,Sex,Mail,Address,Phone_Number) VALUES (?,?,?,?,?,?,?)");
  6. insertStatement.setString(1, Name);
  7. insertStatement.setString(2, Surname );
  8. insertStatement.setString(3, Password);
  9. insertStatement.setInt(4, Sex);
  10. insertStatement.setString(5, Mail);
  11. insertStatement.setString(6 ,Address);
  12. insertStatement.setInt(7 ,Phone_Number);
  13. insertStatement.execute();
  14. insertStatement.close();
  15. conn.close() ;
  16.  
  17. System.out.println("Success");
  18.  
  19. } catch (SQLException e) {
  20.  
  21. System.out.println(e.getMessage());
  22.  
  23. }
  24. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement