studentideadao.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.Statement;
import java.util.ArrayList;
import java.util.List;

import edu.yinhe.mis.dto.HeaderMyselfDTO;
import edu.yinhe.mis.dto.StudentIdeaDTO;
import edu.yinhe.mis.vo.PKVO;
import edu.yinhe.mis.vo.StudentIdeaVO;

import edu.yinhe.mis.vo.StudentVO;
import edu.yinhe.system.model.BaseDAO;
import edu.yinhe.system.vo.LoginVO;

public class StudentIdeaDAO extends BaseDAO {
	PreparedStatement pstmt=null;
	String strSQL=null;
	ResultSet rs=null;
	int score=0;
	
	public Object findById(Object arg0) throws SQLException {
		String stuno = "";
		List list = new ArrayList();
		StudentVO stuvo = null;
		LoginVO vo = (LoginVO)arg0;
		PreparedStatement pstmt = null;
		ResultSet rs = null;
		String SQL = "SELECT stu_no,stu_name,class_no FROM student" +
				" WHERE stu_name IN (SELECT USER_NAME FROM USERS WHERE USER_ID='"+vo.getId()+"' )";
		try{
			pstmt = conn.prepareStatement(SQL);
			rs = pstmt.executeQuery();
			if(rs.next()){
				stuvo = new StudentVO();
				stuvo.setStuNo(rs.getString("stu_no"));
				stuvo.setStuName(rs.getString("stu_name"));
				stuvo.setClassNo(rs.getString("class_no"));
				String classno = stuvo.getClassNo();
			  List alist = (ArrayList)this.findByObject(classno);
				list.add(stuvo);
				list.add(alist);
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}finally{
			if(pstmt!=null) pstmt=null;
			if(rs!=null) rs=null;
		}
		return list;
	}
	public Object findByObject(Object arg0) throws SQLException {
		String stuno = "";
		List list = new ArrayList();
		String classno = (String) arg0;
		PKVO pkvo = null; 
		PreparedStatement pstmt = null;
		ResultSet rs = null;
		String SQL = " SELECT TEACHER_NAME,TEACHER_NO FROM pktable P  " +
				"where P.CLASS_NO='"+ classno+"'";
		try{
			pstmt = conn.prepareStatement(SQL);
			rs = pstmt.executeQuery();
			if(rs.next()){
				pkvo = new PKVO(); 
				pkvo.setTeacher_name(rs.getString("TEACHER_NAME"));
				pkvo.setTeacher_no(rs.getString("TEACHER_NO"));
				list.add(pkvo); 
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}finally{
			if(pstmt!=null) pstmt=null;
			if(rs!=null) rs=null;
		}
		return list;
	}
	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 update(Object arg0) throws SQLException {
		// TODO Auto-generated method stub
		return null;
	}
	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;
	}
	public Object find(Object arg0) throws SQLException {
		Statement st = null;
		ResultSet rs = null;
		StudentIdeaDTO dto= (StudentIdeaDTO)arg0;
		List list = new ArrayList();
		StudentIdeaVO vo =null;
		String SQL = "SELECT stu_no,class_no,teacher_no," +
				"teacher_name,sumscore,grade_date,advices  FROM " +
				"studentidea  WHERE teacher_name='"+dto.getTeachername()+"'";
		if(dto.getStartdate()!=null&&!"".endsWith(dto.getStartdate())){
			SQL = SQL + " and grade_date between '"+dto.getStartdate()+"' and '"+dto.getEnddate()+"'";
		}
		
		try{
			st = conn.createStatement();
			rs = st.executeQuery(SQL);
			while(rs.next()){
				vo = new StudentIdeaVO();
				vo.setStuno(rs.getString("stu_no"));
				vo.setClassno(rs.getString("class_no"));
				vo.setTeacherno(rs.getString("teacher_no"));
				vo.setTeachername(rs.getString("teacher_name"));
				vo.setSumscore(rs.getInt("sumscore"));
				vo.setGradedate(rs.getString("grade_date"));
				vo.setAdvices(rs.getString("advices"));
				list.add(vo);
			}
		} catch (RuntimeException e) {
			e.printStackTrace();
		}finally{
			if(rs!=null) rs.close();
			if(st!=null) st.close();
			SQL = null;
			dto = null;
		}
		return list;
	}
	public Object findAll() throws SQLException {
		// TODO Auto-generated method stub
		return null;
	} 
	 
	/**
	 * @author 姜娟
	 *teachers表与学员意见反馈表的总分查询
	 */
	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("");
		StudentIdeaVO sivo = null;
		int nIndex =1; 
		SQL.append("SELECT t.teacher_name ,avg(s.sumscore) " +
				"sumscore FROM teacher t left join studentidea s" +
				"  on t.teacher_name=s.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()){
			sivo = new StudentIdeaVO(); 
 			sivo.setTeachername(rs.getString("teacher_name"));
    		sivo.setSumscore(rs.getInt("sumscore"));  
			alist.add(sivo);
		}
		return alist;
	
	} 
	/**
	 * 
	 * 填写教学满意度问卷表
	 * @param conn 获得连接
	 * @param  TeaConDTO 对象
	 */
	public Object insert(Object arg0) throws SQLException {
		StudentIdeaDTO dto = (StudentIdeaDTO)arg0;
		int nIndex = 1;
		boolean flag=false;
		
		String SQL = "INSERT INTO studentidea(table_name,table_no,stu_no,class_no,teacher_no,teacher_name," +
				"sumscore,grade_date,advices) 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.getClassno());
			pstmt.setString(nIndex++,dto.getTeacherno());
			pstmt.setString(nIndex++,dto.getTeachername());
			pstmt.setInt(nIndex++,dto.getSumscore());
			pstmt.setString(nIndex++,dto.getGradedate());
			pstmt.setString(nIndex++,dto.getAdvices());
			flag =(Boolean) pstmt.execute();
			conn.commit();
		} catch (SQLException e) {
			e.printStackTrace();
		}finally{
		} 
		return !flag;
	}
	 
}