classmeetdao.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 java.util.List;

import edu.yinhe.mis.common.Page;
import edu.yinhe.mis.dto.ClassmeetDTO;

import edu.yinhe.mis.vo.ClassmeetVO;

import edu.yinhe.system.model.BaseDAO;

public class ClassmeetDAO extends BaseDAO{

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

	public Object delete(Object id) throws SQLException {
		String SQL=null;
		boolean isTrue=false;
		ClassmeetDTO dto=null;
		ClassmeetVO vo=null;
		PreparedStatement ps=null;
		
		dto=(ClassmeetDTO)id;
		
		try {
			SQL="DELETE FROM classmeet WHERE id=?";
			ps=conn.prepareStatement(SQL);
			ps.setInt(1, dto.getId());
			ps.executeUpdate();
			isTrue = true;
		} catch (RuntimeException e) {
			
			e.printStackTrace();
		}finally{
			if(ps!=null) ps.close();
			SQL=null;	
		}
		
		return isTrue;
	}

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

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

	public Object findAll(Object arg0) throws SQLException {
		String SQL=null;
	    List list=new ArrayList();
		
		ClassmeetVO cvo=null;
		PreparedStatement ps=null;
		ResultSet rs=null;
		Page pp=(Page)arg0;
		try{
			                                    
			SQL="SELECT emceeName,theme,time,id,location,content,decision,remark1 FROM classmeet limit ?,?";
			ps=conn.prepareStatement(SQL);
			ps.setInt(1, pp.getCurRow());
			ps.setInt(2, pp.getMaxRowsperPage());
	
			rs=ps.executeQuery();
			
			while(rs.next())
			{
				cvo=new ClassmeetVO();
				cvo.setEmceeName(rs.getString(1));
				cvo.setTheme(rs.getString(2));
				cvo.setTime(rs.getString(3));
				cvo.setId(rs.getInt(4));
				cvo.setLocation(rs.getString(5));
				cvo.setContent(rs.getString(6));
				cvo.setDecision(rs.getString(7));
				cvo.setRemark1(rs.getString(8));
				
				list.add(cvo);
			}
		}
		catch(SQLException e){
			System.out.println(e.getMessage());
		}finally{
			if(rs!=null)rs.close();
			if(ps!=null)ps.close();
			SQL=null;
			cvo=null; 
		}
      return list;
	}

	public Object findById(Object arg0) throws SQLException {
		String SQL=null;
		ClassmeetVO cvo=null;
		ClassmeetDTO cdto=null;
		PreparedStatement ps=null;
		ResultSet rs=null;
		
		boolean flag = false;
		try{
			cdto=(ClassmeetDTO)arg0;                                       
			SQL="SELECT location,theme,time,decision,remark1,content,emceeName,id FROM classmeet WHERE id=?";
			ps=conn.prepareStatement(SQL);
			
		    ps.setInt(1, cdto.getId());
		    rs = ps.executeQuery();
		    
		    while(rs.next()){
		    	cvo  =  new ClassmeetVO();
		    	cvo.setLocation(rs.getString("location"));
		    	cvo.setTheme(rs.getString("theme"));
		    	cvo.setTime(rs.getString("time"));
		    	cvo.setDecision(rs.getString("decision"));
		    	cvo.setRemark1(rs.getString("remark1"));
		    	cvo.setContent(rs.getString("content"));
		    	cvo.setEmceeName(rs.getString("emceeName"));
		    	cvo.setId(rs.getInt("id"));
		    }
		
		}
		catch(SQLException e){
			System.out.println(e.getMessage());
		}finally{
			if(ps!=null)ps.close();
			SQL=null;
			cdto=null; 
		}
		
		return cvo;
	}

	public int getCount(Object arg0) throws SQLException {
		int  count=0;
	    String SQL=null;
	    ResultSet rs=null;
		PreparedStatement ps=null;
		
		try{
			                                         
			SQL="SELECT count(*) FROM classmeet";
			ps=conn.prepareStatement(SQL);
			rs = ps.executeQuery();
			if(rs.next())
			 {
				 count=rs.getInt(1);
			 }
			
		}
		catch(SQLException e){
			
			System.out.println(e.getMessage());
		}finally{
			
			if(ps!=null)ps.close();
			if(rs!=null)rs.close();
			SQL=null;
			arg0=null; 
		}
		return count;
	}

	public Object getMaxId(String arg0) throws SQLException {
		// TODO Auto-generated method stub
		return 0;
	}

	public Object insert(Object obj) throws SQLException {
		boolean flag=false;
	    String SQL=null;
		ClassmeetDTO cdto=null;
		int i=0;
		PreparedStatement ps=null;
		try{
			cdto=(ClassmeetDTO) obj;                                          
			SQL="INSERT INTO Classmeet(theme,time,decision,remark1,content,emceeName,location) values(?,?,?,?,?,?,?)";
			ps=conn.prepareStatement(SQL);
			
			ps.setString(1,cdto.getTheme());
			ps.setString(2,cdto.getTime());
			ps.setString(3,cdto.getDecision());
			ps.setString(4,cdto.getRemark1());
			ps.setString(5,cdto.getContent());
			ps.setString(6,cdto.getEmceeName());
			ps.setString(7,cdto.getLocation());
			
			i = ps.executeUpdate();
			if(i!=-1){
				
				flag=true;
			}
		}
		catch(SQLException e){
			//System.out.println(e.getMessage());
		}finally{
			if(ps!=null)ps.close();
			SQL=null;
			cdto=null; 
		}
		return flag;
		
	}
}