selectbean.java

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

package users;

import java.sql.*;
import javax.sql.DataSource;

public class selectbean {
    Connection conn;
    Statement stm;
    ResultSet rest;

    public selectbean(DataSource ds) {
        try{
            conn =ds.getConnection();
        }catch(Exception e){}
    }

    public ResultSet select(String examtype,String claorsub)throws Exception{
        stm = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
        if (examtype.equals("gxkz")) {

            rest = stm.executeQuery("select * from gxkzinfo where subject like '%" + claorsub + "%'");
        }
        if (examtype.equals("ynks")) {

            rest = stm.executeQuery(
                    "select * from ynksinfo where classname like '%" +claorsub + "%'");
            if(!rest.next()){
                rest = stm.executeQuery(
                        "select * from ynksinfo where subject like '%" +claorsub + "%'");
            }
        }
        System.out.println("claorsub"+claorsub);
       return rest;
    }
}