Guest User

Untitled

a guest
Apr 10th, 2017
26
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.16 KB | None | 0 0
  1. import java.sql.Connection;
  2. import java.sql.DriverManager;
  3. import java.sql.PreparedStatement;
  4. import java.sql.Statement;
  5. import java.util.Scanner;
  6.  
  7.  
  8. public class Jdbc2 {
  9. static void getconnection()
  10. {
  11. try {
  12. Class.forName("oracle.jdbc.driver.oracleDriver");
  13. Connection conn=DriverManager.getConnection
  14. ("jdbc:oracle:thin:@localhost:1521:xe","system","jasleen25");
  15. Statement st=conn.createStatement();
  16. conn.setAutoCommit(true);
  17. String sql = "CREATE TABLE REGSTRIATION"+"(id INTEGER." +"first VARCHAR(10), " +"last VARCHAR(10)," + "age INTEGER)";
  18. st.executeUpdate(sql);
  19. PreparedStatement ps=conn.prepareStatement("insert into regstriation values(?,?,?,?)");
  20. for(int i=0;i<3:i++)
  21. {
  22. System.out.println("enter table data id,firstname,lastname,age");
  23. Scanner s1=new scanner(System.in);
  24. int id=s1.nextInt();
  25. String first=s1.next();
  26. String last=s1.next();
  27. int age=s1.nextInt();
  28. ps.setInt(id, id);
  29. ps.setString(2, first);
  30. ps.setString(2, last);
  31. ps.setInt(4 , age);
  32. ps.
Add Comment
Please, Sign In to add comment