package cn.jack.bean;

import cn.jack.form.GbookForm;
import cn.jack.tool.*;
import java.sql.*;
import java.util.*;

public class GbookManger {
DBConnection DBConn = new DBConnection();

public void Save(String gbtitle,String gbuser,String gbmail,String gbcontent,String gbface,String gbtime,String gbip){
	Connection Conn = DBConn.getConn();
	PreparedStatement ps = null;
	StringBuffer sb = new StringBuffer();
	sb.append("insert into BookContent");
	sb.append("(gbtitle,gbuser,gbmail,gbcontent,gbface,gbtime,gbip)");
	sb.append("values(?,?,?,?,?,?,?)");
	try
	{
		ps = Conn.prepareStatement(sb.toString());
		ps.setString(1,gbtitle);
		ps.setString(2,gbuser);
		ps.setString(3,gbmail);
		ps.setString(4, gbcontent);
		ps.setString(5,gbface);
		ps.setString(6, gbtime);
		ps.setString(7, gbip);
		ps.executeUpdate();
		ps.close();
		Conn.close();
	}catch(Exception e){}
	
}
public List itemlist(){
	List ax = new ArrayList();
	Connection Conn = DBConn.getConn();
	Statement stmt = null;
	ResultSet rs = null;
	String sql="select * from BookContent order by id desc";
	try
	{
		stmt = Conn.createStatement();
		rs = stmt.executeQuery(sql);
		while(rs.next()){
			GbookForm gf = new GbookForm();
			gf.setGbcontent(StringTool.ConversionAll(rs.getString("gbcontent")));
			gf.setGbface(rs.getString("gbface"));
			gf.setGbip(rs.getString("gbip"));
			gf.setGbtime(rs.getString("gbtime"));
			gf.setGbtitle(rs.getString("gbtitle"));
			gf.setGbuser(rs.getString("gbuser"));
			gf.setId(rs.getInt("id"));
			gf.setGbre(rs.getString("gbre"));
			gf.setGbretime(rs.getString("gbretime"));
			ax.add(gf);
		}
			rs.close();
			stmt.close();
			Conn.close();
		
	}catch(Exception e){}
	return ax;
}
}