产品展示公司网站项目，新闻发布，在线留言

/** * @author ����� * @version 1.1 * @date 2008.09.09 * ��˵��������ڲ���ظ���Ϣ�� �� ɾ �� �� * �������£�1.���ǰ̨�Ŀؼ���Ϣ����Revert������в��� * 2.��ݻظ���Ϣ�Ķ�������޸� * 3.��ݻظ���Ϣ��ID����ɾ�� * 4.��ѯȫ����Ϣ * 5.��ݻظ���Ϣ��ID��ѯһ����Ϣ * 6.���MessageID��ѯһ����Ϣ * 7.�����ϢID��ѯһ����߸��Ļظ� */ package dao; import entity.*; import db.ConnectionManager; import java.util.*; import java.sql.*; public class RevertDAO { //�˷������ڣ� 1.���ǰ̨�Ŀؼ���Ϣ����Revert������в��� public int insertRevert(Revert rvt) { int i = 0; Connection con = null; PreparedStatement pstmt = null; String sql = "insert into REVERT values(?,?,?,?)"; con = ConnectionManager.getConnection(); try { pstmt = con.prepareStatement(sql); pstmt.setInt(1, rvt.getMessageID()); pstmt.setString(2, rvt.getContent()); pstmt.setString(3, rvt.getWriter()); pstmt.setString(4, rvt.getWriteDate()); i = pstmt.executeUpdate(); return i; } catch (SQLException e) { e.printStackTrace(); }finally{ ConnectionManager.closeAll(null, pstmt, con); } return i; } //�˷������ڣ� 2.��ݻظ���Ϣ�Ķ�������޸� public void updateRevertById(Revert rvt) { Connection con = null; PreparedStatement pstmt = null; String sql = "update REVERT set content=?,writer=?,writeDate=? where revertID =?"; con = ConnectionManager.getConnection(); try { pstmt = con.prepareStatement(sql); pstmt.setString(1,rvt.getContent()); pstmt.setString(2,rvt.getWriter()); pstmt.setString(3,rvt.getWriteDate()); pstmt.executeUpdate(); } catch (SQLException e) { e.printStackTrace(); }finally{ ConnectionManager.closeAll(null, pstmt, con); } } //�˷������ڣ� 3.��ݻظ���Ϣ��ID����ɾ�� public int deleteRevertById(int id) { int i = 0; Connection con = null; PreparedStatement pstmt = null; String sql = "delete from REVERT where revertID =?"; con = ConnectionManager.getConnection(); try { pstmt = con.prepareStatement(sql); pstmt.setInt(1,id); i = pstmt.executeUpdate(); return i; } catch (SQLException e) { e.printStackTrace(); }finally{ ConnectionManager.closeAll(null, pstmt, con); } return i; } //�˷������ڣ� 4.��ѯȫ����Ϣ public ArrayList<Revert> selectAllRevert() { ArrayList<Revert> arr = new ArrayList<Revert>(); Connection con = null; PreparedStatement pstmt = null; ResultSet rs = null; String sql = "select * from REVERT"; con = ConnectionManager.getConnection(); try { pstmt = con.prepareStatement(sql); rs = pstmt.executeQuery(); while(rs.next()) { Revert rvt = new Revert(); rvt.setRevertID(rs.getInt("revertID")); rvt.setMessageID(rs.getInt("messageID")); rvt.setContent(rs.getString("content")); rvt.setWriter(rs.getString("writer")); rvt.setWriteDate(rs.getString("writeDate")); arr.add(rvt); } return arr; } catch (SQLException e) { e.printStackTrace(); return arr; }finally{ ConnectionManager.closeAll(rs, pstmt, con); } } //�˷������ڣ� 5.��ݻظ���Ϣ��ID��ѯһ����Ϣ public Revert selectRevertById(int id) { Revert rvt = null; Connection con = null; PreparedStatement pstmt = null; ResultSet rs = null; String sql = "select * from REVERT where revertID =?"; con = ConnectionManager.getConnection(); try { pstmt = con.prepareStatement(sql); pstmt.setInt(1,id); rs = pstmt.executeQuery(); if(rs.next()) { rvt = new Revert(); rvt.setRevertID(rs.getInt("revertID")); rvt.setMessageID(rs.getInt("messageID")); rvt.setContent(rs.getString("content")); rvt.setWriter(rs.getString("writer")); rvt.setWriteDate(rs.getString("writeDate")); } } catch (SQLException e) { e.printStackTrace(); }finally{ ConnectionManager.closeAll(rs, pstmt, con); } return rvt; } //�˷������ڣ� 6.���MessageID��ѯһ����Ϣ public Revert selectRevertByMessageID(int id) { Revert rvt = null; Connection con = null; PreparedStatement pstmt = null; ResultSet rs = null; String sql = "select * from REVERT where messageID =?"; con = ConnectionManager.getConnection(); try { pstmt = con.prepareStatement(sql); pstmt.setInt(1,id); rs = pstmt.executeQuery(); if(rs.next()) { rvt = new Revert(); rvt.setRevertID(rs.getInt("revertID")); rvt.setMessageID(rs.getInt("messageID")); rvt.setContent(rs.getString("content")); rvt.setWriter(rs.getString("writer")); rvt.setWriteDate(rs.getString("writeDate")); } } catch (SQLException e) { e.printStackTrace(); }finally{ ConnectionManager.closeAll(rs, pstmt, con); } return rvt; } //�˷������ڣ� 7.�����ϢID��ѯһ����߸��Ļظ� public ArrayList<Revert> selectAllRevertByMessageID(int id) { ArrayList<Revert> arr = new ArrayList<Revert>(); Revert rvt = null; Connection con = null; PreparedStatement pstmt = null; ResultSet rs = null; String sql = "select * from REVERT where messageID =?"; con = ConnectionManager.getConnection(); try { pstmt = con.prepareStatement(sql); pstmt.setInt(1,id); rs = pstmt.executeQuery(); while(rs.next()) { rvt = new Revert(); rvt.setMessageID(rs.getInt("messageID")); rvt.setContent(rs.getString("content")); rvt.setWriter(rs.getString("writer")); rvt.setWriteDate(rs.getString("writeDate")); arr.add(rvt); } } catch (SQLException e) { e.printStackTrace(); }finally{ ConnectionManager.closeAll(rs, pstmt, con); } return arr; } }