jsp留言板包括留言添加，修改，删除等功能

package com.mes.dao; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.text.SimpleDateFormat; import java.util.ArrayList; import java.util.Date; import com.mes.entity.Message; import com.mes.dao.ConnectionManager; public class MessageDao { /* 添加留言信息 */ public int insertMessage(Message message) { int result = 0; Connection conn = ConnectionManager.getConnection(); PreparedStatement pstmt = null; try { pstmt = conn .prepareStatement("insert into message values(?,?,?,?,0)"); pstmt.setString(1, message.getMessageTitle()); pstmt.setString(2, message.getMessageContent()); pstmt.setString(3, message.getMessageWriter()); pstmt.setString(4, new SimpleDateFormat("yy-MM-dd hh:mm:ss") .format(new Date())); result = pstmt.executeUpdate(); } catch (SQLException e) { e.printStackTrace(); } finally { ConnectionManager.closeAll(null, pstmt, conn); } return result; } public int deleteMessage(int messageID) { int result = 0; Connection conn = ConnectionManager.getConnection(); PreparedStatement pstmt = null; try { pstmt = conn .prepareStatement("delete from message where messageID=?"); pstmt.setInt(1, messageID); result = pstmt.executeUpdate(); } catch (SQLException e) { e.printStackTrace(); } finally { ConnectionManager.closeAll(null, pstmt, conn); } return result; } public int udateMessage(Message message) { int result = 0; Connection conn = ConnectionManager.getConnection(); PreparedStatement pstmt = null; try { pstmt = conn .prepareStatement("update MESSAGE set messageTitle=?,messageContent=?,messageWriter=?,messageDate=? where messageID=?"); pstmt.setString(1,message.getMessageTitle()); pstmt.setString(2, message.getMessageContent()); pstmt.setString(3,message.getMessageWriter()); pstmt.setString(4, message.getMessageDate()); pstmt.setInt(5, message.getMessageID()); result=pstmt.executeUpdate(); } catch (SQLException e) { e.printStackTrace(); }finally{ ConnectionManager.closeAll(null, pstmt, conn); } return result; } public ArrayList findAllMessage(){ ArrayList all=new ArrayList(); Connection conn=ConnectionManager.getConnection(); PreparedStatement pstmt=null; ResultSet rs=null; try { pstmt=conn.prepareStatement("select * from MESSAGE"); rs=pstmt.executeQuery(); while(rs.next()){ Message m=new Message(); m.setMessageID(rs.getInt("messageID")); m.setMessageTitle(rs.getString("messageTitle")); m.setMessageContent(rs.getString("messageContent")); m.setMessageWriter(rs.getString("messageWriter")); m.setMessageDate(rs.getString("messageDate")); m.setRevertCount(rs.getInt("revertCount")); all.add(m); } } catch (SQLException e) { e.printStackTrace(); }finally{ ConnectionManager.closeAll(rs, pstmt, conn); } return all; } public Message findOneMessage(int id){ Message m=new Message(); Connection conn=ConnectionManager.getConnection(); PreparedStatement pstmt=null; ResultSet rs=null; try { pstmt=conn.prepareStatement("select * from MESSAGE where messageID=?"); pstmt.setInt(1, id); rs=pstmt.executeQuery(); if(rs.next()){ m.setMessageID(rs.getInt("messageID")); m.setMessageTitle(rs.getString("messageTitle")); m.setMessageContent(rs.getString("messageContent")); m.setMessageWriter(rs.getString("messageWriter")); m.setMessageDate(rs.getString("messageDate")); m.setRevertCount(rs.getInt("revertCount")); } } catch (SQLException e) { e.printStackTrace(); }finally{ ConnectionManager.closeAll(rs, pstmt, conn); } return m; } public int getCount(int id){ int count=0; Connection conn=ConnectionManager.getConnection(); PreparedStatement pstmt=null; ResultSet rs=null; try { pstmt=conn.prepareStatement("select count(*) from reply where messageID=?"); pstmt.setInt(1,id ); rs=pstmt.executeQuery(); if(rs.next()){count=rs.getInt(1);} } catch (SQLException e) { e.printStackTrace(); }finally{ ConnectionManager.closeAll(rs, pstmt, conn); } return count; } }