classjindudao.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 edu.yinhe.mis.dto.ClassJinduDTO;
import edu.yinhe.mis.vo.ClassJinduVO;
import edu.yinhe.system.model.BaseDAO;

/**
 * @author 苏世进
 *
 */
public class ClassJinduDAO extends BaseDAO {

	public Object Permissionlist(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 findAll() throws SQLException {
		// TODO Auto-generated method stub
		return null;
	}

	public Object findAll(Object obj) throws SQLException {
		String SQL=null;
		PreparedStatement pstat=null;
		ArrayList list =  new ArrayList();
		ResultSet rst=null;
		ClassJinduVO  vo =  null;
		ClassJinduDTO dto =(ClassJinduDTO)obj;
		Object[] objs = new Object[2];
		String classname =  "";
		String objectname = "";

		try{
			objs[0]=this.getCount(dto);
			if(dto.getClass_no()==null){
				classname = "";
			}else{
				classname = dto.getClass_no();
			}
			if(dto.getObject_no()==null){
				objectname = "";
			}else{
				objectname = dto.getObject_no();
			}
			StringBuffer buf = new StringBuffer("select c.class_name,h.object_name,o.planperiod,(o.planperiod-h.spare_hour) facthour,h.spare_hour from classes c,outline o,hourplan h where c.class_no=h.class_no and c.class_state='1' and h.object_name=o.object_name");
			if(!classname.trim().equals("")){
				buf.append(" and h.CLASS_NO='"+dto.getClass_no()+"'");
			}
			if(!objectname.trim().equals("")){
				buf.append(" and h.OBJECT_NO='"+dto.getObject_no()+"'");
			}
			if(dto.getClasstimes()!=null&&"".equals(dto.getClasstimes())){
				buf.append(" and SPARE_HOUR='"+dto.getClasstimes()+"'");
			}
			int i = (Integer.parseInt(dto.getCurrentPage())-1)*Integer.parseInt(dto.getRowperPage());
			buf.append(" LIMIT "+i+","+dto.getRowperPage());

			SQL = buf.toString();
			System.out.println(SQL);
			pstat = conn.prepareStatement(SQL);
			rst = pstat.executeQuery();
			while(rst.next()){
				vo=new ClassJinduVO();
				vo.setClass_name(rst.getString("CLASS_NAME"));//班级名称
				vo.setObject_name(rst.getString("OBJECT_NAME"));//课程名称
				vo.setLeavetimes(rst.getString("SPARE_HOUR"));//剩余课次
				vo.setFactperiod(rst.getString("FACTHOUR"));//实际学时
				vo.setRemak3(rst.getString("planperiod"));//总课时
				list.add(vo);
			}
			objs[1]=list;
		}finally{
			if(rst!=null)rst.close();//由于项目庞大，节约资源
			if(pstat!=null)pstat.close();//由于项目庞大，节约资源
			SQL=null;//由于项目庞大，节约资源
		}

		return objs;
	}


	public Object findById(Object obj) throws SQLException {
		String SQL=null;
		ClassJinduDTO dto=null;
		ClassJinduVO vo=null;
		PreparedStatement pstat=null;
		ResultSet rst=null;
		String classname = "";
		String objectname = "";
		try{
			dto=(ClassJinduDTO)obj; 
			if(dto.getClass_no()==null){
				classname = "";
			}else
			{
				classname = dto.getClass_no();
			}
			if(dto.getObject_no()==null){
				objectname = "";
			}else
			{
				objectname = dto.getObject_no();
			}
			StringBuffer buf = new StringBuffer("SELECT c.CLASS_NAME, o.OBJECT_NAME,o.FACTPERIOD,p.teachtime FROM classes c,outline o,pktable p WHERE 1=1");
			if(!classname.trim().equals("")){
				buf.append(" and c.CLASS_NAME='"+dto.getClass_name()+"'");
			}
			if(!objectname.trim().equals("")){
				buf.append(" and o.OBJECT_NAME='"+dto.getObject_name()+"'");
			}
			if(dto.getClasstimes()!=null&&"".equals(dto.getClasstimes())){
				buf.append(" and CLASSTIMES='"+dto.getClasstimes()+"'");
			}
			if(dto.getFactperiod()!=null&&"".equals(dto.getFactperiod())){
				buf.append(" and p.FACTPERIOD='"+dto.getFactperiod()+"'");
			}
			if(dto.getCurrentPage()!=null && !"".equals(dto.getCurrentPage()) && dto.getRowperPage()!=null && !"".equals(dto.getRowperPage())){
				int i = (Integer.parseInt(dto.getCurrentPage())-1)*Integer.parseInt(dto.getRowperPage());
				buf.append(" LIMIT "+i+","+dto.getRowperPage());
			}
			SQL = buf.toString();
			pstat=conn.prepareStatement(SQL);//注意这里的conn是从BaseDAO继承的，可以直接用的
			rst=pstat.executeQuery();
			while(rst.next()){
				vo=new ClassJinduVO();
//				vo.setId(rst.getInt("ID"));
			}
		}catch(SQLException e){
			System.out.println(e.getMessage());
		}finally{
			if(rst!=null)rst.close();//由于项目庞大，节约资源
			if(pstat!=null)pstat.close();//由于项目庞大，节约资源
			SQL=null;//由于项目庞大，节约资源
			dto=null; //由于项目庞大，节约资源
		}

		return vo;
	}

	public int getCount(Object obj) throws SQLException {
		String SQL=null;
		ClassJinduDTO dto = (ClassJinduDTO)obj;
		System.out.println(dto.getClass_name());
		PreparedStatement pstat = null;
		ResultSet rst= null;
		Integer integer = new Integer(0);
		String classname = "";
		String objectname = "";
		if(dto.getClass_no()==null){
			classname = "";
		}else{
			classname = dto.getClass_no();
		}
		if(dto.getObject_no()==null){
			objectname = "";
		}else{
			objectname = dto.getObject_no();
		}
		StringBuffer buf = new StringBuffer("SELECT count(*) result from hourplan WHERE 1=1");
		if(!classname.trim().equals("")){
			buf.append(" and CLASS_NO='"+dto.getClass_no()+"'");
		}
		if(!objectname.trim().equals("")){
			buf.append(" and OBJECT_NO='"+dto.getObject_no()+"'");
		}
		if(dto.getClasstimes()!=null&&"".equals(dto.getClasstimes())){
			buf.append(" and CLASSTIMES='"+dto.getClasstimes()+"'");
		}
		if(dto.getFactperiod()!=null&&"".equals(dto.getFactperiod())){
			buf.append(" and FACTPERIOD='"+dto.getFactperiod()+"'");
		}
		SQL = buf.toString();
		pstat = conn.prepareStatement(SQL);
		rst = pstat.executeQuery();
		if(rst.next()){
			integer = rst.getInt("result");
		}

		return integer;
	}


}