layui用户增加

目录

1.用户管理后台代码

2.用户新增

 3.整天页面

---

1.用户管理后台代码

package com.zking.dao;

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

import com.zking.entity.User;
import com.zking.util.BaseDao;
import com.zking.util.PageBean;
import com.zking.util.StringUtils;

public class UserDao extends BaseDao<User>{
	public User login(User user) throws Exception {
		String sql = "select * from t_oa_user where loginName = '"
				+user.getLoginName()+"' and pwd = '"+user.getPwd()+"'";
		//根据SQL查询符号条件的用户，通常只会返回一条数据
		List<User> users = super.executeQuery(sql, User.class,null);
		return users == null || users.size() == 0 ? null : users.get(0);
		//		return super.executeQuery(sql, clz, pageBean);
	}
//	查询用户信息及对应的角色，角色是通过case when得来的
	public List<Map<String, Object>> list(User user,PageBean pageBean ) throws InstantiationException, IllegalAccessException, SQLException{
		String sql = "SELECT *  \r\n" + 
				",(case rid \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" + 
				"else '其他' end \r\n" + 
				") roleName \r\n" + 
				"from \r\n" + 
				" t_oa_user where 1=1 ";
		String name = user.getName();
		if(StringUtils.isNotBlank(name)) {
			sql += " and name like '%"+name+"%'";
		}
//		当实体类的属性完全包含数据库查询出来的列段时候使用
//		super.executeQuery(sql, clz, pageBean)
//		返回List<Map<String, Object>>, 对应的是联表查询，单个实体类对象不完全包含查询列段
		return super.executeQuery(sql, pageBean);
		
	}
	
	public int add(User user) throws Exception {
		String sql = "insert into t_oa_user(name,loginName,pwd) values(?,?,?)";
		return super.executeUpdate(sql, user, new String [] {"name","loginName","pwd"});
	}
	
	public int del(User user) throws Exception {
		String sql = "delete from t_oa_user where id = ?";
		return super.executeUpdate(sql, user, new String [] {"id"});
	}
	
	public int edit(User user) throws Exception {
		String sql = "update t_oa_user set name=?, loginName=?, pwd=? where id=?";
		return super.executeUpdate(sql, user, new String [] {"name","loginName","pwd","id"});
	}
	
	
}

2.用户新增

 3.整天页面