Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import java.sql.*;
- import java.io.*;
- class second
- {
- public static void main(String arg[])throws Exception
- {
- Class.forName("oracle.jdbc.driver.OracleDriver");
- System.out.println("driver loaded");
- Connection con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:XE","system","oracle");
- System.out.println("connection established");
- Statement st=con.createStatement();
- System.out.println("statement created");
- st.executeUpdate("create table cse(no number,name varchar)");
- System.out.println("table created");
- st.executeUpdate("insert into cse values(1,'kevin')");
- st.executeUpdate("insert into cse values(2,'john')");
- st.executeUpdate("insert into cse values(3,'alvin')");
- System.out.println("3 rows inserted");
- ResultSet rs=st.executeQuery("select *from cse");
- while(rs.next())
- {
- System.out.println(rs.getInt(1)+" "+rs.getString(2));
- }
- rs.close();
- st.close();
- con.close();
- }
- }
Add Comment
Please, Sign In to add comment