请教一个关于数据库连接的问题

源代码
<%@ page contentType = "text/html;charset=gb2312"%>
<%@ page import = "java.sql.*"%>
<%@ page import = "java.util.*"%>
<jsp:useBean id = "accessDB" scope = "page" class = "database.accessDB"/>
<html>
<head>
</title>学生信息</title>
<meta content = "text/html;charset = gb2312" http-equiv = "Cintent-Type" >
<link rel = "stylesheet" href = "main.css">
<script src = "changeRowColor.js"></script>
<script src = "onclickbutton.js"></script>
<script language = "javascript" src = "jsfunction.js"></script>
<script language = "javascript" type="text/javascript">
function showData(obj){
document.all.S_no.value = obj.cells.innerText.Trim();
document.all.Name.value = obj.cells.innerText.Trim();
document.all.Sex.value = obj.cells.innerText.Trim();
document.all.Politic.value = obj.cells.innerText.Trim();
document.all.Department.value = obj.cells.innerText.Trim();
document.all.Come.value = obj.cells.innerText.Trim();
document.all.Birth.value = obj.cells.innerText.Trim();
document.all.Memo.value = obj.cells.innerText.Trim();
}
function checkSubmit(){
if (form1.S_no.value == ""||isNumeric(form1.S_no.value)){
alert("请输入正确的学号!");
form1.S_no.focus();
return false;
}
else if (form1.Name.value == ""){
alert("请输入正确的姓名!");
form1.Name.focus();
return false;
}
else if (form1.Sex.value == ""){
alert("请输入正确的性别!");
form1.Sex.focus();
return false;
}
else if (form1.Politic.value == ""){
alert("请输入正确的政治面貌!");
form1.Politic.focus();
return false;
}
else if (form1.Department.value == ""){
alert("请输入正确的系!");
form1.Department.focus();
return false;
}
else if (form1.Come.value == ""){
alert("请输入正确的籍贯!");
form1.Come.focus();
return false;
}
else if (form1.Birth.value == ""){
alert("请输入正确的生日!");
form1.Birth.focus();
return false;
}
return true;
}
function check(form,operation){
if(operation == "新增"){
var dataTable = document.all.maintable;
var flag = true;
for(var i = 1;i<dataTable.row.length;i++)
{
if(dataTable.row[1].cells(0).innerText.Trim()==document.all.SD_no.value.Trim()){
alert('新增失败:学号为'+document.all.S_no.value+'的学生已经存在!');
form.S_no.focus();
flag = false;
}
}
if(flag){
form.operation.value = "add";
form.action = "carryout.jsp";
form.method = "post";
if(checkSubmit()){
form.submit();
}
}
}
if(operation=="修改"){
var flag = false;
var dataTable = document.all.maintable;
for(var i=1;-<dataTable.rows.length;i++)
{
if(dataTable.rows[i].cell(0).innerText.Trim()==document.all.S_no.value.Trim()){
flag=true;
}
}
if(!flag){
alert("修改失败:不能修改学号!");
}
else if(flag){
form.operation.value = "modify";
form.action="carryout.jsp";
form.method="post";
if(checkSubmit()){
form.submit();
}

}
}
if(operation=="删除"){
var flag= false;
var dataTable=document.all.maintable;
for(var i=1;i<dataTable.rows.length;i++){
if(dataTable.rows[i].cells(0).innerText.Trim()==document.all.S_no.value.Trim()){
flag=true;
}
}
if(!flag){
alert("删除失败:不存在该学生学号!");
else if (confirm("确定要删除此项?")){
if(flag){
form.operation.value="del";
form.action="carryout.jsp";
form.method="post";
form.submit();
}
}
}
}
</script>
<style type="text/html">
</style>
</head>
<%
String S_no="";
String Name="";
String Sex="";
String Politic="";
String Department="";
String Come="";
String Birth="";
String Memo="";
ResultSet rs = null;
%>
<body class =mainInterface>
<form name="form1">
<TABLE class=listFame cellspacing-1 width-"100%">
<tr><td align=center><font size=4><string>学生信息</strong></font></td></tr>
</TABLE>
<TABLE border=1 cellspacing=0 width="100%" bordercolorlight=gray class=listFrame id="maintable">
<tr>
<TD height=5>
<div align="center">学生学号
</div></TD>
<TD height=5>
<div align="center">学生姓名
</div></TD>
<TD height=5>
<div align="center">学生性别
</div></TD>
<TD height=5>
<div align="center">政治面貌
</div></TD>
<TD height=5>
<div align="center">所在系别
</div></TD>
<TD height=5>
<div align="center">学生籍贯
</div></TD>
<TD height=5>
<div align="center">出生日期
</div></TD>
<TD height=5>
<div align="center">相关备注
</div></TD>
</TR>
<%
try{
  String sql="select * from tb_student order by S_no";
  rs = accessDB.executeQuery(sql);
   while(rs.next()){
   S_no = rs.getString("S_no");
   Name = rs.getString("Name");
   Sex = rs.getString("Sex");
   Politic = rs.getString("Politic");
   Department = rs.getString("Department");
   Come = rs.getString("Come");
   Birth = rs.getString("Birth");
   Memo = rs.getString("Memo");
%>
<tr onClick="showData(this);"onMouseDown="changeColor(this);"
onMouseOver=this.style.curor="hand" >
<TD height=5>
<div align="center"><%=S_no%>
</div></TD>
<TD height=5>
<div align="center"><%=Name%>
</div></TD>
<TD height=5>
<div align="center"><%=Sex%>
</div></TD>
<TD height=5>
<div align="center"><%=Politic%>
</div></TD>
<TD height=5>
<div align="center"><%=Department%>
</div></TD>
<TD height=5>
<div align="center"><%=Come%>
</div></TD>
<TD height=5>
<div align="center"><%=Birth%>
</div></TD>
<TD height=5>
<div align="center"><%=Memo%>
</div></TD>
</TR>
<%
}
}
catch(Exception e){}
%>
</TABLE>
<table class = listFrame cellspacing=1 width="100%">
<tr>
<td align=right>
<input type="button" value="新增" name="add" class="buttonout2"
onClick="check(this.form.this.value)">
</td>
<td align=center>
<input type="button" value="修改" name="modify" class="buttonout2"
onClick="check(this.form.this.value)">
</td>
<td align=left>
<input type="button" value="删除" name="delete" c;ass="buttonout2"
onClick="check(this.form.this.value)">
</td>
</tr>
</table>
<table border="0" bordercolorlight="gray" with="100%" >
<tr>
<td width="30%"><div align="right">学号：</div></td>
<td with="70%"><input type="text" class="text" size="60" name="S_no"
maxlength="10"></td>
</tr>
<tr>
<div align="right">姓名：</div></td>
<input type="text" class="text" size="60" name="Name"
maxlength="8"></td>
</tr>
<tr>
<div align="right">性别：</div></td>
<input type="text" class="text" size="60" name="Sex"
maxlength="2"></td>
</tr>
<tr>
<div align="right">政治面貌：</div></td>
<input type="text" class="text" size="60" name="Politic"
maxlength="8"></td>
</tr>
<tr>
<div align="right">所在系别：</div></td>
<input type="text" class="text" size="60" name="Department"</td>
</tr>
<tr>
<div align="right">学生籍贯：</div></td>
<input type="text" class="text" size="60" name="Come"
</td>
</tr>
<tr>
<div align="right">出生日期：</div></td>
<input type="text" class="text" size="60" name="Birth"
maxlength="10"></td>
</tr>
<tr>
<div align="right">相关备注：</div></td>
<input type="text" class="text" size="60" name="Memo"
</td>
</tr>
</table>
</input type="hiden" name="operation">
</form>
</body>
</html>

我faint
E:\jakarta-tomcat-5.0.24\work\Catalina\localhost\_\org\apache\jsp\Student_005finfo_jsp.java:229:
你这个文件出错，把jsp的贴出来做什么…………

package org.apache.jsp;import javax.servlet.*;
import javax.servlet.http.*;
import javax.servlet.jsp.*;
import java.sql.*;
import java.util.*;public final class Student_005finfo_jsp extends org.apache.jasper.runtime.HttpJspBase
    implements org.apache.jasper.runtime.JspSourceDependent {  private static java.util.Vector _jspx_dependants;  public java.util.List getDependants() {
    return _jspx_dependants;
  }  public void _jspService(HttpServletRequest request, HttpServletResponse response)
        throws java.io.IOException, ServletException {    JspFactory _jspxFactory = null;
    PageContext pageContext = null;
    HttpSession session = null;
    ServletContext application = null;
    ServletConfig config = null;
    JspWriter out = null;
    Object page = this;
    JspWriter _jspx_out = null;
    PageContext _jspx_page_context = null;
    try {
      _jspxFactory = JspFactory.getDefaultFactory();
      response.setContentType("text/html;charset=gb2312");
      pageContext = _jspxFactory.getPageContext(this, request, response,
       null, true, 8192, true);
      _jspx_page_context = pageContext;
      application = pageContext.getServletContext();
      config = pageContext.getServletConfig();
      session = pageContext.getSession();
      out = pageContext.getOut();
      _jspx_out = out;      out.write("\r\n");
      out.write("\r\n");
      out.write("\r\n");
      database.accessDB accessDB = null;
      synchronized (_jspx_page_context) {
        accessDB = (database.accessDB) _jspx_page_context.getAttribute("accessDB", PageContext.PAGE_SCOPE);
        if (accessDB == null){
          accessDB = new database.accessDB();
          _jspx_page_context.setAttribute("accessDB", accessDB, PageContext.PAGE_SCOPE);
        }
      }

out.write("\r\n");
      out.write("<html>\r\n");
      out.write("<head>\r\n");
      out.write("</title>瀛︾敓淇℃伅</title>\r\n");
      out.write("<meta content = \"text/html;charset = gb2312\" http-equiv = \"Cintent-Type\" >\r\n");
      out.write("<link rel = \"stylesheet\" href = \"main.css\">\r\n");
      out.write("<script src = \"changeRowColor.js\"></script>\r\n");
      out.write("<script src = \"onclickbutton.js\"></script>\r\n");
      out.write("<script language = \"javascript\" src = \"jsfunction.js\"></script>\r\n");
      out.write("<script language = \"javascript\" type=\"text/javascript\">\r\n");
      out.write("function showData(obj){\r\n");
      out.write("\tdocument.all.S_no.value = obj.cells.innerText.Trim();\r\n");
      out.write("\tdocument.all.Name.value = obj.cells.innerText.Trim();\r\n");
      out.write("\tdocument.all.Sex.value = obj.cells.innerText.Trim();\r\n");
      out.write("\tdocument.all.Politic.value = obj.cells.innerText.Trim();\r\n");
      out.write("\tdocument.all.Department.value = obj.cells.innerText.Trim();\r\n");
      out.write("\tdocument.all.Come.value = obj.cells.innerText.Trim();\r\n");
      out.write("\tdocument.all.Birth.value = obj.cells.innerText.Trim();\r\n");
      out.write("\tdocument.all.Memo.value = obj.cells.innerText.Trim();\r\n");
      out.write("}\r\n");
      out.write("function checkSubmit(){\r\n");
      out.write(" if (form1.S_no.value == \"\"||isNumeric(form1.S_no.value)){\r\n");
      out.write(" \talert(\"璇疯緭鍏ユ纭殑瀛﹀彿!\");\r\n");
      out.write(" \tform1.S_no.focus();\r\n");
      out.write(" \treturn false;\r\n");
      out.write(" \t}\r\n");
      out.write(" else if (form1.Name.value == \"\"){\r\n");
      out.write(" \talert(\"璇疯緭鍏ユ纭殑濮撳悕!\");\r\n");
      out.write(" \tform1.Name.focus();\r\n");
      out.write(" \treturn false;\r\n");
      out.write(" \t}\r\n");
      out.write("else if (form1.Sex.value == \"\"){\r\n");
      out.write(" \talert(\"璇疯緭鍏ユ纭殑鎬у埆!\");\r\n");
      out.write(" \tform1.Sex.focus();\r\n");
      out.write(" \treturn false;\r\n");
      out.write(" \t} \r\n");
      out.write(" else if (form1.Politic.value == \"\"){\r\n");
      out.write(" \talert(\"璇疯緭鍏ユ纭殑鏀挎不闈㈣矊!\");\r\n");
      out.write(" \tform1.Politic.focus();\r\n");
      out.write(" \treturn false;\r\n");
      out.write(" \t} \r\n");
      out.write(" else if (form1.Department.value == \"\"){\r\n");
      out.write(" \talert(\"璇疯緭鍏ユ纭殑绯?\");\r\n");
      out.write(" \tform1.Department.focus();\r\n");
      out.write(" \treturn false;\r\n");
      out.write(" \t} \r\n");
      out.write(" else if (form1.Come.value == \"\"){\r\n");
      out.write(" \talert(\"璇疯緭鍏ユ纭殑绫嶈疮!\");\r\n");
      out.write(" \tform1.Come.focus();\r\n");
      out.write(" \treturn false;\r\n");
      out.write(" \t} \r\n");
      out.write(" else if (form1.Birth.value == \"\"){\r\n");
      out.write(" \talert(\"璇疯緭鍏ユ纭殑鐢熸棩!\");\r\n");
      out.write(" \tform1.Birth.focus();\r\n");
      out.write(" \treturn false;\r\n");
      out.write(" \t} \r\n");
      out.write(" \treturn true;\r\n");

out.write(" \treturn true;\r\n");
      out.write(" }\r\n");
      out.write(" function check(form,operation){\r\n");
      out.write(" if(operation == \"鏂板\"){\r\n");
      out.write(" \tvar dataTable = document.all.maintable;\r\n");
      out.write(" \tvar flag = true;\r\n");
      out.write(" \tfor(var i = 1;i<dataTable.row.length;i++)\r\n");
      out.write(" \t{\r\n");
      out.write(" \t\tif(dataTable.row[1].cells(0).innerText.Trim()==document.all.SD_no.value.Trim()){\r\n");
      out.write(" \t\talert('鏂板澶辫触:瀛﹀彿涓?+document.all.S_no.value+'鐨勫鐢熷凡缁忓瓨鍦?');\r\n");
      out.write(" \t\tform.S_no.focus();\r\n");
      out.write(" \t\tflag = false;\r\n");
      out.write(" \t\t}\r\n");
      out.write(" \t}\r\n");
      out.write(" \tif(flag){\r\n");
      out.write(" \tform.operation.value = \"add\";\r\n");
      out.write(" \tform.action = \"carryout.jsp\";\r\n");
      out.write(" \tform.method = \"post\";\r\n");
      out.write(" \tif(checkSubmit()){\r\n");
      out.write(" \tform.submit();\r\n");
      out.write(" \t}\r\n");
      out.write(" \t}\r\n");
      out.write(" \t}\r\n");
      out.write(" if(operation==\"淇敼\"){\r\n");
      out.write(" var flag = false;\r\n");
      out.write(" var dataTable = document.all.maintable;\r\n");
      out.write(" for(var i=1;-<dataTable.rows.length;i++)\r\n");
      out.write(" {\r\n");
      out.write(" if(dataTable.rows[i].cell(0).innerText.Trim()==document.all.S_no.value.Trim()){\r\n");
      out.write(" flag=true;\r\n");
      out.write(" }\r\n");
      out.write(" }\r\n");
      out.write(" if(!flag){\r\n");
      out.write(" \talert(\"淇敼澶辫触:涓嶈兘淇敼瀛﹀彿!\");\r\n");
      out.write(" \t}\r\n");
      out.write(" \telse if(flag){\r\n");
      out.write(" \tform.operation.value = \"modify\";\r\n");
      out.write(" \tform.action=\"carryout.jsp\";\r\n");
      out.write(" \tform.method=\"post\";\r\n");
      out.write(" \tif(checkSubmit()){\r\n");
      out.write(" \t\tform.submit();\r\n");
      out.write(" \t\t}\r\n");
      out.write(" \t\t\r\n");
      out.write(" \t}\r\n");
      out.write(" }\r\n");
      out.write(" if(operation==\"鍒犻櫎\"){\r\n");
      out.write(" \tvar flag= false;\r\n");
      out.write(" \tvar dataTable=document.all.maintable;\r\n");
      out.write(" \tfor(var i=1;i<dataTable.rows.length;i++){\r\n");
      out.write(" \tif(dataTable.rows[i].cells(0).innerText.Trim()==document.all.S_no.value.Trim()){\r\n");
      out.write(" \t\tflag=true;\r\n");
      out.write(" \t\t}\r\n");
      out.write(" \t}\r\n");
      out.write(" \tif(!flag){\r\n");
      out.write(" \t\talert(\"鍒犻櫎澶辫触:涓嶅瓨鍦ㄨ瀛︾敓瀛﹀彿!\");\r\n");
      out.write(" \telse if (confirm(\"纭畾瑕佸垹闄ゆ椤?\")){\r\n");
      out.write(" \tif(flag){\r\n");
      out.write(" \tform.operation.value=\"del\";\r\n");
      out.write(" \tform.action=\"carryout.jsp\";\r\n");
      out.write(" \tform.method=\"post\";\r\n");
      out.write(" \tform.submit();\r\n");
      out.write(" \t}\r\n");
      out.write(" \t}\r\n");
      out.write(" \t}\r\n");
      out.write(" }\r\n");
      out.write(" </script>\r\n");
      out.write(" <style type=\"text/html\">\r\n");
      out.write(" </style>\r\n");
      out.write(" </head>\r\n");
      out.write(" "); String S_no="";
String Name="";
String Sex="";
String Politic="";
String Department="";
String Come="";
String Birth="";
String Memo="";
ResultSet rs = null;

估计是
database.accessDB 没有 executeQuery(String)方法。

错误提示是这样的
exception org.apache.jasper.JasperException: Unable to compile class for JSPAn error occurred at line: 172 in the jsp file: /Student_info.jspGenerated servlet error:
    [javac] Compiling 1 source fileE:\jakarta-tomcat-5.0.24\work\Catalina\localhost\_\org\apache\jsp\Student_005finfo_jsp.java:229: cannot find symbol
symbol  : method executeQuery(java.lang.String)
location: class database.accessDB
  rs = accessDB.executeQuery(sql);
                       ^
1 error

郁闷......不知道那里找你的sql语句拉...把关键贴出来不就行拉accessDB有定义吗?

调试易

请教一个关于数据库连接的问题

解决方案 »