outlinedao.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.OutlineDTO;
import edu.yinhe.mis.vo.OutlineVO;
import edu.yinhe.system.model.BaseDAO;


/**
 * @author 陈忠
 * Creation date:04-30-2008 
 */
public class OutlineDAO extends BaseDAO {
	
	/**
	 * 根据id，删除outline表中的信息
	 *@throws SQLException
	 * @param arg0 id号
	 * @return flag 删除成功返回true，反之为false。
	 */
	public Object delete(Object arg0) throws SQLException {
		boolean flag=false;
		String oid=(String) arg0;
		String []str=oid.split(" ");
		String id=null;
		
		String sql="DELETE FROM outline WHERE ID=?";
		PreparedStatement pstmt = null;
		try {
			pstmt=conn.prepareStatement(sql);
			if(str!=null){
				for(int i=0;i<str.length;i++){
					id=str[i];
					if(id!=null&&!"".equals(id)){
					pstmt.setInt(1, Integer.parseInt(id));
					pstmt.executeUpdate();}
				}
			}
			flag=true;
		} catch (SQLException e) {
			e.printStackTrace();
		}finally{
			if(pstmt!=null)pstmt.close();
			sql=null;
		}
		return flag;
	}

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

	public Object find(Object arg0) throws SQLException {
		// TODO Auto-generated method stub
		return null;
	}
	
	/**
	 * 查询outline表中的所有信息
	 *@throws SQLException
	 * @return list 查询完成，返回ArrayList集合。
	 */
	public Object findAll() throws SQLException {
		return null;
	}
	
	/**
	 * 查询outline表中的所有信息
	 * @param arg0 传入OutlineDTO对象
	 *@throws SQLException
	 * @return obj 查询完成，返回Object[]的数组。
	 */
	public Object findAll(Object arg0) throws SQLException {
		OutlineVO outlineVO=null;
		OutlineDTO outlineDTO=(OutlineDTO)arg0;
		StringBuffer strbuf=null;
		String sql=null;
		PreparedStatement ps=null;
		ResultSet rs=null;
		ArrayList list=new ArrayList();
		
		Object[] obj=new Object[2];
		Integer count=new Integer(0);
		count=this.getCount(arg0);
		strbuf=new StringBuffer("SELECT ID,OBJECT_NO, OBJECT_NAME,OBJECT_TYPE,OUTLINE_TYPE,CREATER,SEQUENCE_NO,PLANPERIOD,FACTPERIOD FROM outline WHERE 1=1");
		if(outlineDTO.getId()!=0&&!"".equals(outlineDTO.getId())){
			strbuf.append(" AND ID="+outlineDTO.getId());
		}
		
		if(outlineDTO.getObjectName()!=null&&!"".equals(outlineDTO.getObjectName())){
			strbuf.append(" AND OBJECT_NAME='"+outlineDTO.getObjectName()+"'");
		}
		
		if(outlineDTO.getObjectNo()!=null&&!"".equals(outlineDTO.getObjectNo())){
			strbuf.append(" AND OBJECT_NO='"+outlineDTO.getObjectNo()+"'");
		}
		if(outlineDTO.getObjectType()!=null&&!"".equals(outlineDTO.getObjectType())){
			strbuf.append(" AND OBJECT_TYPE='"+outlineDTO.getObjectType()+"'");
		}
		if(outlineDTO.getOutlineType()!=null&&!"".equals(outlineDTO.getOutlineType())){
			strbuf.append(" AND OUTLINE_TYPE='"+outlineDTO.getOutlineType()+"'");
		}
		if(outlineDTO.getPlanperiod()!=0&&!"".equals(outlineDTO.getPlanperiod())){
			strbuf.append(" AND PLANPERIOD="+outlineDTO.getPlanperiod());
		}
		if(outlineDTO.getSequenceNo()!=null&&!"".equals(outlineDTO.getSequenceNo())){
			strbuf.append(" AND SEQUENCE_NO='"+outlineDTO.getSequenceNo()+"'");
		}
		if(outlineDTO.getFactperiod()!=0&&!"".equals(outlineDTO.getFactperiod())){
			strbuf.append(" AND FACTPERIOD="+outlineDTO.getFactperiod());
			
		}
		int i=(Integer.parseInt(outlineDTO.getCurrentPage())-1)*Integer.parseInt(outlineDTO.getRowPerPage());
		strbuf.append(" ORDER BY ID DESC LIMIT "+i+","+outlineDTO.getRowPerPage());
		sql=strbuf.toString();
		ps = conn.prepareStatement(sql);
		rs = ps.executeQuery();
		while(rs.next()){
			outlineVO=new OutlineVO();
			outlineVO.setId(rs.getInt("id"));
			outlineVO.setObjectName(rs.getString("object_name"));
			outlineVO.setObjectNo(rs.getString("object_no"));
			outlineVO.setObjectType(rs.getString("object_type"));
			outlineVO.setOutlineType(rs.getString("outline_type"));
			outlineVO.setCreater(rs.getString("creater"));
			outlineVO.setPlanperiod(rs.getInt("planperiod"));
			outlineVO.setFactperiod(rs.getInt("factperiod"));
			outlineVO.setSequenceNo(rs.getString("sequence_no"));
			list.add(outlineVO);
		}
		obj[0]=count;
		obj[1]=list;
		if(ps!=null)ps=null;
		if(rs!=null)rs=null;
		outlineVO=null;
		outlineDTO=null;
		sql=null;
		strbuf=null;
		return obj;
	}
	
