数据库
1. bean(userinfo)
package njitt.software.cms.bean;
import java.io.Serializable;
import java.util.Date;public class UserInfo implements Serializable {
/**
*
*/
private static final long serialVersionUID = -6013401935448506864L;
private Integer id;
private String loginId;
private String password;
private String email;
private String userName;
private Date registerDate;
private Boolean status;public UserInfo() {
super();
}public UserInfo(Integer id, String loginId, String password, String email, String userName, Date registerDate,
Boolean status) {
super();
this.id = id;
this.loginId = loginId;
this.password = password;
this.email = email;
this.userName = userName;
this.registerDate = registerDate;
this.status = status;
}public Integer getId() {
return id;
}public void setId(Integer id) {
this.id = id;
}public String getLoginId() {
return loginId;
}public void setLoginId(String loginId) {
this.loginId = loginId;
}public String getPassword() {
return password;
}public void setPassword(String password) {
this.password = password;
}public String getEmail() {
return email;
}public void setEmail(String email) {
this.email = email;
}public String getUserName() {
return userName;
}public void setUserName(String userName) {
this.userName = userName;
}public Date getRegisterDate() {
return registerDate;
}public void setRegisterDate(Date registerDate) {
this.registerDate = registerDate;
}public Boolean getStatus() {
return status;
}public void setStatus(Boolean status) {
this.status = status;
}@Override
public String toString() {
return "UserInfo [id=" + id + ", loginId=" + loginId + ", password=" + password + ", email=" + email
+ ", userName=" + userName + ", registerDate=" + registerDate + ", status=" + status + "]";
}}
2. controller(UserInfoController.java)
package njitt.software.cms.controller;
import java.util.HashMap;
import java.util.List;
import java.util.Map;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.RequestMapping;
import org.springframework.web.bind.annotation.ResponseBody;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 loginId,String password,HttpSession session) {
String msg = userInfoService.login(loginId, password);
if(msg.contains("success")) {
session.setAttribute("loginId", loginId);
return"redirect:manager/index.jsp";
}else{
return "login";
}
}
@RequestMapping("/findAllUsers")
@ResponseBody
public Map<String,Object> findAllUsers(){
Map<String,Object> map =new HashMap<String,Object>();
List<UserInfo> list = userInfoService.findAllUsers();
map.put("code", 0);
map.put("msg", "success");
map.put("count", list.size());
map.put("data", list);
return map;
}
}
3.1 mapper(UserInfoMapper.java)
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 findUserInfoByLoginId(String login);
public List<UserInfo> findAllUsers();
}
3.2 mapper(UserInfoMapper.xml)
创建mybatis xml mapper
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="njitt.software.cms.mapper.UserInfoMapper">
<resultMap type="UserInfo" id="userMap">
<id column="id" property="id"/>
<result column="login_id" property="loginId"/>
<result column="password" property="password"/>
<result column="email" property="email"/>
<result column="user_name" property="userName"/>
<result column="register_date" property="registerDate"/>
<result column="status" property="status"/>
</resultMap>
<insert id="insertUserInfo" parameterType="UserInfo">
insert into t_user (login_id, password, email, user_name, register_date, status)
values(#{loginId},#{password},#{email},#{userName},#{registerDate},#{status})
</insert>
<select id="findUserInfoByLoginId" parameterType="String"
resultMap="userMap">
select * from t_user where login_id=#{loginId}
</select>
<select id="findAllUsers" resultMap="userMap">
select * from t_user
</select>
</mapper>
4.1 service/impl/UserInfoServiceImpl.java)
class add userinfoservice
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 njitt.software.cms.bean.UserInfo;
import njitt.software.cms.mapper.UserInfoMapper;
import njitt.software.cms.service.UserInfoService;
import njitt.software.cms.util.EncryptUtil;@Transactional
@Service
public class UserInfoServiceImpl implements UserInfoService {
@Autowired
private UserInfoMapper userInfoMapper;@Override
public int insertUserInfo(UserInfo userInfo) {
// TODO Auto-generated method stub
return userInfoMapper.insertUserInfo(userInfo);
}@Override
public String login(String loginId, String password) {
UserInfo userInfo = userInfoMapper.findUserInfoByLoginId(loginId);
if (userInfo != null && userInfo.getPassword().equals(EncryptUtil.md5Crypt(password))) {
return "login success";
} else {
return "login error";}
}@Override
public List<UserInfo> findAllUsers() {
return userInfoMapper.findAllUsers();
}
}
4.2 service/UserInfoService.java
package njitt.software.cms.service;
import java.util.List;
import njitt.software.cms.bean.UserInfo;
public interface UserInfoService {
public int insertUserInfo(UserInfo userInfo);public String login(String loginId, String password);
public List<UserInfo> findAllUsers();
}
5 test/UserInfoServiceTest.java
package njitt.software.cms.test;
import java.util.Date;
import java.util.List;/*
*
*
*/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;
import njitt.software.cms.util.EncryptUtil;@RunWith(SpringJUnit4ClassRunner.class)
@ContextConfiguration(locations = "classpath:applicationContext.xml")
public class UserInfoServiceTest {@Autowired
private UserInfoService userInfoService;@Test
public void testInserUserInfo() {
UserInfo userInfo = new UserInfo(1, "admin", EncryptUtil.md5Crypt("admin"), "admin@126.com", "系统管理员",
new Date(), true);
int actual = userInfoService.insertUserInfo(userInfo);
int expected = 1;
Assert.assertEquals("新增错误!", expected, actual);
}@Test
public void testLogin() {
String msg = userInfoService.login("admin", "admin");
System.out.println(msg);
}@Test
public void testFindAll() {
List<UserInfo> list = userInfoService.findAllUsers();
for (UserInfo userInfo : list) {
System.out.println(userInfo);
}
}
}