1.user实体类
@Data
public class User {
private Integer userId;
private String userName;
private String passWord;
}
public interface UserDao {
List queryUser();
void deleteUser(int userId);
void insertUser(User user);
User getUserId(int userId);
void updateUser(User user);
List getUserName(String userName);
User userLogin(String userName,String passWord);
int countUser();
}
select * FROM user ORDER BY userId ASC
SELECT *
FROM USER
WHERe
userName = #{userName} AND passWord = #{passWord}
DELETE FROM
USER
WHERe
userId =
#{userId}
INSERT INTO
USER (userName,passWord)
VALUES
(#{userName},#{passWord})
SELECT *
FROM USER
WHERe
userId=#{userId}
update USER
userName=#{userName},
passWord=#{passWord}
where userId=#{userId}
SELECT *
FROM USER
WHERe
userName=#{userName}
SELECT count(*)
FROM USER
public interface UserService
{
List getListUser();
void deleteUser(int userId);
void insertUser(User user);
User getUserId(int userId);
void updateUser(User user);
List getUserName (String userName);
User Login(String userName,String passWord);
int countUser();
List findUserByPage();
}
@Service
public class UserServiceImpl implements UserService{
@Autowired
private UserDao userDao;
public List getListUser(){
return userDao.queryUser();
}
public void deleteUser(int userId){
userDao.deleteUser(userId);
}
public void insertUser(User user) {
userDao.insertUser(user);
}
public User getUserId(int userId){
return userDao.getUserId(userId);
}
public void updateUser(User user){
userDao.updateUser(user);
}
public List getUserName (String userName){
return userDao.getUserName(userName);
}
public int countUser(){return userDao.countUser();}
public User Login(String userName,String passWord){
return userDao.userLogin(userName,passWord);
}
public List findUserByPage(){
List allUser = userDao.queryUser();//全部商品
return allUser;
}
}
@RequestMapping("/show")
public ModelAndView getIndex(Map map) {
List list = new ArrayList(); // 获取区域列表
list = userServiceImpl.getListUser();
map.put("list", list);
return new ModelAndView("index3", map);
}
@RequestMapping(value = "/query")
public ModelAndView getUserName(@RequestParam("userName") String userName) {
Map mm = new HashMap();
List list = new ArrayList();
list = userServiceImpl.getUserName(userName);
mm.put("list", list);
return new ModelAndView("show", mm);
}
@RequestMapping(value = "/update", method = RequestMethod.GET)
public ModelAndView getUserById(int userId) {
Map mm = new HashMap();
User user = userServiceImpl.getUserId(userId);
mm.put("user", user);
return new ModelAndView("form", mm);
}
@RequestMapping(value = "/updateUser")
public void updateUser(@RequestParam("userName") String userName, @RequestParam("passWord") String passWord, @RequestParam("userId") int userId) {
User user = userServiceImpl.getUserId(userId);
user.setUserName(userName);
user.setPassWord(passWord);
userServiceImpl.updateUser(user);
}
@RequestMapping(value = "/delete", method = RequestMethod.GET)
public void delete(Integer userId) {
userServiceImpl.deleteUser(userId);
}
@ResponseBody
@RequestMapping(value = "/save", method = RequestMethod.POST)
public void save(String userName, String passWord) {
User user = new User();
user.setUserName(userName);
user.setPassWord(passWord);
userServiceImpl.insertUser(user);
}
7.index3.ftl文件
layout 后台大布局 - Layui
<#include "nav3.ftl">
<#include "left2.ftl">
新增用户
搜索用户
用户表
用户id
用户姓名
用户密码
操作
<#list list as li>
${li.userId}
${li.userName}
${li.passWord}
修改
删除
© layui.com - 底部固定区域