Advertisement
Rishabh_CTLI

SQL Java

Aug 11th, 2016
86
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.25 KB | None | 0 0
  1. package com.ctli.training.database.example;
  2.  
  3.  
  4. import java.sql.Connection;
  5. import java.sql.DriverManager;
  6. import java.sql.ResultSet;
  7. import java.sql.SQLException;
  8. import java.sql.Statement;
  9.  
  10. public class TestDatabase {
  11.  
  12. public static void main(String[] args){
  13. Connection con=null;
  14.  
  15. try{
  16. Class.forName("oracle.jdbc.driver.OracleDriver");
  17. } catch (ClassNotFoundException e) {
  18. System.out.println("Please add driver jar in classpath");
  19. }
  20.  
  21. try{
  22. con=DriverManager.getConnection("jdbc:oracle:thin:@10.140.4.104:1578:training","training","enter_password_here");
  23.  
  24. } catch (SQLException e){
  25.  
  26. e.printStackTrace();
  27. }
  28.  
  29. Statement stmt=null;
  30.  
  31. try{
  32. stmt=con.createStatement();
  33.  
  34. } catch(SQLException e){
  35. e.printStackTrace();
  36.  
  37. }
  38.  
  39. ResultSet rs=null;
  40.  
  41. try{
  42. rs= stmt.executeQuery("select * from rishabh_login_data where uname='admin'");
  43. } catch(SQLException e){
  44. e.printStackTrace();
  45.  
  46. }
  47.  
  48. try{
  49. while(rs.next()){
  50. System.out.println(rs.getString(1)+" "+rs.getString(2)+" "+rs.getString(3)+" "+rs.getString(4)+" "+rs.getString(5));
  51. }
  52. } catch(SQLException e1){
  53. e1.printStackTrace();
  54.  
  55. }
  56.  
  57. try{
  58. con.close();
  59. } catch(SQLException e){
  60. e.printStackTrace();
  61.  
  62. }
  63. }
  64.  
  65. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement