borrowstatics.java

来自「eclipse+struts+sqlserver 简单图书管理系统,内有文档」· Java 代码 · 共 37 行

package kignbi.dong;

import java.sql.ResultSet;
import java.util.ArrayList;

public class BorrowStatics {
	
	public static ArrayList Static(DB db,String searchType,String condition) throws Exception {
		ArrayList stats = new ArrayList();
		String stype1=null;
		ResultSet rs;
		String strSql = null;

		
		//strSql = "select stype case when "+stype+"='bid' then '图书编号' when" +stype+"='uid' then '读者编号' else stype='日期' end "
		
		if(searchType.equals("bid")){stype1="图书编号";}
		if(searchType.equals("uid")){stype1="读者编号";}
		if(searchType.equals("fdate")){stype1="日期";}
		System.out.print(searchType);
		strSql="select '"+stype1+"' stype ,'"+condition+"' condition,ftype,sum(fnum) snumber  from dayflow where "
		+searchType+" like '%"+condition+"%' group by ftype" ;
		rs = db.OpenSql(strSql);
        System.out.print(strSql);
		while (rs.next()) {
			Statics stat= new Statics();
			stat.setStype(rs.getString("stype"));
			stat.setCondition(rs.getString("condition"));
			stat.setFtype(rs.getString("ftype"));
			stat.setSnumber(rs.getInt("snumber"));
			stats.add(stat);
		}
		return stats;
	}

}