调试JSP程序时出现500错误，请教各位该怎么改呢？

Question

jspbean

Answer 1

cpjs.jsp  面面的第3行有问题，把jsp代码贴 出来呀 。

Answer 2

我已经查看过，net\WebRoot\WEB-INF\classes\com\wsy是存在selectsql.class文件的
使用的语句是：<jsp:useBean id="sql" class="com.wsy.selectsql" scope="page"/>，
selectsql.class文件内容package com.wsy;
import java.sql.*;
import java.util.*;
import java.text.*;public class selectsql {
public static ResultSet rs;
public static StringTrans s;
public static connsqlserver connsqlserver=new connsqlserver();
/*
 * 鍏充簬tb_usertable琛ㄧ殑鎿嶄綔
 */

public static Collection getRet(){
Collection ret=new ArrayList(); try{
connsqlserver connsqlserver=new connsqlserver();
String sql="select * from tb_usertable";
rs=connsqlserver.executeQuery(sql);
while(rs.next()){
String names=rs.getString("name");
String passwords=rs.getString("password");
user user=new user();
user.setName(names);
user.setPassword(passwords);
ret.add(user);
}

}
catch(Exception e){
e.printStackTrace();
}
connsqlserver.close();
return ret;
}
public static int check(String name,String password){
int i=0;
String names="";
String passwords="";
try{
connsqlserver connsqlserver=new connsqlserver();
String sql="select * from tb_usertable where name='"+name+"'and password='"+password+"'";
System.out.println(sql);
rs=connsqlserver.executeQuery(sql);
while(rs.next()){
names=rs.getString("name");
passwords=rs.getString("password");
if(names!=null){
i=1;
}
}
}
catch(Exception e){
e.printStackTrace();
}
connsqlserver.close();
return i;
}
/*
 * 鍏充簬tb_news琛ㄧ殑鎿嶄綔
 */
public int Insert(String title,String author,String news){
int i=0;
try{
connsqlserver connsqlserver=new connsqlserver();
String sql="insert into tb_news(title,author,content) values('"+title+"','"+author+"','"+news+"')";
i=connsqlserver.executeUpdate(sql);
}catch(Exception e){
e.printStackTrace();
}
connsqlserver.close();
return i;
}
public void Insert1(String title,String author,String news){
try{
connsqlserver connsqlserver=new connsqlserver();
String sql="insert into tb_business(title,author,content) values('"+title+"','"+author+"','"+news+"')";
connsqlserver.executeUpdate(sql);
}catch(Exception e){
e.printStackTrace();
}
}
public Collection selectNewsAll(){
Collection ret=new ArrayList();
try{
connsqlserver connsqlserver=new connsqlserver();
String sql="select * from tb_news";
ResultSet rs=connsqlserver.executeQuery(sql);
while(rs.next()){
news news1=new news();
news1.setId(rs.getString("id"));
news1.setTitle(rs.getString("title"));
news1.setContent(rs.getString("content"));
news1.setAuthor(rs.getString("author"));
news1.setSubmittime(rs.getString("submittime"));
ret.add(news1);
}
}catch(Exception e){
e.printStackTrace();
}
connsqlserver.close();
return ret;

}
public Collection selectNews(String id){
Collection ret=new ArrayList();
try{
connsqlserver connsqlserver=new connsqlserver();
String sql="select * from tb_news where id='"+id+"'";
ResultSet rs=connsqlserver.executeQuery(sql);
while(rs.next()){
String ids=rs.getString("id");
String title=rs.getString("title");
String author=rs.getString("author");
String news=rs.getString("content");
news news1=new news();
news1.setId(ids);
news1.setTitle(title);
news1.setContent(news);
news1.setAuthor(author);
ret.add(news1);
}
}catch(Exception e){
e.printStackTrace();
}
connsqlserver.close();
return ret;

}
public Collection selectNews(){
Collection ret=new ArrayList();
try{
connsqlserver connsqlserver=new connsqlserver();
String sql="select top 6 * from tb_news";
ResultSet rs=connsqlserver.executeQuery(sql);
while(rs.next()){
String title=rs.getString(2);
String author=rs.getString(3);
String news=rs.getString(4);
news news1=new news();
news1.setTitle(title);
news1.setContent(news);
news1.setAuthor(author);
ret.add(news1);
}
}catch(Exception e){
e.printStackTrace();
}
connsqlserver.close();
return ret;

}
public Collection selectNewsforqyxw(){
Collection ret=new ArrayList();
try{
connsqlserver connsqlserver=new connsqlserver();
String sql="select top 15 * from tb_news";
ResultSet rs=connsqlserver.executeQuery(sql);
while(rs.next()){
String title=rs.getString(2);
String author=rs.getString(3);
String news=rs.getString(4);
news news1=new news();
news1.setTitle(title);
news1.setContent(news);
news1.setAuthor(author);
ret.add(news1);
}
}catch(Exception e){
e.printStackTrace();
}
connsqlserver.close();
return ret;

}
public  int updateNews(String title,String content,String author,String id){
int i=0;
try{ connsqlserver connsqlserver=new connsqlserver();
String sql="UPDATE tb_news SET title = '"+title+"', content = '"+content+"', author = '"+author+"' WHERE (id = '"+id+"')";
i=connsqlserver.executeUpdate(sql);
}catch(Exception e){
e.printStackTrace();
}
connsqlserver.close();
return i;
}
public int delNews(String id){
int i=0;
try{
connsqlserver connsqlserver=new connsqlserver();
String sql="delete from tb_news where id='"+id+"'";
i=connsqlserver.executeUpdate(sql);
}catch(Exception e){
e.printStackTrace();
}
connsqlserver.close();
return i;
}
/*
 * 鍏充簬tb_business琛ㄧ殑鎿嶄綔
 */
public Collection selectBusinessAll(){
Collection ret=new ArrayList();
try{
connsqlserver connsqlserver=new connsqlserver();
String sql="select * from tb_business";
ResultSet rs=connsqlserver.executeQuery(sql);
while(rs.next()){
product product=new product();
product.setId(rs.getString("id"));
product.setImg(rs.getString("img"));
product.setMsg(rs.getString("ms"));
product.setName(rs.getString("name"));
product.setSubmittime(rs.getString("submittime"));
product.setCategory(rs.getString("category"));
ret.add(product);
}
}catch(Exception e){
e.printStackTrace();
}
connsqlserver.close();
return ret;

}
public ResultSet selectbusiness(){
ResultSet rs=null;
try{
connsqlserver connsqlserver=new connsqlserver();
String sql="select  * from tb_business";
rs=connsqlserver.executeQuery(sql);
rs.last();
}catch(Exception e){
e.printStackTrace();
}
//connsqlserver.close();
return rs;

}
public Collection selectBusinessForId(String id){
Collection ret=new ArrayList();
try{
connsqlserver connsqlserver=new connsqlserver();
String sql="select * from tb_business where id='"+id+"'";
ResultSet rs=connsqlserver.executeQuery(sql);
while(rs.next()){
product product=new product();
product.setId(rs.getString("id"));
product.setImg(rs.getString("img"));
product.setMsg(rs.getString("ms"));
product.setName(rs.getString("name"));
product.setSubmittime(rs.getString("submittime"));
product.setCategory(rs.getString("category"));
ret.add(product);
}
}catch(Exception e){
e.printStackTrace();
}
connsqlserver.close();
return ret;

}
public Collection selectBusinessFy(int page){
Collection ret=new ArrayList();
DownTable down=new DownTable();
try{
connsqlserver connsqlserver=new connsqlserver();
String sql="select top 10 * from tb_business where id not in(select top "+down.getPageSize()*page+" id from tb_business  order by id)order by id";
//String sql="select * from (select top 20 * from (select top "+10*page+" * from tb_business order by id ASC)as aSysTable order by id desc) as bsystable order by id ASC";
//System.out.println(sql);
ResultSet rs=connsqlserver.executeQuery(sql);
while(rs.next()){
product product=new product();
product.setId(rs.getString("id"));
product.setImg(rs.getString("img"));
product.setMsg(rs.getString("ms"));
product.setName(rs.getString("name"));
product.setSubmittime(rs.getString("submittime"));
product.setCategory(rs.getString("category"));
ret.add(product);
}
}catch(Exception e){
e.printStackTrace();
}
connsqlserver.close();
return ret;

}

Answer 3

用到usebean的语句只有一句：<jsp:useBean id="sql" class="com.wsy.selectsql" scope="page"/>

Answer 4

把这个bean（com.wsy.selectsql）中所有的属性和方法都先注释掉，然后看看页面还报错

Answer 5

还是报同样的错误换个其它的bean（简单的，比如定义个Student)看看呢