package?com.gzmu.interManSys.dao;

import?java.sql.Connection;
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;

import?com.gzmu.interManSys.model.Memo;
import?com.gzmu.interManSys.model.PageBean;
import?com.gzmu.interManSys.util.StringUtil;

public?class?MemoDao?{
	//顯示備忘錄列表以及查詢
	public?ResultSet?memoList（Connection?conPageBean?pageBeanMemo?memo）throws?Exception{
		StringBuffer?sb=new?StringBuffer（“select?*?from?t_memo?where?title=‘備忘錄‘?and?my?like‘%“+memo.getMy（）+“%‘“）;
		//如果時間不為空，則查詢條件為時間的記錄
		if（StringUtil.isNotEmpty（memo.getTime（）））{
			sb.append（“?and?time?like?‘%“+memo.getTime（）+“%‘“）;
		}
		if（pageBean!=null）{
			sb.append（“?limit?“+pageBean.getStart（）+““+pageBean.getRows（））;
		}
		PreparedStatement?pstmt=con.prepareStatement（sb.toString（））;
		return?pstmt.executeQuery（）;
	}
	//統計任務記錄數
	public?int?memoCount（Connection?con?Memo?memo）?throws?Exception{
		StringBuffer?sb=new?StringBuffer（“select?count（*）?as?total?from?t_memo?where?title=‘備忘錄‘?and?my?like?‘%“+memo.getMy（）+“%‘“）;
		
		//如果時間不為空，則查詢條件為時間的記錄
		if（StringUtil.isNotEmpty（memo.getTime（）））{
			sb.append（“?and?time?like?‘%“+memo.getTime（）+“%‘“）;
		}
		PreparedStatement?pstmt=con.prepareStatement（sb.toString（））;
		ResultSet?rs=pstmt.executeQuery（）;
		if（rs.next（））{
			return?rs.getInt（“total“）;
		}
		else{
			return?0;
		}
	}
	//刪除備忘錄事件
	public?int?memoDel（Connection?con?String?delIds）?throws?Exception?{
		String?sql=“delete?from?t_memo?where?memoId?in（“+delIds+“）“;
		PreparedStatement?ps=con.prepareStatement（sql）;
		return?ps.executeUpdate（）;
	}
	//添加備忘錄事件
	public?int?memoAdd（Connection?conMemo?memo）?throws?Exception{
		String?sql=“insert?into?t_memo（）?value（null????）“;
		PreparedStatement?ps=con.prepareStatement（sql）;
		ps.setString（1?memo.gettitle（））;
		ps.setString（2?memo.getContent（））;
		ps.setString（3?memo.getTime（））;
		ps.setString（4?memo.getMy（））;
		return?ps.executeUpdate（）;
	}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件?????????727??2015-08-18?11:33??NetworkRepairsSys\.classpath
?????文件????????1050??2015-08-23?09:12??NetworkRepairsSys\.project
?????目錄???????????0??2015-08-23?10:30??NetworkRepairsSys\.settings\
?????文件?????????503??2015-04-22?20:22??NetworkRepairsSys\.settings\.jsdtscope
?????文件??????????95??2015-08-10?13:44??NetworkRepairsSys\.settings\org.eclipse.core.resources.prefs
?????文件?????????670??2015-08-23?09:16??NetworkRepairsSys\.settings\org.eclipse.jdt.core.prefs
?????文件?????????505??2015-08-23?09:12??NetworkRepairsSys\.settings\org.eclipse.wst.common.component
?????文件?????????305??2015-05-19?20:58??NetworkRepairsSys\.settings\org.eclipse.wst.common.project.facet.core.xml
?????文件??????????49??2015-04-22?20:22??NetworkRepairsSys\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2015-04-22?20:22??NetworkRepairsSys\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????目錄???????????0??2015-08-23?10:30??NetworkRepairsSys\build\
?????目錄???????????0??2015-08-23?10:30??NetworkRepairsSys\build\classes\
?????目錄???????????0??2015-08-23?10:30??NetworkRepairsSys\build\classes\com\
?????目錄???????????0??2015-08-23?10:30??NetworkRepairsSys\build\classes\com\gzmu\
?????目錄???????????0??2015-08-23?10:30??NetworkRepairsSys\build\classes\com\gzmu\interManSys\
?????目錄???????????0??2015-08-23?10:30??NetworkRepairsSys\build\classes\com\gzmu\interManSys\dao\
?????文件????????3057??2015-08-23?09:16??NetworkRepairsSys\build\classes\com\gzmu\interManSys\dao\MemoDao.class
?????文件????????3772??2015-08-23?09:16??NetworkRepairsSys\build\classes\com\gzmu\interManSys\dao\MessageDao.class
?????文件????????3425??2015-08-23?09:16??NetworkRepairsSys\build\classes\com\gzmu\interManSys\dao\PersonInfoModifyDao.class
?????文件????????4864??2015-08-23?09:16??NetworkRepairsSys\build\classes\com\gzmu\interManSys\dao\TaskDao.class
?????文件????????4466??2015-08-23?09:16??NetworkRepairsSys\build\classes\com\gzmu\interManSys\dao\TaskHandInDao.class
?????文件????????4105??2015-08-23?09:16??NetworkRepairsSys\build\classes\com\gzmu\interManSys\dao\TaskReceiveDao.class
?????文件????????6220??2015-08-23?09:16??NetworkRepairsSys\build\classes\com\gzmu\interManSys\dao\UserDao.class
?????目錄???????????0??2015-08-23?10:30??NetworkRepairsSys\build\classes\com\gzmu\interManSys\model\
?????文件????????1522??2015-08-23?09:16??NetworkRepairsSys\build\classes\com\gzmu\interManSys\model\Memo.class
?????文件????????1766??2015-08-23?09:16??NetworkRepairsSys\build\classes\com\gzmu\interManSys\model\Message.class
?????文件?????????894??2015-08-23?09:16??NetworkRepairsSys\build\classes\com\gzmu\interManSys\model\PageBean.class
?????文件????????2987??2015-08-23?09:16??NetworkRepairsSys\build\classes\com\gzmu\interManSys\model\Task.class
?????文件????????3320??2015-08-23?09:16??NetworkRepairsSys\build\classes\com\gzmu\interManSys\model\User.class
?????目錄???????????0??2015-08-23?10:30??NetworkRepairsSys\build\classes\com\gzmu\interManSys\util\
?????文件????????1825??2015-08-23?09:16??NetworkRepairsSys\build\classes\com\gzmu\interManSys\util\CharacterEncodingFilter.class
............此處省略916個文件信息