Advertisement
Guest User

Untitled

a guest
Dec 13th, 2017
131
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.56 KB | None | 0 0
  1. public void addStudent(String id, String firstName, String lastName, String email, String pass, PrintWriter out){
  2. //this.Connect(out);
  3. //name = name;
  4. PreparedStatement addStudent;
  5. out.println("Test addStudenet");
  6.  
  7. //String strSelect2 = ("insert into userAccount(firstName, lastName, email, pass) values('"+firstName+"' , '"+lastName+"' ,'"+email+"' , '"+pass+"');");
  8.  
  9. // System.out.println("The SQL query is: " + strSelect2);
  10. // out. println("The SQL query is: " + strSelect2);
  11.  
  12. System.out.println();
  13. out.println();
  14.  
  15. try {
  16. String ins = "insert into useraccount (firstName,lastName,email,pass) values(?,?,?,?)";
  17.  
  18. addStudent = conn.prepareStatement(ins);
  19.  
  20.  
  21. addStudent.setString(1,firstName);
  22. addStudent.setString(2,lastName);
  23. addStudent.setString(3,email);
  24. addStudent.setString(4,pass);
  25.  
  26. out.println(addStudent);
  27. out.println("Er det her det er feil?");
  28. addStudent.executeUpdate();
  29. conn.commit();
  30. conn.close();
  31.  
  32. out.println("Lagt til " +firstName + " " +lastName+ " " +email+ " " +pass+ "");
  33.  
  34.  
  35.  
  36. } // end try
  37. catch (Exception ex) {
  38. System.out.println(ex.getCause());
  39. System.out.println("error");
  40. out.println("Ikke hentet fra DB " +ex);
  41. }
  42. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement