使用方法如下:

    1. import com.alex.orderapi.dao.entity.UserEntity;
    2. import com.alibaba.fastjson.JSON;
    3. import com.gitee.sunchenbin.mybatis.actable.command.BaseModel;
    4. import com.gitee.sunchenbin.mybatis.actable.command.PageResultCommand;
    5. import com.gitee.sunchenbin.mybatis.actable.manager.common.BaseCRUDManager;
    6. import org.springframework.beans.factory.annotation.Autowired;
    7. import org.springframework.web.bind.annotation.RequestMapping;
    8. import org.springframework.web.bind.annotation.RestController;
    9. import javax.servlet.http.HttpServletRequest;
    10. import java.util.Date;
    11. import java.util.LinkedHashMap;
    12. import java.util.List;
    13. @RestController
    14. public class MysqlController {
    15. @Autowired
    16. private BaseCRUDManager baseCRUDManager;
    17. @RequestMapping("/select/user")
    18. public String select(HttpServletRequest request) {
    19. Object sss1 = request.getSession().getAttribute("sss");
    20. request.getSession(true).setAttribute("sss","111");
    21. UserEntity insert = baseCRUDManager.insert(UserEntity.builder().loginName("111").build());
    22. UserEntity insertSelective = baseCRUDManager.insertSelective(UserEntity.builder().id(10000L).loginName("222").build());
    23. List<UserEntity> userEntities1 = baseCRUDManager.selectAll(UserEntity.class);
    24. boolean b = baseCRUDManager.updateByPrimaryKey(UserEntity.builder().id(10000L).mobile("1111").build());
    25. boolean b1 = baseCRUDManager.updateByPrimaryKeySelective(UserEntity.builder().id(2L).mobile("1111").build());
    26. UserEntity userEntity = baseCRUDManager.selectOne(UserEntity.builder().id(1L).mobile("1111").build());
    27. UserEntity userEntity1 = baseCRUDManager.selectByPrimaryKey(UserEntity.builder().id(8L).mobile("1111").build());
    28. List<UserEntity> select = baseCRUDManager.select(UserEntity.builder().mobile("1111").build());
    29. int i = baseCRUDManager.selectCount(UserEntity.builder().build());
    30. int sss = baseCRUDManager.delete(UserEntity.builder().realName("sss").build());
    31. int i1 = baseCRUDManager.deleteByPrimaryKey(UserEntity.builder().id(5L).loginName("222").build());
    32. boolean b2 = baseCRUDManager.existsByPrimaryKey(UserEntity.builder().id(1L).build());
    33. boolean b3 = baseCRUDManager.existsByPrimaryKey(UserEntity.builder().id(222L).build());
    34. UserEntity user = new UserEntity();
    35. user.setCurrentPage(1);
    36. user.setPageSize(5);
    37. LinkedHashMap<String, String> ordermap = new LinkedHashMap<>();
    38. ordermap.put("id",BaseModel.ASC);
    39. user.setOrderBy(ordermap);
    40. PageResultCommand<UserEntity> search = baseCRUDManager.search(user);
    41. user.setCurrentPage(2);
    42. PageResultCommand<UserEntity> search2 = baseCRUDManager.search(user);
    43. PageResultCommand<UserEntity> search3 = baseCRUDManager.search(user, 1, 5, ordermap);
    44. return "insert:" + JSON.toJSONString(insert) + "<p> insertSelective:" + JSON.toJSONString(insertSelective) + "<p> selectAll:" + JSON.toJSONString(userEntities1) + "<p> updateByPrimaryKey:" + b + "<p> updateByPrimaryKeySelective:" + b1 + "<p> selectOne:" + JSON.toJSONString(userEntity) + "<p> selectByPrimaryKey:" + JSON.toJSONString(userEntity1) + "<p> select:" + JSON.toJSONString(select) + "<p> selectCount:" + i + "<p> delete:" + sss + "<p> deleteByPrimaryKey:" + i1 + "<p> b2:" + b2 + "<p> b3:" + b3+ "<p> search:" + JSON.toJSONString(search)+ "<p> search2:" + JSON.toJSONString(search2)+ "<p> search3:" + JSON.toJSONString(search3);
    45. }
    46. }
    47. import com.gitee.sunchenbin.mybatis.actable.annotation.*;
    48. import com.gitee.sunchenbin.mybatis.actable.command.BaseModel;
    49. import lombok.AllArgsConstructor;
    50. import lombok.Builder;
    51. import lombok.NoArgsConstructor;
    52. import java.io.Serializable;
    53. import java.math.BigDecimal;
    54. import java.util.Date;
    55. @Builder
    56. @NoArgsConstructor
    57. @AllArgsConstructor
    58. @Table(name = "user_entity")
    59. public class UserEntity extends BaseModel implements Serializable {
    60. @IsKey
    61. @IsAutoIncrement
    62. private Long id;
    63. @Column
    64. @Index
    65. private String loginName;
    66. @Column
    67. private String nickName;
    68. @Column
    69. private String realName;
    70. @Column
    71. private String password;
    72. @Column
    73. private String mobile;
    74. @Column
    75. private Boolean isTrue;
    76. @Column
    77. private Integer it;
    78. @Column
    79. private BigDecimal decimalss;
    80. @Column
    81. private Date createTime;
    82. @Column
    83. private Date modifyTime;
    84. }