Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <server> - class DbConnect
- //1
- import java.sql.Connection;
- Connection conn;
- //2
- String dbDriver = "oracle.jdbc.driver.OracleDriver";
- Class.forName(dbDriver);
- //3
- String dbUrl = "jdbc:oracle:thin:@127.0.0.1:?:xe"; // (?) docker container : 59161 oracle 1521 <db 데이터베이스에 접속한 포트와 일치>
- String dbUser = "db에서 사용한 사용자명";
- String dbPwd = "사용자명의 암호";
- conn = DriverManager.getConncetion(dbUrl, dbUser, dbPwd); // 이후 클라이언트에서 conn에 접근해 db서버에 접근가능
- <getter>
- public void getConn() { return conn; }
- <Client>
- Connection conn = new DbConncet().getConn();
- + PreparedStatement //sql exe
- + ResultSet //cursor
Add Comment
Please, Sign In to add comment