会议排坐和送首

目录

1.dao方法

2.类

1.dao方法

package com.zking.web;

import java.util.Date;
import java.util.List;
import java.util.Map;
import java.util.UUID;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.apache.commons.beanutils.ConvertUtils;

import com.zking.dao.MeetingInfoDao;
import com.zking.entity.MeetingInfo;
import com.zking.framework.ActionSupport;
import com.zking.framework.ModelDriver;
import com.zking.util.Base64ImageUtils;
import com.zking.util.MyDateConverter;
import com.zking.util.PageBean;
import com.zking.util.PropertiesUtil;
import com.zking.util.R;
import com.zking.util.ResponseUtil;


public class MeetingInfoAction extends ActionSupport implements ModelDriver {
	private MeetingInfo meetingInfo = new MeetingInfo();
	private MeetingInfoDao meetingInfoDao = new MeetingInfoDao();

	@Override
	public MeetingInfo getModel() {
//		注册一个转换器
		ConvertUtils.register(new MyDateConverter(), Date.class);
		return meetingInfo;
	}

	public String list(HttpServletRequest req, HttpServletResponse resp) {
		PageBean pageBean = new PageBean();
		pageBean.setRequest(req);
		try {
			List meetingInfos = meetingInfoDao.list(meetingInfo, pageBean);
			req.setAttribute("meetingInfos", meetingInfos);
			req.setAttribute("pageBean", pageBean);
		} catch (Exception e) {
			e.printStackTrace();
		}
		return "list";
	}
	
	
	public String updateSeatPicById(HttpServletRequest req, HttpServletResponse resp) {
		try {
			String dirpath = PropertiesUtil.getValue("dirpath");
			String serverPath = PropertiesUtil.getValue("serverPath");
			String fileName = UUID.randomUUID().toString().replaceAll("-","")+".png";
//			meetingInfo.getSeatPic();
			 Base64ImageUtils.GenerateImage(meetingInfo.getSeatPic().replaceAll("data:image/png;base64,",""), dirpath+fileName);
			 meetingInfo.setSeatPic(serverPath+fileName);
			 
			 
			 
//			rs是sql语句执行的影响行数
			int rs = meetingInfoDao.updateSeatPicById(meetingInfo);
			if(rs>0) {
				ResponseUtil.writeJson(resp, R.ok(200, "会议排坐成功"));
			}
		} catch (Exception e) {
			e.printStackTrace();
			try {
				ResponseUtil.writeJson(resp, R.ok(0, "会议排坐失败"));
			} catch (Exception e1) {
				// TODO Auto-generated catch block
				e1.printStackTrace();
			}
		}
		return null;
	}

	public String add(HttpServletRequest req, HttpServletResponse resp) {
		try {
//			rs是sql语句执行的影响行数
			int rs = meetingInfoDao.add(meetingInfo);
			if(rs>0) {
				ResponseUtil.writeJson(resp, R.ok(200, "会议信息数据新增成功"));
			}
		} catch (Exception e) {
			e.printStackTrace();
			try {
				ResponseUtil.writeJson(resp, R.ok(0, "数会议信息据新增失败"));
			} catch (Exception e1) {
				// TODO Auto-generated catch block
				e1.printStackTrace();
			}
		}
		return null;
	}

//	我的会议
	public String myInfos(HttpServletRequest req, HttpServletResponse resp) {
		try {
			PageBean pageBean = new PageBean();
			pageBean.setRequest(req);
			List> lst = meetingInfoDao.myInfos(meetingInfo, pageBean);
//		注意：layui中的数据表的格式
			ResponseUtil.writeJson(resp, R.ok(0, "我的会议数据查询成功",pageBean.getTotal(),lst));
		} catch (Exception e) {
			e.printStackTrace();
			try {
				ResponseUtil.writeJson(resp, R.ok(0, "我的会议数据查询失败"));
			} catch (Exception e1) {
				// TODO Auto-generated catch block
				e1.printStackTrace();
			}
		}
		return null;
	}
	
	
	
	
	public String delete(HttpServletRequest req, HttpServletResponse resp) {
		try {
			meetingInfoDao.delete(meetingInfo);
		} catch (Exception e) {
			e.printStackTrace();
		}
		return "toList";
	}

	public String edit(HttpServletRequest req, HttpServletResponse resp) {
		try {
			meetingInfoDao.edit(meetingInfo);
		} catch (Exception e) {
			e.printStackTrace();
		}
		return "toList";
	}

	public String toEdit(HttpServletRequest req, HttpServletResponse resp) {
		if (meetingInfo.getId() == null || meetingInfo.getId() == 0)
			return "toEdit";
		if (meetingInfo.getId() != 0) {
			try {
				List list = meetingInfoDao.list(meetingInfo, null);
				req.setAttribute("meetingInfo", list.get(0));
			} catch (Exception e) {
				e.printStackTrace();
			}
		}
		return "toEdit";
	}
}

2.类

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>













    
    
	
		
			
		
		
			添加座位