类似google地图

package com.marco.leaveMessage.dao; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.util.ArrayList; import java.util.List; import com.marco.leaveMessage.connectionFactory.ConnectionFactory; import com.marco.leaveMessage.entity.Message; import com.marco.leaveMessage.entity.Revert; public class MessageDao { public boolean addMessage(Message message) { Connection con = ConnectionFactory.instance().getCon(); PreparedStatement pstmt = null; ResultSet rs = null; try { pstmt = con .prepareStatement("insert into message values(null,?,?,?,?)"); pstmt.setString(1, message.getUser()); pstmt.setString(2, message.getTitle()); pstmt.setString(3, message.getText()); pstmt.setString(4, message.getDate().toLocaleString()); int k = pstmt.executeUpdate(); return k != 0 ? true : false; } catch (SQLException e) { e.printStackTrace(); } finally { ConnectionFactory.instance().close(rs, pstmt, con); } return false; } public List<Message> getMessage() { List<Message> list = new ArrayList<Message>(); Connection con = ConnectionFactory.instance().getCon(); PreparedStatement pstmt = null; ResultSet rs = null; try { pstmt = con.prepareStatement("select * from message"); rs = pstmt.executeQuery(); while (rs.next()) { Message message = new Message(); message.setDate(rs.getDate("date")); message.setMid(rs.getInt("mid")); message.setText(rs.getString("message")); message.setTitle(rs.getString("title")); message.setUser(rs.getString("name")); list.add(message); } } catch (Exception e) { e.printStackTrace(); } finally { ConnectionFactory.instance().close(rs, pstmt, con); } return list; } public List<Revert> getRevert(Message message) { List<Revert> list = new ArrayList<Revert>(); Connection con = ConnectionFactory.instance().getCon(); PreparedStatement pstmt = null; ResultSet rs = null; try { pstmt = con .prepareStatement("select rdate,text,username from revert,user where mid=?"); pstmt.setInt(1, message.getMid()); rs = pstmt.executeQuery(); while (rs.next()) { Revert revert = new Revert(); revert.setDate(rs.getDate("rdate")); revert.setText(rs.getString("text")); revert.getUser().setName(rs.getString("username")); list.add(revert); } } catch (Exception e) { e.printStackTrace(); } finally { ConnectionFactory.instance().close(rs, pstmt, con); } return list; } public Message getMessage(int mid){ Message message=new Message(); Connection con = ConnectionFactory.instance().getCon(); PreparedStatement pstmt = null; ResultSet rs = null; try{ pstmt=con.prepareStatement("select * from message where mid=?"); pstmt.setInt(1,mid); rs=pstmt.executeQuery(); if(rs.next()){ message.setDate(rs.getDate("date")); message.setText(rs.getString("message")); message.setTitle(rs.getString("title")); message.setUser(rs.getString("name")); } }catch(Exception e){ e.printStackTrace(); }finally { ConnectionFactory.instance().close(rs, pstmt, con); } return message; } }