Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import java.sql.Connection;
- import java.sql.DriverManager;
- import java.sql.PreparedStatement;
- import java.sql.Statement;
- import java.util.Scanner;
- public class Jdbc2 {
- static void getconnection()
- {
- try {
- Class.forName("oracle.jdbc.driver.oracleDriver");
- Connection conn=DriverManager.getConnection
- ("jdbc:oracle:thin:@localhost:1521:xe","system","jasleen25");
- Statement st=conn.createStatement();
- conn.setAutoCommit(true);
- String sql = "CREATE TABLE REGSTRIATION"+"(id INTEGER." +"first VARCHAR(10), " +"last VARCHAR(10)," + "age INTEGER)";
- st.executeUpdate(sql);
- PreparedStatement ps=conn.prepareStatement("insert into regstriation values(?,?,?,?)");
- for(int i=0;i<3:i++)
- {
- System.out.println("enter table data id,firstname,lastname,age");
- Scanner s1=new scanner(System.in);
- int id=s1.nextInt();
- String first=s1.next();
- String last=s1.next();
- int age=s1.nextInt();
- ps.setInt(id, id);
- ps.setString(2, first);
- ps.setString(2, last);
- ps.setInt(4 , age);
- ps.
Add Comment
Please, Sign In to add comment