leaverdao.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.LeaverDTO;

import edu.yinhe.mis.vo.LeaverVO;

import edu.yinhe.system.model.BaseDAO;


public class LeaverDAO extends BaseDAO {

	/**
	 * 增加
	 */
	public Object insert(Object arg0) throws SQLException {
		int j =0;
		boolean flag = false;
		PreparedStatement pst = null;
		LeaverDTO ldto=(LeaverDTO)arg0;
		String sql="INSERT INTO leaver(STU_NO,STU_NAME,CLASS_NO,PHONE,LEFT_REASON,REMARK_INFO,ABOUT_SAFE,ISCONSENT,LEFT_TIME,RETURN_TIME) VALUES(?,?,?,?,?,?,?,?,?,?)";
		try{    
		    pst=conn.prepareStatement(sql);
			pst.setString(1, ldto.getStuNo());
			pst.setString(2, ldto.getStuName());
			pst.setString(3, ldto.getClassNo());
			pst.setString(4, ldto.getPhone());
			pst.setString(5, ldto.getLeftReason());
			pst.setString(6, ldto.getRemarkInfo());
			pst.setString(7, ldto.getAboutSafe());
			pst.setString(8, ldto.getIsconsent());
			pst.setString(9, ldto.getLeftTime());
			pst.setString(10,ldto.getReturnTime());		
			j = pst.executeUpdate();
			if(j==1){
				flag = true;
			}else{
				flag = false;
			}
		}catch(SQLException e)
		{
			e.printStackTrace();
		}finally{
			if(pst !=null)pst =null;
			ldto =null;
		}
		return flag;
	}
	/**
	 * 修改
	 */
	public Object update(Object arg0) throws SQLException {
		Boolean flag = false;
		int n=0;
		LeaverDTO ldto = (LeaverDTO) arg0;
		PreparedStatement pst=null;
		LeaverVO vo = new LeaverVO();
		try {
			String sql="UPDATE leaver SET STU_NO=?,STU_NAME=?,CLASS_NO=?,PHONE=?,LEFT_REASON=?,REMARK_INFO=?,";
					sql += "ABOUT_SAFE=?,ISCONSENT=?,LEFT_TIME=?,RETURN_TIME=?  WHERE ID=? ";
			pst=conn.prepareStatement(sql);
			
			pst.setString(1,ldto.getStuNo());
			pst.setString(2, ldto.getStuName());
			pst.setString(3, ldto.getClassNo());
			pst.setString(4, ldto.getPhone());
			pst.setString(5, ldto.getLeftReason());
			pst.setString(6, ldto.getRemarkInfo());
			pst.setString(7, ldto.getAboutSafe());
			pst.setString(8, ldto.getIsconsent());
			pst.setString(9, ldto.getLeftTime());
			pst.setString(10, ldto.getReturnTime());
			
			pst.setInt(11, ldto.getId());
			n = pst.executeUpdate();
			if(n!=0){	
				flag = true;
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}finally{
			if(pst!=null){
				pst.close();
				vo=null;
				ldto=null;
				
			}//由于项目庞大，节约资源		
		}
		return flag;
	}
    /**
     * 删除
     */
	public Object delete(Object arg0) throws SQLException {
		Boolean flag =false;
		int n;
		LeaverDTO ldto =null;
		PreparedStatement pst=null;
		String sql="DELETE FROM leaver WHERE ID=?";
		try {
			ldto = (LeaverDTO)arg0;
			pst=conn.prepareStatement(sql);
			pst.setInt(1,ldto.getId().intValue());
			n = pst.executeUpdate();
			if(n!=-1){	
				flag =true;
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}finally{
			if(pst!=null)pst.close();//由于项目庞大，节约资源
			sql = null;
		}
		
		return flag;
	}

    /**
     * 查找
     */
	public Object findById(Object arg0) throws SQLException {
		LeaverVO vo = new LeaverVO();		
		String sql="SELECT * FROM leaver WHERE ID =?";
		LeaverDTO ldto = (LeaverDTO) arg0;
		PreparedStatement pst = null;
		ResultSet rst= null;		
		try {
			pst=conn.prepareStatement(sql);
			pst.setInt(1, ldto.getId());
			rst= pst.executeQuery();
			
			while(rst.next()){
				vo.setID(rst.getInt("ID"));
				vo.setStuNo(rst.getString("STU_NO"));
				vo.setStuName(rst.getString("STU_NAME"));
				vo.setClassNo(rst.getString("CLASS_NO"));
				vo.setPhone(rst.getString("PHONE"));
				vo.setLeftReason(rst.getString("LEFT_REASON"));
				vo.setRemarkInfo(rst.getString("REMARK_INFO"));
				vo.setAboutSafe(rst.getString("ABOUT_SAFE"));
				vo.setIscontent(rst.getString("ISCONSENT"));
				vo.setLeftTime(rst.getString("LEFT_TIME"));
				vo.setReturnTime(rst.getString("RETURN_TIME"));
			}			
		} catch (SQLException e) {
			
			e.printStackTrace();
		}finally{
			if(rst!=null)rst.close();//由于项目庞大，节约资源
			if(pst!=null)pst.close();//由于项目庞大，节约资源
			sql=null;//由于项目庞大，节约资源			
		}
		return vo;
	}

public Object Permissionlist(Object arg0) throws SQLException {
		
		PreparedStatement pstmt = null;
		ResultSet rst=null;
		int ID=Integer.parseInt((String)(arg0));
		ArrayList list = new ArrayList();
		String SQL = "SELECT * FROM leaver WHERE id=?";
		LeaverVO vo = null;
		String str=(String)arg0;
		try {
			pstmt=conn.prepareStatement(SQL);
			pstmt.setString(1, str);
			rst = (ResultSet) pstmt.executeQuery();
			while(rst.next()){
				vo.setID(rst.getInt(ID));
				vo.setStuNo(rst.getString("stuNo"));
				vo.setStuName(rst.getString("stuName"));
				vo.setClassNo(rst.getString("classNO"));
				vo.setPhone(rst.getString("PHONE"));
				vo.setLeftReason(rst.getString("leftReason"));
				vo.setRemarkInfo(rst.getString("remarkInfo"));
				vo.setAboutSafe(rst.getString("aboutSafe"));
				vo.setIscontent(rst.getString("ISCONSENT"));
				vo.setLeftTime(rst.getString("leftTime"));
				vo.setReturnTime(rst.getString("returnTime"));
				list.add(vo);
			}
		}catch (SQLException e) {
			e.printStackTrace();
		}finally{
			if(pstmt != null)pstmt.close();
			if(rst != null)rst.close();
			SQL = null;
			vo = null;
		}
		return list;
	}

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

	public Object findAll() throws SQLException {		
		
		
		ArrayList  list=new ArrayList ();
		LeaverVO vo  = null;
		PreparedStatement pstat=null;
	    ResultSet rst=null;
		try {
			String sql= "select * from leaver";
			pstat = conn.prepareStatement(sql);
			rst = pstat.executeQuery();
			
			while(rst.next()){
				 vo= new LeaverVO();
				vo.setID(rst.getInt("id"));
				vo.setStuNo(rst.getString("STU_NO"));
				vo.setStuName(rst.getString("STU_NAME"));
				vo.setClassNo(rst.getString("CLASS_NO"));
				vo.setPhone(rst.getString("PHONE"));
				vo.setLeftReason(rst.getString("LEFT_REASON"));
				vo.setRemarkInfo(rst.getString("REMARK_INFO"));
				vo.setAboutSafe(rst.getString("ABOUT_SAFE"));
				vo.setIscontent(rst.getString("ISCONSENT"));
				vo.setLeftTime(rst.getString("LEFT_TIME"));
				vo.setReturnTime(rst.getString("RETURN_TIME"));
				list.add(vo);
			}			
		} catch (SQLException e) {
			
			e.printStackTrace();
		}finally{
			if(rst!=null)rst.close();//由于项目庞大，节约资源
			if(pstat!=null)pstat.close();//由于项目庞大，节约资源		
		}
		return list;
	}


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

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

	public int getCount(Object arg0) throws SQLException {		
		return 0;
	}

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