applydao.java

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

package edu.yinhe.mis.model;

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

import edu.yinhe.mis.dto.ApplyDTO;
import edu.yinhe.mis.vo.ApplyVO;
import edu.yinhe.mis.vo.TeacherVO;
import edu.yinhe.system.model.BaseDAO;

/**
 * 
 * @author 贺志国
 *
 */
public class ApplyDAO extends BaseDAO {

	public Object delete(Object arg0) throws SQLException {
		return null;
	}

	public Object find() throws SQLException {
		PreparedStatement ps = null;
		ResultSet rs = null;
		ApplyVO avo = null;
		ArrayList list = new ArrayList();
		String SQL = null;
		SQL ="SELECT APPLYMAN,WORKNO,RESEARCHGROUP,TEACHCLASS,TEACHCOURSE,REASON,INSTEADMAN,STARTDATE,ENDDATE,APPLYTIME FROM apply ORDER BY ID DESC";
		ps = conn.prepareStatement(SQL);
		rs=ps.executeQuery();
		while(rs.next()){
			avo = new ApplyVO();
			avo.setApplyMan(rs.getString("APPLYMAN"));
			avo.setWorkNo(rs.getString("WORKNO"));
			avo.setResearchGroup(rs.getString("RESEARCHGROUP"));
			avo.setTeachClass(rs.getString("TEACHCLASS"));
			avo.setTeachCourse(rs.getString("TEACHCOURSE"));
			avo.setInsteadMan(rs.getString("INSTEADMAN"));
			avo.setStartDate(rs.getString("STARTDATE"));
			avo.setEndDate(rs.getString("ENDDATE"));
			avo.setReason(rs.getString("REASON"));
			avo.setApplyTime(rs.getString("APPLYTIME"));
			list.add(avo);
		}
		return list;
	}


	/**
	 * 查找调课替代人,分页显示
	 * @return 替代人的集合list
	 */
	public Object find(Object obj) throws SQLException {
		PreparedStatement ps = null;
		ResultSet rs = null;
		String SQL = null;
		ApplyDTO dto = (ApplyDTO)obj;
		TeacherVO tvo = null;
		ArrayList list = new ArrayList();
		Object[] objs = new Object[2];
		
		objs[0] = this.findById(dto);
		SQL = "SELECT ID,TEACHER_NAME,TEACHER_NO FROM teacher WHERE TEACHER_ABILITY="+dto.getTeachCourse();
		ps = conn.prepareStatement(SQL);
	    rs = ps.executeQuery();
	    while(rs.next()){
	    	tvo = new TeacherVO();
	    	tvo.setId(rs.getInt("ID"));
	    	tvo.setTeacher_name(rs.getString("TEACHER_NAME"));
	    	tvo.setTeacher_no(rs.getString("TEACHER_NO"));
	    	list.add(tvo);
	    }
	    objs[1] = list;
		return objs;
	}
	
	
	public Object findAll() throws SQLException {
		return null;
	}
	/**
	 * 得到申请人列表,分页显示
	 * @return 对象数组objs
	 */
	public Object findAll(Object obj) throws SQLException {
		PreparedStatement ps = null;
		ResultSet rs = null;
		ArrayList list = new ArrayList();//此处不能为ArrayList list = null;必须new ArrayList();否则list.add(vo)会出错,不会放到list里面;
		ApplyVO applyVO = null;
		ApplyDTO dto = (ApplyDTO)obj;
		String SQL = null;
		Object[] objs = new Object[2];
		
		objs[0] = this.getCount(dto);
		SQL = "SELECT ID,APPLYMAN,WORKNO,RESEARCHGROUP,TEACHCLASS,TEACHCOURSE,REASON,INSTEADMAN,STARTDATE,ENDDATE,APPLYTIME FROM apply ORDER BY ID DESC limit ?,?";
		ps = conn.prepareStatement(SQL);
		ps.setInt(1, (Integer.parseInt(dto.getCurrentPage())-1)*Integer.parseInt(dto.getRowperPage()));
		ps.setInt(2,Integer.parseInt(dto.getRowperPage()));
		rs = ps.executeQuery();
		while(rs.next()){
		applyVO = new ApplyVO();//每循环一次就new一个对象
		applyVO.setId(rs.getInt("ID"));
		applyVO.setApplyMan(rs.getString("APPLYMAN"));
		applyVO.setWorkNo(rs.getString("WORKNO"));
		applyVO.setResearchGroup(rs.getString("RESEARCHGROUP"));
		applyVO.setTeachClass(rs.getString("TEACHCLASS"));
		applyVO.setTeachCourse(rs.getString("TEACHCOURSE"));
		applyVO.setInsteadMan(rs.getString("INSTEADMAN"));
		applyVO.setStartDate(rs.getString("STARTDATE"));
		applyVO.setEndDate(rs.getString("ENDDATE"));
		applyVO.setReason(rs.getString("REASON"));
		applyVO.setApplyTime(rs.getString("APPLYTIME"));
		    list.add(applyVO);
		}
		objs[1] = list;
		return objs;
	}

