guestbook.java

ajax+jsp留言本,大家可以免费下载

package com.javacms;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.text.DateFormat;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Calendar;
import java.util.Date;
import java.util.List;

public class GuestBook {
	private int id;
	private String nickname;
	private String content;
	private String ip;
	private String adddate;
	private String reply;

	public GuestBook(){}
	
	/**
	 * 带成员参数的构造函数
	 * @param int1
	 * @param string
	 * @param string2
	 * @param string3
	 * @param string5
	 * @param string4
	 */
	public GuestBook(int int1, String string, String string2, String string3, String string5, String string4) {
		this.id=int1;
		this.nickname=string;
		this.content=string2;
		this.ip=string3;
		this.adddate=string5;
		this.reply=string4;
	}
	
	/**
	 * 保存留言
	 *
	 */
	public String save(){
		String sql;
		ResultSet rs;
		sql="Select adddate From guestbook where ip='"+ip+"' Order By Id Desc LIMIT 0,1";
		rs=DatabaseConnector.exeSql(sql);
		try {
			while(rs.next()){
				SimpleDateFormat s=new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
				String now=s.format(new Date());
				String before=rs.getString("adddate");
				try {
					long b=Util.between(now,before);
					//一小时的间隔时间，防止重复提交留言
					int r=(int)(b/(1000*60*60));
					if(r<1){
						return "err";
					}
				}catch (ParseException e) {
					return "err";
				}
			}
			sql="Insert guestbook(nickname,content,ip,adddate) Values('"+nickname+"','"+content+"','" + ip + "','"+adddate+"')";
			DatabaseConnector.updateSql(sql);
			return "ok";
		} catch (SQLException e) {
			return "err";
		}finally{
			try {
				rs.close();
			} catch (SQLException e) {}
		}
	}
	
	/**
	 * <p>根据每页显示的留言条数，计算总共的分页数</p>
	 * @param page 每页显示的留言条数
	 * @return 总共的分页数
	 */
	public int getPageCount(int page){
		String sql="Select Count(id) From guestbook";
		ResultSet rs;
		int initPage=1;
		rs=DatabaseConnector.exeSql(sql);
		try{
			while(rs.next()){
				int i=rs.getInt(1);
				if(i>page){
					if(i%page!=0){
						initPage=i/page+1;
					}else{
						initPage=i/page;
					}
				}else{
					return initPage;
				}
			}
		}catch(Exception e){
			return initPage;
		}finally{
			try {
				rs.close();
			} catch (SQLException e) {}
		}
		return initPage;
	}
	
	/**
	 * 
	 * @param page 当前请求显示的页数
	 * @param p 每页显示的留言条数
	 * @return 留言列表集合
	 */
	public List getData(int page, int p) {
		String sql="Select * From guestbook Order By ID DESC LIMIT "+(page*p)+","+p+"";
		ResultSet rs;
		ArrayList list = new ArrayList();
		rs=DatabaseConnector.exeSql(sql);
		try {
			int i=0;
			GuestBook g;
			while(rs.next()){
				g=new GuestBook(rs.getInt("id"),rs.getString("nickname"),rs.getString("content"),rs.getString("ip"),rs.getString("adddate"),rs.getString("reply"));
				list.add(i,g);
				i++;
			}
		} catch (SQLException e) {
			return null;
		}finally{
			try {
				rs.close();
			} catch (SQLException e) {}
		}
		return list;
	}
	
	public String getAdddate() {
		return adddate;
	}

	public void setAdddate(String d) {
		this.adddate = d;
	}

	public String getContent() {
		return content;
	}

	public void setContent(String content) {
		this.content = content;
	}

	public int getId() {
		return id;
	}

	public void setId(int id) {
		this.id = id;
	}

	public String getIp() {
		return ip;
	}

	public void setIp(String ip) {
		this.ip = ip;
	}

	public String getNickname() {
		return nickname;
	}

	public void setNickname(String nickname) {
		this.nickname = nickname;
	}

	public String getReply() {
		return reply;
	}

	public void setReply(String reply) {
		this.reply = reply;
	}
}