dao分析和总结最新分析和总结.docxVIP

package com.bbs.dao; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.util.ArrayList; import java.util.Date; import java.util.List; import com.bbs.entity.Message; import com.bbs.entity.User; public class MessageDao extends AbstractMySqlDao{ /** 往 message 表中插入数据 @param message @return */ public Message insert(Message message) { int pid = message.getPid(); String messagecontent = message.getMessage(); int uid = message.getUid(); Date messagetime = message.getMessagetime(); String sql = insert into message(pid,message,uid,messagetime) values(?,?,?,?); Connection con = getConnection(); PreparedStatement pstate = null; try { con = getConnection(); pstate = con.prepareStatement(sql); pstate.setInt(1,pid); pstate.setString(2,messagecontent); pstate.setInt(3, uid); pstate.setDate(4,new java.sql.Date(messagetime.getTime())); pstate.executeUpdate(); ResultSet keys = pstate.getGeneratedKeys(); //得到刚刚插入的对象的 id if(keys.next()) { int id = keys.getInt(1); message.setId(id); } } catch (SQLException e) { e.printStackTrace(); }finally { close(con, pstate, null); } return message; } public User geiifo() { String sql = ; Connection con = null; PreparedStatement pstate = null; ResultSet rs = null; try {  con = getConnection(); pstate = con.prepareStatement(sql); rs = pstate.executeQuery(); while(rs.next()) { User temp = new User(); temp.setId(rs.getInt(1)); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return null; } /** 取出 message 表中的所有数据 @return */ public ListMessage listAll() { String sql = select * from message; ListMessage list = new ArrayListMessage(); Connection con = null; PreparedStatement pstate = null; ResultSet rs = null; try {  con = getConnection(); pstate = con.prepareStatement(sql); rs = pstate.executeQuery(); while (rs.next()) { Message temp = new Message(); temp.setId(rs.getInt(1)); temp.setPid(rs.getInt(2)); temp.setMessage(rs.getString(3)); te