	/**
	 * 根据id查看指定的申请人信息
	 * @return applyVO
	 */
	public Object findById(Object obj) throws SQLException {
		PreparedStatement ps = null;
		ResultSet rs = null;
		ApplyDTO dto = (ApplyDTO)obj;
		ApplyVO applyVO = null;
		String SQL = null;
		
		SQL = "SELECT ID,APPLYMAN,WORKNO,RESEARCHGROUP,TEACHCLASS,TEACHCOURSE,REASON,INSTEADMAN,STARTDATE,ENDDATE,APPLYTIME FROM apply WHERE id=?";
		ps = conn.prepareStatement(SQL);
		ps.setInt(1, dto.getId());
		rs = ps.executeQuery();
		while(rs.next()){
		applyVO = new ApplyVO();//每循环一次就new一个对象
		applyVO.setId(rs.getInt("ID"));
		applyVO.setApplyMan(rs.getString("APPLYMAN"));
		applyVO.setWorkNo(rs.getString("WORKNO"));
		applyVO.setResearchGroup(rs.getString("RESEARCHGROUP"));
		applyVO.setTeachClass(rs.getString("TEACHCLASS"));
		applyVO.setTeachCourse(rs.getString("TEACHCOURSE"));
		applyVO.setInsteadMan(rs.getString("INSTEADMAN"));
		applyVO.setStartDate(rs.getString("STARTDATE"));
		applyVO.setEndDate(rs.getString("ENDDATE"));
		applyVO.setReason(rs.getString("REASON"));
		applyVO.setApplyTime(rs.getString("APPLYTIME"));
		}
		return applyVO;
	}

	public Object findByObject(Object obj) throws SQLException {
		PreparedStatement ps = null;
		ResultSet rs = null;
		ApplyVO avo = null;
		ApplyDTO dto = (ApplyDTO)obj;
		ArrayList list = new ArrayList();
		Object[] objs = new Object[2];
		String SQL = null;
		objs[0] = this.insert(dto);
		SQL ="SELECT APPLYMAN,WORKNO,RESEARCHGROUP,TEACHCLASS,TEACHCOURSE,REASON,INSTEADMAN,STARTDATE,ENDDATE,APPLYTIME FROM apply";
		ps = conn.prepareStatement(SQL);
		rs = ps.executeQuery();
		while(rs.next()){
			avo = new ApplyVO();
			avo.setApplyMan(rs.getString("APPLYMAN"));
			avo.setWorkNo(rs.getString("WORKNO"));
			avo.setResearchGroup(rs.getString("RESEARCHGROUP"));
			avo.setTeachClass(rs.getString("TEACHCLASS"));
			avo.setTeachCourse(rs.getString("TEACHCOURSE"));
			avo.setInsteadMan(rs.getString("INSTEADMAN"));
			avo.setStartDate(rs.getString("STARTDATE"));
			avo.setEndDate(rs.getString("ENDDATE"));
			avo.setReason(rs.getString("REASON"));
			avo.setApplyTime(rs.getString("APPLYTIME"));
			list.add(avo);
		}
		objs[1] = list;
		return objs;
	}

	public int getCount(Object obj) throws SQLException {
        PreparedStatement ps = null;
        ResultSet rs = null;
        Integer count = new Integer(0);
        String SQL = null;
        SQL = "SELECT COUNT(*) FROM apply";
        ps = conn.prepareStatement(SQL);
        rs = ps.executeQuery();
        while(rs.next()){
        	count = rs.getInt(1);
        }
        System.out.println(count);
		return count;
	}

	public Object getMaxId(Object obj) throws SQLException {
		return null;
	}

	/**
	 * 将申请人信息插入到数据库
	 * @return boolean值
	 */
	public Object insert(Object obj) throws SQLException {
		PreparedStatement ps = null;
		ApplyDTO dto = null;
		String SQL = null;
		int Index=0;
		int i =0;
		boolean flag =  false;

		try {
			SQL = "INSERT INTO apply(APPLYMAN,WORKNO,RESEARCHGROUP,TEACHCLASS,TEACHCOURSE,REASON,INSTEADMAN,STARTDATE,ENDDATE,APPLYTIME) values(?,?,?,?,?,?,?,?,?,?)";
			dto = (ApplyDTO) obj;
			ps = conn.prepareStatement(SQL);
			ps.setString(++Index, dto.getApplyMan());
			ps.setString(++Index, dto.getWorkNo());
			ps.setString(++Index, dto.getResearchGroup());
			ps.setString(++Index, dto.getTeachClass());
			ps.setString(++Index, dto.getTeachCourse());
			ps.setString(++Index, dto.getReason());
			ps.setString(++Index, dto.getInsteadMan());
		    ps.setString(++Index, dto.getStartDate());
		    ps.setString(++Index, dto.getEndDate());
			ps.setString(++Index, dto.getApplyTime());
			i = ps.executeUpdate();
			conn.commit();
			if(i==1){
				flag = true;
			}
		} catch (RuntimeException e) {
			e.printStackTrace();
		}finally{
			if(ps!=null)ps.close();
			dto = null;
			SQL = null;
		}
		return flag;
	}
	
	public Object update(Object arg0) throws SQLException {
		PreparedStatement ps =  null;
		ApplyDTO dto = (ApplyDTO)arg0;
		boolean flag = false;
		int i = 0;
		String SQL = null;
//		Object[] objs = new Object[2];
		String agree = "";
		if(dto.getCurrentPage()==null){
			agree= "";
		}else{
			agree = dto.getCurrentPage();
		}
		if(agree.equals("11")){
			SQL ="UPDATE pktable SET teacher_name=?,teacher_no=? WHERE id=?";
			ps = conn.prepareStatement(SQL);
			ps.setString(1,dto.getTeacher_name());
			ps.setString(2,dto.getTeacher_no());
			ps.setInt(3, dto.getId());
			i = ps.executeUpdate();
			if(i!=-1){
				flag = true;
			}
		}else{
			SQL ="UPDATE apply SET INSTEADMAN=? WHERE ID=?";
			ps = conn.prepareStatement(SQL);
			ps.setString(1, dto.getTeacher_name());
			ps.setInt(2, dto.getId());
			i = ps.executeUpdate();
			if(i!=-1){
				flag = true;
			}
		}

		return flag;
	}

}