90d10de4b288001d160fad3e9d937e41

一个相对比较简单的留言簿！功能还比较齐全！

package com.pure35.database;
import java.sql.Connection;
import java.sql.Date;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import com.pure35.vo.MessageVo;
public class MessageDao {
	Connection con=null;
	PreparedStatement pm=null;
	ResultSet rs;
	String sql="";
	MessageVo message;
	
	public boolean addMessage(MessageVo message) {
		try {
			con=DBConn.getConnection();//连接数据库
			
			sql="insert into message(subject,mdate,username,content) values(?,?,?,?)";
			
			pm=con.prepareStatement(sql);
			
			pm.setString(1, message.getSubject());
			pm.setDate(2, message.getMdate());
			pm.setString(3, message.getUsername());
			pm.setString(4, message.getContent());		
			pm.executeUpdate();
			
			
		} catch (SQLException e) {
			
			e.printStackTrace();
			return false;
		} catch (ClassNotFoundException e) {
			// 
			e.printStackTrace();
			return false;
		}finally{
			try {
				pm.close();
				DBConn.closeConnection();
			} catch (SQLException e) {
				// 
				e.printStackTrace();
			}
			
			
		}
		return true;
	}
	
	public boolean updateMessage(MessageVo msvo){
		sql="update message set subject=?,content=?,mdate=?";
		try {
			
			con =  DBConn.getConnection();
			pm = con.prepareStatement(sql);
			pm.setString(1, msvo.getSubject());
			pm.setString(2, msvo.getContent());
			pm.setDate(3, msvo.getMdate());
			pm.executeUpdate();	
			
		} catch (ClassNotFoundException e1) {
			// TODO Auto-generated catch block
			e1.printStackTrace();
			return false;
		} catch (SQLException e1) {
			// TODO Auto-generated catch block
			e1.printStackTrace();
			return false;
		}finally{
				DBConn.closeConnection();	
		}
		return true;	
	}
	
	public List queryMessage(String sql ){
		List list=new ArrayList();
    	try {
    		con=DBConn.getConnection();
			pm=con.prepareStatement(sql);
			System.out.println(sql);
			rs=pm.executeQuery();
			while(rs.next()){				
				int id=rs.getInt("id");;
			    String subject=rs.getString("subject");
				 Date  mdate=rs.getDate(3);
				 String username=rs.getString("username");
				 String content=rs.getString("content");
				
				message=new MessageVo();
				message.setContent(content);
				message.setId(id);
				message.setMdate(mdate);
				message.setUsername(username);
				message.setSubject(subject);				
				list.add(message);				
			}
			
		} catch (SQLException e) {
			
			e.printStackTrace();
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			try {
				rs.close();
				pm.close();
				DBConn.closeConnection();
			} catch (SQLException e) {
				e.printStackTrace();
			}		
		}
 		
		return list;
	}
	
}