카테고리 없음
JDBC DB 접속 기본 설정 방식
Request
2009. 2. 12. 20:21
JBDC 하실 DB 접속 설정(오라클)
String jdbcUrl="jdbc:oracle:thin:@localhost:1521:orcl";
String dbId="scott";
String dbPass="tiger";
Class.forName("oracle.jdbc.driver.OracleDriver");
con=DriverManager.getConnection(jdbcUrl,dbId,dbPass);
---------------------------------------------------------------------
3.JBDC시 DB 접속 설정(mySQL)
String jdbcUrl="jdbc:mysql://localhost:3306/jsptest";
String dbId="scott";
String dbPass="tiger";
Class.forName("com.mysql.jdbc.Driver");
con=DriverManager.getConnection(jdbcUrl,dbId,dbPass);
String jdbcUrl="jdbc:oracle:thin:@localhost:1521:orcl";
String dbId="scott";
String dbPass="tiger";
Class.forName("oracle.jdbc.driver.OracleDriver");
con=DriverManager.getConnection(jdbcUrl,dbId,dbPass);
---------------------------------------------------------------------
3.JBDC시 DB 접속 설정(mySQL)
String jdbcUrl="jdbc:mysql://localhost:3306/jsptest";
String dbId="scott";
String dbPass="tiger";
Class.forName("com.mysql.jdbc.Driver");
con=DriverManager.getConnection(jdbcUrl,dbId,dbPass);