我是用STRUTS写的一个从数据库中取出数据在页面显示的例子
第一个是javabean:
代码如下:
package bbs.domain;
public class Bbs{
    private int id;
    private String bbsname;
    private String lasttop;
    private String lastaut;
    private String master;
    private int today;
    private int topicnumber;
    private int postnumber;
    
    public void setId(int id){
        this.id = id;
    }
    public int getId(){
        return id;
    }
    public void setBbsname(String bbsname){
        this.bbsname = bbsname;
    }
    public String getBbsname(){
        return bbsname;
    }
    public void setLasttop(String lasttop){
        this.lasttop = lasttop;
    }
    public String getLasttop(){
        return lasttop;
    }
    public void setLastaut(String lastaut){
        this.lastaut = lastaut;
    }
    public String getLastaut(){
        return lastaut;
    }
    public void setMaster(String master){
        this.master = master;
    }
    public String getMaster(){
        return master;
    }
    public void setToday(int today){
        this.today = today;
    }
    public int getToday(){
        return today;
    }
    public void setTopicnumber(int topicnumber){
        this.topicnumber = topicnumber;
    }
    public int getTopicnumber(){
        return topicnumber;
    }
    public void setPostnumber(int postnumber){
        this.postnumber = postnumber;
    }
    public int getPostnumber(){
        return postnumber;
    }
}
第二个程序是一个ActionForm:
package bbs.domain;
import java.util.Vector;
import org.apache.struts.action.ActionForm;
public class BbsBean extends ActionForm{
    private Vector data;
    public void setData(Vector v){
        this.data = v;
    }
    public Vector getData(){
        return this.data;
    }
}
第三个是Action:
package bbs.action;
/*
*描述:显示信息
*@author bluedreams
*@version 2.0
*/
import java.sql.*;
import java.util.Vector;
import javax.sql.DataSource;
import javax.servlet.http.*;
import org.apache.struts.action.*;
import bbs.domain.*;
public class BbsListAction extends Action{
    public ActionForward execute(ActionMapping mapping,
                                ActionForm form,
                                HttpServletRequest request,
                                HttpServletResponse response)
            throws Exception{
        BbsBean bbsBean = (BbsBean)form;
        DataSource dataSource;
        Connection conn = null;
        ResultSet rs;
        Statement stm;
        try{
            dataSource = getDataSource(request,"mybbs");
            conn = dataSource.getConnection();
            stm = conn.createStatement();
            String sql ="select * from bbslist";
            rs = stm.executeQuery(sql);
            Vector v = new Vector();
            Bbs bbs =null;
            while(rs.next()){
                bbs = new Bbs();
                bbs.setId(rs.getInt("id"));    
                bbs.setBbsname(rs.getString("bbsname"));
                bbs.setLasttop(rs.getString("lasttop"));
                bbs.setLastaut(rs.getString("lastaut"));
                bbs.setMaster(rs.getString("master"));
                bbs.setToday(rs.getInt("today"));
                bbs.setTopicnumber(rs.getInt("topicnumber"));
                bbs.setPostnumber(rs.getInt("postnumber"));
                v.add(bbs);
            }
                bbsBean.setData(v);
                request.setAttribute("bbslist",bbsBean.getData());
        }catch(Exception e){
            e.printStackTrace();
        }finally{
            try{
                if(conn!=null){
                    conn.close();
                }
            }catch(Exception e){
                e.printStackTrace();
            }
        }
            return mapping.findForward("bbslist");
    }
}
错误信息显示是该行出错了
我怎么检查都感觉没错
谁来帮帮忙啊
[此贴子已经被作者于2006-10-25 13:29:23编辑过]



											
	    

	
										
					
	