±Û¾´ÀÌ :Jeros 1998³â 1¿ù 23ÀÏ 15:08:59
¾È³çÇϼ¼¿ä ..
¸ÕÀú¹øÀÇ ´äº¯ °¨»çÇÕ´Ï´Ù...
À̹ø¿¡ Á¦°¡ Áú¹® µå¸± °ÍÀº JDBC¸¦ ÀÌ¿ëÇÏ¿© DB¸¦ Á¢±ÙÇÏ´Â °ÍÀÔ´Ï´Ù.
ÇöÀç MS-Access¸¦ DB·Î »ç¿ëÇϴµ¥
JDBC ºÐ·ùÀÇ Ã¹¹ø°ÀÎ JDBC-ODBC-Bridge¸¦ »ç¿ëÇÏ¿©,
Áï JDK1.1.5¹öÀüÀÇ sql ÆÐÅ°Áö¸¦ »ç¿ëÇÏ°í µå¶óÀ̹ö·Î
JdbcOdbcDriver¸¦ »ç¿ëÇÏ¿´½À´Ï´Ù.
¾ÖÇø´À¸·Î JDBC-ODBC Driver¸¦ »ç¿ëÇϸé
¹®Á¦°¡ ÀÖ´Ù´Â °É·Î ¾Ë°í ÀÖ½À´Ï´Ù.
win95¿¡¼ local·Î appletviewer·Î´Â ÀÏ´Ü Àß µË´Ï´Ù.
netscapeµµ ÀߵDZ¸¿ä...
±×·±µ¥ IE´Â local¿¡¼ ¾ÈµÇ´Â ±º¿ä....
Á¦ Áú¹®Àº
1. NT ServerÀÇ MS-Access¸¦ ¾ÖÇø´¿¡¼ jdk¿¡¼ Áö¿øÇÏ´Â
driver(JdbcOdbcDriver)·Î Á¢±ÙÀÌ °¡´ÉÇÑÁö...
- Áö±Ý ½Ã¸ÇÅØÀÇ dbanywhere¸¦ ´Ù¿î¹Þ¾Ò´Âµ¥ ±×°ÍÀ» »ç¿ëÇÒ±î
»ý°¢ÁßÀÔ´Ï´Ù...
2. ¸¸¾à OracleÀ» »ç¿ëÇÏ°Ô µÇ¸é jdkÀÇ sql-packege¸¸À¸·Î
°¡´ÉÇÑÁö ÀÔ´Ï´Ù...
Á¦ Áú¹®ÀÌ ÀÌ»óÇÑ °÷ÀÌ ÀÖÀ¸½Ã´Ù¸é
NT-Server¿Í Unix Server¿¡¼ ms-Access¸¦ Á¢±ÙÇϱâ À§ÇÑ
ÀýÂ÷¸¦ ¾Ë·ÁÁֽñ⸦...
Âü°í·Î ÀúÀÇ ¼Ò½º Áß DB ¿¬°á ºÎºÐÀ» ÇÔ²² ¿Ã¸³´Ï´Ù...
class DBControl
{
Connection connect;
Statement stmt;
ResultSetMetaData rsetMeta;
ResultSet rset;
public DBControl(String dbname)
{
_connectDB("sun.jdbc.odbc.JdbcOdbcDriver","jdbc:odbc:"+dbname);
}
// ############################## connect DataBase
void _connectDB(String drvName,String dbUrl){
try
{
// Load the Oracle JDBC driver
Class.forName(drvName);
System.out.println("JdbcOdbcDrive is created!");
// Connect to the database
// You can put a database name after the @ sign in the connection URL.
connect = DriverManager.getConnection(dbUrl);
System.out.println("Connection created!");
// Create a Statement
stmt = connect.createStatement();
System.out.println("Statement created!");
}
catch (SQLException ex)
{
System.out.println("SQL error: "+ex);
}
catch (java.lang.Exception ex)
{
System.out.println("Not found: "+ex);
}
}
// ################################################################