statisticsobjbean.java

通过jsp/servlet实现web打印

package bean;

import java.io.Serializable;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Vector;

public class StatisticsObjBean implements Serializable{
	private Vector v=new Vector();
	private Vector num=new Vector();
	private String itemName;
	private String itemFee;
	public Vector objsta(){
		String sql="select * from Print_item";
		DBOperate db=new DBOperate();
		ResultSet rs=db.getDataInfo(sql);
		try {
			while(rs.next()){
				StatisticsObjBean sta=new StatisticsObjBean();
				sta.setItemFee(rs.getString("itemFee"));
				sta.setItemName(rs.getString("itemName"));
				v.add(sta);
			}
			return v;
		} catch (SQLException e) {
			e.printStackTrace();
			return null;
		}finally{
			db.closeConnection();
		} 
		
	}
	
	public Vector getV() {
		return v;
	}

	public void setV(Vector v) {
		this.v = v;
	}
	public void getPeople(){
		String sql="select count(*) as count from CL_User";
		DBOperate db=new DBOperate();
		ResultSet rs=db.getDataInfo(sql);
		try {
			while(rs.next()){
				num.add(rs.getString("count"));
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}
		finally{
			db.closeConnection();
		} 
	}

	public String getPeopleGroup(String groupname){
		String count="";
		String sql="select count(*) as count from CL_User where UserLevel="+groupname;
		DBOperate db=new DBOperate();
		ResultSet rs=db.getDataInfo(sql);
		try {
			while(rs.next()){
				count=rs.getString("count");
			}
			return count;
		} catch (SQLException e) {
			e.printStackTrace();
			return count;
		}finally{
			db.closeConnection();
		} 
		
	}
	
	public int getallmoney(){
		String sql="select itemFee from Print_item";
		DBOperate db=new DBOperate();
		ResultSet rs=db.getDataInfo(sql);
		Vector<Integer> allmoney= new Vector<Integer>();
		allmoney.removeAllElements();
		try {
			while(rs.next()){
				allmoney.add(rs.getInt(1));
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}
		int amoney=0;
		for(int i=0;i<allmoney.size();i++){
			amoney+=allmoney.get(i);
		}
		return amoney;
		
	}
	
	public Vector getNum() {
		return num;
	}

	public void setNum(Vector num) {
		this.num = num;
	}

	public String getItemName() {
		return itemName;
	}

	public void setItemName(String itemName) {
		this.itemName = itemName;
	}

	public String getItemFee() {
		return itemFee;
	}

	public void setItemFee(String itemFee) {
		this.itemFee = itemFee;
	}
	
	public String getGroupname(String groupname){
		String group="";
		String sql="select * from Cl_UserGroup where ID="+groupname;
		DBOperate db=new DBOperate();
		ResultSet rs=db.getDataInfo(sql);
		try {
			while(rs.next()){
				group=rs.getString("GroupName");
			}
			return group;
		} catch (SQLException e) {
			e.printStackTrace();
			return null;
		}finally{
			db.closeConnection();
		} 
	}
}