leaveworddao.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.LeaveWordDTO;
import edu.yinhe.mis.vo.LeaveWordVO;
import edu.yinhe.system.model.BaseDAO;

public class LeaveWordDAO extends BaseDAO{
//删除留言
	public Object delete(Object arg0) throws SQLException {
		boolean falg = false;
		String SQl=null;
		PreparedStatement pstat=null;
		try {
			SQl="DELETE FROM leaveword WHERE ID=?";
			pstat = conn.prepareStatement(SQl);
			pstat.executeUpdate();
			falg = true;
		} catch (RuntimeException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			if(pstat!=null)pstat.close();
		}
		return falg;
	}

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

	public Object find(Object obj) throws SQLException {

		return null;
	}

	public Object findAll() throws SQLException {
		// TODO Auto-generated method stub
		return null;
	}
	//查看留言
	public Object findAll(Object obj) throws SQLException {
		String SQL=null;
		LeaveWordDTO dto=null;
		LeaveWordVO vo=null;
		PreparedStatement pstat=null;
		ResultSet rst=null;
		try {
		dto = (LeaveWordDTO)obj;		
		SQL = "SELCE * FROM leaveword";
		pstat =conn.prepareStatement(SQL);
		rst = pstat.executeQuery();
		ArrayList list = new ArrayList();
			while(rst.next()){
				vo = new LeaveWordVO();
				vo.setID(rst.getInt("ID"));
				vo.setTITLE(rst.getString("TITLE"));
				vo.setCONTENT(rst.getString("CONTENT"));
				vo.setLEAVEDATE(rst.getString("LEAVEDATE"));
				vo.setABSWERCONTENT(rst.getString("ABSWERCONTENT"));
				list.add(vo);
			}
		} catch (RuntimeException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			if(rst!=null)rst.close();
			if(pstat!=null)pstat.close();
		}
		return null;
	}

	public Object findById(Object obj) throws SQLException {
		String sql="";
		int n = 0;
		LeaveWordVO vo = null;
		LeaveWordDTO dto = new LeaveWordDTO();
		PreparedStatement ps = null;
		ResultSet rs = null;
		try{
				n = (Integer)obj;
				sql = "SELECT * FROM leaveword WHERE id = ?";
				ps = conn.prepareStatement(sql);
				ps.setInt(1, n);
			    rs = ps.executeQuery();
			    while(rs.next()){
			    	vo = new LeaveWordVO();
			    	vo.setID(rs.getInt("id"));
			    	vo.setTITLE(rs.getString("title"));
			    	vo.setCONTENT(rs.getString("content"));
			    	
			    }
		}catch(SQLException e){
			System.out.println(e.getMessage());
		}finally{

			if(ps!=null)ps.close();//由于项目庞大，节约资源
			sql=null;//由于项目庞大，节约资源
			dto=null; //由于项目庞大，节约资源
		}
		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;
	}
//增加留言
	public Object insert(Object obj) throws SQLException {
		boolean flag = false;
		PreparedStatement pstat=null;
		String SQL=null;
		LeaveWordDTO dto =(LeaveWordDTO) obj;
		SQL = "INSERT INTO leaveword(TITLE,CONTENT,LEAVEDATE) VALUES(?,?,?)";
		pstat = conn.prepareStatement(SQL);
		pstat.setString(1, dto.getTITLE());
		pstat.setString(2, dto.getCONTENT());
		pstat.setTimestamp(3, new java.sql.Timestamp(new java.util.Date().getTime()));
        pstat.executeUpdate();	
        flag = true;
		if(pstat!=null){pstat.close();};
		return flag;
	}
//修改留言
	public Object update(Object obj) throws SQLException {
		boolean flag = false;
		PreparedStatement pstat =null;
		String SQL =null;
		LeaveWordDTO dto = (LeaveWordDTO)obj;
		SQL = "UPDATE leaveword SET ABSWERCONTENT=? WHERE ID=?";
		pstat =conn.prepareStatement(SQL);
		pstat.setString(1, dto.getABSWERCONTENT());
		pstat.setInt(2, dto.getID());
		pstat.executeUpdate();
		flag = true;
		if(pstat!=null){pstat.close();}
		return flag;
	}

}