jdbc¿¡ °üÇÑ Áú¹®ÀÔ´Ï´Ù.


[ ´ÙÀ½ ±Ûµé ] [ À̾ ±Û¿Ã¸®±â(´äÇϱâ) ] [ ÀÚ¹Ù ¹¯°í ´äÇϱâ ]

±Û¾´ÀÌ :±è°æ¿ì 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();
}
}
}


´ÙÀ½ ±Ûµé:



À̾ ±Û¿Ã¸®±â(´äÇϱâ)

À̸§:
E-Mail:
Á¦¸ñ:
³»¿ë:
HTML ÅÂ±× Æ÷ÇÔ ¿©ºÎ: HTML ¹®¼­ÀÏ °æ¿ì üũ
°ü·Ã URL(¼±ÅÃ):
URL Á¦¸ñ(¼±ÅÃ):
°ü·Ã À̹ÌÁö URL:


[ ´ÙÀ½ ±Ûµé ] [ À̾ ±Û¿Ã¸®±â(´äÇϱâ) ] [ ÀÚ¹Ù ¹¯°í ´äÇϱâ ]