gradestatdao.java

中应用程序的访问权限对Java Web Console 中应用程序的访问权限 成功登录 Web 控制台后,可能无法自动访问在该控制台中注册的所有应用程序。通常,必须安装应用程序,才能让所有的用户在控制

package edu.yinhe.mis.model;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;

import edu.yinhe.mis.dto.BoardDTO;
import edu.yinhe.mis.dto.GradeDTO;
import edu.yinhe.mis.dto.GradeStatDTO;
import edu.yinhe.mis.vo.BoardVO;
import edu.yinhe.mis.vo.GradeStatVO;
import edu.yinhe.mis.vo.GradeVO;
import edu.yinhe.mis.vo.TestpaperruleVO;
import edu.yinhe.system.model.BaseDAO;
import edu.yinhe.system.model.IBaseDAO;

/**
 * 
 * @author 何亮
 * 
 */
public class GradeStatDAO extends BaseDAO {

	
	public Object delete(Object arg0) throws SQLException {
		String sql=null;
		PreparedStatement pstat=null;
		ResultSet rst=null;
		ArrayList alist=new ArrayList();
		GradeStatVO gsvo=null;
		try {
			sql="SELECT OBJECT_NAME FROM grade_stat_table";
			pstat=conn.prepareStatement(sql);
			rst=pstat.executeQuery();
			while(rst.next()){
				gsvo=new GradeStatVO();
				gsvo.setObject_name(rst.getString("OBJECT_NAME"));
				alist.add(gsvo);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			sql=null;
		}
		return alist;

	}
		
/**
 * 从成绩表中查找科目 
 */
	public Object find() throws SQLException {
		String sql=null;
		PreparedStatement pstat=null;
		ResultSet rst=null;
		ArrayList alist=new ArrayList();
		GradeVO gvo=null;
		try {
			sql="SELECT OBJECT_NAME FROM grade_table";
			pstat=conn.prepareStatement(sql);
			rst=pstat.executeQuery();
			while(rst.next()){
				gvo=new GradeVO();
				gvo.setObjectname(rst.getString("OBJECT_NAME"));
				alist.add(gvo);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			sql=null;
		}
		return alist;

	}
/**
 *根据科目得到该科考生总数
 */
	public Object find(Object arg0) throws SQLException {
		String sql=null;
		PreparedStatement pstat=null;
		ResultSet rst=null;
		Integer sum=0;
		String objectname=null;
		GradeVO vo=new GradeVO();
		vo=(GradeVO) arg0;
		objectname=vo.getObjectname();
		try {
			sql="SELECT COUNT(*) FROM grade_table WHERE OBJECT_NAME='"+objectname+"'";
			pstat=conn.prepareStatement(sql);
			rst=pstat.executeQuery();
			while(rst.next()){
				sum = rst.getInt("COUNT(*)");
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			sql=null;
		}
		return sum;
	}

	public Object findAll() throws SQLException {
		String sql =null;
		PreparedStatement pstat=null;
		ResultSet rst=null;
		GradeStatVO gsvo=null;
		try {
			sql= "SELECT FETLE FROM grade_stat_table";
			pstat=conn.prepareStatement(sql);
			rst=pstat.executeQuery();
			
			while(rst.next()){
				gsvo=new GradeStatVO();
				gsvo.setFatle(rst.getInt("FETLE"));
			}
		} catch (SQLException e) {
		
			e.printStackTrace();
		}
		return gsvo;
	}

	public Object findAll(Object obj) throws SQLException {
		String sql =null;
		PreparedStatement pstat=null;
		ResultSet rst=null;
		GradeStatDTO gsdto=new GradeStatDTO();
		GradeStatVO gsvo=null;
		gsdto=(GradeStatDTO) obj;
		String objectname=gsdto.getObject_name();
		try {
			sql="SELECT AVERAGESCORE,PASSPERCENT,FOLLOWSCOREKEEPER,MAINSCOREKEEPER " +
					"FROM grade_stat_table WHERE OBJECT_NAME='"+objectname+"'";
			pstat=conn.prepareStatement(sql);
			rst=pstat.executeQuery();
			while(rst.next()){
				gsvo=new GradeStatVO();
				gsvo.setAveragescore(rst.getString("AVERAGESCORE"));
				gsvo.setPasspercent(rst.getString("PASSPERCENT"));
				gsvo.setFollowscorekeeper(rst.getString("FOLLOWSCOREKEEPER"));
				gsvo.setMainscorekeeper(rst.getString("MAINSCOREKEEPER"));
				
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			sql=null;
		}
		return gsvo;
	}

	public Object findById(Object arg0) throws SQLException {
		String sql=null;
		PreparedStatement pstat=null;
		ResultSet rst=null;
		GradeVO gvo=new GradeVO();
		TestpaperruleVO tvo=null;
		ArrayList alist=new ArrayList();
		gvo=(GradeVO) arg0;
		String objectname=null;
		objectname=gvo.getObjectname();
		try {
			sql="SELECT QUESTION_VALUE,QUESTIONTYPE_ID FROM testpaperrule WHERE OBJECT_NAME='"+objectname+"'";
			pstat=conn.prepareStatement(sql);
			rst=pstat.executeQuery();
			while(rst.next()){
				tvo=new TestpaperruleVO();
				tvo.setQuestionValue(rst.getInt("QUESTION_VALUE"));
				tvo.setQuestionTypeID(rst.getInt("QUESTIONTYPE_ID"));
				alist.add(tvo);
			}
		} catch (RuntimeException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			sql=null;
		}
		return alist;
	}
/**
 * 根据科目得到所有考生的成绩
 */
	public Object findByObject(Object arg0) throws SQLException {
		String sql=null;
		PreparedStatement pstat=null;
		ResultSet rst=null;
		String objectname=null;
		ArrayList alist1=new ArrayList();
		GradeVO gvo=null;
		try {
			gvo=(GradeVO) arg0;
			objectname=gvo.getObjectname();
			sql="SELECT SUMSCORE,SELECTONEPOINT,SELECTMANYPOINT,JUDGEMENTPOINT,FOLLOW_SCORE," +
					"MAIN_SCORE FROM grade_table WHERE OBJECT_NAME='"+objectname+"'";
			pstat=conn.prepareStatement(sql);
			rst=pstat.executeQuery();
			while(rst.next()){
				gvo=new GradeVO();
				gvo.setSumscore(rst.getString("SUMSCORE"));
//				gvo.setSelectonepoint(rst.getString("SELECTONEPOINT"));
//				gvo.setSelectmanypoint(rst.getString("SELECTMANYPOINT"));
//				gvo.setJudgementpoint(rst.getString("JUDGEMENTPOINT"));
				gvo.setFollowscore(rst.getString("FOLLOW_SCORE"));
				gvo.setMainscore(rst.getString("MAIN_SCORE"));
				alist1.add(gvo);
			}
		} catch (RuntimeException e) {
			System.out.println("在GradeStatDAO的findByObject(Object arg0)方法中出项异常");
			e.printStackTrace();
		}finally{
			sql=null;
		}
		return alist1;

	}

	public int getCount(Object arg0) throws SQLException {

		// TODO Auto-generated method stub
		return 0;
	}

	public Object getMaxId(Object arg0) throws SQLException {

		// TODO Auto-generated method stub
		return null;
	}

	
	public Object insert(Object obj) throws SQLException {
		Integer flag=0;
		String sql=null;
		PreparedStatement pstat=null;
		ResultSet rst=null;
		GradeStatDTO gsdto=new GradeStatDTO();
		gsdto=(GradeStatDTO) obj;
		String mainscorekeeper = "aa";//主观题得分率
		if(mainscorekeeper=="NaN%"){
			mainscorekeeper="0";
		}
		String passpercent = gsdto.getPasspercent();//及格率
		String objectname = gsdto.getObject_name();//科目名
		String averagescore = gsdto.getAveragescore();//平均分
		String followscorekeeper = gsdto.getFollowscorekeeper();//客观题得分率
		try {
			sql="INSERT INTO grade_stat_table(AVERAGESCORE,PASSPERCENT," +
					"OBJECT_NAME,FOLLOWSCOREKEEPER,MAINSCOREKEEPER) VALUES" +
					"("+averagescore+","+passpercent+",'"+objectname+"',"+followscorekeeper+","+mainscorekeeper+")";
			pstat=conn.prepareStatement(sql);
			pstat.executeUpdate();
			conn.commit();
			flag=1;
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			sql=null;
		}
		return flag;
		
	}


	public Object update(Object obj) throws SQLException {
		String sql=null;
		PreparedStatement pstat=null;
		ResultSet rst=null;
		try {
			sql="UPDATE grade_stat_table SET FETLE=1";
			pstat=conn.prepareStatement(sql);
			pstat.executeUpdate();
			conn.commit();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			if(rst==null){
				rst.close();
			}if(pstat==null){
				pstat.close();
			}
			conn.close();
			sql=null;
		}
		return null;
	}

}