¼Ò½º Á» ºÁºÁÁÖ¼¼¿ä...


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

±Û¾´ÀÌ :¹Ú°Ë¿µ 2000³â 3¿ù 15ÀÏ 10:18:28

¾È³çÇϼ¼¿ä...
À¥ºê¶ó¿ìÀú¿¡¼­ inputÀ» ¹Þ¾Æ ³»¿ëÀ» À¥À¸·Î ´Ù½Ã »Ñ·ÁÁÖ°í
¶ÇÇÑ µ¥ÀÌÅͺ£À̽º¿¡ ±× ³»¿ëÀ» ÀúÀåÇÏ·Á±¸ Çϴµ¥ È­¸é¿¡ »Ñ·ÁÁִ°ÍÀº µÇ´Âµ¥ µðºñ¿¡´Â ÀúÀåÀÌ ¾ÈµÇ´õ¶ó±¸¿ä...
¿Ö ¾ÈµÇ´ÂÁö ¸ð¸£°Ú¾î¿ä...
¾Æ·¡¿Í °°ÀÌ ½ÇÇà°ú ¼Ò½º¸¦ ºÙÀÔ´Ï´Ù...
¹¹°¡ ¹®Á¦Àΰ¡¿ä???°¥ÄÑÁÖ¼¼¿ä....
/users/kypark/javaservlet: java InputServlet01
·Îµå ¼º°ø
¿¬°á ¼º°ø
ORA-00928: missing SELECT keyword


µ¥ÀÌÅͺ£À̽º ¿¬°á ½ÇÆÐjdbc:oracle:thin:@localhost:1521:ITFT
ù¹ø° Çʵå:park µÎ¹ø° Çʵåkeomyoung
ù¹ø° Çʵå:oh µÎ¹ø° Çʵåhyunju


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


public class InputServlet01 extends HttpServlet
{
public void doGet(HttpServletRequest req, HttpServletResponse res)
throws ServletException, IOException



{

res.setContentType("text/html;charset=euc-kr");
String name=req.getParameterValues("name")[0];
String juso=req.getParameterValues("juso")[0];


PrintWriter out = new PrintWriter(
new OutputStreamWriter(res.getOutputStream(),"ksc5601"));


out.println("<HTML><BODY>");
out.println("<p>"+Uni2Ksc(name)+"´ÔÀÇ ÁÖ¼Ò´Â"+Uni2Ksc(juso)+"ÀÔ´Ï´Ù</p>");
out.println("</BODY></HTML>");


out.flush();
out.close();



}


public String Uni2Ksc(String Unicodestr)
throws UnsupportedEncodingException


{
if (Unicodestr == null)
return null;
return new String(Unicodestr.getBytes("8859_1"),"ksc5601");
}



public static void main (String args[]) {


String url = "jdbc:oracle:thin:@localhost:1521:ITFT";
String username = "";
String password = "";



try
{
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
System.out.println("·Îµå ¼º°ø");
}
catch (Exception e)


{
System.out.println(e.getMessage());
System.out.println("JDBC/ODBC µå¶óÀÌºê ·Îµå ½ÇÆÐ");
return;
}


Statement stmt = null;
Connection con = null;


try
{
con = DriverManager.getConnection(url, "system", "manager");
stmt = con.createStatement();
System.out.println("¿¬°á ¼º°ø");

stmt.executeUpdate("insert into selectDBtable"+"values(Uni2Ksc(name),Uni2Ksc(juso))");


stmt.close();
con.close();

}
catch (Exception e)
{
System.out.println(e.getMessage());
System.err.println("µ¥ÀÌÅͺ£À̽º ¿¬°á ½ÇÆÐ"+url);
}


try {
ResultSet result = stmt.executeQuery("select * from selectDBtable ");
while(result.next()) {


String field1 = result.getString(1);
String field2 = result.getString(2);


System.out.println("ù¹ø° Çʵå:"+field1+"µÎ¹ø° Çʵå"+field2);
}


con.close();
}
catch (Exception e) {
System.out.println(e.getMessage());
e.printStackTrace();
}
}




}



´ÙÀ½ ±Ûµé:



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

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


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