Advertisement
Guest User

Untitled

a guest
Aug 11th, 2016
66
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.14 KB | None | 0 0
  1. import java.sql.Connection;
  2. import java.sql.DriverManager;
  3. import java.sql.PreparedStatement;
  4. import java.sql.ResultSet;
  5. import java.sql.SQLException;
  6. import java.sql.Statement;
  7.  
  8. public String addEmployee(String name, String department, int experience){
  9.  
  10.  
  11.  
  12. Connection connector = null;
  13. PreparedStatement stmt = null;
  14.  
  15. try {
  16.  
  17. Class.forName("com.mysql.jdbc.Driver");
  18. // Load a connection to my DB
  19. String url = "jdbc:mysql://localhost:3306/myjobsite";
  20. connector = DriverManager.getConnection(url, "golden", "password");
  21. String sql="INSERT INTO employees(name,department,experience) values(?,?,?)";
  22. stmt = connector.prepareStatement(sql);
  23. stmt.setString(1, name);
  24. stmt.setString(2, department);
  25. stmt.setInt(3, experience);
  26. stmt.execute(); //run sql
  27.  
  28.  
  29. } catch (SQLException e) {
  30. // TODO Auto-generated catch block
  31. return "Connection Failure";
  32.  
  33. } catch (ClassNotFoundException e) {
  34. // TODO Auto-generated catch block
  35. e.printStackTrace();
  36. }
  37.  
  38. return "Executed sql";
  39.  
  40.  
  41. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement