±Û¾´ÀÌ :ÀÚ¹Ù¸Ç 1999³â 2¿ù 18ÀÏ 16:41:39
¾È³çÇϼ¼¿ä. ¿©·¯ºÐ..
ÀÚ¹Ù¸¦ Á¶±Ý º¸´Ù°¡ °üµÎ¾ú´Âµ¥, ÀÌÁ¦
´Ù½Ã °øºÎ¸¦ ÇÒ·Á°í ÇÕ´Ï´Ù.
·ÎÄÿ¡¼ µðºñ¸¦ Çϳª ºÒ·¯ ¿Ã·Á°í Çϴµ¥,
ÀÌ»óÇÏ°Ô ÄÄÆÄÀÏ ÀÚü°¡ ¾ÈµÇ³×¿ä.
jdk1.2 ¸¦ »ç¿ëÇÏ°í ÀÖ½À´Ï´Ù.
¹«¾ùÀÌ ¹®Á¦ ÀÎÁö ÄÄÆÄÀϽà ¿¡·¯¸Þ¼¼Áö¶óµµ
³ª¿À¸é, ¾î¶»°Ô Çغ¸°Ú´Âµ¥, ÄÄÆÄÀϽÃÅ°¸é..
¹¬¹¬ºÎ´äÀÔ´Ï´Ù.
°¨À» ¸ø Àâ°Ú±º¿ä. µµ¿ò ÁÖ¼¼¿ä.
±×·³ ÁÁÀº ÇÏ·çµÇ¼¼¿ä..
import java.sql.*;
public class JdbcOdbc {
public static void main(String args[]) {
String URL = "jdbc:odbc:employ";
String username = "";
String password = "";
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Statement stmt = null;
Connection con = null;
con = DriverManager.getConnection(URL, username, password);
stmt = con.createStatement();
ResultSet rs = stmt.executeQuery("select * from weather;");
while(rs.next()) {
String city = rs.getString(2);
int lo = rs.getInt(3);
int hi = rs.getInt(4);
java.util.Date day = rs.getDate(5);
System.out.println(city + " " + lo + " " + hi + " " + day.toString());
}
con.close();
} catch (Exception e) {
System.out.println(e);
}
}
}