新的CN问题~接前一个帖子~

newyoung2000 2003-08-31 03:51:11

好不容易调试好了前一个东东，接着下一个东西又不对了，报错信息如下：
description The requested service (Servlet assessex is currently unavailable) is not currently available.
据说是服务器已经当掉了~~~555~~~怎么办啊~~
前一个页面的代码见 http://expert.csdn.net/Expert/topic/2206/2206529.xml
现在出问题的页面代码见下：

package Webservlet;

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

public class exAssess extends HttpServlet {
private static final String CONTENT_TYPE = "text/html; charset=GB2312";
//Initialize global variables
public void init() throws ServletException {
String sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
try {
Class.forName(sDBDriver);
}
catch(java.lang.ClassNotFoundException e){
System.err.println(e.getMessage());
}
}
//封装查询语句
public ResultSet executeQuery(String sql){
String sConnStr = "jdbc:odbc:homworkwebserver";
Connection connect = null;
ResultSet rs = null;
try {
connect = DriverManager.getConnection(sConnStr,"sa","");
Statement stmt = connect.createStatement();
rs = stmt.executeQuery(sql);
}
catch(SQLException ex) {
System.err.println(ex.getMessage());
}
return rs;
}

public void executeInsert(String sql){
String sConnStr = "jdbc:odbc:homworkwebserver";
Connection connect = null;
try{
connect = DriverManager.getConnection(sConnStr,"sa","");
Statement stmt = connect.createStatement();
stmt.execute(sql);
}
catch(SQLException ex){
System.err.println(ex.getMessage());
}
}
//Process the HTTP Get request
public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
response.setContentType(CONTENT_TYPE);
PrintWriter out = response.getWriter();
HttpSession session = request.getSession();
String exid = request.getParameter("exid").trim();
String sql = "select * from exercise where exid = '"+exid+"'";
ResultSet rs = executeQuery(sql);
out.println("<html><head><meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\">");
out.println("<title>批改作业</title><style type=\"text/css\"></style>");
out.println("<SCRIPT>function NO(){ alert(\"请不要修改学生作业的原文！\");}function Check(){ if (document.form1.exassess.value ==\"\"){alert(\"请输入您批改的内容！\");return false;}if(document.form1.exmark.value ==\"\"){alert(\"请打出分数\");return false;}}</SCRIPT>");
out.println("</head><body>");
out.println("<div align=\"center\"> <form name=\"form1\" method=\"post\" onSubmit=\"if(Check() == false) return false;\" action=\"/Assessex\">");
out.println("<table width=\"760\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\">");
out.println("<tr><td height=\"16\" colspan=\"7\" align=\"center\" valign=\"middle\" bgcolor=\"#dce8f3\">批改作业</td></tr>");
out.println(" <tr><td height=\"17\" colspan=\"7\" valign=\"top\"><hr size=\"0\"></td></tr>");
try{
rs.next();
out.println("<tr><td height=\"16\" colspan=\"2\" align=\"right\" valign=\"middle\" bgcolor=\"#dce8f3\">作业名：</td>");
out.println("<td colspan=\"5\" align=\"left\" valign=\"middle\" bgcolor=\"#99CCFF\">"+rs.getString("exname").trim()+"</td></tr>");
out.println("<tr><td height=\"16\" colspan=\"2\" align=\"right\" valign=\"middle\" bgcolor=\"#dce8f3\">科目：</td>");
out.println("<td colspan=\"5\" align=\"left\" valign=\"middle\" bgcolor=\"#99CCFF\">"+rs.getString("exclass").trim()+"</td></tr>");
String excontent = rs.getString("excontent");
//byte[] temp_t = excontent.getBytes("ISO-8859-1");
//excontent = new String(temp_t);
String exfile = rs.getString("exfile").trim();
//temp_t = exfile.getBytes("ISO-8859-1");
//exfile = new String(temp_t);
String studentid = rs.getString("studentid").trim();
String mark = rs.getString("exmark").trim();
out.println("<tr><td height=\"16\" colspan=\"2\" align=\"right\" valign=\"middle\" bgcolor=\"#dce8f3\">作业提交人：</td>");
out.println("<td colspan=\"5\" valign=\"middle\" bgcolor=\"#99CCFF\">"+studentid+"</td></tr>");
out.println("<tr><td height=\"16\" colspan=\"4\" align=\"center\" valign=\"middle\" bgcolor=\"#dce8f3\">作业内容</td>");
if(mark.equalsIgnoreCase("null"))
out.println("<td colspan=\"3\" align=\"center\" valign=\"middle\" bgcolor=\"#dce8f3\">批改内容(此作业未批改)</td></tr>");
else
out.println("<td colspan=\"3\" align=\"center\" valign=\"middle\" bgcolor=\"#dce8f3\">批改内容(此作业已经批改)</td></tr>");
out.println("<tr><td height=\"390\" colspan=\"5\" valign=\"top\" bgcolor=\"#dce8f3\"> <textarea name=\"textarea\" cols=\"60\" rows=\"28\" onFocus=\"NO()\" onChange=\"NO()\">"+excontent+"</textarea></td>");
if(!mark.equalsIgnoreCase("null")){
sql = "select * from assess where exid = '"+exid+"'";
ResultSet RS = executeQuery(sql);
RS.next();
String asscontent = RS.getString("assess");
out.println(" <td colspan=\"2\" valign=\"top\" bgcolor=\"#dce8f3\"> <textarea name=\"exassess\" cols=\"60\" rows=\"28\">"+asscontent+"</textarea></td></tr>");
RS.close();
}else
out.println(" <td colspan=\"2\" valign=\"top\" bgcolor=\"#dce8f3\"> <textarea name=\"exassess\" cols=\"60\" rows=\"28\"></textarea></td></tr>");

if (!exfile.equalsIgnoreCase("null"))
out.println("<tr><td height=\"16\" colspan=\"5\" valign=\"top\" bgcolor=\"#dce8f3\">该作业包含附件:<a href = /exupload/"+studentid+"/"+exfile+"> "+exfile+"</a></td>");
else
out.println("<tr><td height=\"16\" colspan=\"5\" valign=\"top\" bgcolor=\"#dce8f3\">该作业没有包含附件</td>");
if(mark.equalsIgnoreCase("null"))
out.println("<td colspan=\"2\" valign=\"middle\" bgcolor=\"#dce8f3\">成绩： <input name=\"exmark\" type=\"text\" id=\"exmark\" size=\"3\" maxlength=\"3\"><input type=\"hidden\" name=\"exid\" value = '"+exid+"'></td></tr>");
else
out.println("<td colspan=\"2\" valign=\"middle\" bgcolor=\"#dce8f3\">成绩： <input name=\"exmark\" type=\"text\" value = \""+mark+"\"id=\"exmark\" size=\"3\" maxlength=\"3\"><input type=\"hidden\" name=\"exid\" value = '"+exid+"'><input type=\"hidden\" name=\"assess\" value =\"ok\"></td></tr>");
rs.close();

}catch(SQLException e){
System.err.println(e.getMessage());
}
out.println("<tr><td height=\"17\" colspan=\"7\" valign=\"top\"><hr size=\"0\"></td></tr>");
out.println("<tr><td width=\"229\" height=\"16\" valign=\"top\"> </td>");
out.println("<td colspan=\"2\" align=\"center\" valign=\"middle\"><input type=\"submit\" name=\"Submit\" value=\"提交批改\"></td>");
out.println("<td colspan=\"3\" align=\"center\" valign=\"middle\"><input type=\"reset\" name=\"Submit2\" value=\"重新批改\"></td>");
out.println("<td width=\"262\" valign=\"top\"> </td></tr>");
out.println("<tr><td height=\"0\"></td><td></td><td></td><td width=\"14\"></td><td width=\"7\"></td><td width=\"192\"></td><td></td></tr>");
out.println("<tr><td height=\"1\"></td><td width=\"61\"></td><td width=\"150\"></td><td></td><td></td><td></td><td></td></tr></table></form>");
out.println("</div></body></html>");
}
//Clean up resources
public void destroy() {
}
}

...全文