demandsql.java

JSP简单的OA系统_非常不错的一个系统

package com.zh.util;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
import com.zh.conpool.*;
import com.bwm.string.Str;
import java.io.*;
import java.util.Vector;
import java.util.Iterator;
import java.util.Collection;
import com.zh.util.demandset;
public class demandsql{
	String sql;
	ResultSet rs;
	Condata con=new Condata();
	Vector vec=new Vector();
	demandset demand=new demandset();
	String id;
	int countpage=0;
	int showpage=0;
	int pagesize=0;
	int rowcount=0;
	public Vector getSql(String id,int pagesize,int showpage){
		this.id=id;
		this.pagesize=pagesize;
		this.showpage=showpage;
		sql="select * from tb_demand where ClientId='"+id+"' order by id Desc";
		try{
			con.getConnection();
		}catch(Exception e){
			e.getMessage();
		}
		Iterator it=vec.iterator();
		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++){
				demandset demand=new demandset();
				//demand.setId(rs.getString(1));
				demand.setClientId(rs.getString(1));
				demand.setDemand(rs.getString(3));
				demand.setMoney(rs.getInt(4));
				demand.setExplain(rs.getString(5));
				vec.add(demand);
				if(!rs.next())
				break;	
			}
			}
		}catch(SQLException er){
			er.getMessage();
		}
		try{
			con.close();
			con=null;
		}catch(Exception e){
			e.getMessage();
		}
		return vec;
	}
}