Guest User

Untitled

a guest
Dec 21st, 2018
145
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.70 KB | None | 0 0
  1. <server> - class DbConnect
  2. //1
  3. import java.sql.Connection;
  4. Connection conn;
  5.  
  6. //2
  7. String dbDriver = "oracle.jdbc.driver.OracleDriver";
  8. Class.forName(dbDriver);
  9.  
  10. //3
  11. String dbUrl = "jdbc:oracle:thin:@127.0.0.1:?:xe"; // (?) docker container : 59161 oracle 1521 <db 데이터베이스에 접속한 포트와 일치>
  12. String dbUser = "db에서 사용한 사용자명";
  13. String dbPwd = "사용자명의 암호";
  14.  
  15. conn = DriverManager.getConncetion(dbUrl, dbUser, dbPwd); // 이후 클라이언트에서 conn에 접근해 db서버에 접근가능
  16. <getter>
  17. public void getConn() { return conn; }
  18.  
  19. <Client>
  20. Connection conn = new DbConncet().getConn();
  21. + PreparedStatement //sql exe
  22. + ResultSet //cursor
Add Comment
Please, Sign In to add comment