会议OA项目--我的会议

白敬亭的鞋44ma

已于 2022-07-23 20:23:20 修改

阅读量247

点赞数

分类专栏： jquery 文章标签： sql 数据库

于 2022-07-23 19:50:55 首次发布

本文链接：https://blog.csdn.net/qq_66924116/article/details/125947495

版权

一、我的会议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 ;

表t_oa_meetiginfo的部分数据展示

二、我的会议后台代码

meetingdao方法

package com.zking.dao;

import java.lang.String;
import java.sql.SQLException;
import java.util.List;
import java.util.Map;

import com.zking.entity.MeetingInfo;
import com.zking.util.BaseDao;
import com.zking.util.PageBean;
import com.zking.util.StringUtils;
/**
 * 
 * @author 灏忔潕椋炲垁
 *
 */
public class MeetingInfoDao extends BaseDao<MeetingInfo> {
	public  int add(MeetingInfo meetingInfo) throws Exception {
		String sql = "insert into t_oa_meeting_info(title,content, canyuze, liexize,zhuchiren, location,startTime,endTime,remark) values(?,?,?,?,?,?,?,?,?)";
		return super.executeUpdate(sql, meetingInfo, new String[] { "title", "content" ,"canyuze", "liexize","zhuchiren", "location","startTime","endTime","remark"});
	}
	
	//我的会议sql
	private String getSQL() {
		return "\r\n" + 
				"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')\r\n" + 
				"startTime,DATE_FORMAT(a.endTime,'%Y-%m-%d %H-%m-%s') endTime, 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  and 1=1";
		
	}
//ctrl+n --->juint窗口
	
//			public List<Map<String, Object>> myinfos(MeetingInfo info PageBean pageBean) throws Exception {
		public List<Map<String, Object>> myinfos(MeetingInfo info, PageBean pageBean)
					throws SQLException, InstantiationException, IllegalAccessException {
		String sql=getSQL();//调用sql语句	
			//会议标题用来模糊查询
			String title=info.getTitle();//拿到标题
			if(StringUtils.isNotBlank(title)) {
				sql += " and title like '%"+title