package com.itcast.controller;

import java.util.Date;
import java.util.List;

import org.n3r.idworker.Sid;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

import com.itcast.entity.SysUser;
import com.itcast.service.SysUserService;
import com.itcast.utils.ItCastJSONResult;

/**
?* mybatis springboot整合CURDController
?* 訪問路徑：http://localhost:8080/mybatis/saveUser
?* 訪問路徑：http://localhost:8080/mybatis/updateUser
?* 訪問路徑：http://localhost:8080/mybatis/deleteUser
?* 訪問路徑：http://localhost:8080/mybatis/queryUserById?userId=1001
?* 訪問路徑：http://localhost:8080/mybatis/queryUserList
?* 訪問路徑：http://localhost:8080/mybatis/queryUserListPaged
?* 訪問路徑：http://localhost:8080/mybatis/queryUserByIdCustom?userId=1001
?* 訪問路徑：http://localhost:8080/mybatis/saveUserTransactional
?* @author jack
?*
?*/
@RestController
@RequestMapping("mybatis")
public class MyBatisCURDController {

?? ?final static Logger log=LoggerFactory.getLogger(MyBatisCURDController.class);

?? ?@Autowired
?? ?private Sid sid;
?? ?
?? ?@Autowired
?? ?private SysUserService userService;
?? ?
?? ?@RequestMapping("/saveUser")
?? ?public ItCastJSONResult saveUser() throws Exception{
?? ??? ?
?? ??? ?log.info("保存用戶,當前時間:{},操作人:{}",new Date(),"jack");
?? ??? ?
?? ??? ?String userid=sid.nextShort();
?? ??? ?
?? ??? ?SysUser user=new SysUser();
?? ??? ?user.setId(userid);
?? ??? ?user.setUsername("軒轅花狐貂"+new Date());
?? ??? ?user.setNickname("花狐貂"+new Date());
?? ??? ?user.setPassword("abc123456");
?? ??? ?user.setIsDelete(0);
?? ??? ?user.setRegistTime(new Date());
?? ??? ?
?? ??? ?userService.saveUser(user);
?? ??? ?
?? ??? ?return ItCastJSONResult.ok("插入成功");
?? ?}
?? ?
?? ?@RequestMapping("/updateUser")
?? ?public? ItCastJSONResult updateUser(){
?? ??? ?SysUser user=new SysUser();
?? ??? ?user.setId("1001");
?? ??? ?user.setUsername("mybatisUser"+new Date());
?? ??? ?user.setNickname("mybatisUser"+new Date());
?? ??? ?user.setPassword("mybatisUser");
?? ??? ?user.setIsDelete(0);
?? ??? ?user.setRegistTime(new Date());
?? ??? ?userService.updateUser(user);
?? ??? ?return ItCastJSONResult.ok("更新成功");
?? ?}
?? ?
?? ?@RequestMapping("/deleteUser")
?? ?public ItCastJSONResult deleteUser(String userId) {
?? ??? ?
?? ??? ?userService.deleteUser(userId);
?? ??? ?
?? ??? ?return ItCastJSONResult.ok("刪除成功");
?? ?}
?? ?
?? ?@RequestMapping("/queryUserById")
?? ?public ItCastJSONResult queryUserById(String userId) {
?? ??? ?log.info("userId="+userId);
?? ??? ?log.info("queryUserById查詢到的結(jié)果"+userService.queryUserById(userId));
?? ??? ?return ItCastJSONResult.ok(userService.queryUserById(userId));
?? ?}
?? ?
?? ?
?? ?@RequestMapping("/queryUserList")
?? ?public ItCastJSONResult queryUserList() {
?? ??? ?
?? ??? ?SysUser user = new SysUser();
/*?? ??? ?user.setUsername("test");
?? ??? ?user.setNickname("test");*/
?? ??? ?
?? ??? ?List<SysUser> userList = userService.queryUserList(user);
?? ??? ?
?? ??? ?return ItCastJSONResult.ok(userList);
?? ?}
?? ?
?? ?@RequestMapping("/queryUserListPaged")
?? ?public ItCastJSONResult queryUserListPaged(Integer page) {
?? ??? ?
?? ??? ?if (page == null) {
?? ??? ??? ?page = 1;
?? ??? ?}

?? ??? ?int pageSize = 3;
?? ??? ?
?? ??? ?SysUser user = new SysUser();
//?? ??? ?user.setNickname("lee");
?? ??? ?
?? ??? ?List<SysUser> userList = userService.queryUserListPaged(user, page, pageSize);
?? ??? ?
?? ??? ?log.info("userList的大小:"+userList.size());
?? ??? ?log.info("userList:"+userList);
?? ??? ?return ItCastJSONResult.ok(userList);
?? ?}
?? ?
?? ?@RequestMapping("/queryUserByIdCustom")
?? ?public ItCastJSONResult queryUserByIdCustom(String userId) {
?? ??? ?
?? ??? ?return ItCastJSONResult.ok(userService.queryUserByIdCustom(userId));
?? ?}
?? ?
?? ?@RequestMapping("/saveUserTransactional")
?? ?public ItCastJSONResult saveUserTransactional() {
?? ??? ?
?? ??? ?String userId = sid.nextShort();
?? ??? ?
?? ??? ?SysUser user = new SysUser();
?? ??? ?user.setId(userId);
?? ??? ?user.setUsername("lee" + new Date());
?? ??? ?user.setNickname("lee" + new Date());
?? ??? ?user.setPassword("abc123");
?? ??? ?user.setIsDelete(0);
?? ??? ?user.setRegistTime(new Date());
?? ??? ?
?? ??? ?userService.saveUserTransactional(user);
?? ??? ?
?? ??? ?return ItCastJSONResult.ok("保存成功");
?? ?}
}
==================================================

