Guest User

Untitled

a guest
Apr 20th, 2016
26
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.81 KB | None | 0 0
  1. import java.util.*;
  2. import java.awt.event.*;
  3.  
  4. class student
  5. {
  6. public static void main(String k[])
  7. {
  8. Scanner sc = new Scanner(System.in);
  9. System.out.println("Enter name, roll no, cgpa");
  10. String name=sc.nextLine();
  11. int roll = sc.nextInt();
  12. double cgpa = sc.nextDouble();
  13. try
  14. {
  15. Class.forName("com.mysql.jdbc.Driver");
  16. Connection con= DriverManager.getConnection("jdbc:mysql:@localhost:3306","root","tiger");
  17. String name1=name.getText();
  18. int roll1 = Integer.parseInt(roll.getText());
  19. double cgpa1 = Double.parseDouble(cgpa.getText());
  20. PreparedStatement p = con.PrepareStatement("insert into k1404 values(? ,?, ? )");
  21. p.setString(1,name1);
  22. p.setInt(2,roll1);
  23. p.setString(3,cgpa1);
  24. int i=p.executeUpdate();
  25.  
  26.  
  27. }
  28. catch(Exception e){System.out.print(e)}
  29. }
  30. }
Add Comment
Please, Sign In to add comment