testpaperruledao.java

中应用程序的访问权限对Java Web Console 中应用程序的访问权限 成功登录 Web 控制台后,可能无法自动访问在该控制台中注册的所有应用程序。通常,必须安装应用程序,才能让所有的用户在控制

package edu.yinhe.mis.model;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;

import edu.yinhe.mis.dto.DemoDTO;
import edu.yinhe.mis.dto.TestpaperruleDTO;
import edu.yinhe.mis.vo.DemoVO;
import edu.yinhe.mis.vo.TestpaperruleVO;
import edu.yinhe.system.model.BaseDAO;
import edu.yinhe.system.model.IBaseDAO;
/**
 * 
 * @author 王丹
 *
 */

public class TestpaperruleDAO extends BaseDAO {

	public Object delete(Object obj) throws SQLException {
		
		String sql=null;
		PreparedStatement ps =null;
		int n=-1;
		int m=0;
		Integer k = 0;
		String[] str=new String[2];
		try {
			TestpaperruleVO vo=new TestpaperruleVO();
			str=(String[])obj;
			sql="DELETE FORM testpaperrule WHERE ID=?";
			ps=conn.prepareStatement(sql);
			ps.setInt(1, m);
			n=ps.executeUpdate();
			if(n!=-1){
				k = 1;
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}finally{
			if(ps!=null)ps.close();
			sql=null;
		}
		return k;
	}
 
	public Object find() throws SQLException {
		
		
		
		return null;
	}

	public Object find(Object arg0) throws SQLException {

		return null;
	}

	public Object findAll() throws SQLException {

		return null;
	}

	public Object findAll(Object obj) throws SQLException {

		StringBuffer sb = new StringBuffer("SELECT * FROM testpaperrule WHERE 1 = 1");
		String SQL=null;
		PreparedStatement pstat=null;
		ResultSet rs = null;
		Object []objs = new Object[2];
		TestpaperruleVO vo=new TestpaperruleVO();
		TestpaperruleDTO dto = (TestpaperruleDTO)obj;
		ArrayList list = new ArrayList();
		Integer count = new Integer(0);
		try{
			count = this.getCount(dto);
			SQL=sb.toString();
			pstat = conn.prepareStatement(SQL);
			rs = pstat.executeQuery();
			while(rs.next()){
				vo=new TestpaperruleVO();
				vo.setTestPaperRuleNo(rs.getString("testPaperRuleNo"));
				vo.setQuestionTypeID(rs.getInt("questionTypeID"));
				vo.setObjectName(rs.getString("objectName"));
				vo.setQuestionAmount(rs.getInt("questionAmount"));
				vo.setQuestionValue(rs.getInt("questionValue"));
				vo.setQuestionDifficultScale(rs.getString("questionDifficultScale"));
				vo.setRuleName(rs.getString("ruleName"));
				vo.setScoreScale(rs.getString("scoreScale"));
				vo.setSave1(rs.getString("save1"));
				list.add(vo);
			}
			objs[0]=list;
			objs[1]=count;
		}finally{
			if(pstat!=null)pstat.close();
			SQL=null;
			dto=null;
		}

		return objs;
	}

	public Object findById(Object obj) throws SQLException {
			Integer m = 0;
			TestpaperruleVO vo = null;
			ResultSet rs = null;
			PreparedStatement ps = null;
			String sql = null;

			try {
				m = (Integer)obj;
				sql = "SELECT q.TESTPAPERRULE_NO,q.QUESTIONTYPE_ID,q.OBJECT_NAME,q.QUESTIONAMOUNT," +
						"q.QUESTION_VALUE,q.QUESTIONDIFFICULTSCALE,q.RULENAME,q.SCORESCALE," +
						"q.SAVE1 from testpaperrule q WHERE  ID=?"; 
				ps = conn.prepareStatement(sql);
				ps.setInt(1, m);
				rs = ps.executeQuery();
				while(rs.next()){
					vo = new TestpaperruleVO();
					vo.setTestPaperRuleNo(rs.getString("testPaperRuleNo"));
					vo.setQuestionTypeID(rs.getInt("questionTypeID"));
					vo.setObjectName(rs.getString("objectName"));
					vo.setQuestionAmount(rs.getInt("questionAmount"));
					vo.setQuestionValue(rs.getInt("questionValue"));
					vo.setQuestionDifficultScale(rs.getString("questionDifficultScale"));
					vo.setRuleName(rs.getString("ruleName"));
					vo.setScoreScale(rs.getString("scoreScale"));
					vo.setSave1(rs.getString("save1"));
				}
			} catch (SQLException e) {
				e.printStackTrace();
			}finally{
				if(ps!=null) ps = null;
				if(rs!=null) rs = null;
				sql = null;
			}
			return vo;
		}

	public Object findByObject(Object arg0) throws SQLException {

		return null;
	}

	public int getCount(Object obj) throws SQLException {
			Integer integer = new Integer(0);
			String sql = "";
			StringBuffer sb = new StringBuffer("SELECT count(*) FROM testpaperrule WHERE 1 = 1");
			PreparedStatement ps = null;
			ResultSet rs = null;
			TestpaperruleVO vo=new TestpaperruleVO();
			TestpaperruleDTO dto = (TestpaperruleDTO)obj;
			Integer count = new Integer(0);
			try {

				if(dto.getRuleName()!=null&&!"".equals(dto.getRuleName())){
					sb.append(" AND ruleName like'%"+dto.getRuleName()+"%'");
				}
				sql = sb.toString();
				ps = conn.prepareStatement(sql);
				rs = ps.executeQuery();
				while(rs.next()){
					integer = new Integer(rs.getInt(1));
				}
			} catch (SQLException e) {
				e.printStackTrace();
			}finally{
				if(ps != null) ps.close();
				if(rs != null) rs.close();
				sql = null;
			}	
			return integer;
		}
	public Object getMaxId(Object arg0) throws SQLException {

		return null;
	}

	public Object insert(Object obj) throws SQLException {
		PreparedStatement ps =null;
		int n=0;
		TestpaperruleDTO dto=(TestpaperruleDTO)obj;
		String sql="insert into testpaperrule(TESTPAPERRULE_NO,QUESTIONTYPE_ID" +
				",OBJECT_NAME,QUESTIONAMOUNT,QUESTION_VALUE,QUESTIONDIFFICULTSCALE," +
				"RULENAME,SCORESCALE,SAVE1)"+"values(?,?,?,?,?,?,?,?,?)"; 
		
		try {
			ps=conn.prepareStatement(sql);
			ps.setString(1, dto.getTestPaperRuleNo());
			ps.setInt(2, dto.getQuestionTypeID());
			ps.setString(3, dto.getObjectName());
			ps.setInt(4, dto.getQuestionAmount());
			ps.setInt(5, dto.getQuestionValue());
			ps.setString(6,dto.getQuestionDifficultScale());
			ps.setString(7, dto.getRuleName());
			ps.setString(8, dto.getScoreScale());
			ps.setString(9, dto.getSave1());
			ps.executeUpdate();
			n = 1;
		}catch (SQLException e) {
			e.printStackTrace();
		}finally{
			if(ps!=null)ps.close();
			sql=null;
			dto=null;
		}
		return n;
	}
	public Object update(Object obj) throws SQLException {
		Integer m = 0;
		String sql="";
		TestpaperruleVO vo=new TestpaperruleVO();
		TestpaperruleDTO dto=new TestpaperruleDTO();
		Integer n=-1;
		PreparedStatement ps =null;
		ResultSet rs = null;
		
		try {
			dto = (TestpaperruleDTO)obj;
			sql="UPDATE testpaperrule SET TESTPAPERRULE_NO=?,QUESTIONTYPE_ID=?," +
					"OBJECT_NAME=?,QUESTIONAMOUNT=?,QUESTION_VALUE=?,QUESTIONDIFFICULTSCALE=?," +
					"RULENAME=?,SCORESCALE=?,SAVE1=?";
			ps=conn.prepareStatement(sql);
			ps.setString(1, dto.getTestPaperRuleNo());
			ps.setInt(2, dto.getQuestionTypeID());
			ps.setString(3, dto.getObjectName());
			ps.setInt(4, dto.getQuestionAmount());
			ps.setInt(5, dto.getQuestionValue());
			ps.setString(6,dto.getQuestionDifficultScale());
			ps.setString(7, dto.getRuleName());
			ps.setString(8, dto.getScoreScale());
			ps.setString(9, dto.getSave1());
			n = ps.executeUpdate();
			if(n!=-1){
				m = 1;
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}finally{
			if(ps!=null)ps.close();
			sql=null;
			dto=null;
		}
		return m;
	}

}