layui之会议OA系统2.0

最新推荐文章于 2024-11-03 09:30:00 发布

zsm030616

最新推荐文章于 2024-11-03 09:30:00 发布

阅读量119

点赞数 1

文章标签： layui 数据库 sql

本文链接：https://blog.csdn.net/zsm030616/article/details/125967280

版权

本文详细介绍了使用layui构建会议OA系统2.0的过程，包括sql编写、后台dao方法与Action子控制器实现、前台js与jsp文件的应用，以及异常处理策略，特别是针对sql异常和图片路径异常的解决方案。

摘要由CSDN通过智能技术生成

一，sql编写

select a.id,a.title,a.content,a.canyuze,a.liexize,a.zhuchiren
,b.`name`zhuchirenname,
a.location,
DATE_FORMAT(a.startTime,'%Y-%m-%d %H-%m-%s') startTime,
DATE_FORMAT(a.endTime,'%Y-%m-%d %H-%m-%s') endTime,
a.state,
(
 case a.state
 when 0 then '取消会议'
 when 1 then '新建'
 when 2 then '待审核'
 when 3 then '驳回'
 when 4 then '代开'
 when 5 then '进行中'
 when 6 then '开启投票'
 when 7 then '结束会议'
 else '其它' end
 
) meetingstate,
a.seatPic,a.remark,a.auditor,
c.`name` auditorname from t_oa_meeting_info a
inner join t_oa_user b on a.zhuchiren = b.id
left join t_oa_user c on a.auditor = c.id

二，会议后台

1.dao方法编写

将以上的sql语句封装成一个方法，方便后面我们调用

	private String getSql() {
		return "select a.id,a.title,a.content,a.canyuze,a.liexize,a.zhuchiren\r\n" + 
				",b.`name`zhuchirenname,\r\n" + 
				"a.location,\r\n" + 
				"DATE_FORMAT(a.startTime,'%Y-%m-%d %H-%m-%s') startTime,\r\n" + 
				"DATE_FORMAT(a.endTime,'%Y-%m-%d %H-%m-%s') endTime,\r\n" + 
				"a.state,\r\n" + 
				"(\r\n" + 
				" case a.state\r\n" + 
				" when 0 then '取消会议'\r\n" + 
				" when 1 then '新建'\r\n" + 
				" when 2 then '待审核'\r\n" + 
				" when 3 then '驳回'\r\n" + 
				" when 4 then '代开'\r\n" + 
				" when 5 then '进行中'\r\n" + 
				" when 6 then '开启投票'\r\n" + 
				" when 7 then '结束会议'\r\n" + 
				" else '其它' end\r\n" + 
				" \r\n" + 
				") meetingstate,\r\n" + 
				"a.seatPic,a.remark,a.auditor,\r\n" + 
				"c.`name` auditorname from t_oa_meeting_info a\r\n" + 
				"inner join t_oa_user b on a.zhuchiren = b.id\r\n" + 
				"left join t_oa_user c on a.auditor = c.id\r\n" + 
				"";
	}

我的会议查询dao方法

//我的会议
	public List<Map<String, Object>> myInfos(MeetingInfo info, PageBean pageBean) throws SQLException, InstantiationException, IllegalAccessException {
		//拿到封装好的SQL
		String sql = getSql();
		//会议标题
		String title = info.getTitle();
		if(StringUtils.isNotBlank(title)) {
			sql +=" and title like '%"+title+"%'";
		}
		sql +=&