Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import java.sql.Connection;
- import java.sql.DriverManager;
- import java.sql.PreparedStatement;
- import java.sql.ResultSet;
- import java.sql.SQLException;
- import java.sql.Statement;
- public String addEmployee(String name, String department, int experience){
- Connection connector = null;
- PreparedStatement stmt = null;
- try {
- Class.forName("com.mysql.jdbc.Driver");
- // Load a connection to my DB
- String url = "jdbc:mysql://localhost:3306/myjobsite";
- connector = DriverManager.getConnection(url, "golden", "password");
- String sql="INSERT INTO employees(name,department,experience) values(?,?,?)";
- stmt = connector.prepareStatement(sql);
- stmt.setString(1, name);
- stmt.setString(2, department);
- stmt.setInt(3, experience);
- stmt.execute(); //run sql
- } catch (SQLException e) {
- // TODO Auto-generated catch block
- return "Connection Failure";
- } catch (ClassNotFoundException e) {
- // TODO Auto-generated catch block
- e.printStackTrace();
- }
- return "Executed sql";
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement