±Û¾´ÀÌ :¹Ú°Ë¿µ 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();
}
}
}