	/**
	 * 根据id查询outline表中的信息
	 * @param arg0 传入OutlineDTO类型的对象
	 *@throws SQLException
	 * @return list 查询完成，返回ArrayList类型的集合。
	 */
	public Object findById(Object arg0) throws SQLException {
		OutlineDTO outlineDTO=null;
		OutlineVO outlineVO=null;
		ArrayList list=new ArrayList();
		String sql=null;
		PreparedStatement ps =null;
		ResultSet rs=null;
		outlineDTO=(OutlineDTO)arg0;
		sql="SELECT ID,OBJECT_NO, OBJECT_NAME,OBJECT_TYPE,OUTLINE_TYPE,CREATER,SEQUENCE_NO,PLANPERIOD,FACTPERIOD FROM outline WHERE ID=?";
		ps= conn.prepareStatement(sql);
		ps.setInt(1,outlineDTO.getId());
		rs = ps.executeQuery();
		while(rs.next()){
			outlineVO=new OutlineVO();
			outlineVO.setId(rs.getInt("id"));
			outlineVO.setObjectName(rs.getString("object_name"));
			outlineVO.setObjectNo(rs.getString("object_no"));
			outlineVO.setObjectType(rs.getString("object_type"));
			outlineVO.setOutlineType(rs.getString("outline_type"));
			outlineVO.setCreater(rs.getString("creater"));
			outlineVO.setPlanperiod(rs.getInt("planperiod"));
			outlineVO.setSequenceNo(rs.getString("sequence_no"));
			outlineVO.setFactperiod(rs.getInt("factperiod"));
			list.add(outlineVO);
		}
		
		if(ps!=null)ps=null;
		if(rs!=null)rs=null;
		outlineDTO=null;
		outlineVO=null;
		return list;
	}

	public Object findByObject(Object arg0) throws SQLException {
		// TODO Auto-generated method stub
		return null;
	}
	
