guestbook.java

这个是一个用JSP做的留言网站的程序

/*
 * 留言板Bean
 * 最后修改日期：2007-8-8
 */
package com.deepteach.guestBook;

import java.sql.*;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.ArrayList;

import com.deepteach.dao.DBjdbcConnection;


public class GuestBook
{
	 private int Guest_id;
	 private String GuestName;
	 private String GuestFrom;
	 private String GuestContent;
	 private int GuestType;
	 private int GuestIsPassed;
	 private String GuestFace;
	 private String GuestQQ;
	 private String GuestHomePage;
	 private String GuestEmail;
	 private String GuestTel;
	 private String GuestDatetime;
	 private int user_id;
	 private DBjdbcConnection dbop;

	 public GuestBook()
	 {
		 Guest_id=0;
		 GuestName=null;
		 GuestFrom=null;
		 GuestContent=null;
		 GuestType=0;
		 GuestIsPassed=0;
		 GuestFace=null;
		 GuestQQ=null;
		 GuestHomePage=null;
		 GuestEmail=null;
		 GuestTel=null;
		 GuestDatetime=null;
		 user_id=0;
		 dbop=new DBjdbcConnection();
	 }

	 public  ArrayList query()
	 {
		 String sql="select * from GuestBook where 1=1 ";
		 if(this.GuestName!=null)	sql=sql+" and GuestName= '"+GuestName+"' ";
		 if(this.GuestFrom!=null)	sql=sql+" and GuestFrom= '"+GuestFrom+"' ";
		 if(this.GuestContent!=null)	sql=sql+" and GuestContent= '"+GuestContent+"' ";
		 if(this.GuestType!=-1) sql=sql+" and GuestType="+GuestType+" ";	
		 if(this.GuestIsPassed!=0) sql=sql+" and GuestIsPassed="+GuestIsPassed+" ";	
		 if(this.GuestFace!=null)	sql=sql+" and GuestFace= '"+GuestFace+"' ";
		 if(this.GuestQQ!=null)	sql=sql+" and GuestQQ= '"+GuestQQ+"' ";
		 if(this.GuestHomePage!=null)	sql=sql+" and GuestHomePage= '"+GuestHomePage+"' ";
		 if(this.GuestEmail!=null)	sql=sql+" and GuestEmail= '"+GuestEmail+"' ";
		 if(this.GuestTel!=null)	sql=sql+" and GuestTel= '"+GuestTel+"' ";
		 if(this.GuestDatetime!=null)	sql=sql+" and GuestDatetime= '"+GuestDatetime+"' ";
		 if(this.user_id!=0) sql=sql+" and user_id="+user_id+" ";	
		 sql=sql+" order by GuestDatetime desc";
		 ResultSet rs=dbop.executeQuery(sql);
		 ArrayList al=new ArrayList();	
		 try
		 {
			 while(rs.next())
			 {
				 GuestBook a=new GuestBook();
				 a.setGuest_id(rs.getInt("Guest_id"));
				 a.setGuestName(rs.getString("GuestName"));
				 a.setGuestFrom(rs.getString("GuestFrom"));
				 a.setGuestContent(rs.getString("GuestContent"));
				 a.setGuestType(rs.getInt("GuestType"));
				 a.setGuestIsPassed(rs.getInt("GuestIsPassed"));
				 a.setGuestFace(rs.getString("GuestFace"));
				 a.setGuestQQ(rs.getString("GuestQQ"));
				 a.setGuestHomePage(rs.getString("GuestHomePage"));
				 a.setGuestEmail(rs.getString("GuestEmail"));
				 a.setGuestTel(rs.getString("GuestTel"));
				 a.setGuestDatetime(rs.getString("GuestDatetime"));
				 a.setUser_id(rs.getInt("user_id"));
				 al.add(a);
			 }
		 }
		 catch(Exception e){}
		 return al;		
	 }		

	 public int add()
	 {
		 if(this.GuestName==null) GuestName="";
		 if(this.GuestFrom==null) GuestFrom="";
		 if(this.GuestContent==null) GuestContent="";
		 if(this.GuestFace==null) GuestFace="";
		 if(this.GuestQQ==null) GuestQQ="";
		 if(this.GuestHomePage==null) GuestHomePage="";
		 if(this.GuestEmail==null) GuestEmail="";
		 if(this.GuestTel==null) GuestTel="";
		 if(this.GuestDatetime==null){
			 SimpleDateFormat formatter = new SimpleDateFormat("yyyy-MM-dd HH:mm"); 
			 java.util.Date currentTime = new java.util.Date();//得到当前系统时间 

			 String str_date = formatter.format(currentTime); //将日期时间格式化
			 GuestDatetime=str_date;
		 }
		 String sql="insert into GuestBook(GuestName,GuestFrom,GuestContent,GuestType,GuestIsPassed,GuestFace,GuestQQ,GuestHomePage,GuestEmail,GuestTel,GuestDatetime,user_id) values('"+GuestName+"','"+GuestFrom+"','"+GuestContent+"',"+GuestType+","+GuestIsPassed+",'"+GuestFace+"','"+GuestQQ+"','"+GuestHomePage+"','"+GuestEmail+"','"+GuestTel+"','"+GuestDatetime+"',"+user_id+")";
		 int tiao=dbop.executeUpdate(sql);
		 return tiao;
	 }	


