epibolysql.java

企业办公自动化管理系统

package com.zh.util;
import com.zh.util.epibolyset;
import com.zh.conpool.*;
import com.bwm.string.*;
import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.util.Vector;
public class epibolysql{
	String sql;
	String id;
	ResultSet rs=null;
	int showpage=1;
	int pagecount=0;
	int pagesize=0;
	int rowcount=0;
	Condata con=new Condata();
	public Vector Init(String id,int showpage,int pagesize){
		try{
			con.getConnection();
		}catch(Exception e){
			e.getMessage();
		}
		this.id=id;
		this.showpage=showpage;
		this.pagesize=pagesize;
		
		Vector v1=new Vector();
		sql="select * from tb_epiboly where ContId='"+id+"' order by Id DESC";
		try{
			rs=con.executeQuery(sql);
			if(!rs.next()){
			}else{
				rs.last();
				rowcount=rs.getRow();
				pagecount=(((rowcount%pagesize)==0)?(rowcount/pagesize):(rowcount/pagesize+1));
				if(showpage>pagecount){
					showpage=pagecount;
				}
				rs.absolute((showpage-1)*pagesize+1);
				for(int i=0;i<pagesize;i++){
					gathersql gath=new gathersql();
					gath.setId(rs.getString(1));
					gath.setDattime(rs.getString(3));
					gath.setMoney(rs.getInt(4));
					gath.setTest(rs.getString(5));
					v1.add(gath);
				if(!rs.next()){
					break;
				}
				}
				}
			}catch(SQLException ex){
			ex.getMessage();
		}
		try{
			con.close();
			con=null;
		}catch(Exception e){
			e.getMessage();
		}
		return v1;
	}
	public String getRs(String id){
		this.id=id;
		sql="select * from tb_epiboly where ContId='"+id;
		return sql;
	}
}