classinnerblogicclass.java

关于学校管理

package student.manage.classinner;

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

import student.manage.javaConnction.connectionDB;
import student.manage.mark.*;
import student.manage.mark.MarkBean;

public class ClassInnerBlogicClass {

	connectionDB db = new connectionDB();

	Statement state = null;

	ResultSet result = null;

	ResultSet rs = null;

	

	public Statement getConn() {

		state = db.getConnectionDB();
		return state;
	}

	public ArrayList getAllList(MarkBean markBean) {
		ArrayList allList = new ArrayList();
		allList.add(this.getList1(markBean));
		allList.add(this.getList2(markBean));
		allList.add(this.getList3(markBean));
		allList.add(this.getList4(markBean));
		allList.add(this.getList5(markBean));
		allList.add(this.getList6(markBean));
		allList.add(this.getList7(markBean));
		allList.add(this.getList8(markBean));
		allList.add(this.getList9(markBean));
		return allList;

	}

	public ArrayList getList1(MarkBean markBean) {
		ArrayList list = new ArrayList();
		// String sql = "select CLASS_ID,YUWEN_B ,COUNT(YUWEN_B)AS YUWEN
		// ,SHUXUE_B,count(SHUXUE_B)AS SHUXUE,YINGYU_B,count(YINGYU_B)AS
		// YINGYU,WULI_B,COUNT(WULI_B),HUAXUE_B,COUNT(HUAXUE_B),ZHENGZHI_B,COUNT(ZHENGZHI_B),LISHI_B,COUNT(LISHI),DILI_B,COUNT(DILI_B),SHENGWU_B,COUNT(SHENGWU_B)AS
		// YUWEN from (" +
		// "select * from (" +markBean.getSql()+ ") AS B ) AS D " +
		// "WHERE GRADE_ID = '"+markBean.getGRADE_ID()+"' GROUP BY
		// CLASS_ID,YUWEN_B,SHUXUE_B,YINGYU_B,ZHENGZHI_B,LISHI_B,DILI_B,WULI_B,HUAXUE_B,SHENGWU_B";

		String sql1 = "select  CLASS_ID,YUWEN_B ,COUNT(YUWEN_B)AS YUWEN from ("
				+ "select * from (" + markBean.getSql() + ") AS B ) AS D "
				+ "WHERE GRADE_ID = '" + markBean.getGRADE_ID()
				+ "'  GROUP BY CLASS_ID,YUWEN_B order by CLASS_ID";

		System.out.println(sql1);
		try {
			rs = this.getConn().executeQuery(sql1);
			while (rs.next()) {
				CopyOfMarkBean markBean1 = new CopyOfMarkBean();
				markBean1.setCLASS_ID(rs.getString(1));
				markBean1.setYUWEN_B(rs.getString(2));
				markBean1.setYUWEN(rs.getInt(3));
				list.add(markBean1);
			}

		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}

		return list;

	}

	public ArrayList getList2(MarkBean markBean) {

		ArrayList list = new ArrayList();
		String sql2 = "select  CLASS_ID ,SHUXUE_B,count(SHUXUE_B)AS SHUXUE from ("
				+ "select * from ("
				+ markBean.getSql()
				+ ") AS B ) AS D "
				+ "WHERE GRADE_ID = '"
				+ markBean.getGRADE_ID()
				+ "'  GROUP BY CLASS_ID,SHUXUE_B order by CLASS_ID";
		System.out.println(sql2);
		try {

			rs = this.getConn().executeQuery(sql2);
			while (rs.next()) {
				Copy_2_of_MarkBean markBean1 = new Copy_2_of_MarkBean();
				markBean1.setCLASS_ID(rs.getString(1));
				markBean1.setSHUXUE_B(rs.getString(2));
				markBean1.setSHUXUE(rs.getInt(3));
				list.add(markBean1);
			}

		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}

		return list;

	}

	public ArrayList getList3(MarkBean markBean) {

		ArrayList list = new ArrayList();
		String sql3 = "select  CLASS_ID ,YINGYU_B,count(YINGYU_B)AS YINGYU from ("
				+ "select * from ("
				+ markBean.getSql()
				+ ") AS B ) AS D "
				+ "WHERE GRADE_ID = '"
				+ markBean.getGRADE_ID()
				+ "'  GROUP BY CLASS_ID,YINGYU_B order by CLASS_ID";
		System.out.println(sql3);
		try {

			rs = this.getConn().executeQuery(sql3);
			while (rs.next()) {
				Copy_3_of_MarkBean markBean1 = new Copy_3_of_MarkBean();
				markBean1.setCLASS_ID(rs.getString(1));
				markBean1.setYINGYU_B(rs.getString(2));
				markBean1.setYINGYU(rs.getInt(3));
				list.add(markBean1);
			}

		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}

		return list;

	}

