¼­ºí¸´°ú DB¿¬°á....Á¦¹ß ´äº¯À» ºÎŹÇÕ´Ï´Ù....


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

±Û¾´ÀÌ :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¿¬°áÇÏ´Ï Àß µÇ´õ±º¿ä....
¿Ö ¼­ºí¸´Àº ¾ÈµÇ´ÂÁö .......


±×·³ ´äº¯ ºÎŹµå¸³´Ï´Ù.


´ÙÀ½ ±Ûµé:



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

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


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