testbo.java~38~

考试管理系统：实现学生信息的注册、修改、查询、删除；以及对试题进行管理：增加试题、修改试题、删除试题、查询试题

package edu.sccp.examManager.business;

import edu.sccp.examManager.database.ConnectBean;
import edu.sccp.examManager.tools.Tools;
import edu.sccp.examManager.VO.TestVO;
import java.util.ArrayList;
import java.sql.SQLException;
import java.sql.PreparedStatement;

/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2006</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class TestBO {
    public TestBO() {
    }

    public ArrayList findByAll(){
        ArrayList list=null;
        ConnectBean cb=new ConnectBean();
        if(!cb.openConnection()){
               Tools.showDialog("数据库连接失败！");
               return null;
           }
           try {
            cb.createPreparedStatement("select * from t_test");
            cb.executeQuery();
            list=new ArrayList();
            //String data = "试题编号**试题名称**试题类别**题干**选项A**选项B**选项C**选项D**正确答案**试题难度**备注";
            //list.add(data);
            while(cb.next()){
                TestVO test = new TestVO();
                test.setTestId(cb.getString(1));
                test.setTestName(cb.getString(2).trim());
                test.setTestType(cb.getString(3).trim());
                test.setTestContent(cb.getString(4).trim());
                test.setTestItemA(cb.getString(5).trim());
                test.setTestItemB(cb.getString(6).trim());
                test.setTestItemC(cb.getString(7).trim());
                test.setTestItemD(cb.getString(8).trim());
                test.setTestAnswer(cb.getString(9).trim());
                test.setDifficulty(cb.getString(10).trim());
                test.setTestMemo(cb.getString(11));
                list.add(test);
            }
        }
        catch (SQLException ex) {
            Tools.println(ex.getMessage());
            return null;
        }
        return list;
    }



    public ArrayList findBySubClass(String typeName){
        ArrayList list=null;
        ConnectBean cb=new ConnectBean();
        PreparedStatement ps=null;
        TestTypeBO tbo=new TestTypeBO();
        String typeId=tbo.findByTypeName(typeName);
        if(!cb.openConnection()){
               Tools.showDialog("数据库连接失败！");
               return null;
           }
           try {
            ps=cb.createPreparedStatement("select * from t_test where substring(f_testid,1,4)=?");
            ps.setString(1,typeId);
            //ps.setString(2,"%");
            cb.executeQuery();
            list=new ArrayList();
            String data = "试题编号**试题名称**试题类别**题干**选项A**选项B**选项C**选项D**正确答案**试题难度**备注";
            list.add(data);
            while(cb.next()){
                TestVO test = new TestVO();
                test.setTestId(cb.getString(1));
                test.setTestName(cb.getString(2).trim());
                test.setTestType(cb.getString(3).trim());
                test.setTestContent(cb.getString(4).trim());
                test.setTestItemA(cb.getString(5).trim());
                test.setTestItemB(cb.getString(6).trim());
                test.setTestItemC(cb.getString(7).trim());
                test.setTestItemD(cb.getString(8).trim());
                test.setTestAnswer(cb.getString(9).trim());
                test.setDifficulty(cb.getString(10).trim());
                test.setTestMemo(cb.getString(11));
                list.add(test);
            }
        }
        catch (SQLException ex) {
            Tools.println(ex.getMessage());
            return null;
        }
        return list;
    }

    public boolean addTest(TestVO test){
        System.out.println("testVO==="+test);
        boolean bl=false;
        ConnectBean cb=new ConnectBean();
        PreparedStatement ps=null;
        bl=false;
        try {
            if(!cb.openConnection()){
                Tools.showDialog("数据库连接失败！");
                return false;
            }
            ps=cb.createPreparedStatement("insert into t_test values(?,?,?,?,?,?,?,?,?,?,?)");//see material in API:java.sql  Interface PreparedStatement
            ps.setString(1,test.getTestId());
            ps.setString(2,test.getTestName());
            ps.setString(3,test.getTestType());
            ps.setString(4,test.getTestContent());
            ps.setString(5,test.getTestItemA());
            ps.setString(6,test.getTestItemB());
            ps.setString(7,test.getTestItemC());
            ps.setString(8,test.getTestItemD());
            ps.setString(9,test.getTestAnswer());
            ps.setString(10,test.getDifficulty());
            ps.setString(11,test.getTestMemo());
            ps.executeUpdate();
            bl=true;//insert transaction succeeded!!
        } catch (SQLException ex) {
            Tools.println(ex.getMessage());
            return bl;//insert failure!!
        }
        catch (Exception ex) {
            Tools.println(ex.getMessage());
            return bl;
        }
        return bl;
    }

    public boolean editTest(TestVO test){
        ConnectBean cb=new ConnectBean();
        PreparedStatement ps=null;
         boolean bl=false;
      if(!cb.openConnection()){
          Tools.showDialog("数据库连接失败！");
      }
      try {
          ps = cb.createPreparedStatement("update t_test set f_name=?,f_content=?,f_itemA=?,f_itemB=?,f_itemC=?,f_itemD=?,f_date=?,f_difficulty=? where f_testid=?", true);
          ps.setString(1,test.getTestName());
          ps.setString(2,test.getTestContent());
          ps.setString(3,test.getTestItemA());
          ps.setString(4,test.getTestItemB());
          ps.setString(5,test.getTestItemC());
          ps.setString(6,test.getTestItemD());
          ps.setString(7,test.getTestAnswer());
          ps.setString(8,test.getDifficulty());
          ps.setString(9,test.getTestId());
          ps.executeUpdate();
          bl= true;
      }catch (SQLException ex1) {
          Tools.println(ex1.getMessage());
          bl=false;
      }
    return bl;
    }

    public boolean deleteExaminee(String pk){
        boolean bl=false;
        ConnectBean cb=new ConnectBean();
        PreparedStatement ps=null;
        if(!cb.openConnection()){
            Tools.showDialog("数据库连接失败！");
            return false;
        }
        try {
            ps = cb.createPreparedStatement("delete from t_student where f_stuid=?", true);
            ps.setString(1, pk);
            ps.executeUpdate();
            bl=true;
        }catch (SQLException ex1) {
            Tools.showDialog("发生异常,即将退出......");
            Tools.println(ex1.getMessage());
            bl=false;
        }
        return bl;
    }


}