	public ArrayList getList4(MarkBean markBean) {

		ArrayList list = new ArrayList();
		String sql4 = "select  CLASS_ID ,WULI_B,COUNT(WULI_B) from ("
				+ "select * from (" + markBean.getSql() + ") AS B ) AS D "
				+ "WHERE GRADE_ID = '" + markBean.getGRADE_ID()
				+ "'  GROUP BY CLASS_ID,WULI_B order by CLASS_ID";
		System.out.println(sql4);
		try {

			rs = this.getConn().executeQuery(sql4);
			while (rs.next()) {
				Copy_4_of_MarkBean markBean1 = new Copy_4_of_MarkBean();
				markBean1.setCLASS_ID(rs.getString(1));
				markBean1.setWULI_B(rs.getString(2));
				markBean1.setWULI(rs.getInt(3));
				list.add(markBean1);
			}

		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}

		return list;

	}

	public ArrayList getList5(MarkBean markBean) {

		ArrayList list = new ArrayList();
		String sql5 = "select  CLASS_ID ,HUAXUE_B,COUNT(HUAXUE_B) from ("
				+ "select * from (" + markBean.getSql() + ") AS B ) AS D "
				+ "WHERE GRADE_ID = '" + markBean.getGRADE_ID()
				+ "'  GROUP BY CLASS_ID,HUAXUE_B order by CLASS_ID";
		System.out.println(sql5);
		try {
			rs = this.getConn().executeQuery(sql5);
			while (rs.next()) {
				Copy_5_of_MarkBean markBean1 = new Copy_5_of_MarkBean();
				markBean1.setCLASS_ID(rs.getString(1));
				markBean1.setHUAXUE_B(rs.getString(2));
				markBean1.setHUAXUE(rs.getInt(3));
				list.add(markBean1);
			}

		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}

		return list;

	}

	public ArrayList getList6(MarkBean markBean) {

		ArrayList list = new ArrayList();
		String sql6 = "select  CLASS_ID ,ZHENGZHI_B,COUNT(ZHENGZHI_B) from ("
				+ "select * from (" + markBean.getSql() + ") AS B ) AS D "
				+ "WHERE GRADE_ID = '" + markBean.getGRADE_ID()
				+ "'  GROUP BY CLASS_ID,ZHENGZHI_B order by CLASS_ID";
		System.out.println(sql6);
		try {
			
				rs = this.getConn().executeQuery(sql6);
				while (rs.next()) {
				Copy_6_of_MarkBean markBean1 = new Copy_6_of_MarkBean();
				markBean1.setCLASS_ID(rs.getString(1));
				markBean1.setZHENGZHI_B(rs.getString(2));
				markBean1.setZHENGZHI(rs.getInt(3));
				list.add(markBean1);
			}

		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return list;
	}

	public ArrayList getList7(MarkBean markBean) {

		ArrayList list = new ArrayList();
		String sql7 = "select  CLASS_ID ,LISHI_B,COUNT(LISHI) from ("
				+ "select * from (" + markBean.getSql() + ") AS B ) AS D "
				+ "WHERE GRADE_ID = '" + markBean.getGRADE_ID()
				+ "'  GROUP BY CLASS_ID,LISHI_B order by CLASS_ID";

		System.out.println(sql7);
		try {
			
				rs = this.getConn().executeQuery(sql7);
				while (rs.next()) {
				Copy_7_of_MarkBean markBean1 = new Copy_7_of_MarkBean();
				markBean1.setCLASS_ID(rs.getString(1));
				markBean1.setLISHI_B(rs.getString(2));
				markBean1.setLISHI(rs.getInt(3));
				list.add(markBean1);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}

		return list;

	}

	public ArrayList getList8(MarkBean markBean) {

		ArrayList list = new ArrayList();
		String sql8 = "select  CLASS_ID ,DILI_B,COUNT(DILI_B) from ("
				+ "select * from (" + markBean.getSql() + ") AS B ) AS D "
				+ "WHERE GRADE_ID = '" + markBean.getGRADE_ID()
				+ "'  GROUP BY CLASS_ID,DILI_B order by CLASS_ID";
		System.out.println(sql8);

		try {
			
				rs = this.getConn().executeQuery(sql8);
				while (rs.next()) {
				Copy_8_of_MarkBean markBean1 = new Copy_8_of_MarkBean();
				markBean1.setCLASS_ID(rs.getString(1));
				markBean1.setDILI_B(rs.getString(2));
				markBean1.setDILI(rs.getInt(3));
				list.add(markBean1);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}

		return list;

	}

	public ArrayList getList9(MarkBean markBean) {

		ArrayList list = new ArrayList();
		String sql9 = "select  CLASS_ID ,SHENGWU_B,COUNT(SHENGWU_B) from ("
				+ "select * from (" + markBean.getSql() + ") AS B ) AS D "
				+ "WHERE GRADE_ID = '" + markBean.getGRADE_ID()
				+ "'  GROUP BY CLASS_ID,SHENGWU_B order by CLASS_ID";
		System.out.println(sql9);

		try {
			
				rs = this.getConn().executeQuery(sql9);
				while (rs.next()) {
				Copy_9_of_MarkBean markBean1 = new Copy_9_of_MarkBean();
				markBean1.setCLASS_ID(rs.getString(1));
				markBean1.setSHENGWU_B(rs.getString(2));
				markBean1.setSHENGWU(rs.getInt(3));
				list.add(markBean1);
			}

		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}

		return list;

	}

}