package com.zh.util;
import java.io.*;
import java.sql.*;
import com.bwm.string.Str;
import javax.servlet.*;
import javax.servlet.http.*;
import com.zh.conpool.Condata;
import java.util.Vector;
import java.util.Iterator;
import com.zh.util.gathersql;
public class gatheradd{
	String sql;
	String dattime;
	int money;
	String test;
	String id;
	String create;
	String modify;
	Str str=new Str();
	Condata con=new Condata();
	String clientname;
	String contid;
	int pagesize=0;
	int showpage=0;
	int countpage=0;
	String topage;
	int rowcount=0;
	String cid;
	public void Init(javax.servlet.http.HttpServletRequest req,javax.servlet.http.HttpServletResponse res)throws ServletException,IOException,SQLException{
		try{
			con.getConnection();
		}catch(Exception e){
			e.getMessage();
		}
		PrintWriter out=res.getWriter();
		dattime=req.getParameter("dattime");
		try{
			money=Integer.parseInt(req.getParameter("money"));	
		}catch(NumberFormatException er){
			er.getMessage();
		}
		id=req.getParameter("id");
		cid=req.getParameter("cid");
		out.print(id);
		test=str.toChinese(req.getParameter("test"));
		clientname=req.getParameter("clientName");
		create=req.getParameter("create");
		modify=req.getParameter("modify");
		if(create!=null&&create.equals("create")){
			sql="insert into tb_gather(ContId,Dattime,Money,Test)values('"+cid+"','"+dattime+"','"+money+"','"+test+"')";
		}else if(modify!=null&&modify.equals("1")){
			sql="delete tb_gather where Id='"+id+"'";
		}
		out.println(modify);	
		int temp=con.executeUpdate(sql);
		if(temp>0){
			out.println("<br>");
			out.println("數(shù)據(jù)庫更新成功");
			res.sendRedirect("Get_Log_Index.jsp?id="+cid+"&&clientName="+clientname+"");
		}else{
			out.println("數(shù)據(jù)更新失敗");
		}
		try{
			con.close();
			con=null;
		}catch(Exception e){
			e.getMessage();
		}
	}
	public Vector getRs(String id,int pagesize,int showpage){
		this.id=id;
		this.showpage=showpage;
		this.pagesize=pagesize;
		Vector v1=new Vector();
		Iterator it=v1.iterator();
		sql="select * from tb_gather where ContId='"+id+"' order by Id DESC";
		ResultSet rs=null;
		try{
			con.getConnection();
		}catch(Exception e){
			e.getMessage();
		}
		try{
			rs=con.executeQuery(sql);
			if(!rs.next()){
			}else{
				rs.last();
				rowcount=rs.getRow();
				countpage=(((rowcount%pagesize)==0)?(rowcount/pagesize):(rowcount/pagesize+1));
				if(showpage<0){
					showpage=1;
				}
				if(showpage>countpage){
					showpage=countpage;
				}
				rs.absolute((showpage-1)*pagesize+1);
				for(int i=0;i<pagesize;i++){				
					gathersql gather=new gathersql();
					gather.setId(rs.getString(1));
					gather.setDattime(rs.getString(3).substring(0,10));
					gather.setMoney(rs.getInt(4));
					gather.setTest(rs.getString(5));
					v1.add(gather);
				if(!rs.next()){
					break;
				}
				}
		}
		}catch(SQLException er){
			er.getMessage();
		}
		try{
			con.close();
			con=null;
		}catch(Exception e){
			e.getMessage();
		}
		return v1;
	
	}
	public String getSql(String id){
		this.id=id;
		sql="select * from tb_gather where ContId='"+id+"'";
		return sql;
	}
}