package njitt.software.cms.mapper;
import java.util.List;
import njitt.software.cms.bean.ManagerInfo;
public interface ManagerInfoMapper {
public int insertManagerInfo(ManagerInfo managerInfo);
public ManagerInfo findManagerInfoByLoginId(String loginId);
public List findAllUsers();
}
insert into
t_manager (login_id,password,email,user_name,register_date,status)
values(#{loginId},#{password},#{email},#{userName},#{registerDate},#{status})
select * from t_manager where login_id=#{loginId}
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.ManagerInfo;
import njitt.software.cms.mapper.ManagerInfoMapper;
import njitt.software.cms.service.ManagerInfoService;
import njitt.software.cms.util.EncryptUtil;
@Transactional
@Service
public class ManagerInfoServiceImpl implements ManagerInfoService {
@Autowired
private ManagerInfoMapper managerInfoMapper;
@Override
public int insertManagerInfo(ManagerInfo managerInfo) {
// TODO Auto-generated method stub
return managerInfoMapper.insertManagerInfo(managerInfo);
}
@Override
public String login(String loginId,String password) {
ManagerInfo managerInfo = managerInfoMapper.findManagerInfoByLoginId(loginId);
if(managerInfo !=null&&managerInfo.getPassword().equals(EncryptUtil.md5Crypt(password))) {
return "login success";
}else {
return "login error";
}
}
@Override
public PageInfo findAllUsers(int pageIndex, int pageSize) {
PageHelper.startPage(pageIndex,pageSize);
List list=managerInfoMapper.findAllUsers();
PageInfo pageInfo=new PageInfo(list);
return pageInfo;
}
}
package njitt.software.cms.service;
import com.github.pagehelper.PageInfo;
import njitt.software.cms.bean.ManagerInfo;
public interface ManagerInfoService {
public int insertManagerInfo(ManagerInfo managerInfo);
public String login(String loginId,String password);
public PageInfo findAllUsers(int pageIndex, int pageSize);
}
package njitt.software.cms.test;
import java.util.Date;
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.ManagerInfo;
import njitt.software.cms.service.ManagerInfoService;
import njitt.software.cms.util.EncryptUtil;
@RunWith(SpringJUnit4ClassRunner.class)
@ContextConfiguration(locations = "classpath:applicationContext.xml")
public class ManagerInfoServiceTest {
@Autowired
private ManagerInfoService managerInfoService;
@Test
public void testInsertManagerInfo() {
ManagerInfo managerInfo = new ManagerInfo(1, "admin", EncryptUtil.md5Crypt("admin"), "admin@123.com", "����",
new Date(), true);
int actual = managerInfoService.insertManagerInfo(managerInfo);
int expected = 1;
Assert.assertEquals("��������", expected, actual);
}
@Test
public void testLogin() {
String msg = managerInfoService.login("admin2", "admin2");
System.out.println(msg);
}
}