getmoneyhistorybean.java

通过jsp/servlet实现web打印

package bean;

import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.util.Vector;

public class GetMoneyHistoryBean {
	
	private Vector information=new Vector();
	
	private Vector getmoneyhistroy=new Vector();
	
	//private Vector userGroup=new Vector();

	public Vector getGetmoneyhistroy() {
		return getmoneyhistroy;
	}

	public void setGetmoneyhistroy(Vector getmoneyhistroy) {
		this.getmoneyhistroy = getmoneyhistroy;
	}
	
	public void getuserGroup(){
		DBOperate db=new DBOperate();
		String sql="select * from Cl_UserGroup where ID>=7";
		ResultSet rs=db.getDataInfo(sql);
		getmoneyhistroy.removeAllElements();
		try {
			ResultSetMetaData meta = rs.getMetaData();
			while(rs.next()){
				Vector v=new Vector();
				for(int i=1;i<=meta.getColumnCount();i++){
					v.add(rs.getString(i));				
				}
				getmoneyhistroy.add(v);
			}
			
			//System.out.println(getmoneyhistroy.size());
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			db.closeConnection();
		}
		
	}
	
	public Vector getUserInformation(String sex,String groupuser,String username){
		String sql="select * from UserView ";
		if(sex.equals("") && groupuser.equals("") && username.equals("")&& groupuser!=null && username!=null){
			sql=sql;
		}else{
			sql=sql+" where ";
			if(!sex.equals("")){
				if(sex.equals("请选择")){
					sql=sql+" ";
				}else{
					sql=sql+"  sex='"+sex+" '";
				}
				
			}
			if(!groupuser.equals("")){
				if(groupuser.equals("7") && sex.equals("请选择")){
					sql=sql+"  UserLevel>=7";
				}else if(groupuser.equals("7") && !sex.equals("请选择")){
					sql=sql+" and UserLevel>=7";
				}else if(!groupuser.equals("7") && sex.equals("请选择")){
					sql=sql+"  UserLevel="+groupuser;
				}else if(!groupuser.equals("7") && !sex.equals("请选择")){
					sql=sql+" and UserLevel="+groupuser;
				}
				
			}
			if(!username.equals("")){
				String s[]=username.split(" ");
				sql=sql+" and ";
				for(int i=0;i<s.length;i++){
					sql=sql+"  name like '%"+s[i]+"%' or ";
				}
				sql=sql.substring(0,sql.length()-3);
			}
		}
		System.out.println(sql);
		DBOperate db=new DBOperate();
		ResultSet rs=db.getDataInfo(sql);
		try {
			while(rs.next()){
				Vector v=new Vector();
				v.add(rs.getString("name"));
				v.add(rs.getString("birthday"));
				v.add(rs.getString("sex"));
				v.add(rs.getString("usergroup"));
				v.add(rs.getString("subject"));
				v.add(rs.getString("college"));
				information.add(v);
			}
			//System.out.println(information.size());
			
			return information;
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			
			return null;
		}finally{
			db.closeConnection();
		}
		
	}

	public Vector getInformation() {
		return information;
	}

	public void setInformation(Vector information) {
		this.information = information;
	}

	public int getAllStatistics(String sex,String groupuser,String username){
		int count=0;
		String sql="select count(*) as count from Cl_User";
		if(sex.equals("") && groupuser.equals("") && username.equals("")&& groupuser!=null && username!=null){
			sql=sql;
		}else{
			sql=sql+" where ";
			if(!sex.equals("")){
				if(sex.equals("请选择")){
					sql=sql+" UserSex=0 or UserSex=1 ";
				}else{
					sql=sql+" UserSex="+sex;
				}
				
			}
			if(!groupuser.equals("")){
				if(groupuser.equals("7")){
					sql=sql+" and UserLevel>=7";
				}else{
					sql=sql+" and UserLevel="+groupuser;
				}
				
			}
			if(!username.equals("")){
				String s[]=username.split(" ");
				sql=sql+" and ";
				for(int i=0;i<s.length;i++){
					sql=sql+"  UserReName like '%"+s[i]+"%' or ";
				}
				sql=sql.substring(0,sql.length()-3);
			}
		}
		System.out.println(sql);
		DBOperate db=new DBOperate();
		ResultSet rs=db.getDataInfo(sql);
		try {
			while(rs.next()){
				count=rs.getInt("count");
			}
			//System.out.println(information.size());
			
			return count;
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			
			return 0;
		}finally{
			db.closeConnection();
		}
	}
}