紧急求助,请达人帮忙看看~~~~~
小D才开始学JSP,遇到一个奇怪的问题。
从前一个页面中点了一个链接,http://localhost:8080/exAssess?exid=10,但是老是说The requested resource (/exAssess) is not available.但是exAssess.java在啊?搞不懂了~
干脆偶把exAssess.java的代码也贴出来,望达人帮偶看看~谢谢~253~~~
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();
System.out.print("hao");
String exid = request.getParameter("exid").trim();
System.out.print(exid);
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\"><!--td { font-size: 9pt;}--></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\"><!--DWLayoutTable-->");
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\"><!--DWLayoutEmptyCell--> </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\"><!--DWLayoutEmptyCell--> </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() {
}
}