checkdao.java

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

package edu.yinhe.mis.model;
/**
 * 
 * @author 谢攀
 *
 */

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

import edu.yinhe.mis.dto.CheckDTO;
import edu.yinhe.mis.dto.StudentDTO;
import edu.yinhe.mis.vo.CheckVO;
import edu.yinhe.mis.vo.ClassesVO;
import edu.yinhe.mis.vo.StudentVO;
import edu.yinhe.system.model.BaseDAO;

public class CheckDAO extends BaseDAO{

	/**
	 *根据学生姓名删除根据学生姓名查询check表和student表中指定的信息；
	 * @throws SQLException
	 * @return boolean
	 */
	public Object delete(Object arg0) throws SQLException {
		// TODO Auto-generated method stub
		PreparedStatement ps=null;
		boolean flag=false;
		String sql=null;
		CheckDTO dto=(CheckDTO) arg0;
		sql="DELETE CLASS_NO,STU_NAME,STUDY_MARK,LATE,LEAVES,TRUANT FROM student WHERE WRITE_TIME=?";
		try {
			 ps=conn.prepareStatement(sql);
			 int i=ps.executeUpdate();
			 if(i!=-1){
			      flag=true;
			 }
		} catch (RuntimeException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			ps=null;		
		}
		return flag;
	}
	/**
	 * 查询class表的所有班级
	 * @throws SQLException
	 * @return boolean
	 */
	public Object find() throws SQLException {
		// TODO Auto-generated method stub
		PreparedStatement ps=null;
		ResultSet rs=null;
		List list=new ArrayList();
		ClassesVO vo=null;
		String sql="";
		
		try {
			sql="SELECT CLASS_NO FROM classes";
			ps=conn.prepareStatement(sql);
			rs=ps.executeQuery();
			while(rs.next()){
				vo = new ClassesVO();
				vo.setClassNo(rs.getString("CLASS_NO"));
				list.add(vo);
			}
		} catch (RuntimeException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			if(ps!=null){
				ps=null;
				sql=null;				
				rs=null;
				vo=null;
			}
		}
		return list;
	}
	