	/**
	 * 查询outline表中的所有信息的条数
	 * @param arg0 传入OutlineDTO类型的对象
	 *@throws SQLException
	 * @return integer 查询完成，返回int整数。
	 */
	public int getCount(Object arg0) throws SQLException {
		OutlineDTO outlineDTO=(OutlineDTO)arg0;
		Integer integer=new Integer(0);
		StringBuffer strbuf=new StringBuffer("SELECT COUNT(*)aa FROM outline WHERE 1=1");
		String sql=null;
		PreparedStatement ps=null;
		ResultSet rs=null;
		
		if(outlineDTO.getId()!=0&&!"".equals(outlineDTO.getId())){
			strbuf.append(" AND ID="+outlineDTO.getId());
		}
		
		if(outlineDTO.getObjectName()!=null&&!"".equals(outlineDTO.getObjectName())){
			strbuf.append(" AND OBJECT_NAME='"+outlineDTO.getObjectName()+"'");
		}
		
		if(outlineDTO.getObjectNo()!=null&&!"".equals(outlineDTO.getObjectNo())){
			strbuf.append(" AND OBJECT_NO='"+outlineDTO.getObjectNo()+"'");
		}
		if(outlineDTO.getObjectType()!=null&&!"".equals(outlineDTO.getObjectType())){
			strbuf.append(" AND OBJECT_TYPE='"+outlineDTO.getObjectType()+"'");
		}
		if(outlineDTO.getOutlineType()!=null&&!"".equals(outlineDTO.getOutlineType())){
			strbuf.append(" AND OUTLINE_TYPE='"+outlineDTO.getOutlineType()+"'");
		}
		if(outlineDTO.getPlanperiod()!=0&&!"".equals(outlineDTO.getPlanperiod())){
			strbuf.append(" AND PLANPERIOD="+outlineDTO.getPlanperiod());
		}
		if(outlineDTO.getSequenceNo()!=null&&!"".equals(outlineDTO.getSequenceNo())){
			strbuf.append(" AND SEQUENCE_NO='"+outlineDTO.getSequenceNo()+"'");
		}
		if(outlineDTO.getFactperiod()!=0&&!"".equals(outlineDTO.getFactperiod())){
			strbuf.append(" AND FACTPERIOD="+outlineDTO.getFactperiod());
			
		}
		sql=strbuf.toString();
		ps = conn.prepareStatement(sql);
		rs = ps.executeQuery();
		while(rs.next()){
			integer = new Integer(rs.getInt("aa"));
		}
		
		if(ps!=null)ps=null;
		if(rs!=null)rs=null;
		outlineDTO=null;
		sql=null;
		strbuf=null;
		return integer;
	}

	public Object getMaxId(Object arg0) throws SQLException {
		// TODO Auto-generated method stub
		return null;
	}
	/**
	 * 向outline表中新增数据
	 * @param arg0 传入OutlineDTO类型的对象
	 *@throws SQLException
	 * @return flag 添加完成，返回true，反之为false。
	 */
	public Object insert(Object arg0) throws SQLException {
		String sql=null;
		boolean flag=false;
		PreparedStatement ps=null;
		int index=1;
		OutlineDTO outlineDTO=null;
		sql="INSERT INTO outline(OBJECT_NO, OBJECT_NAME,OBJECT_TYPE,OUTLINE_TYPE,CREATER,SEQUENCE_NO,PLANPERIOD,FACTPERIOD) VALUE(?,?,?,?,?,?,?,?)";
		ps = conn.prepareStatement(sql);
		outlineDTO=(OutlineDTO)arg0;
		ps.setString(index++,outlineDTO.getObjectNo());
		ps.setString(index++,outlineDTO.getObjectName());
		ps.setString(index++,outlineDTO.getObjectType());
		ps.setString(index++,outlineDTO.getOutlineType());
		ps.setString(index++,outlineDTO.getCreater());
		ps.setString(index++,outlineDTO.getSequenceNo());
		ps.setInt(index++,outlineDTO.getPlanperiod());
		ps.setInt(index++, outlineDTO.getFactperiod());
		ps.executeUpdate();
		conn.commit();
		flag=true;
		
		if(ps!=null)ps=null;
		outlineDTO=null;
		return flag;
	}
	/**
	 * 根据id修改outline表中数据
	 * @param arg0 传入OutlineDTO类型的对象
	 *@throws SQLException
	 * @return flag 修改完成，返回true，反之为false。
	 */
	public Object update(Object arg0) throws SQLException {
		boolean flag=false;
		String sql=null;
		int index=1;
		PreparedStatement ps=null;
		OutlineDTO outlineDTO=(OutlineDTO)arg0;
		sql="UPDATE outline SET OBJECT_NO=?, OBJECT_NAME=?,OBJECT_TYPE=?,OUTLINE_TYPE=?,CREATER=?,SEQUENCE_NO=?,PLANPERIOD=?,FACTPERIOD=? WHERE ID=? ";
		ps = conn.prepareStatement(sql);
		ps.setString(index++,outlineDTO.getObjectNo());
		ps.setString(index++,outlineDTO.getObjectName());
		ps.setString(index++,outlineDTO.getObjectType());
		ps.setString(index++,outlineDTO.getOutlineType());
		ps.setString(index++,outlineDTO.getCreater());
		ps.setString(index++,outlineDTO.getSequenceNo());
		ps.setInt(index++,outlineDTO.getPlanperiod());
		ps.setInt(index++,outlineDTO.getFactperiod());
		ps.setInt(index++, outlineDTO.getId());
		
		ps.executeUpdate();

		flag=true;
		
		if(ps!=null)ps=null;
		outlineDTO=null;
		return flag;
	}

}