Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import java.sql.*;
- class Jdbc2{
- public static void main(String args[]) throws Exception{
- Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
- Connection con = DriverManager.getConnection("jdbc:odbc:oradsn","scott","tiger");
- Statement st = con.createStatement();
- String query = "select * from rajesh";
- ResultSet rs = st.executeQuery(query);
- while(rs.next()!=false)
- System.out.println(rs.getInt("sno") + " " + rs.getString("name") + " "
- +rs.getString("sex") + " " + rs.getString("address") +
- " "+ rs.getInt("age"));
- rs.close();
- st.close();
- con.close();
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment