writeresultsetdao.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.WriteresultsetDTO;
import edu.yinhe.mis.vo.WriteresultsetVO;
import edu.yinhe.system.model.BaseDAO;
/**
 * 
 * @author 张海亚
 * Creation date:04-30-2008 
 */
public class WriteresultsetDAO extends BaseDAO {

	/**
	 * 根据谈话编号 id删除 writeresultset表中的谈话记录
	 * @throws SQLException
	 * @param obj id 号
	 * @return flag 删除成功返回1，反之为0
	 */
	String SQL="";
	public Object delete(Object obj) throws SQLException {
		WriteresultsetDTO wdto=(WriteresultsetDTO)obj;
		PreparedStatement ps=null;
		Integer flag=0;
		try {
			SQL="delete from writeresultset where ID=?";
			ps = conn.prepareStatement(SQL);
			ps.setInt(1,wdto.getId());
			ps.executeUpdate();
			flag=1;
		} catch (RuntimeException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		finally{
			if(ps!=null)ps.close();//由于项目庞大，节约资源
			SQL=null;//由于项目庞大，节约资源
			wdto=null; //由于项目庞大，节约资源
		}
		return flag;
	}

	public Object find(Object arg0) throws SQLException {
		// TODO Auto-generated method stub
		return null;
	}
	/**
	 * 查看writeresultset表中的所有的谈话记录
	 * @param 无传入值
	 * @throws SQLException
	 * @return wvo
	 */
	public Object findAll() throws SQLException {
		PreparedStatement ps=null;
		ResultSet rs=null;
		Integer ID=null;
		WriteresultsetDTO wdto=null;
		// StringBuffer strBuf=new  StringBuffer("");
		WriteresultsetVO wvo=null;
		ArrayList list=new  ArrayList();
		try {
			SQL = "select * from writeresultset order by id desc";
//			if(wdto.getPageSize()!=null&&!"".equals(wdto.getPageSize())&&wdto.getPageNo()!=null
//			&&!"".equals(wdto.getPageNo())){
//			int pageNo=(Integer.parseInt(wdto.getPageNo())-1)*Integer.parseInt(wdto.getPageSize());
//			strBuf.append(" limit "+pageNo+","+Integer.parseInt(wdto.getPageSize()));
//			}
			ps = conn.prepareStatement(SQL);
			rs = ps.executeQuery();
			while(rs.next()){
				wvo=new WriteresultsetVO();
				wvo.setId(rs.getInt("ID"));
				wvo.setTalkPlace(rs.getString("talk_place"));
				wvo.setTalkContent(rs.getString("talk_content"));
				wvo.setStuNo(rs.getString("stu_no"));
				wvo.setTeacherNo(rs.getString("teacher_no"));
				wvo.setStuName(rs.getString("stu_name"));
				wvo.setTeacherName(rs.getString("teacher_name"));
				wvo.setTalkWay(rs.getString("talk_way"));
				wvo.setBeginTime(rs.getString("begin_time"));
				wvo.setEndTime(rs.getString("end_time"));
				list.add(wvo);
			}
		}catch (RuntimeException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			SQL=null;//由于项目庞大，节约资源			
			if(ps!=null)ps.close();//由于项目庞大，节约资源
			if(rs!=null)rs.close();//由于项目庞大，节约资源
		}

		return list;
	}

/**
 * 根据学生姓名，谈话方式，开始时间和结束时间来搜索谈话记录
 * @param obj
 * @throws SQLException
 * @return list
 */
	public Object findAll(Object obj) throws SQLException {
		PreparedStatement ps=null;
		ResultSet rs=null;
		Integer ID=null;
		int i=1;
		WriteresultsetDTO wdto=(WriteresultsetDTO)obj;
		WriteresultsetVO wvo=null;
		ArrayList list=new  ArrayList();
		try{
			SQL="select * from writeresultset where 1=1 ";
			if(!"".equals(wdto.getStuName())){
				SQL=SQL+" and stu_name=?";	
			}
			if(!"".equals(wdto.getTalkWay())){
				SQL=SQL+" and talk_way=?";	
			}
			if(!"".equals(wdto.getBeginTime())){
				SQL=SQL+" and begin_time>? and begin_time<?";	
			}
			
			System.out.println(SQL);
			ps=conn.prepareStatement(SQL);
			if(!"".equals(wdto.getStuName())){
				ps.setString(i++, wdto.getStuName());
			}
			if(!"".equals(wdto.getTalkWay())){
				ps.setString(i++,wdto.getTalkWay());
			}
			if(!"".equals(wdto.getBeginTime())&&!"".equals(wdto.getEndTime())){
				ps.setString(i++,wdto.getBeginTime());
				ps.setString(i++,wdto.getEndTime());
			}
			rs=ps.executeQuery();
			while(rs.next()){
				wvo=new WriteresultsetVO();
				wvo.setId(rs.getInt("ID"));
				wvo.setTalkPlace(rs.getString("talk_place"));
				wvo.setTalkContent(rs.getString("talk_content"));
				wvo.setStuNo(rs.getString("stu_no"));
				wvo.setTeacherNo(rs.getString("teacher_no"));
				wvo.setStuName(rs.getString("stu_name"));
				wvo.setTeacherName(rs.getString("teacher_name"));
				wvo.setTalkWay(rs.getString("talk_way"));
				wvo.setBeginTime(rs.getString("begin_time"));
				wvo.setEndTime(rs.getString("end_time"));
				list.add(wvo);
			}
		}
		catch(SQLException e){
			System.out.println(e.getMessage());
		}finally{
			if(rs!=null)rs.close();//由于项目庞大，节约资源
			if(ps!=null)ps.close();//由于项目庞大，节约资源
			SQL=null;//由于项目庞大，节约资源

		}
		return list;
	}

	/**
	 * 根据谈话编号查询谈话记录
	 * @param id 谈话编号
	 * @throws SQLException
	 * @return wvo
	 */
	public Object findById(Object obj) throws SQLException {
		PreparedStatement ps=null;
		ResultSet rs=null;
		Integer ID = null;
		WriteresultsetVO wvo=null;
		WriteresultsetDTO wdto=(WriteresultsetDTO)obj;
		try {
			SQL="select *from writeresultset where ID=?";
			ps= conn.prepareStatement(SQL);
			ps.setInt(1, wdto.getId());
			rs=ps.executeQuery();
			while(rs.next()){
				wvo=new WriteresultsetVO();
				wvo.setId(rs.getInt("id"));
				wvo.setTalkPlace(rs.getString("talk_place"));
				wvo.setTalkContent(rs.getString("talk_content"));
				wvo.setStuNo(rs.getString("stu_no"));
				wvo.setTeacherNo(rs.getString("teacher_no"));
				wvo.setStuName(rs.getString("stu_name"));
				wvo.setTeacherName(rs.getString("teacher_name"));
				wvo.setTalkWay(rs.getString("talk_way"));
				wvo.setBeginTime(rs.getString("begin_time"));
				wvo.setEndTime(rs.getString("end_time"));
			}
		}catch (RuntimeException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		finally{
			if(rs!=null)rs.close();//由于项目庞大，节约资源
			if(ps!=null)ps.close();//由于项目庞大，节约资源
			SQL=null;//由于项目庞大，节约资源
			wdto=null; //由于项目庞大，节约资源
		}
		return wvo;
	}
	public Object findByObject(Object arg0) throws SQLException {
		// TODO Auto-generated method stub
		return null;
	}

	public int getCount(Object obj) throws SQLException {
		PreparedStatement ps=null;
		ResultSet rs=null;
		WriteresultsetDTO wdto=(WriteresultsetDTO)obj;
		int count =0;
		StringBuffer strBuf=new StringBuffer("");
		strBuf.append("select  count(*)  icount FROM  writeresultset");
		ps = conn.prepareStatement(strBuf.toString());
		rs = ps.executeQuery();
		if(rs.next()){
			count = rs.getInt(1);
		}

		return count;
	}

	/**
	 * 向writeresultset表中添加谈话记录
	 * @param obj 传入WriteresultsetDTO类型的对象
	 * @throws SQLException
	 * @return flag 添加完成，返回1，反之为0
	 */

	public Object insert(Object obj)throws SQLException {
		boolean flag=false;
	    int i=0;
		PreparedStatement ps=null;
		ResultSet rs=null;
		WriteresultsetDTO wdto=(WriteresultsetDTO)obj;
		try {
			SQL="insert into writeresultset(talk_place,talk_content,stu_no,teacher_no,stu_name,teacher_name,talk_way,begin_time,end_time)values(?,?,?,?,?,?,?,?,?)";
			ps = conn.prepareStatement(SQL);
			ps.setString(1,wdto.getTalkPlace());
			ps.setString(2,wdto.getTalkContent());
			ps.setString(3,wdto.getStuNo());
			ps.setString(4,wdto.getTeacherNo());
			ps.setString(5,wdto.getStuName());
			ps.setString(6,wdto.getTeacherName());
			ps.setString(7,wdto.getTalkWay());
			ps.setString(8,wdto.getBeginTime());
			ps.setString(9,wdto.getEndTime());
			i=ps.executeUpdate();
			 if(i==1){
				 flag=true;
			 }
			 else{
				 
				 flag=false;
			 }
			

		}
		catch (RuntimeException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		finally{
			if(rs!=null)rs.close();//由于项目庞大，节约资源
			if(ps!=null)ps.close();//由于项目庞大，节约资源
			SQL=null;//由于项目庞大，节约资源
			wdto=null; //由于项目庞大，节约资源
		}
		return flag;
	}

	/**
	 * 根据谈话编号id修改writeresultset表中的谈话记录
	 @param obj 传入WriteresultsetDTO类型的对象
	 * @throws SQLException
	 * @return flag 添加完成，返回1，反之为0
	 */
	public Object update(Object obj) throws SQLException {
		Integer flag=0;
		PreparedStatement ps=null;
		WriteresultsetDTO wdto=(WriteresultsetDTO)obj;
		try {

			SQL="update writeresultset set talk_place=?,talk_content=?,stu_no=?,teacher_no=?,stu_name=?,teacher_name=?,talk_way=?,begin_time=?,end_time=? where ID=?";
			ps = conn.prepareStatement(SQL);
			ps.setString(1,wdto.getTalkPlace());
			ps.setString(2,wdto.getTalkContent());
			ps.setString(3,wdto.getStuNo());
			ps.setString(4,wdto.getTeacherNo());
			ps.setString(5,wdto.getStuName());
			ps.setString(6,wdto.getTeacherName());
			ps.setString(7,wdto.getTalkWay());
			ps.setString(8,wdto.getBeginTime());
			ps.setString(9,wdto.getEndTime());
			ps.setInt(10,wdto.getId());
			flag = ps.executeUpdate();
		} catch (RuntimeException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		finally{
			if(ps!=null)ps.close();//由于项目庞大，节约资源
			SQL=null;//由于项目庞大，节约资源
			wdto=null; //由于项目庞大，节约资源
		}
		return flag;
	}

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