目录
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.整天页面