getguestbook.java

一个Struts的简易留言本

package net.javafan.guestbook.data;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;

import net.javafan.guestbook.dboperator.DBConn;

public class GetGuestbook{
	
	public ArrayList getGblist() throws Exception{
		ArrayList gblist = new ArrayList();
		ResultSet rs = null;
		DBConn db = new DBConn();
		try{
			String sql = "select * from guestbook order by adddate desc";
			rs = db.executeQuery(sql);
			while(rs.next()){
				GuestBook gb = new GuestBook();
				gb.setId(Integer.parseInt(rs.getString("id")));
				gb.setUsername(toGB(rs.getString("username")));
				gb.setEmail(rs.getString("email"));
				gb.setHomepage(rs.getString("homepage"));
				gb.setOicq(rs.getString("oicq"));
				gb.setFace(rs.getString("face"));
				gb.setContent(toGB(rs.getString("content")));
				gb.setUserip(rs.getString("userip"));
				gb.setAdddate(rs.getString("adddate"));
				gb.setReply(rs.getString("reply"));
				gb.setReplydate(rs.getString("replydate"));
				gblist.add(gb);
				gb = null;
			}
		}catch(SQLException ex){
			System.out.print("Query Data Error:" + ex.getMessage());
		}finally{
			rs.close();
			db.CloseConn();
		}
		return gblist;
	}
	
	public static String toGB(String iso){
		String gb=null; 
		if (iso != null) { 
			try { 
				gb=new String(iso.getBytes("ISO-8859-1"),"GB2312"); 
			} catch (Exception e) { 
				gb=null; 
			} 
		} 
		return gb; 
	}
	
}