	 public int delete(int Guest_id)
	 {
		 String sql="delete   from GuestBook where Guest_id="+Guest_id+" or GuestType="+Guest_id;

		 int tiao=dbop.executeUpdate(sql);
		 return tiao;
	 }	


	 public int update(int Guest_id)
	 {
		 String sql="update GuestBook set GuestIsPassed="+ GuestIsPassed + "where Guest_id="+Guest_id;
		 int tiao=dbop.executeUpdate(sql);
		 return tiao;
	 }
	 

	 /*
	  * setXXX() getXXX() 方法
	  */
	 public void setGuest_id(int Guest_id)
	 {
		 this.Guest_id=Guest_id;
	 }

	 public int getGuest_id()
	 {
	 	return Guest_id;
	 }

	 public void setGuestName(String GuestName)
	 {
		 this.GuestName=GuestName;
	 }

	 public String getGuestName()
	 {
	 	return GuestName;
	 }

	 public void setGuestFrom(String GuestFrom)
	 {
		 this.GuestFrom=GuestFrom;
	 }

	 public String getGuestFrom()
	 {
	 	return GuestFrom;
	 }

	 public void setGuestContent(String GuestContent)
	 {
		 this.GuestContent=GuestContent;
	 }

	 public String getGuestContent()
	 {
	 	return GuestContent;
	 }

	 public void setGuestType(int GuestType)
	 {
		 this.GuestType=GuestType;
	 }

	 public int getGuestType()
	 {
	 	return GuestType;
	 }

	 public void setGuestIsPassed(int GuestIsPassed)
	 {
		 this.GuestIsPassed=GuestIsPassed;
	 }

	 public int getGuestIsPassed()
	 {
	 	return GuestIsPassed;
	 }

	 public void setGuestFace(String GuestFace)
	 {
		 this.GuestFace=GuestFace;
	 }

	 public String getGuestFace()
	 {
	 	return GuestFace;
	 }

	 public void setGuestQQ(String GuestQQ)
	 {
		 this.GuestQQ=GuestQQ;
	 }

	 public String getGuestQQ()
	 {
	 	return GuestQQ;
	 }

	 public void setGuestHomePage(String GuestHomePage)
	 {
		 this.GuestHomePage=GuestHomePage;
	 }

	 public String getGuestHomePage()
	 {
	 	return GuestHomePage;
	 }

	 public void setGuestEmail(String GuestEmail)
	 {
		 this.GuestEmail=GuestEmail;
	 }

	 public String getGuestEmail()
	 {
	 	return GuestEmail;
	 }

	 public void setGuestTel(String GuestTel)
	 {
		 this.GuestTel=GuestTel;
	 }

	 public String getGuestTel()
	 {
	 	return GuestTel;
	 }

	 public void setGuestDatetime(String GuestDatetime)
	 {
		 this.GuestDatetime=GuestDatetime;
	 }

	 public String getGuestDatetime()
	 {
	 	return GuestDatetime;
	 }

	 public void setUser_id(int user_id)
	 {
		 this.user_id=user_id;
	 }

	 public int getUser_id()
	 {
	 	return user_id;
	 }
	 
	 
	 /*
	  * ┌──────────────────── 今日图灵 ──┐
	  * │方法名：formatDate()
	  * │作  用：用于格式化所读取的 String 日期
	  * │参  数：String currentTime
	  * │说  明：
	  * │日  期：2007/8/8
	  * │编写人：吕海鹏
	  * └──────────────────── www.aatii.com ──┘
	  * */
	 public String formatDate(String currentTime){
		 //格式化日期
		 //import java.text.SimpleDateFormat;				
		//SimpleDateFormat formatter = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); 
		SimpleDateFormat formatter = new SimpleDateFormat("yyyy-MM-dd HH:mm"); 
		//Date currentTime = new java.util.Date();//得到当前系统时间 
		//String str_date1 = formatter.format(currentTime); //将日期时间格式化 
		
		//String str_date2 = currentTime; //将Date型日期时间转换成字符串形式 
		
		String str_date = "";
		try {
			str_date = formatter.format(formatter.parse(currentTime));
		} catch (ParseException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
		}

		return str_date;
		 
	 }
	 
	 
}