package com.itcast.service.impl;

import java.util.List;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import com.github.pagehelper.PageHelper;
import com.itcast.entity.SysUser;
import com.itcast.mapper.SysUserMapper;
import com.itcast.mapper.SysUserMapperCustom;
import com.itcast.service.SysUserService;

import tk.mybatis.mapper.entity.Example;
import org.thymeleaf.util.StringUtils;

@Service
public class SysUserServiceImpl implements SysUserService {

?? ?@Autowired
?? ?private SysUserMapper userMapper;
?? ?@Autowired
?? ?private SysUserMapperCustom userMapperCustom;

?? ?@Override
?? ?public void saveUser(SysUser user) throws Exception {
?? ??? ?userMapper.insert(user);

?? ?}

?? ?@Override
?? ?public void updateUser(SysUser user) {
?? ??? ?userMapper.updateByPrimaryKeySelective(user);

?? ?}

?? ?@Override
?? ?public void deleteUser(String userId) {
?? ??? ?// TODO Auto-generated method stub
?? ??? ?userMapper.deleteByPrimaryKey(userId);
?? ?}

?? ?@Override
?? ?public SysUser queryUserById(String userId) {

?? ??? ?return userMapper.selectByPrimaryKey(userId);
?? ?}

?? ?@Override
?? ?public List<SysUser> queryUserList(SysUser user) {
?? ??? ?try {
?? ??? ??? ?Example example = new Example(SysUser.class);
?? ??? ??? ?Example.Criteria criteria = example.createCriteria();

?? ??? ??? ?if (!StringUtils.isEmptyOrWhitespace(user.getUsername())) {
?? ??? ??? ??? ?// criteria.andEqualTo("username", user.getUsername());
?? ??? ??? ??? ?criteria.andLike("username", "%" + user.getUsername() + "%");
?? ??? ??? ?}

?? ??? ??? ?if (!StringUtils.isEmptyOrWhitespace(user.getNickname())) {
?? ??? ??? ??? ?criteria.andLike("nickname", "%" + user.getNickname() + "%");
?? ??? ??? ?}

?? ??? ??? ?List<SysUser> userList = userMapper.selectByExample(example);
?? ??? ??? ?return userList;
?? ??? ?} catch (Exception ex) {
?? ??? ??? ?System.out.println(ex.getMessage());
?? ??? ??? ?// TODO: handle exception
?? ??? ??? ?return null;
?? ??? ?}
?? ?}

?? ?@Override
?? ?public List<SysUser> queryUserListPaged(SysUser user, Integer page, Integer pageSize) {
?? ??? ?// 開始分頁
?? ??? ?PageHelper.startPage(page, pageSize);
?? ??? ?Example example = new Example(SysUser.class);
?? ??? ?Example.Criteria criteria = example.createCriteria();
?? ??? ?if (StringUtils.isEmptyOrWhitespace(user.getNickname())) {
?? ??? ??? ?criteria.andLike("nickname", "%" + user.getNickname() + "%");

?? ??? ?}
?? ??? ?example.orderBy("registTime").desc();
?? ??? ?List<SysUser> userList = userMapper.selectByExample(example);
?? ??? ?return userList;
?? ?}

?? ?@Override
?? ?public SysUser queryUserByIdCustom(String userId) {
?? ??? ?List<SysUser> userList = userMapperCustom.queryUserSimplyInfoById(userId);

?? ??? ?if (userList != null && !userList.isEmpty()) {
?? ??? ??? ?return (SysUser) userList.get(0);
?? ??? ?}

?? ??? ?return null;
?? ?}

?? ?@Override
?? ?public void saveUserTransactional(SysUser user) {
?? ??? ?userMapper.insert(user);

?? ??? ?int a = 1 / 0;

?? ??? ?user.setIsDelete(1);
?? ??? ?userMapper.updateByPrimaryKeySelective(user);

?? ?}

}