newsbean.java

sql+struts+jsp 提供考试的一般需求

package users;
import javax.sql.DataSource;
import java.sql.*;
import users.newsForm;
import java.util.ArrayList;

public class newsBean {
    Connection conn=null;
    public newsBean(DataSource ds)throws Exception {
        conn=ds.getConnection();
    }
    public ArrayList nsearch(String id){
        ArrayList a=new ArrayList();
        try{
            Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
            String sql="select * from news where n_id="+id;
            ResultSet rst=stmt.executeQuery(sql);
            newsForm f=new newsForm();
            while(rst.next()){
                f.setTopic(rst.getString(2));
                f.setContent(rst.getString(3));
                f.setTime(rst.getString(4));
                f.setAuthor(rst.getString(5));
                a.add(f);
            }
        }catch(Exception e){
            e.printStackTrace();
        }
        return a;
    }
}