servlet+JSP+easyUI+mysql网络报修系统

servlet+JSP+easyUI+mysql网络报修系统

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个文件信息