<%@ page contentType="text/html; charset=utf-8" language="java" import="java.sql.*" errorPage="errorpage.jsp" %><%@ page import="java.io.*"%><%@ page import="java.util.*"%><html xmlns="[url]http://www.w3.org/1999/xhtml[/url]"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>学生</title> </head><jsp:useBean id="student" scope="page" class="student.class"/> <body bgcolor="#0099FF" text="#FFFFFF" link="#33FF00"> <p> <% String admin_id = (String)session.getAttribute("id"); if(admin_id==null){response.sendRedirect("login.jsp");} String name="",id="",password="",jiguan="",dep="",sex="",tel="",mail=""; int mark=0; %> </p> <p> </p><p align="center"><font color="#00FF00" size="+3" face="华文行楷">所有学生</font></p><p><a href="addstudent.jsp"><font size="+1" face="华文行楷">新加学生</font></a></p> <div align="center"> <table width="75%" border="1"> <tr> <td>学生号</td> <td>姓名</td> <td>密码</td> <td>籍贯</td> <td>系别</td> <td>性别</td> <td>学分</td> <td>电话</td> <td><p>E_mail</p></td> <td>删除</td> <td>更新</td> </tr><% ResultSet rs = student.getStudent(); while(rs.next()){ id=rs.getString("id"); name=rs.getString("name"); password=rs.getString("password"); jiguan=rs.getString("jiguan"); dep=rs.getString("department"); sex=rs.getString("sex"); mark=rs.getInt("mark"); tel=rs.getString("tel"); if(tel==null || tel.equals("")) tel="没有"; mail=rs.getString("e_mail"); if(mail==null || mail.equals("")) mail="没有";%> <tr> <td><%=id%></td> <td><%=name%></td> <td><%=password%></td> <td><%=jiguan%></td> <td><%=dep%></td> <td><%=sex%></td> <td><%=mark%></td> <td><%=tel%></td> <td><%=mail%></td> <td><a href="StudentSvlt?action=delete&id=<%=id%>">删除</a></td> <td><a href="updatestu.jsp?id=<%=id%> ">更新</a> </td> </tr> <% } %> </table> </div> <p align="center"> </p><a href="admin.jsp"><<Back </a> </body></html>
import java.sql.*;public class student { private String name; private String password; private String id; private String jiguan; private String sex; private String dep; public void setDep(String s){dep=s;} public String getDep(){return dep;} public void setSex(String s){sex=s;} public String getSex(){return sex;} public String getId() { return id; } public void setId(String id) { this.id = id; } public String getName() { return name; } public void setName(String name) { this.name = name; } public String getPassword() { return password; } public void setPassword(String password) { this.password = password; } public String getJiguan() { return jiguan; } public void setJiguan(String jiguan) { this.jiguan = jiguan; } //检查该学生是否已经注册 public boolean hasLogin(String id){ boolean f=true; String sql="select id from student where id ='"+id+"'"; sqlBean db =new sqlBean(); try{ ResultSet rs=db.executeQuery(sql); if(rs.next()){ f=false;} else{ f=true;} }catch(Exception e){ e.getMessage();} return f; } public ResultSet getStudent(){ String sql="select * from student "; sqlBean db= new sqlBean(); ResultSet rs = db.executeQuery(sql); return rs; } public void updateStudent(){ String sql="update student "+ " set name='"+name+"',sex='"+sex+"',department='"+dep+"', "+ "password='"+password+"',jiguan='"+jiguan+"' "+ " where id='"+id+"' "; sqlBean db= new sqlBean(); db.executeInsert(sql); } public void deleteStudent(){ String sql="delete from student where id ='"+id+"' "; sqlBean db= new sqlBean(); db.executeDelete(sql); } public int deleteStudent(String id){ int num=0; String sql="delete from student where id ='"+id+"' "; sqlBean db= new sqlBean(); num=db.executeDelete(sql); return num; } public void addStudent() { String sql="insert into student(name,password,id,sex,department,jiguan) "+ "VALUES('"+name+"','"+password+"','"+id+"','"+sex+"','"+dep+"','"+jiguan+"')"; sqlBean db =new sqlBean(); db.executeInsert(sql); } }
HTTP Status 500 - --------------------------------------------------------------------------------type Exception reportmessage description The server encountered an internal error () that prevented it from fulfilling this request.exception org.apache.jasper.JasperException: /getStudent.jsp(10,0) The value for the useBean class attribute student.class is invalid. org.apache.jasper.compiler.DefaultErrorHandler.jspError(DefaultErrorHandler.java:40) org.apache.jasper.compiler.ErrorDispatcher.dispatch(ErrorDispatcher.java:407) org.apache.jasper.compiler.ErrorDispatcher.jspError(ErrorDispatcher.java:148) org.apache.jasper.compiler.Generator$GenerateVisitor.visit(Generator.java:1175) org.apache.jasper.compiler.Node$UseBean.accept(Node.java:1117) org.apache.jasper.compiler.Node$Nodes.visit(Node.java:2164) org.apache.jasper.compiler.Node$Visitor.visitBody(Node.java:2214) org.apache.jasper.compiler.Node$Visitor.visit(Node.java:2220) org.apache.jasper.compiler.Node$Root.accept(Node.java:457) org.apache.jasper.compiler.Node$Nodes.visit(Node.java:2164) org.apache.jasper.compiler.Generator.generate(Generator.java:3322) org.apache.jasper.compiler.Compiler.generateJava(Compiler.java:199) org.apache.jasper.compiler.Compiler.compile(Compiler.java:296) org.apache.jasper.compiler.Compiler.compile(Compiler.java:277) org.apache.jasper.compiler.Compiler.compile(Compiler.java:265) org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:564) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:299) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:315) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265) javax.servlet.http.HttpServlet.service(HttpServlet.java:803)note The full stack trace of the root cause is available in the Apache Tomcat/5.5.23 logs.
引用第143楼zc1984于2007-05-18 11:39发表的:The server encountered an internal error () ~~~~~~蝈蝈检查一下服务器的配置~~~然后写一个最简单的程序去测试一下服务器是否能够正常工作~~~~~.......
引用第145楼zc1984于2007-05-18 17:59发表的:如何确定fwq没有问题的呢？
.gif)
[ 此贴被zc1984在2007-03-24 20:49重新编辑 ]
