±Û¾´ÀÌ :woogya 1999³â 11¿ù 04ÀÏ 16:31:22
¾È³çÇϼ¼¿ä.
ÀÌ°÷¿¡ ¿Ã·ÁÁø ±Û·Î ¸¹Àº µµ¿òÀ» ¹Þ°í ÀÖ½À´Ï´Ù.
Á¦°¡ Áö±Ý ÇÏ°í ÀÖ´Â ÀÏÁß¿¡ Àß ¾ÈµÇ´Â ºÎºÐÀÌ ÀÖ¾î ÀÌ·¸°Ô Áú¹®À» ¿Ã¸®°Ô µÇ¾ú½À´Ï´Ù.
¿ì¼± ¼ºí¸´°ú ¿À¶óŬDB¿ÍÀÇ ¿¬°á¿¡ °üÇÑ°Ì´Ï´Ù.
¹°·Ð °Ô½ÃÆÇ¿¡µµ ¸¹Àº ±ÛÀÌ ¿Ã¶ó¿Í ÀÖÁö¸¸ Á¦°¡ Àß ¸ô¶ó¼ ±×·±Áö Á¦´ë·Î ÀÎÁö°¡ ¾ÈµÇ´Â±º¿ä....
Á¦°¡ Áö±Ý »ç¿ëÇϴ ȯ°æÀº HP-UX¼¹ö, Oracle7.3.4, Netscape Enterprise Server 3.61ÀÌ°í ÀÚ¹Ùȯ°æÀº JDK1.1.7, JSDK2.0, Oracle JDBC Drivers 7.3.4(1.22)ÀÔ´Ï´Ù.
ÀÚ¹Ù, ¼ºí¸´ÀÇ ±âº» ÄÄÆÄÀÏ°ú °á°ú¹°Àº ½ÇÇàµË´Ï´Ù.
ÀÚ¹Ù ¾îÇø®ÄÉÀ̼ÇÀ¸·Î DB Connectµµ Å×½ºÆ®°¡ ¿Ï·áµÇ¾ú°í Çѱ۹®Á¦µµ ó¸®µÈ »óÅÂÀε¥, ¼ºí¸´À¸·Î DB¸¦ ¿¬°áÇÏ·Á¸é Àڲ٠Ŭ·¡½º¸¦ ¸øã´Â´Ù°Å³ª No Suitable Driver¶ó°íµµ ¸Þ¼¼Áö°¡ ³ª¿É´Ï´Ù....
ÇöÀç UNIX ÇØ´ç »ç¿ëÀÚÀÇ .profile¿¡ Ŭ·¡½ºÆнº¼³Á¤À» ÇÏ¿´½À´Ï´Ù.(Unix's user : miracle)
Ŭ·¡½ºÆнº ¼³Á¤Àº ´ÙÀ½°ú °°ÀÌ Çß½À´Ï´Ù.
# Set up the search paths:
PATH= $PATH:/instrument/ora723/bin:/electronic1/opt/java/bin:/electronic1/JSDK2.0/bin:.
export CLASSPATH=$CLASSPATH:/electronic1/opt/java/lib/classes.zip
export CLASSPATH=$CLASSPATH:/electronic1/JSDK2.0/lib/jsdk.jar
export ORACLE_HOME=/instrument/ora723
export CLASSPATH=$CLASSPATH:$ORACLE_HOME/jdbc/lib/classes111.zip
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/jdbc/lib
ÀÌ·¸°Ô ¼¼ÆõǾî ÀÖ°í¿ä....
±×¿Ü ´Ù¸¥ ¼³Á¤Àº ¾ÈÇß½À´Ï´Ù.
Àü¿¡ Novell Netware¿¡¼ Çѹø ¼³Á¤ÇßÀ»¶§¿¡µµ ±×¿Ü¿¡ ¼³Á¤ÇØÁÖ´Â °Ç ¾ø¾ú´ø °É·Î ±â¾ïÇÏ°í Àְŵç¿ä...
Á¤¸» ¹«¾ùÀÌ À߸øµÇ¾ú´ÂÁö Àß ¸ð¸£°Ú½À´Ï´Ù.
Á¶±ÝÀÌ¶óµµ Á¶¾ðÀ» ºÎŹµå¸³´Ï´Ù....
±×¸®°í Ȥ½Ã³ª Çؼ ¼Ò½º¸¦ ¿Ã¸®°Ú½À´Ï´Ù.
-------------------------------------------------------
//import java.lang.*;
import java.io.*;
import java.sql.*;
import java.math.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class JDBCServlet extends HttpServlet {
Connection conn;
Statement stmt;
ResultSet rset;
String name = "";
public void init(ServletConfig config) throws ServletException {
super.init(config);
}
public void doGet(HttpServletRequest req, HttpServletResponse res)
throws ServletException, IOException {
PrintWriter out=null;
out = new PrintWriter(new OutputStreamWriter(res.getOutputStream()), true);
res.setContentType("text/html");
out.println("<html>");
out.println("<head><title>JDBC TEST</title></head>");
out.println("<body>JDBC TEST <br>");
try {
//DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
Class.forName("oracle.jdbc.driver.OracleDriver");
//À§ 2°¡Áö ¹æ¹ýÀ¸·Î µå¶óÀ̹ö ·Îµå
conn = DriverManager.getConnection("jdbc:oracle:thin:@100.5.54.7:1521:MISS","voc","voc99");
stmt = conn.createStatement();
rset = stmt.executeQuery(ascToksc1("select code_name from voc_codes"));
out.println("<table border=\"1\">");
out.println("<tr>");
while(rset.next())
//name = ascToksc2(rset.getString("ename"));
out.println("<td>" + ascToksc2(rset.getString("code_name")) + "</td>");
out.println("</tr>");
out.println("</table>");
} catch(Exception e) {
out.println("Error¹ß»ý:" + e.toString());
}
out.println("</body></html>");
}
/* ÇÑ±Û ÀÎÄÚµù */
public static String ascToksc1(String str)
throws UnsupportedEncodingException {
if ( str == null )
return null;
return new String(str.getBytes("8859_1"), "KSC5601");
}
public static String ascToksc2(String str)
throws UnsupportedEncodingException {
if ( str == null )
return null;
return new String(str.getBytes("KSC5601"), "8859_1");
}
public void destroy() {
try {
conn.close();
} catch(Exception e) {
e.printStackTrace();
}
}
}
------------------------------------------------------
Âü, ¾ÖÇø´À¸·Î DB¿¬°áÇÏ´Ï Àß µÇ´õ±º¿ä....
¿Ö ¼ºí¸´Àº ¾ÈµÇ´ÂÁö .......
±×·³ ´äº¯ ºÎŹµå¸³´Ï´Ù.