informdao.java

一个jsp的oa系统,里面有很多亮点学习!

package com.oa.lp.dao;

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

import com.oa.lp.model.CommLinkMan;
import com.oa.lp.model.Company;
import com.oa.lp.model.Inform;
import com.oa.lp.util.DTOPopulator;

public class InformDAO {
	private Connection conn;

	public Connection getConn() {
		return conn;
	}

	public void setConn(Connection conn) {
		this.conn = conn;
	}
	
	
	/**
	 * 新增通知
	 * @param menu
	 * @throws SQLException
	 */
	public void addInforms(Inform inform) throws SQLException{
		String sql = "insert into INFORM(INFORM_TITLE,INFORM_CONTENT,INFORM_SEND_TIME,SEND_PERSON,INFORM_STATE)" +
				"values(?,?,?,?,?)";
		PreparedStatement pstmt = conn.prepareStatement(sql);
		pstmt.setString(1,inform.getInformTitle());
		pstmt.setString(2,inform.getInformcontent());
		pstmt.setDate(3,inform.getInformSendTime());
		pstmt.setString(4,inform.getSendPerson());
		pstmt.setInt(5,inform.getInformState());
		pstmt.executeUpdate();
		pstmt.close();
	}
		
		/**
		 * 通过通知ID查找通知信息
		 * @param companyId
		 * @return
		 * @throws Exception
		 */
		public Inform getInformById(int informId) throws Exception{
			Inform inform = new Inform();
			List list=null;
			String sql = "select * from INFORM where INFORM_ID=?";
			PreparedStatement pstmt = conn.prepareStatement(sql);
			pstmt.setInt(1,informId);
			ResultSet rs = pstmt.executeQuery();
			list = DTOPopulator.populate(rs, Inform.class);
			if(list.size()>0){
				inform = (Inform)list.get(0);
			}
			rs.close();
			pstmt.close();
			return inform;
		}
		
		/**
		 * 更新通知
		 * @param company
		 * @throws SQLException
		 */
		public void updateInform(Inform inform) throws SQLException{
			String sql = "update INFORM set INFORM_TITLE=?,INFORM_CONTENT=?,INFORM_SEND_TIME=?," +
					"SEND_PERSON=?,INFORM_STATE=? where INFORM_ID=?";
			PreparedStatement pstmt = conn.prepareStatement(sql);
		
			pstmt.setString(1,inform.getInformTitle());
			pstmt.setString(2,inform.getInformcontent());
			pstmt.setDate(3,inform.getInformSendTime());
			pstmt.setString(4,inform.getSendPerson());
			pstmt.setInt(5,inform.getInformState());
			pstmt.setInt(6,inform.getInformId());
			
			pstmt.executeUpdate();
			pstmt.close();
		}
		
		/**
		 * 通知列表 
		 */
		public List listAllInforms() throws Exception{
			List list = null; 
			String sql = "select * from INFORM";
			PreparedStatement pstmt = conn.prepareStatement(sql);
			ResultSet rs = pstmt.executeQuery();
			//将结果集中的每一行记录封装成一个对象,再放进集合返回
			list = DTOPopulator.populate(rs, Inform.class);
			pstmt.close();
			return list;
		}
		
		
	}