package njitt.software.cms.bean;
import java.io.Serializable;
import java.util.Date;
import org.springframework.format.annotation.DateTimeFormat;
import com.fasterxml.jackson.annotation.JsonFormat;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;
@AllArgsConstructor
@NoArgsConstructor
@Data
public class UserInfo implements Serializable{
private static final long serialVersionUID = 3317389902771634439L;
private Integer id;
private String name;
private String password;
private String phone;
@DateTimeFormat(pattern="yyyy-MM-dd HH:mm:ss")
@JsonFormat(pattern="yyyy-MM-dd HH:mm:ss")
private Date registerDate
}
package njitt.software.cms.controller;
import java.util.Arrays;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpSession;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestBody;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.ResponseBody;
import com.github.pagehelper.PageInfo;
import njitt.software.cms.bean.UserInfo;
import njitt.software.cms.service.UserInfoService;
@Controller
public class UserInfoController {
@Autowired
private UserInfoService userInfoService;
@RequestMapping("/login")
public String login(String name,String password,HttpSession session) {
String msg = userInfoService.login(name, password);
if(msg.contains("success")) {
session.setAttribute("name",name);
return "redirect:manager/index.jsp";
}else {
return "login";
}
}
@RequestMapping("/findAllUsers")
@ResponseBody
public Map
Map
PageInfo
map.put("code", 0);
map.put("msg", "success");
map.put("count", pageInfo.getTotal());
map.put("data", pageInfo.getList());
return map;
}
@RequestMapping("/deleteUserInfo")
public String deleteUserInfo(HttpServletRequest request, Model model) {
Integer id = Integer.valueOf(request.getParameter("action"));
userInfoService.deleteUserInfo(id);
return listUserInfo(model);
}
public String listUserInfo(Model model) {
List
model.addAttribute("UserInfo", userInfos);
return "ListUserInfo";
}
@RequestMapping("/deleteSelectedUsers")
public String deleteSelectedUsers(Integer[] ids) {
List
userInfoService.deleteSelectedUsers(list);
return "redirect:manager/list_user.jsp";
}
@RequestMapping("/updateUserInfo")
@ResponseBody
public Integer updateUserInfo(@RequestBody UserInfo userInfo) {
int result = userInfoService.updateUserInfo(userInfo);
return result;
}
@RequestMapping("/register")
public String register(UserInfo userInfo, Model model) {
String msg = userInfoService.register(userInfo);
if(msg.contains("成功")) {
return "redirect:manager/list_user.jsp";
}else {
model.addAttribute("msg", msg);
return "redirect:manager/register.jsp";
}
}
@RequestMapping("/editUserInfo")
@ResponseBody
public UserInfo editUserInfo(int id) {
UserInfo userInfo = userInfoService.findUserInfoById(id);
return userInfo;
}
//用于退出页面
@RequestMapping("/tologinout")
public String tologinout(HttpServletRequest request) {
request.getSession().removeAttribute("message");
request.getSession().invalidate();
return"login";
}
}
package njitt.software.cms.mapper;
import java.util.List;
import njitt.software.cms.bean.UserInfo;
public interface UserInfoMapper {
public int insertUserInfo(UserInfo userInfo);
public UserInfo findUserInfoByName(String name);
public List
public int deleteUserInfo(int id);
public void deleteSelectedUsers(List
public Integer updateUserInfo(UserInfo userInfo);
public UserInfo findUserInfoById(int id);
}
insert into user_list(user_name,user_password,user_phone)
values(#{name},#{password},#{phone})
resultMap="userMap">
select * from user_list where user_name=#{name}
resultMap="userMap">
select * from user_list where user_id=#{id}
package njitt.software.cms.service;
import java.util.List;
import com.github.pagehelper.PageInfo;
import njitt.software.cms.bean.UserInfo;
public interface UserInfoService {
public int insertUserInfo(UserInfo userInfo);
public String login(String name,String password);
public PageInfo
public int deleteUserInfo(int id);
public void deleteSelectedUsers(List
public int updateUserInfo(UserInfo userInfo);
public String register(UserInfo userInfo);
public List
public UserInfo findUserInfoById(int id);
}
package njitt.software.cms.service.impl;
import java.util.List;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;
import com.github.pagehelper.PageHelper;
import com.github.pagehelper.PageInfo;
import njitt.software.cms.bean.UserInfo;
import njitt.software.cms.mapper.UserInfoMapper;
import njitt.software.cms.service.UserInfoService;
@Transactional
@Service
public class UserInfoServiceImpl implements UserInfoService{
@Autowired
private UserInfoMapper userInfoMapper;
@Override
public int insertUserInfo(UserInfo userInfo) {
return userInfoMapper.insertUserInfo(userInfo);
}
@Override
public List
return userInfoMapper.findAllUsers();
}
@Override
public String login(String name,String password) {
UserInfo userInfo = userInfoMapper.findUserInfoByName(name);
if(userInfo !=null &&
userInfo.getPassword().equals(password)) {
return "login success";
}else {
return "login error";
}
}
@Override
public PageInfo
PageHelper.startPage(pageIndex,pageSize);//拦截功能,返回了当前页的pageSize条数据
List
PageInfo
return pageInfo;
}
@Override
public void deleteSelectedUsers(List
userInfoMapper.deleteSelectedUsers(ids);
}
@Override
public int updateUserInfo(UserInfo userInfo) {
return userInfoMapper.updateUserInfo(userInfo);
}
@Override
public String register(UserInfo userInfo) {
UserInfo existUser = userInfoMapper.findUserInfoByName(userInfo.getName());
if(existUser==null) {
userInfoMapper.insertUserInfo(userInfo);
return "新增成功";
}else {
return "新增错误:登录名已存在";
}
}
@Override
public int deleteUserInfo(int id) {
return userInfoMapper.deleteUserInfo(id);
}
@Override
public UserInfo findUserInfoById(int id) {
return userInfoMapper.findUserInfoById(id);
}
}
package njitt.software.cms.test;
import org.junit.Assert;
import org.junit.Test;
import org.junit.runner.RunWith;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.test.context.ContextConfiguration;
import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;
import njitt.software.cms.bean.UserInfo;
import njitt.software.cms.service.UserInfoService;
@RunWith(SpringJUnit4ClassRunner.class)
@ContextConfiguration(locations="classpath:applicationContext.xml")
public class UserInfoServiceTest {
@Autowired
private UserInfoService userInfoService;
@Test
public void testInsertUserInfo() {
UserInfo userInfo = new UserInfo(1,"admin12","admin12","12238759669", null);
int actual = userInfoService.insertUserInfo(userInfo);
int expected = 1;
Assert.assertEquals("新增错误!", expected,actual);
}
@Test
public void testLogin() {
String msg = userInfoService.login("admin2", "admin2");
System.out.println(msg);
}
// @Test
// public void testFindAllUsers() {
// List
// for (UserInfo userInfo : list) {
// System.out.println(userInfo);
// }
// }
}



