package dao;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import bean.academyBean;
import bean.classBean;
import bean.professionBean;
import bean.sexBean;
import bean.timeBean;
import bean.typeBean;
import db.db;
public class chartsDAO {
private Connection conn;
public chartsDAO(){
this.conn=db.getConnection();
}
public ArrayList<academyBean> academyChart()
{
PreparedStatement pstmt = null;
ResultSet rst = null;
String sql = "select u_academy,count(*) from user , borrow where borrow.U_ID = user.U_ID group by u_academy";
try{
pstmt = conn.prepareStatement(sql);
rst = pstmt.executeQuery();
ArrayList<academyBean> array = new ArrayList<academyBean>();
while(rst.next())
{
academyBean ab = new academyBean();
ab.setU_academy(rst.getString("u_academy"));
ab.setNum(rst.getInt("count(*)"));
array.add(ab);
}
pstmt.close();
rst.close();
return array;
}catch(SQLException e){
return new ArrayList<academyBean>();
}finally{
try{
conn.close();
}catch(SQLException e){
System.out.println("Error occured at closing connection");
}
}
}
public ArrayList<classBean> classChart()
{
PreparedStatement pstmt = null;
ResultSet rst = null;
String sql = "select u_class,count(*) from user , borrow where borrow.U_ID = user.U_ID group by u_class";
try{
pstmt = conn.prepareStatement(sql);
rst = pstmt.executeQuery();
ArrayList<classBean> array = new ArrayList<classBean>();
while(rst.next())
{
classBean cb = new classBean();
cb.setU_class(rst.getString("u_class"));
cb.setNum(rst.getInt("count(*)"));
array.add(cb);
}
pstmt.close();
rst.close();
return array;
}catch(SQLException e){
return new ArrayList<classBean>();
}finally{
try{
conn.close();
}catch(SQLException e){
System.out.println("Error occured at closing connection");
}
}
}
public ArrayList<professionBean> professionChart()
{
PreparedStatement pstmt = null;
ResultSet rst = null;
String sql = " select u_profession,count(*) from user , borrow where borrow.U_ID = user.U_ID group by u_profession";
try{
pstmt = conn.prepareStatement(sql);
rst = pstmt.executeQuery();
ArrayList<professionBean> array = new ArrayList<professionBean>();
while(rst.next())
{
professionBean cb = new professionBean();
cb.setU_profession(rst.getString("u_profession"));
cb.setNum(rst.getInt("count(*)"));
array.add(cb);
}
pstmt.close();
rst.close();
return array;
}catch(SQLException e){
return new ArrayList<professionBean>();
}finally{
try{
conn.close();
}catch(SQLException e){
System.out.println("Error occured at closing connection");
}
}
}
public ArrayList<sexBean> sexChart()
{
PreparedStatement pstmt = null;
ResultSet rst = null;
String sql = "select u_sex,count(*) from user , borrow where borrow.U_ID = user.U_ID group by u_sex";
try{
pstmt = conn.prepareStatement(sql);
rst = pstmt.executeQuery();
ArrayList<sexBean> array = new ArrayList<sexBean>();
while(rst.next())
{
sexBean sb = new sexBean();
sb.setU_sex(rst.getString("u_sex"));
sb.setNum(rst.getInt("count(*)"));
array.add(sb);
}
pstmt.close();
rst.close();
return array;
}catch(SQLException e){
return new ArrayList<sexBean>();
}finally{
try{
conn.close();
}catch(SQLException e){
System.out.println("Error occured at closing connection");
}
}
}
public ArrayList<typeBean> typeChart()
{
PreparedStatement pstmt = null;
ResultSet rst = null;
String sql = "select u_type,count(*) from user , borrow where borrow.U_ID = user.U_ID group by u_type";
try{
pstmt = conn.prepareStatement(sql);
rst = pstmt.executeQuery();
ArrayList<typeBean> array = new ArrayList<typeBean>();
while(rst.next())
{
typeBean tb = new typeBean();
tb.setU_type(rst.getString("u_type"));
tb.setNum(rst.getInt("count(*)"));
array.add(tb);
}
pstmt.close();
rst.close();
return array;
}catch(SQLException e){
return new ArrayList<typeBean>();
}finally{
try{
conn.close();
}catch(SQLException e){
System.out.println("Error occured at closing connection");
}
}
}
public ArrayList<timeBean> timeChart()
{
PreparedStatement pstmt = null;
ResultSet rst = null;
String sql = "select MONTH(borrow_time) as month,count(*) from borrow group by MONTH(borrow_time)";
try{
pstmt = conn.prepareStatement(sql);
rst = pstmt.executeQuery();
ArrayList<timeBean> array = new ArrayList<timeBean>();
while(rst.next())
{
timeBean timebean = new timeBean();
timebean.setU_time(rst.getInt("month"));
timebean.setNum(rst.getInt("count(*)"));
array.add(timebean);
}
pstmt.close();
rst.close();
return array;
}catch(SQLException e){
return new ArrayList<timeBean>();
}finally{
try{
conn.close();
}catch(SQLException e){
System.out.println("Error occured at closing connection");
}
}
}
}
qlp.zip （58个子文件） 
qlp .settings 
org.eclipse.wst.jsdt.ui.superType.name 6B com.genuitec.eclipse.core.prefs 138B org.eclipse.wst.common.project.facet.core.xml 252B org.eclipse.wst.common.component 447B org.eclipse.wst.jsdt.ui.superType.container 49B .jsdtscope 500B org.eclipse.jdt.core.prefs 395B src dao text.java 523B chartsDAO.java 7KB action chartsAction.java 2KB db db.java 846B bean academyBean.java 339B sexBean.java 304B typeBean.java 312B timeBean.java 306B classBean.java 320B professionBean.java 357B struts.xml 1KB .project 2KB WebRoot 
professionChart.html 2KB timeChart.html 3KB META-INF MANIFEST.MF 36B WEB-INF web.xml 736B classes dao text.class 1KB chartsDAO.class 6KB action chartsAction.class 4KB db db.class 1KB bean academyBean.class 729B classBean.class 717B sexBean.class 705B typeBean.class 711B timeBean.class 643B professionBean.class 747B struts.xml 1KB lib 
struts2-json-plugin-2.3.4.jar 69KB javassist-3.11.0.GA.jar 600KB asm-tree-3.3.jar 21KB mysql-connector-java-5.1.45-bin.jar 976KB asm-3.3.jar 43KB xwork-core-2.3.24.jar 661KB log4j-core-2.2.jar 807KB ognl-3.0.6.jar 223KB freemarker-2.3.22.jar 1.24MB log4j-api-2.2.jar 130KB asm-commons-3.3.jar 37KB struts2-core-2.3.24.jar 812KB commons-io-2.2.jar 170KB commons-lang3-3.2.jar 376KB commons-fileupload-1.3.1.jar 67KB js echarts.common.min.js 459KB echarts.min.js 727KB sexChart.html 2KB typeChart.html 2KB index.jsp 834B classChart.html 2KB academyChart.html 2KB .mymetadata 282B .classpath 529B .myeclipse 资源评论
