DB Connection (JDBC)

- 준비물 : ojdbc.jar (검색하면 쉽게 나오므로 생략)

imsiTest.java (임시 테스트파일) 중 DB Conn 일부분 Connection conn = null; Statement stmt = null; ResultSet rs = null; ConnectionManager CM = new ConnectionManager(); String QUERY = new String(); QUERY = " SELECT userid, username, userpass, userjumin, userauth, regdate FROM imsi_table "; try { conn = CM.getConn(conn); stmt = conn.createStatement(); rs = stmt.executeQuery(query);
ConnectionManager.java (JDBC Driver loading) public Connection getConn(Connection conn) throws ClassNotFoundException { try { Class.forName("oracle.jdbc.driver.OracleDriver"); conn = DriverManager.getConnection("jdbc:oracle:thin:@xxx.xxx.xxx.xxx:1521:xxxx", "xxxx", "xxxx); // 설정부분 System.out.println("[ ORACLE JDBC DRIVER RUN ]"); } catch(Exception e) { e.printStackTrace(); } return conn; } 기본 Connection 맺는 부분에 대해 간단히 정리해 놓음