contentmentdao.java

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

package edu.yinhe.mis.model;


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

import edu.yinhe.mis.dto.ContentmentDTO;
import edu.yinhe.mis.vo.ContentmentVO;
import edu.yinhe.mis.vo.TeacherVO;
import edu.yinhe.system.model.BaseDAO;
import edu.yinhe.system.vo.LoginVO;

/**
 * 
 * @author  宋玉萍
 *
 */
public class ContentmentDAO extends BaseDAO {

	PreparedStatement pstmt = null;

	public Object delete(Object arg0) throws SQLException {
		return false;
	}

	public Object find() throws SQLException {
		return null;
	}

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

	public Object findAll() throws SQLException {
		return null;
	}

	public Object findAll(Object arg0) throws SQLException {
		PreparedStatement pstmt = null;
		ResultSet rs = null;
		ContentmentDTO dto = (ContentmentDTO )arg0;
		List list = new ArrayList();
		ContentmentVO vo = null;
		 
		String SQL = "";
		SQL =  "SELECT ID,TABLE_NAME,TABLE_NO,TEACHER_NAME,JUDGE1,JUDGE2,JUDGE3,ADVICE,GRADE_DATE,CLASS_NO" +
		" FROM CONTENTMENT " +
		"WHERE 1=1 AND TEACHER_NAME='"+dto.getTeacherName()+"' "; 
		if(dto.getStartdate()!=null&&!"".equals(dto.getStartdate())){
			SQL=SQL+" AND GRADE_DATE BETWEEN '"+dto.getStartdate()+"' AND '"+dto.getEnddate()+"' ";
		}if(dto.getClassNo()!=null&&!"".endsWith(dto.getClassNo())){
			SQL = SQL + "AND CLASS_NO='"+dto.getClassNo()+"'";
		}
		SQL = SQL +" ORDER BY GRADE_DATE DESC";
		try {

			pstmt = conn.prepareStatement(SQL);
			rs = pstmt.executeQuery();

			while(rs.next()){
				vo = new ContentmentVO();
				vo.setId(rs.getInt("ID"));
				vo.setTableName(rs.getString("TABLE_NAME"));
				vo.setTableNo(rs.getString("TABLE_NO"));
				vo.setTeacherName(rs.getString("TEACHER_NAME"));
				vo.setClassNo(rs.getString("CLASS_NO"));
				vo.setJudge1(rs.getString("JUDGE1"));
				vo.setJudge2(rs.getString("JUDGE2"));
				vo.setJudge3(rs.getString("JUDGE3"));
				vo.setAdvice(rs.getString("ADVICE"));
				vo.setGradeDate("GRADE_DATE");
				list.add(vo);
			}
		}catch (SQLException e) {

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

	/**
	 * @author 宋玉萍
	 * 获得符合条件的老师
	 */
	public Object findById(Object arg0) throws SQLException {
		LoginVO vo = (LoginVO)arg0;
		TeacherVO tvo = null;
		PreparedStatement pstmt = null;
		ResultSet rs = null;
		List list = new ArrayList();
		String teano = this.getTeano(vo);
		String SQL = "SELECT TEACHER_NO,TEACHER_NAME,ENTER_TIME,DEPARTMENT_NAME FROM TEACHER T,DEPARTMENT D WHERE " +
				"TEACHER_NAME IN (SELECT TEACHER_NAME FROM TEACHER WHERE TEACHER_NAME IN ( " +
				"SELECT TEACHER_NAME FROM TEACHER WHERE SUPER_TEACHER_NO IN " +
				"(SELECT TEACHER_NO FROM TEACHER WHERE SUPER_TEACHER_NO='"+teano+"')  OR " +
				"SUPER_TEACHER_NO='"+teano+"' OR TEACHER_NO='"+teano+"') " +
						" AND TEACHER_STATES='在职') AND T.DEPARTMENT_NO=D.DEPARTMENT_NO";
		try{
			pstmt = conn.prepareStatement(SQL);
			rs = pstmt.executeQuery();
			while(rs.next()){
				tvo = new TeacherVO();
				tvo.setTeacher_no(rs.getString("TEACHER_NO"));
				tvo.setTeacher_name(rs.getString("TEACHER_NAME"));
				tvo.setEnter_time(rs.getString("ENTER_TIME"));
				tvo.setRemark2(rs.getString("DEPARTMENT_NAME"));
				list.add(tvo);
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}finally{
			if(pstmt!=null) pstmt=null;
			if(rs!=null) rs=null;
		}
		return list;
	}
	/**
	 * @author 宋玉萍
	 *  根据登录信息获得老师编号
	 */
	public String getTeano(Object arg0) throws SQLException {
		String teano = "";
		LoginVO vo = (LoginVO)arg0;
		PreparedStatement pstmt = null;
		ResultSet rs = null;
		String SQL = "SELECT TEACHER_NO FROM TEACHER WHERE TEACHER_NAME IN (SELECT USER_NAME FROM USERS WHERE USER_ID='"+vo.getId()+"' )";
		try{
			pstmt = conn.prepareStatement(SQL);
			rs = pstmt.executeQuery();
			if(rs.next()){
				teano = (String )rs.getString("TEACHER_NO");
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}finally{
			if(pstmt!=null) pstmt=null;
			if(rs!=null) rs=null;
		}
		return teano;
	}
	
	/**
	 *  从数据库的到信息
	 * @param arg0
	 * @return
	 * @throws SQLException
	 */

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


	public int getCount(Object arg0) throws SQLException {
		return 0;
	}

	

	/**
	 * 
	 * 填写教学满意度问卷表
	 * @param conn 获得连接
	 * @param  TeaConDTO 对象
	 */
	public Object insert(Object arg0) throws SQLException {
		ContentmentDTO dto = (ContentmentDTO)arg0;
		int nIndex = 1;
		boolean flag=false;
		
		String SQL = "INSERT INTO contentment(table_name,table_no,stu_no,teacher_name,judge1,judge2,judge3,advice,grade_date,class_no) values (?,?,?,?,?,?,?,?,?,?)";
		try {
			pstmt = conn.prepareStatement(SQL);
			pstmt.setString(nIndex++,dto.getTableName() );
			pstmt.setString(nIndex++,dto.getTableNo());
			pstmt.setString(nIndex++,dto.getStuNo());
			pstmt.setString(nIndex++,dto.getTeacherName() );
			pstmt.setString(nIndex++,dto.getJudge1());
			pstmt.setString(nIndex++,dto.getJudge2() );
			pstmt.setString(nIndex++,dto.getJudge3() );
			pstmt.setString(nIndex++,dto.getAdvice());
			pstmt.setString(nIndex++,dto.getGradeDate() );
			pstmt.setString(nIndex++,dto.getClassNo() );
			flag =(Boolean) pstmt.execute();
			conn.commit();
		} catch (SQLException e) {
			e.printStackTrace();
		}finally{
		} 
		return !flag;
	}

public Object getMaxId(Object obj) {
		
		return null;
	}


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

	

}