compareblogicclass.java

关于学校管理

package student.manage.compare;

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.MarkBean;
import student.manage.mark.SuperBean;

public class CompareBlogicClass {

	connectionDB db = new connectionDB();

	Statement state = null;

	ResultSet result = null;

	int insertNum = 0;

	public Statement getConn() {

		state = db.getConnectionDB();
		return state;
	}
	
	public ArrayList getSecondMark(SuperBean superBean) {
		ArrayList list = new ArrayList();
		
        String sql = "select * from (select * from RIKO_MARK where ZONG >=(select min(T.ZONG) from (Select  TOP "+superBean.getConditionEnd()+" (ZONG) from RIKO_MARK t  where GRADE_ID = '"+superBean.getMarkBean().getGRADE_ID()+"' order by ZONG desc) AS T ) and GRADE_ID = '"+superBean.getMarkBean().getGRADE_ID()+"' and ZONG <=(select min(T.ZONG) from (Select  TOP "+superBean.getConditionStart()+" (ZONG)  from RIKO_MARK t  where GRADE_ID = '"+superBean.getMarkBean().getGRADE_ID()+"' ORDER BY ZONG DESC) AS T)  and GRADE_ID = '"+superBean.getMarkBean().getGRADE_ID()+"') AS A ";
	
		
			System.out.println(sql);
			try {

				ResultSet rs = this.getConn().executeQuery(sql);
				while (rs.next()) {
					MarkBean markBean = new MarkBean();
					markBean.setGRADE_ID((rs.getString(2)));
					markBean.setCLASS_ID((rs.getString(3)));
					markBean.setSTUDENT_NAME((rs.getString(4)));
					markBean.setYUWEN((rs.getInt(5)));
					markBean.setYUWEN_SECOND_MARK((rs.getInt(6)));
					markBean.setYUWEN_B((rs.getString(7)));
					markBean.setSHUXUE((rs.getInt(8)));
					markBean.setSHUXUE_SECOND_MARK((rs.getInt(9)));
					markBean.setSHUXUE_B((rs.getString(10)));
					markBean.setZHENGZHI((rs.getInt(11)));
					markBean.setZHENGZHI_SECOND_MARK((rs.getInt(12)));
					markBean.setZHENGZHI_B((rs.getString(13)));
					markBean.setYINGYU((rs.getInt(14)));
					markBean.setYINGYU_SECOND_MARK((rs.getInt(15)));
					markBean.setYINGYU_B((rs.getString(16)));
					markBean.setWULI((rs.getInt(17)));
					markBean.setWULI_SECOND_MARK((rs.getInt(18)));
					markBean.setWULI_B((rs.getString(19)));
					markBean.setHUAXUE((rs.getInt(20)));
					markBean.setHUAXUE_SECOND_MARK((rs.getInt(21)));
					markBean.setHUAXUE_B((rs.getString(22)));
					markBean.setLISHI((rs.getInt(23)));
					markBean.setLISHI_SECOND_MARK((rs.getInt(24)));
					markBean.setLISHI_B((rs.getString(25)));
					markBean.setDILI((rs.getInt(26)));
					markBean.setDILI_SECOND_MARK((rs.getInt(27)));
					markBean.setDILI_B((rs.getString(28)));
					markBean.setSHENGWU((rs.getInt(29)));
					markBean.setSHENGWU_SECOND_MARK((rs.getInt(30)));
					markBean.setSHENGWU_B((rs.getString(31)));
					markBean.setZONG((rs.getInt(32)));
					markBean.setSql(sql);
					list.add(markBean);
				}
				
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
			return list;
	}
	
}