Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- try {
- connect= DriverManager.getConnection("jdbc:mysql://localhost:3306/stocks","root","");
- st = connect.createStatement();
- System.out.println("Inserting Data into DataBase");
- String query = "INSERT INTO stocks('hyderabad','bangalore','noida','ncr')VALUES(?,?,?,?)";
- PreparedStatement statement= (PreparedStatement) connect.prepareStatement(query);
- System.out.println("Inserting");
- statement.setInt(1, hyderabad);
- statement.setInt(2, bangalore);
- statement.setInt(3,noida);
- statement.setInt(4, ncr);
- System.out.println("Data inserted");
- statement.executeUpdate();
- System.out.println("Closing");
- //statement.close();
- st.close();
- connect.close();
- System.out.println("Works:");
Add Comment
Please, Sign In to add comment