¼Ò½ºÀÔ´Ï´Ù.


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

±Û¾´ÀÌ :À¯Çü¿­ 1998³â 6¿ù 02ÀÏ 15:44:28

In Reply to: [Re] ¼Ò½º¸¦ Çѹø ¿Ã·Á ÁÖ½ÃÁÒ(³»¿ë ¾ø½¿) posted by ä½Â±â on 1998³â 5¿ù 30ÀÏ 15:21:25:

import java.io.*;
import java.util.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;


public class YServlet extends HttpServlet {


Connection conn;
Statement stmt;
ServletOutputStream printStream;
ResultSet rset = null;


public void service (HttpServletRequest req, HttpServletResponse res)
throws ServletException, IOException
{
//res.setContentType("text/plain; charset=ks_c_5601_1987");//ks_c_5601_1987"//euc-kr
res.setContentType("text/html");//ks_c_5601_1987"//euc-kr
printStream = res.getOutputStream();

printStream.println("-------- Yufirst is so Cool! --------");
printStream.println("");
printStream.println("");
printStream.println("WebServer ¼­ºí¸´ Test- SSI");
printStream.println("");
printStream.println("");
printStream.println("

¼­ºí¸´ : Test DBServlet
");
printStream.println("
");
printStream.println("
");
printStream.println("
");
printStream.println(" µðºñ¿¡¼­ ÀÐÀº ºÎºÐ: ");
//*
getCustomer( );
printStream.println("
");
printStream.println("
");
printStream.println("server side include test - À¯Çü¿­(Yufirst) ");
printStream.println("");
printStream.println("");
// */
printStream.flush();

}


public String getServletInfo() {
return "Returns a string representation of the current time";
}
// µðºñÀÇ ÇÑ±Û ÄÚµå ü°è¸¦ ÀÚ½ÅÀÇ È¯°æÀÇ ÇÑ±Û ÄÚµå ü°è·Î ¹Ù²Þ
public String ko (String s)
{
String str = null;
try {
str = new String (s.getBytes("8859_1"), "KSC5601");
}
catch (UnsupportedEncodingException e) {
return "Error";
}
return str.trim();
}


//ÀÚ½ÅÀÇ È¯°æÀÇ ÇÑ±Û ÄÚµå ü°è¸¦ µðºñÀÇ ÇÑ±Û ÄÚµå ü°è·Î ¹Ù²Þ
public String en (String s)
{
String str = null;
try {
str = new String (s.getBytes("KSC5601"), "8859_1");
}
catch (UnsupportedEncodingException e) {
return "Error";
}
return str.trim();
}
public void getCustomer( ) throws IOException
{
printStream.println(" µå¶óÀ̹ö ¼³Á¤: ");
try {
Class.forName ("oracle.jdbc.driver.OracleDriver");
}
catch (ClassNotFoundException e) {
printStream.println("¿À·ù : Class Not Found Exception : "+ e.getMessage() );
}
printStream.println(" µå¶óÀ̹ö ¼³Á¤³¡: ");
try {
conn = DriverManager.getConnection ("jdbc:oracle:thin:@210.105.196.181:1521:ORCL",
"jsic98", "jsic98");
stmt = conn.createStatement ();
}
catch (SQLException e) {
printStream.println("¿À·ù : SQL Exception : "+ e.getMessage() );
//e.printStackTrace ();
}
printStream.println(" Driver conneted! ");


String ssn=null, name=null, addr=null;
int i = 0;
// String sql = "select * from CUSTOMER";
// String sqlConverted = en (sql);
//*
printStream.println(" Before query : " );
try {
//rset = stmt.executeQuery("Select name from Customer" );//
stmt.executeUpdate("Insert into Customer values ('3','3','3') " );//Succeed!
//stmt.executeUpdate("Delete from Customer where RTrim(ssn)='3'" );
} catch (SQLException e) {
printStream.println(" Query Error: ");
}
printStream.println(" After query : ");
/* try {
while (rset.next()) {
try {
name = ko (rset.getString(1));
}
catch (NullPointerException e) {
name = null;
}
}
} catch (SQLException e) {
printStream.println(" Äõ¸± ¼öÇà ¿¡·¯: ");
System.out.println("error");
}
//*/
printStream.println("--------finished-----------");
}


}


´ÙÀ½ ±Ûµé:



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

À̸§:
E-Mail:
Á¦¸ñ:
³»¿ë:
°ü·Ã URL(¼±ÅÃ):
URL Á¦¸ñ(¼±ÅÃ):
°ü·Ã À̹ÌÁö URL:


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