µå¶óÀ̹ö°¡ ·Îµå°¡ ¾ÈµÇ³×¿ä..¤Ð.¤Ð (3-tier program)


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

±Û¾´ÀÌ :±èÁ¤Çý 1998³â 12¿ù 11ÀÏ 19:10:05

¿À¶óŬ thin µå¶óÀ̹ö¸¦ »ç¿ëÇÏ°í Àִµ¥.
ÀÚ²Ù¸¸ µå¶óÀ̹ö°¡ ·Îµå°¡ ¾ÈµÈ´Ù°í Çϳ׿ä...
¿Ö ±×·±Áö ¸ô°Ú³×¿ä..
´äº¯ ºÎŹµå¸³´Ï´Ù¿ä.. Çø®Áî...


±×¸®°í ¿¡·¯ ¸Þ¼¼Áö´Â ´ÙÀ½°ú °°½À´Ï´Ù. ¼Ò½ºµµ ÷ºÎÇÒ²²¿ä


ERROR Exceptio : java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver



<MyServer.java>


import java.rmi.Naming;
import java.rmi.RemoteException;
import java.rmi.RMISecurityManager;
import java.rmi.server.UnicastRemoteObject;
import java.io.*;
import java.sql.*;
import java.util.*;
//import postgres95.*;



public class MyServer extends UnicastRemoteObject implements Methods
{


public MyServer() throws RemoteException {
super();
System.out.println("Server Started");
}
/** µ¥ÀÌÅÍ º£À̽º Àüü °Ë»ö */
public void totalSearch(String search) {


Connection conn = null;
// String result_search[] = null;


//static final int SERVER_PORT = 7942;
System.out.println("¬÷ S");
try{
//Unicode convert
search = new String(search.getBytes("KSC5601"),"ISO-8859-1");
Class.forName("oracle.jdbc.driver.OracleDriver");
String Query = "select * from gb";
//PGDriver gd = (PGDriver) new postgres95.PGDriver();
String url = "jdbc:oracle:thin:@sunduk:1521:EDU";
conn = DriverManager.getConnection(url,"sapphire","sapphire");


Statement stat = (Statement)conn.createStatement();
ResultSet rs = (ResultSet)stat.executeQuery(Query);


//postgres DB¿¡¼­¸¸ Á¦°øµÇ´Â ¸Þ¼Òµå (getRowCount())
//* result_search = new String[rs.getRowCount()];
while(rs.next()) {
int no = rs.getInt("NO");
String kName = rs.getString("K_NAME");
System.out.println("NO = "+no+" K_Name="+kName);
}

rs.close();
stat.close();
conn.close();


} catch (Exception E) {
System.out.println("ERROR Exceptio : " + E);
try{
conn.close();
} catch(SQLException j) {
System.out.println("ERROR SQLExceptio : " + j);
}
}
}


public static void main(String args[]) {


int SERVER_PORT = 1099;
// Create and install a security manager
if (System.getSecurityManager() == null) {
System.setSecurityManager(new RMISecurityManager());
}


try {
MyServer ms = new MyServer();
Naming.rebind("MyServer", ms);
} catch (Exception e) {
System.out.println("MyServer err: " + e.getMessage());
e.printStackTrace();
}
}


}



³×.. ÀÌ»óÀÔ´Ï´Ù..


Á¤¸»·Î ´äº¯ ºÎŹµå¸³´Ï´Ù..
¾ÆÁÖ Áß¿äÇÑ °Å¶ó¼­¿ä....






´ÙÀ½ ±Ûµé:



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

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


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