글쓴이 :huindu 1999년 10월 06일 14:15:36
************ 애플릿쪽 ****************
public void ServletGetCall()
{
BufferedReader in;
System.out.println("day_text.getText()="+day_text.getText());
System.out.println("URLEncoder.encode(day_text.getText())="+URLEncoder.encode(day_text.getText()));
// String servleturl = "http://localhost/hee/MyServlet/dbaccess/ScheduleServlet?day="
servleturl = "http://100.23.113.9:8080/servlet/ScheduleServlet?day="+URLEncoder.encode(day_text.getText());
String nextLine;
try
{
try {
if (Class.forName("com.ms.security.PolicyEngine") != null)
PolicyEngine.assertPermission(PermissionID.SYSTEM);
} catch (Throwable cnfe) {
}
System.out.println("try");
URL ScheduleServlet = new URL(servleturl);
System.out.println("servlet call servleturl==>"+servleturl);
// in = new BufferedReader(new InputStreamReader(ScheduleServlet.openStream(),"KSC5601"));
in = new BufferedReader(new InputStreamReader(ScheduleServlet.openStream()));
System.out.println("in after");
if(in.readLine().startsWith("+ER")){
System.out.println("start er");
return;
}
System.out.println("while before");
while((nextLine = in.readLine())!=null){
System.out.println("set text before nextLine="+nextLine);
schedule_text.setText(nextLine);
}
System.out.println("text null");
repaint();
in.close();
}catch(MalformedURLException ee){
showStatus("Error"+ee.toString());
}catch(Exception e){
showStatus("Error"+e.toString());
}
}
************ 서블릿쪽 ****************
public void doGet(HttpServletRequest req, HttpServletResponse res)
{
System.out.println("do get");
try
{
res.setContentType("text/plain; charset=euc-kr");
String day= req.getParameter("day");
System.out.println("do get() day="+day);
PrintWriter out;
System.out.println("out");
// out = new PrintWriter(new OutputStreamWriter(res.getOutputStream(), "KSC5601"));
out = new PrintWriter(new OutputStreamWriter(res.getOutputStream()));
System.out.println("out after 1111");
// Class.forName("oracle.jdbc.driver.OracleDriver");
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
System.out.println("jdbc 111222");
// String url = "jdbc:odbc:servletDB";
String url = "jdbc:oracle:thin:@100.23.113.9"+":1521:ORA7";
System.out.println("do get() url==>"+url);
con = DriverManager.getConnection(url,"area","area734");
System.out.println("connection");
stmt = con.createStatement();
System.out.println("print result before");
PrintResult(out,day);
return;
}
catch (Exception e) { System.out.println("exception e="+e);}
}