°£´ÜÇÑ ConnectionFactory ÀÛ¼ºÀÇ ¿¹
ConnectionFactory.java
import java.sql.*;
public class ConnectionFactory {
public ConnectionFactory() {}
public Connection getConnection()
throws SQLException {
Connection conn = null;
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn = DriverManager.getConnection("jdbc:odbc:dbdsn", "id", "password");
}
catch (ClassNotFoundException cnfe) {
System.out.println(cnfe);
}
return conn;
}
}
C:\JavaExample\19>javac ConnectionFactory.java
µ¥ÀÌÅͺ£À̽ºÀÇ Ä¿³Ø¼ÇÀ» ¸¸µé¾îÁִ Ŭ·¡½º.
µ¥ÀÌÅͺ£À̽º¿¡ Ä¿³Ø¼ÇÀ» ¸¸µé±â À§ÇÑ ¼¼ºÎ ±¸ÇöÀ» °¨ÃçµÎ°í, Ä¿³Ø¼ÇÀ» ¿äûÇÑ Å¬¶óÀÌ¾ðÆ® Å¬·¡½º¿¡°Ô Ãß»óÈµÈ ÀÎÅÍÆäÀ̽º Á¦°ø
ConnectionFactory¸¦ »ç¿ëÇÏ´Â ¿¹Á¦
ClientClass.java
import java.sql.*;
public class ClientClass {
public static void main(String[] args) throws SQLException {
Connection conn = new ConnectionFactory().getConnection();
if (conn != null) {
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("SELECT * FROM MyTest");
rs.close();
stmt.close();
conn.close();
}
}
}
C:\JavaExample\19>javac ClientClass.java
C:\JavaExample\19>java ClientClass
ClientClass°¡ ¼Õ½±°Ô µ¥ÀÌÅͺ£À̽º ¿¬°áÀ» ÇÒ ¼ö ÀÖÀ¸¸ç, µ¥ÀÌÅͺ£À̽º ¿¬°á°ú ½ÇÇàÀÇ ºÎºÐÀ» ºÐ¸®½ÃÄÑ ÀÛ¾÷À» µ¶¸³ÀûÀ̰í È¿À²ÀûÀ¸·Î ¼öÇà
jabookÀúÀÚ¸íÇÔ |
Á¦¸ñ:¼Ò¼³°°Àº¹Ì´ÏÄÚµå ÀÛ¼ºÀÚ:Àںϸâ¹ö ÇÑâÇå |