revertdao.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.ApplyDTO;
import edu.yinhe.mis.dto.BoardDTO;
import edu.yinhe.mis.dto.LeaveWordDTO;
import edu.yinhe.mis.dto.RevertDTO;
import edu.yinhe.mis.vo.LeaveWordVO;
import edu.yinhe.mis.vo.RevertVO;
import edu.yinhe.system.model.BaseDAO;
import edu.yinhe.system.model.IBaseDAO;
/**
 * 
 * @author 黄强
 *
 */

public class  RevertDAO extends BaseDAO {

	public Object delete(Object obj) throws SQLException {

		boolean flage = false;
		try {
			String SQL = null;
			PreparedStatement pstat = null;
			SQL = "DELETE FORM revert WHERE ID = ?";
			pstat = conn.prepareStatement(SQL);
			pstat.executeUpdate();
			
			flage = true;
			if(pstat!=null)
			{
				pstat.close();
			}
		} catch (RuntimeException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		
		return flage;
	}

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

	public Object find(Object arag0) 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;
		RevertDTO rdto = null;
		RevertVO vo = null;
		PreparedStatement ps = null;
		ArrayList list = new ArrayList();
		ResultSet rs=null;
		try {
		rdto = (RevertDTO)obj;
		SQL = "SELECT * FROM revert WHERE CARD_ID=?";
		ps = conn.prepareStatement(SQL);
		ps.setInt(1, rdto.getCARD_ID());
		rs = ps.executeQuery();
		while(rs.next()){
			vo = new RevertVO();
			vo.setID(rs.getInt("ID"));
			vo.setREVERT_TITLE(rs.getString("REVERT_TITLE")); 
			vo.setREVERT_CONTENT(rs.getString("REVERT_CONTENT"));
			vo.setREVERT_TIME(rs.getString("REVERT_TIME").toString().substring(0, 19));
			vo.setREVERTER(rs.getString("REVERTER"));
			vo.setREVERT_STATE(rs.getString("REVERT_STATE"));
			list.add(vo);
		}
	} catch (RuntimeException e) {
		// TODO Auto-generated catch block
		e.printStackTrace();
	}finally{
		if(rs!=null)
		{
			rs.close();
		}
			if(ps!=null)ps.close();
		}
		return list;
	}
	

	public Object findById(Object arg0) throws SQLException {
		String SQL=null;
		RevertDTO dto=null;
		RevertVO vo=null;
		PreparedStatement pstat=null;
		ArrayList list = new ArrayList();
		ResultSet rst=null;
		try {
		dto = (RevertDTO)arg0;		
		SQL = "SELCE * FROM revert WHERE id = ? ";
		pstat =conn.prepareStatement(SQL);
		rst = pstat.executeQuery();
			while(rst.next()){
				vo = new RevertVO();
				vo.setREVERT_TITLE(rst.getString("REVERT_TITLE"));
				vo.setREVERT_CONTENT(rst.getString("REVERT_CONTENT"));
				vo.setREVERT_TIME(rst.getString("REVERT_TIME"));
				vo.setREVERTER(rst.getString("REVERTER"));
				vo.setREVERT_STATE(rst.getString("REVERT_STATE"));
				vo.setCARD_ID(rst.getInt("CARD_ID"));
				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 list;
	}

	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 {
		PreparedStatement ps = null;
		String SQL = null;
		RevertDTO dto=null;
		ResultSet rs = null;
		int i=0;
		int j=0;
		boolean flag=false;
		int maxID = 0;
		try {
			dto = (RevertDTO) obj;
			SQL = "INSERT INTO revert(REVERT_TITLE,REVERT_CONTENT,REVERT_TIME,CARD_ID,REVERTER) VALUES(?,?,?,?,?)";
			ps = conn.prepareStatement(SQL);
			ps.setString(1,dto.getREVERT_TITLE());
			ps.setString(2, dto.getREVERT_CONTENT());
			ps.setString(3, dto.getREVERT_TIME());
			ps.setInt(4, dto.getCARD_ID());
			ps.setString(5, dto.getREVERTER());
			i = ps.executeUpdate();

			
			if(i!=0){
				flag = true;
			}
			
		} catch (RuntimeException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			if(ps!=null)
			{
			  ps.close();
			}		
		
		}	
		return flag;
	}
	/**
	 *  修改
	 */
	public Object update(Object obj) throws SQLException {
		PreparedStatement ps = null;
		RevertDTO dto = null;
		String SQL = null;
		boolean falg =false;
		Integer id = (Integer) obj;
		try {
			SQL="UPDATE revert SET REVERT_STATE=1 WHERE ID="+id;
			ps = conn.prepareStatement(SQL);
		
		    ps.executeUpdate();
		
		} catch (RuntimeException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			if(ps!=null)
			{
				ps.close();
			}
			
		}
		 
		
		return falg;
	}

}
//SELECT 
//C.CARD_TITLE,C.CARD_CONTENT,C.CREATE_TIME,R.REVERT_TITLE,R.REVERT_CONTENT,R.REVERT_TIME
//FROM card C,revert R,guanlian G WHERE C.ID=G.cardid AND R.ID=G.contentidAND C.ID=?;