listenmaindao.java

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

package edu.yinhe.mis.model;


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


import edu.yinhe.mis.dto.HeaderMyselfDTO;
import edu.yinhe.mis.dto.ListenmainDTO;
import edu.yinhe.mis.vo.ListenmainVO;
import edu.yinhe.system.model.BaseDAO;


public class ListenmainDAO extends BaseDAO{
	/**
	 * 听课记录的DTO
	 */
	ListenmainDTO lmd=null;
	/**
	 * SQL语句预处理
	 */
	PreparedStatement ps=null;
	/**
	 * 结果集的存放;
	 */
	ResultSet rs=null;
	/**
	 * 存放VO
	 */
	@SuppressWarnings("unchecked")
	List list=new ArrayList();
	int nIndex=1;

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

	public Object find() throws SQLException {
		// TODO Auto-generated method stub
		return null;
	}
	/**
	 * @author 姜娟
	 * 听课记录表与老师表的联系
	 * 
	 */
	@SuppressWarnings("unchecked")
	public Object find(Object arg0) throws SQLException {
		PreparedStatement pstmt = null;	
		ResultSet rs = null;	
		List list = null;
		HeaderMyselfDTO dto = (HeaderMyselfDTO)arg0;
		ArrayList alist = new ArrayList();
		StringBuffer SQL = new StringBuffer("");
		ListenmainVO tvo = null;
		int nIndex =1;
		SQL.append("select t.teacher_name,avg(lis.CONTENTMENTSCORE) CONTENTMENTSCORE FROM teacher t" +
				"  left join listen_main lis on t.teacher_name=lis.teacher" +
		        "  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()){
			tvo = new ListenmainVO();
        	tvo.setTeacher(rs.getString("teacher_name"));
  			tvo.setContentmentscore(rs.getInt("CONTENTMENTSCORE"));
			alist.add(tvo);
		}
		return alist;
	}

	
	public Object findAll() throws SQLException {
		// TODO Auto-generated method stub
		return null;
	}
	/**
	 * @author wanjiansheng
	 * 多条件匹配查询听课记录表
	 */
	public Object findAll(Object arg0) throws SQLException {
		List list=new ArrayList();
		ListenmainVO lvo = null;
		ListenmainDTO lmd=(ListenmainDTO)arg0;
		StringBuffer sb=new StringBuffer("SELECT MAIN_ID,TABLE_NAME,TABLE_NO," +
				"CONTENT,APPRAISE,GENERALCOMMENT,CONTENTMENTSCORE,CLASSROOM_NAME," +
		"LISTENER,CLASS_NO,STUDENT_NUM,LISTEN_DATE,TEACHER from listen_main where 1=1 ");
		if(lmd.getMainId()!=null&&!"".equals(lmd.getMainId())){
			sb=sb.append("And MAIN_ID="+lmd.getMainId());
		}
		if(lmd.getTableNo()!=null&&!"".equals(lmd.getTableNo())){
			sb=sb.append("And TABLE_NO='"+lmd.getTableNo()+"'");
		}
		if(lmd.getTeacher()!=null&&!"".equals(lmd.getTeacher())){
			sb=sb.append("And TEACHER like '%"+lmd.getTeacher()+"%'");
		}
		if(lmd.getStartDate()!=null&&!"".equals(lmd.getStartDate())&&
				lmd.getEndDate()!=null&&!"".equals(lmd.getEndDate())){
			sb =sb.append(" AND LISTEN_DATE BETWEEN '"+lmd.getStartDate()+"' and '"+lmd.getEndDate()+"'");
		}
		System.out.println(sb.toString());
		ps=conn.prepareStatement(sb.toString());
		rs = ps.executeQuery();
		while(rs.next()){
			lvo = new ListenmainVO();
			lvo.setMainId(rs.getInt("MAIN_ID"));
			lvo.setTableNo(rs.getString("TABLE_NO"));
			lvo.setContent(rs.getString("CONTENT"));
			lvo.setAppraise(rs.getString("APPRAISE"));
			lvo.setGeneralcomment(rs.getString("GENERALCOMMENT"));
			lvo.setContentmentscore(rs.getInt("CONTENTMENTSCORE"));		
			lvo.setClassroomName(rs.getString("CLASSROOM_NAME"));
			lvo.setListener(rs.getString("LISTENER"));			
			lvo.setClassNo(rs.getString("CLASS_NO"));
			lvo.setStudentNum(rs.getString("STUDENT_NUM"));
			lvo.setListenDate(rs.getString("LISTEN_DATE"));
			lvo.setTeacher(rs.getString("TEACHER"));
			list.add(lvo);
		}
		return list;
	}

	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 wanjiansheng
	 * 导入听课记录的Excel表
	 */
	public Object insert(Object arg0) throws SQLException {
		ListenmainDTO lmd=(ListenmainDTO)arg0;
		boolean flag=false;
		String SQL="INSERT INTO listen_main(TABLE_NAME,TABLE_NO," +
		"CONTENT,APPRAISE,GENERALCOMMENT,CONTENTMENTSCORE,CLASSROOM_NAME," +
		"LISTENER,CLASS_NO,STUDENT_NUM,LISTEN_DATE,TEACHER) VALUES(?,?,?,?,?,?,?,?,?,?,?,?)";
		ps=conn.prepareStatement(SQL);
		ps.setString(nIndex++, lmd.getTableName());
		System.out.println(lmd.getTableName());
		ps.setString(nIndex++, lmd.getTableNo());
		ps.setString(nIndex++, lmd.getContent());
		ps.setString(nIndex++, lmd.getAppraise());
		ps.setString(nIndex++, lmd.getGeneralcomment());
		ps.setInt(nIndex++, Integer.parseInt(lmd.getContentmentscore()));
		System.out.println(lmd.getContentmentscore());
		ps.setString(nIndex++, lmd.getClassroomName());
		ps.setString(nIndex++, lmd.getListener());
		ps.setString(nIndex++, lmd.getClassNo());
		ps.setString(nIndex++, lmd.getStudentNum());
		ps.setString(nIndex++, lmd.getListenDate());
		ps.setString(nIndex++, lmd.getTeacher());
		ps.executeUpdate();
		flag=true;
		conn.commit();
		if(ps!=null){
			ps.close();
			//strSQL=null;
			lmd=null;
		}
		return flag;
	}


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

}