Guest User

Untitled

a guest
Sep 21st, 2017
24
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.79 KB | None | 0 0
  1. import java.sql.*;
  2. class adi{
  3. public static void main(String args[]){
  4. try{
  5. Class.forName("com.mysql.jdbc.Driver");
  6. Connection c=DriverManager.getConnection("jdbc:mysql://localhost:3306/adi","root","12345");
  7. Statement s=c.createStatement();
  8. s.execute("insert into tab values('two',2,9)");
  9. s.execute("insert into tab values('three',3,8)");
  10. ResultSet rs=s.executeQuery("select * from tab");
  11. while(rs.next()){
  12. System.out.println(rs.getString(1)+" "+rs.getString(2)+" "+rs.getString(3));
  13. }
  14. s.executeUpdate("update tab set marks=3 where roll=3");
  15. rs=s.executeQuery("select * from tab");
  16. while(rs.next()){
  17. System.out.println(rs.getString(1)+" "+rs.getString(2)+" "+rs.getString(3));
  18. }
  19. }
  20. catch(Exception e)
  21. {
  22. System.out.println(e);
  23. }
  24. }
  25. }
Add Comment
Please, Sign In to add comment