callsql.java

企业办公自动化管理系统

package com.zh.util;
import java.sql.*;
import com.zh.util.*;
import javax.servlet.*;
import javax.servlet.http.*;
import com.bwm.string.*;
import java.util.Collection;
import java.util.ArrayList;
import java.util.Vector;
import java.util.Iterator;
import com.zh.conpool.Condata;
public class callsql{
	
	String dattime;
	Vector coll=new Vector();
	String callid;
	String calltest;
	String callresult;
	String callremark;
	String operation;
	Condata con=new Condata();
	String sql;
	ResultSet rs;
	int showpage=0;
	int pagesize=0;
	String id;
	public Vector select(int pagesize,int showpage,String id){
		
		int countpage=0;
		int countrow=0;
		this.showpage=showpage;
		this.pagesize=pagesize;
		this.id=id;
		try{
			con.getConnection();
		}catch(Exception e){
			e.getMessage();
		}	
		sql="select * from tb_call where ClientId='"+id+"' order by Id DESC";	
		Iterator it=coll.iterator();	
		try{	
			rs=con.executeQuery(sql);
			if(!rs.next()){
			}else{
				rs.last();
				countrow=rs.getRow();
				countpage=(((countrow%pagesize)==0)?(countrow/pagesize):(countrow/pagesize+1));
				rs.absolute((showpage-1)*pagesize+1);//定位下一页的首记录
				for(int i=1;i<pagesize;i++){
				call cal=new call();
				cal.setCallid(rs.getString(1));
				cal.setDattime(rs.getString(2));
				cal.setCallTest(rs.getString(4));
				cal.setResult(rs.getString(5));
				cal.setCallremark(rs.getString(6));
				cal.setOperation(rs.getString(7));
				coll.add(cal);					
				if(!rs.next())
				break;
				}
		}
		}catch(Exception ex){
		
		}
		try{
				con.close();
				con=null;
			}catch(Exception e){
				e.getMessage();
			}
		return coll;
		}
		public int count(int pagesize,int showpage){
			int count=0;
			int countrow=0;
			ResultSet rst=null;
			this.showpage=showpage;
			this.pagesize=pagesize;
			try{
				con.getConnection();
			}catch(Exception e){
				e.getMessage();
			}	
			sql="select * from tb_call";
		try{
			
			rst=con.executeQuery(sql);
			if(!rst.next()){
			}else{
				rst.last();
				countrow=rst.getRow();
				count=(((countrow%pagesize)==0)?(countrow/pagesize):(countrow/pagesize+1));	
		}
		}catch(Exception e){
			e.getMessage();
		}
	
		return count;
		
	}
	
}