/* * 留言板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;		 	 }	 	 }