±Û¾´ÀÌ :ÀÌÀç¿ì 1999³â 6¿ù 10ÀÏ 00:30:08
ÀÚ¹Ù·£µå¿Í Åë½ÅÀÇ ÇÁ·Î±×·¥ °³¹ßÀÚ µ¿È£È¸¿¡ ¹°¾îº¸¾Æµµ ¾Æ¹«µµ ´äº¯À» ÇØ ÁÖÁö ¾Ê¾Æ ¸¶Áö¸·À¸·Î ¿©±â¿¡ ¿Ã¸³´Ï´Ù.
windows98¿¡¼ thin drive¸¦ ÀÌ¿ëÇÏ¿© pc oracle 7.3À» ¿¬°áÇÏ·Á°í ÇÕ´Ï´Ù.
autoexec.bat ÆÄÀÏ¿¡´Â ¾Æ·¡¿Í °°ÀÌ path, classpath¸¦ ¼³Á¤ÇÏ¿´½À´Ï´Ù.
set PATH=%PATH%;C:\JDK1.2\BIN;c:\orawin95\jdbc\lib
set classpath=c:\orawin95\jdbc\lib\classes111.zip
±×·± ÈÄ¿¡ ¼Ò½º ÈÀÏÀ» ¿¡·¯ ¾øÀÌ ÄÄÆÄÀÏ ÇÑ ÈÄ ½ÇÇàÀ» ÇÏ·Á°í ÇÏ¸é ´ÙÀ½°ú °°Àº ¿¡·¯°¡ ¹ß»ýÇÕ´Ï´Ù. ±×¸®±¸ ÀÌ ÀÚ¹Ù ÇÁ·Î±×·¥»Ó¸¸ ¾Æ´Ï¶ó ´Ù¸¥ ÀÚ¹Ù ÇÁ·Î±×·¥¿¡¼µµ ¶È°°Àº ¿¡·¯°¡ ¹ß»ýÇÏ¿´½À´Ï´Ù.(Exception in thread "main"
java.lang.NoClassDefFounderror: JdbcOracle)
¾Æ¹«·¡µµ Á¦°¡ ȯ°æ ¼³Á¤À» À߸ø ÇØ ÁØ °Í °°Àºµ¥ ²À °¡¸£ÃÄ ÁÖ¼ÌÀ¸¸é ÇÕ´Ï´Ù.
Âü°í·Î ¼Ò½º ÆÄÀÏÀº ´ÙÀ½°ú °°½À´Ï´Ù.
import java.sql.*;
import java.util.*;
import java.lang.*;
public class JdbcOracle {
public static void main(String[] args) {
String db_connect = new String ("jdbc:oracle:thin:@localhost:1521:orcl");
String db_user = new String("scott");
String db_passwd = new String("tiger");
Connection conn;
Statement stat;
String DriverName = "oracle.jdbc.driver.OracleDriver";
try {
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
conn = DriverManager.getConnection(db_connect, db_user, db_passwd);
stat = conn.createStatement();
ResultSet rs = stat.executeQuery("select * from weather");
while(rs.next()) {
String city = rs.getString(1);
short lo = rs.getShort(2);
short hi = rs.getShort(2);
java.util.Date day = rs.getDate(4);
System.out.println(city + " " + lo + " " + hi + " " + day);
}
stat.close();
conn.close();
} catch(Exception e) {
System.out.println("error sql");
e.printStackTrace();
}
}
}