qualitymaindao.java

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

package edu.yinhe.mis.model;

/**
 * @author 熊星
 * 注释为测试代码
 */
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;

import edu.yinhe.mis.dto.HeaderMyselfDTO;
import edu.yinhe.mis.dto.QualityMainDTO;
import edu.yinhe.mis.vo.QualityMainVO;
import edu.yinhe.system.model.BaseDAO;

public class QualitymainDAO extends BaseDAO {

	/**
	 *  @author 熊星
	 * 从数据库中查找记录 return list
	 * 
	 */
	public Object find(Object arg0) throws SQLException {
		PreparedStatement pstmt = null;
		ResultSet rs = null;
		QualityMainDTO dto = (QualityMainDTO) arg0;
		List list = new ArrayList();
		QualityMainVO vo = null;
		String SQL = null;
		try {
			SQL = "SELECT TEACHER_NAME,DEPARTMENT_NAME,SUMSCORE,CHECKER,CHECK_TIME FROM quality_main WHERE 1=1  ";
			
			  if (dto.getTeacherName() != null &&
			  !"".equals(dto.getTeacherName())) { 
				  SQL = SQL + " AND TEACHER_NAME LIKE '%"+dto.getTeacherName()+"%'";
				  }

			  if(dto.getStartdate()!=null&&!"".equals(dto.getStartdate())){
			  SQL=SQL+" AND CHECK_TIME BETWEEN '"+dto.getStartdate()+"' AND '"+dto.getEnddate()+"'"; }
	 
			SQL = SQL + " ORDER BY CHECK_TIME";
			pstmt = conn.prepareStatement(SQL);
			rs = pstmt.executeQuery();

			while (rs.next()) {
				vo = new QualityMainVO();
				// vo.setId(rs.getInt("ID"));
				vo.setTeacherName(rs.getString("TEACHER_NAME"));
				vo.setDepartmentName(rs.getString("DEPARTMENT_NAME"));
				vo.setSumScore(rs.getInt("SUMSCORE"));
				vo.setChecker(rs.getString("CHECKER"));
				vo.setCheckTime(rs.getString("CHECK_TIME"));
				list.add(vo);
			}
		} catch (SQLException e) {

			e.printStackTrace();
		} finally {
			if (rs != null)
				rs.close();
			if (pstmt != null)
				pstmt.close();
			SQL = null;
			dto = null;
		}
		// list.add(vo);
		return list;
	}

	public Object find() throws SQLException {
		// TODO Auto-generated method stub
		return null;
	}

	public Object findAll() throws SQLException {
		// TODO Auto-generated method stub
		return null;
	}

	/**
	 * @author 姜娟 老师表与教师品质月度考核表
	 */
	public Object findAll(Object arg0) throws SQLException {
		PreparedStatement pstmt = null;
		ResultSet rs = null;
		HeaderMyselfDTO dto = (HeaderMyselfDTO) arg0;
		ArrayList alist = new ArrayList();
		StringBuffer SQL = new StringBuffer("");
		QualityMainVO qmvo = null;
		Statement st = null;
		int nIndex = 1;
		try {
			SQL
					.append("SELECT t.teacher_name teacher,avg(q.sumscore) sumsocre"
							+ "  FROM teacher t left join quality_main q on t.teacher_name=q.teacher_name"
							+ "  group by t.teacher_name ");

			if (dto.getCurrentPage() != null
					&& !"".equals(dto.getCurrentPage())
					&& dto.getPageSize() != null
					&& !"".equals(dto.getPageSize())) {
				int curr = (Integer.parseInt(dto.getCurrentPage()) - 1)
						* Integer.parseInt(dto.getPageSize());
				SQL.append(" limit " + curr + ","
						+ Integer.parseInt(dto.getPageSize()));
			}
			pstmt = conn.prepareStatement(SQL.toString());
			rs = pstmt.executeQuery();
			while (rs.next()) {
				qmvo = new QualityMainVO();
				qmvo.setTeacherName(rs.getString("teacher"));
				qmvo.setSumScore(rs.getInt("sumsocre"));
				alist.add(qmvo);
			}
		} catch (SQLException e) {
			e.printStackTrace();
		} finally {
			if (rs != null)
				rs.close();
			if (pstmt != null)
				pstmt.close();
			SQL = null;
			dto = null;
		}
		return alist;
	}

	public Object findById(Object arg0) throws SQLException {
		// TODO Auto-generated method stub
		return null;
	}

	public Object findByObject(Object arg0) throws SQLException {
		// TODO Auto-generated method stub
		return null;
	}

	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;
	}

	/**
	 * @author 熊星
	 * 向数据库中插入Excel表中的内容 
	 * return 是否插入成功
	 */
	public Object insert(Object arg0) throws SQLException {
		PreparedStatement ps = null;
		boolean isInsert = false;
		QualityMainDTO dto = (QualityMainDTO) arg0;
		int nIndex = 1;
		String strSQL = "INSERT INTO quality_main(TABLE_NAME,TABLE_NO,SCORE,"
				+ "BEHAVE,SCORE_WAY,FACT_SCORE,SUMSCORE,EXPLAINS,"
				+ "TEACHER_NAME,DEPARTMENT_NAME,CHECKER,CHECK_TIME) VALUES(?,?,?,?,?,?,?,?,?,?,?,?)";
		try {
			ps = conn.prepareStatement(strSQL);
			ps.setString(nIndex++, dto.getTableName());
			ps.setString(nIndex++, dto.getTableNo());
			ps.setString(nIndex++, dto.getScore());
			ps.setString(nIndex++, dto.getBehave());
			ps.setString(nIndex++, dto.getScoreWay());
			ps.setString(nIndex++, dto.getFactScore());
			ps.setInt(nIndex++, dto.getSumScore());
			ps.setString(nIndex++, dto.getExplain());
			ps.setString(nIndex++, dto.getTeacherName());
			ps.setString(nIndex++, dto.getDepartmentName());
			ps.setString(nIndex++, dto.getChecker());
			ps.setString(nIndex++, dto.getCheckTime());
			int i = ps.executeUpdate();
			if (i == 1) {
				isInsert = true;
			}
			conn.commit();
		} catch (SQLException e) {
			e.printStackTrace();
		} finally {
			if (ps != null)
				ps = null;
			strSQL = null;
		}
		return isInsert;
	}

	public Object update(Object arg0) throws SQLException {
		return null;
	}

}