	/**
	 * 查询check表后student表中所有指定的信息；
	 * @throws SQLException
	 * @return list 查询完成，返回ArrayList集合。
	 */
	public Object findAll(Object arg0) throws SQLException {
		// TODO Auto-generated method stub
		PreparedStatement ps=null;
		ResultSet rs=null;
		ArrayList list=new ArrayList();
		CheckVO vo=null;
		String sql=null;
		int index=1;
		CheckDTO dto=(CheckDTO) arg0;
		sql="SELECT CLASS_NO,STU_NAME," +
				"STUDY_MARK,LATE,LEAVEES,TRUANT FROM student where 1=1";
		StringBuffer StrBuf=new StringBuffer(sql);
		try {
			if(dto.getClassNo()!=null&&!"".equals(dto.getClassNo())){
				StrBuf.append(" AND CLASS_NO='"+dto.getClassNo()+"'");
			}
			if(dto.getStuName()!=null&&!"".equals(dto.getStuName())){
				StrBuf.append(" AND STU_NAME='"+dto.getStuName()+"'");
			}
			StrBuf.append(" limit ?,?");
			sql = StrBuf.toString();
			ps=conn.prepareStatement(sql);
			ps.setInt(index++,(dto.getCurrentPage()-1)*dto.getPageSize());
			ps.setInt(index++, dto.getPageSize());
			rs =ps.executeQuery();			
		while(rs.next()){
			vo=new CheckVO();
            vo.setStuName(rs.getString("STU_NAME"));
            vo.setClassNo(rs.getString("CLASS_NO"));
            vo.setSturyMark(rs.getString("STUDY_MARK"));
            vo.setLate(rs.getString("LATE"));
            vo.setLeavees(rs.getString("LEAVEES"));
            vo.setTruant(rs.getString("TRUANT"));
            list.add(vo);
		   }
		}catch (RuntimeException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			if(ps!=null){
				ps=null;
				sql=null;
				StrBuf=null;
				rs=null;
				dto=null;
				vo=null;
			}
		}
		return list;
	}
	/**
	 * 根据学生姓名查询check表和student表中指定的信息；
	 * @throws SQLException
	 * @return list 查询完成，返回ArrayList集合。
	 */
	public Object findById(Object arg0) throws SQLException {
		// TODO Auto-generated method stub
		PreparedStatement ps=null;
		ResultSet rs=null;
		ArrayList list=new ArrayList();
		StudentVO svo=null;
		CheckVO vo=null;
		String sql=null;
		String StuName=(String) arg0;
		sql="SELECT s.CLASS_NO,s.STU_NO, c.CHECK_NAME,c.WRITE_TIME," +
				"c.TEACHER_NAME,s.CLASS_NO,s.STU_NAME,s.STUDY_MARK,s.LATE," +
				"s.LEAVEES,s.TRUANT FROM checkes c,student s " +
				"where s.CLASS_NO=c.CLASS_NO AND s.STU_NAME=? ";
		try {
			ps=conn.prepareStatement(sql);
			ps.setString(1, StuName);
			rs=ps.executeQuery();
			
		while(rs.next()){
			vo=new CheckVO();
			vo.setCheckName(rs.getString("CHECK_NAME"));
			vo.setTeacherName(rs.getString("TEACHER_NAME"));
            vo.setWriteTime(rs.getString("WRITE_TIME"));
            vo.setStuName(rs.getString("STU_NAME"));
            vo.setClassNo(rs.getString("CLASS_NO"));
            vo.setStuNo(rs.getString("STU_NO"));
            vo.setSturyMark(rs.getString("STUDY_MARK"));
            vo.setLate(rs.getString("LATE"));
            vo.setLeavees(rs.getString("LEAVEES"));
            vo.setTruant(rs.getString("TRUANT"));
            list.add(vo);
		   }
		}catch (RuntimeException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			if(ps!=null){
				ps=null;
				sql=null;
				rs=null;
				vo=null;
		
			}
		}
		return list;
	}
	/**
	 * 增加student表中指定的记录；
	 * @throws SQLException
	 * @return boolean 
	 */
	public Object findByObject(Object arg0) throws SQLException {
		// TODO Auto-generated method stub
		PreparedStatement ps=null;
		boolean flag=false;
		CheckDTO dto=(CheckDTO) arg0;
		String sql="INSERT INTO checkes(CLASS_NO,CHECK_NAME,WRITE_TIME,TEACHER_NAME) VALUE(?,?,?,?)";
		
		try {
			ps=conn.prepareStatement(sql);
			ps.setString(1, dto.getClassNo());
			ps.setString(2, dto.getCheckName());
			ps.setString(3, dto.getWriteTime());
			ps.setString(4, dto.getTeacherName());
			int i=ps.executeUpdate();
			if(i!=-1){
				flag=true;
			}
		} catch (RuntimeException e) {
			e.printStackTrace();
		}finally{
			ps=null;
			sql=null;
			dto=null;
		}
		
		return flag;
	}
	/**
	 * 查询check表中所有的信息；
	 * @throws SQLException
	 * @return integer 查询完成，返回Integer。
	 */
	public int getCount(Object arg0) throws SQLException {
		PreparedStatement ps=null;
		ResultSet rs=null;
		ArrayList list=null;
		CheckVO vo=null;
		int integer=0;
		String sql=null;
		int index=1;
		CheckDTO dto=(CheckDTO) arg0;
		sql="SELECT COUNT(*) FROM student where 1=1";
        StringBuffer StrBuf=new StringBuffer(sql);
		try {
			if(dto.getClassNo()!=null&&!"".equals(dto.getClassNo())){
				StrBuf.append(" AND CLASS_NO='"+dto.getClassNo()+"'");
			}
			if(dto.getStuName()!=null&&!"".equals(dto.getStuName())){
				StrBuf.append(" AND STU_NAME='"+dto.getStuName()+"'");
			}
			sql = StrBuf.toString();
			ps=conn.prepareStatement(sql);
			rs=ps.executeQuery();
		while(rs.next()){
			integer=new Integer(rs.getInt(1)); 
		   }
		}catch (RuntimeException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			if(ps!=null){
				ps=null;
				sql=null;
				rs=null;
				dto=null;
			}
		}
		return integer;
	}
	/**
	 * 增加student表中指定的记录；
	 * @throws SQLException
	 * @return boolean 
	 */
	public Object insert(Object arg0) throws SQLException {
		// TODO Auto-generated method stub
		PreparedStatement ps=null;
		Boolean flag=false;
		CheckDTO dto=(CheckDTO) arg0;
		String sql=null;
		sql="INSERT INTO student(CLASS_NO,STU_NO,STU_NAME,STUDY_MARK,LATE,LEAVEES,TRUANT) VALUE(?,?,?,?,?,?,?) ";
		
		try {
			ps=conn.prepareStatement(sql);
			ps.setString(1, dto.getClassNo());
			ps.setString(2, dto.getStuNo());
			ps.setString(3, dto.getStuName());
			ps.setString(4, dto.getSturyMark());
			ps.setString(5, dto.getLate());
			ps.setString(6, dto.getLeavees());
			ps.setString(7, dto.getTruant());
			int i=ps.executeUpdate();
			conn.commit();
			if(i!=-1){
				 flag=true;
			}
		} catch (RuntimeException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			ps=null;
			sql=null;
			dto=null;
		}
		
		return flag;
	}

	/**
	 * 根据班级编号查询该班级指定的信息；
	 * @throws SQLException
	 * @return boolean 
	 */
	public Object update(Object arg0) throws SQLException {
		// TODO Auto-generated method stub
		PreparedStatement ps=null;
		ResultSet rs=null;
		ArrayList list=null;
		CheckVO vo=null;
		CheckDTO dto=(CheckDTO) arg0;		
		boolean flag=false;
		String sql=null;		
		sql="SELECT s.CLASS_NO, c.CHECK_NAME,c.WRITE_TIME,c.TEACHER_NAME,s.CLASS_NO,s.STU_NAME,s.STUDY_MARK,s.LATE,s.LEAVEES," +
				"s.TRUANT FROM checkes c left join  " +
				"student s on 1=1 AND s.CLASS_NO=? group by c.CHECK_NAME";
		
		try {
			  ps=conn.prepareStatement(sql);
			  rs=ps.executeQuery();
			  while(rs.next()){
				    vo.setCheckName(rs.getString("checkName"));
					vo.setTeacherName(rs.getString("teachername"));
		            vo.setWriteTime(rs.getString("writeTime"));
		            vo.setStuName(rs.getString("stuName"));
		            vo.setClassNo(rs.getString("classNO"));
		            vo.setSturyMark(rs.getString("sturyMark"));
		            vo.setLate(rs.getString("late"));
		            vo.setLeavees(rs.getString("leavees"));
		            vo.setTruant(rs.getString("truant"));
		            list.add(vo);
			  }
		} catch (RuntimeException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			if(ps!=null){
				ps=null;
				sql=null;
				rs=null;
				dto=null;	
				vo=null;		
			}		
		}
		return flag;
	}

	
	public Object findAll() throws SQLException {
		// TODO Auto-generated method stub
		
		
		
		return null;
	}


}