±Û¾´ÀÌ :±è°æ¿ì 2000³â 2¿ù 23ÀÏ 16:18:50
¾È³çÇϼ¼¿ä! Àú´Â ÀÚ¹Ù¶õ ¾ð¾î¸¦ ÇÑÁö ¾ó¸¶ ¾ÈµÇ´Â Ãʺ¸ÀÔ´Ï´Ù.
Ãʺ¸°¡ ÇÏ·Á´Ùº¸´Ï ³Ê¹« ¸·È÷´Â°Ô ¸¹ÀÌ ÀÖ´Â °Í °°¾Æ¿ä
Á¦°¡ Áú¹®ÇÏ°í ½ÍÀº °ÍÀº ¾Æ·¡ÀÇ ÄÚµåÀε¥
¾Æ·¡¿Í °°ÀÌ ÄÚµùÀ» ÇÑ ÈÄ¿¡ ÄÄÆÄÀÏÀ» ÇÏ°í ½ÇÇàÀ» Çϸé
=> Exception in thread NULL Exception in thread "main" Exception in thread "main"
À§¿Í °°Àº ¸Þ¼¼Áö°¡ ³ª¿À°í ¾Æ¹«·± ¹ÝÀÀ¾øÀÌ Á¾·áµË´Ï´Ù.
¾î¶»°Ô ÇØ¾ß ÇÒ Áö¸¦ ¸ð¸£°Ú¾î¼ ÀÌ·¸°Ô µµ¿òÀ» ¿äûÇÕ´Ï´Ù.
²À Á» µµ¿ÍÁÖ¼¼¿ä!
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:oci@203.236.127.188:1521:ORCL");
String db_user = new String("webmaster");
String db_pass = new String("masterkey");
Connection conn;
Statement stat;
String DriverName = "oracle.jdbc.driver.OracleDriver";
try {
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
conn = DriverManager.gerConnection(db_connect,db_user,db_pass);
stat = conn.createStatement();
ResultSet rs = stat.executeQuery("select * from mydb");
while(rs.next()) {
String empno = rs.getstring(1);
String ename = rs.getString(2);
System.out.println(empno + " " + ename);
}
stat.close();
conn.close();
} catch(Exception e) {
System.out.println("error sql");
e.printStackTrace();
}
}
}