Advertisement
Guest User

Untitled

a guest
Oct 5th, 2016
62
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.48 KB | None | 0 0
  1. import java.sql.*;
  2.  
  3. public class JavaConnection {
  4.  
  5. public static void main(String[] args) throws ClassNotFoundException, SQLException {
  6. Class.forName("oracle.jdbc.driver.OracleDriver");
  7. Connection con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:8080:xe","******","*******");
  8. Statement st=con.createStatement();
  9. String sql="select * from emp";
  10. ResultSet rs=st.executeQuery(sql);
  11. while(rs.next())
  12. System.out.println(rs.getInt(1)+" "+rs.getString(2));
  13. con.close();
  14.  
  15. }
  16. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement