±Û¾´ÀÌ :ÃÖÈ¿Á¤ 1998³â 6¿ù 23ÀÏ 16:57:23
óÀ½À¸·Î jdbc¸¦ °øºÎÇÒ·Á°í Çϴµ¥.. ¾îµð¼±°¡ ´ÙÀ½°ú °°Àº ¼Ò½º¸¦ ±¸Çß½À´Ï´Ù. ±×·±µ¥ 11¹ø° ÁÙ¿¡
String dirverName = "oracle.jdbc.driver.OravleDriver";
ÀÇ Àǹ̿Í
ÀÌ º¯¼ö°¡ ³ªÁß¿¡ Class.forName(drivername)¿¡¼ ¾²ÀÌ´Â Àǹ̰¡ ¹«¾ðÁö.. °¥ÄÑÁÖ¼¼¿ä.
¿À¶óŬÀÇ thinµå¶óÀ̹ö¸¦ ´Ù¿î·Îµå ¹Þ¾Ò´Âµ¥. ÀÌ°ÍÀ» ¾î´À µð·ºÅ丮¿¡ ¼³Ä¡¸¦ ÇÏ°í ±×¸®°í Äڵ忡¼ µå¶óÀ̹ö°¡ ¼³Ä¡µÈ µð·ºÅ丮¿Í °ü°èµÈ ºÎºÐÀÌ ÀÖ´ÂÁö ¾Ë°í ½Í½À´Ï´Ù.
import java.sql.*;
import java.io.*;
import java.util.*;
class sample {
public static void main(String args[])
throws ClassNotFoundException,SQLException
{
System.out.println("Start connection process...");
String driverName="oracle.jdbc.driver.OracleDriver";
System.out.println("Registering the jdbc Driver...");
Class.forName(driverName);
String drcon="jdbc:oracle:thin:@localhost:1521:orcl";
System.out.println("Attempting to connect to the oracle..");
Connection dbcon=DriverManager.getConnection("jdbc:oracle:thin:@203.248.150.167:1521:orcl","scote","tiger");
System.out.println("Co0nnection!!");
System.out.println("Creating a statement...");
Statement dbStatement=dbcon.createStatement();
String q="select * from javaland";
ResultSet queryResults=dbStatement.executeQuery(q);
int i=0;
while(queryResults.next()){
System.out.println("ROW "+i+" "+convert(queryResults.getString(1))
+" "+convert(queryResults.getString(2))
+" "+convert(queryResults.getString(3))
+" "+convert(queryResults.getString(4)));
i++;
}
}
private static String convert(String str)
{
String result=null;
try{
byte[] rawBytes=str.getBytes("8859_1");
result=new String(rawBytes,"KS5601");
}catch(Exception e){}
return result;
}
}