Guest User

Untitled

a guest
Feb 4th, 2018
72
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.73 KB | None | 0 0
  1. try {
  2. connect= DriverManager.getConnection("jdbc:mysql://localhost:3306/stocks","root","");
  3. st = connect.createStatement();
  4. System.out.println("Inserting Data into DataBase");
  5. String query = "INSERT INTO stocks('hyderabad','bangalore','noida','ncr')VALUES(?,?,?,?)";
  6. PreparedStatement statement= (PreparedStatement) connect.prepareStatement(query);
  7. System.out.println("Inserting");
  8. statement.setInt(1, hyderabad);
  9. statement.setInt(2, bangalore);
  10. statement.setInt(3,noida);
  11. statement.setInt(4, ncr);
  12. System.out.println("Data inserted");
  13. statement.executeUpdate();
  14. System.out.println("Closing");
  15. //statement.close();
  16. st.close();
  17. connect.close();
  18. System.out.println("Works:");
  19. }
Add Comment
Please, Sign In to add comment