tocompstatdao.java

实现银行系统中某个部门的计算机设备管理、公共信息管理、权限用户管理、系统设置等,为系统的安全正常运行提供保障

package com.isoftstone.banktearm1.dao;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.Iterator;

import com.isoftstone.banktearm1.db.DB;
import com.isoftstone.banktearm1.vo.BankTeam1StatVo;


public class ToCompStatDao extends DB{
	 
	public ArrayList getlist()throws SQLException, ClassNotFoundException{
		 
		 ArrayList list=new ArrayList();
		 Connection cn=this.getConnection();
		 Statement stmt=cn.createStatement();
		 String sql="select count(NumberID) as [count],UnitName from [comp], Unit where mid(cstr(NumberID),1,2)=cstr(Unit.UnitID) group by UnitName";
		 ResultSet rs=stmt.executeQuery(sql);
		 
		 while(rs.next()){
			 BankTeam1StatVo vo=new BankTeam1StatVo();
			 vo.setCount(rs.getInt("count"));
			 vo.setUnitName(rs.getString("UnitName"));
			 list.add(vo);
			 
		 }
		 this.closs(rs, stmt, cn);
		 return list;
	}
	
	
	
	
	public ArrayList getSum()throws SQLException, ClassNotFoundException{
		 BankTeam1StatVo vo=new BankTeam1StatVo();
		ArrayList list=new ArrayList();
		 Connection cn=this.getConnection();
		 Statement stmt=cn.createStatement();
		 String sql="select count(NumberID) from comp,unit where  UnitID and mid(cstr(comp.NumberID),1,2)=cstr(unit.UnitID)";
		 ResultSet rs=stmt.executeQuery(sql);
		 
		 while(rs.next()){
			vo.setSum(rs.getInt("Expr1000"));
			 list.add(vo);
		 }
		 this.closs(rs, stmt, cn);
		 return list;
		 
	}
	
	public static void main(String age[]){
		ArrayList list=new ArrayList();
		ToCompStatDao dao=new ToCompStatDao();
		
		try{
		list=dao.getlist();
		if(list!=null){
			Iterator it=list.iterator();
			while(it.hasNext()){
				BankTeam1StatVo vo=(BankTeam1StatVo)it.next();
				System.out.println(vo.getCount());
			   System.out.println(vo.getUnitName());
			 
			}
		}
		
		}
		catch (Exception e) {
		System.out.println(e.getMessage());
		}
	}
}