revertdao.java

简单的企业宣传的网站

package dao;
import entity.*;
import java.util.*;
import java.sql.*;
public class RevertDao extends BaseDao{
	private Connection conn=null;
	private PreparedStatement pstmt=null;
	private ResultSet rs=null;
	public List selectRevertByMessageID(String messageID)
	{
		List list=new ArrayList();
		String sql="select *from revert where messageID=?";
		try {
			conn=this.getConn();
			pstmt=conn.prepareStatement(sql);
			pstmt.setString(1, messageID);
			rs=pstmt.executeQuery();
			while(rs.next())
			{
				Revert revert=new Revert();
				revert.setRevertID(rs.getInt("revertID"));
				revert.setMessageID(rs.getInt("messageID"));
				revert.setContent(rs.getString("content"));
				revert.setWriter(rs.getString("writer"));
				revert.setWriteDate(rs.getString("writeDate"));
				list.add(revert);
			}
		} catch (ClassNotFoundException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
		} catch (SQLException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
		}finally
		{
			this.closeAll(conn, pstmt, rs);
		}
		return list;
	}
	public int insertRevert(Revert revert)
	{
		String sql="insert into revert values(?,?,?,?)";
		String []param=new String []{revert.getMessageID()+"",revert.getContent(),revert.getWriter(),revert.getWriteDate()};
		return this.excuteSQL(sql, param);
	}
}