第七色在线视频,2021少妇久久久久久久久久,亚洲欧洲精品成人久久av18,亚洲国产精品特色大片观看完整版,孙宇晨将参加特朗普的晚宴

頂頂頂頂

測試一下

嘻嘻嘻

框架結(jié)構(gòu)

特性

排除字段

流程

排除非表字段的三種方式

使用場景：實體類中的某個屬性不對應(yīng)表中的任何字段，只是用于保存臨時數(shù)據(jù)，或者臨時組裝的數(shù)據(jù)。

使用方式：

1、transient修飾實體類屬性（修飾的屬性不會被序列化）。

缺陷：有些需求需要序列化該字段。

2、static修飾屬性（Lombok對靜態(tài)屬性不會提供get、set方法）。

缺陷：每個對象的屬性值一致。

3、@TableField(exist=false)，這個注解用來表示數(shù)據(jù)表中不存在該字段，默認是true。

推薦使用第三種方式

Mybatis-Plus簡介

Mybatis增強工具，只做增強，不作改變，簡化開發(fā)，提高效率。

官網(wǎng)地址：https://mybatis.plus/

github項目地址：https://github.com/baomidou/mybatis-plus

碼云項目地址：https://gitee.com/baomidou/mybatis-plus

Mybatis-Plus特點：

1、無侵入（只做增強，不作改變）、損耗小（程序啟動時，進行注入增強的功能）、強大的CRUD操作（通用Service、通用Mapper，通過少量配置可實現(xiàn)單表操作，類似Hibernate）、支持條件構(gòu)造器，支持各類需求。

2、支持Lambda形式調(diào)用、提供了Lambda條件構(gòu)造器，支持多種數(shù)據(jù)庫（主流的Mysql、Oracle、SQL Server等）

3、支持主鍵生成策略、支持ActiveRecord模式（實體類只需要繼承Model，然后通過實體類完成CRUD操作）。

4、支持自定義全局通用操作（支持全局通用方法注入）、支持關(guān)鍵詞自動轉(zhuǎn)義（數(shù)據(jù)庫關(guān)鍵詞自動轉(zhuǎn)義）

5、內(nèi)置代碼生成器（實體、Mapper接口、Mapper.xml文件、Service、Controller）、內(nèi)置分頁插件（基于Mybatis的物理分頁）、內(nèi)置性能分析插件

6、內(nèi)置全局攔截插件（提供了全表的delete、update智能分析阻斷，也可以自定義攔截規(guī)則，以防誤操作）、內(nèi)置sql注入剝離器（支持sql注入剝離，有效防止注入攻擊）

public class ServiceTest{

@Autowired

private UserService userService;

@Test?

public void getOne(){

User one = userService.getOne(Wrappers.<User> lambdaQuery().gt(User::getAge. 25), false);

System.out.println(one);

}

? ? //批量插入

@Test?

public void batchInsert(){

User user1 = new User();

user1.setName("青山");

user1.setAge(20);

User user2 = new User();

user2.setName("綠水");

user2.setAge(21);

User user3 = new User();

user3.setName("小橋");

user3.setAge(22);

List<User> userList = Arrays.asList(user1, user2, user3);

boolean saveBatch = userService.saveBatch(userList);

System.out.println(saveBatch);

}

//批量插入

@Test?

public void batchInsertOrUpdate(){

//插入

User user1 = new User();

user1.setName("青山1");

user1.setAge(20);

? ? ? ? //插入

User user2 = new User();

user2.setName("綠水1");

user2.setAge(21);

? ? ? ? //更新

User user3 = new User();

? ? ? ? user3.setId(10004);

user3.setName("小橋");

user3.setAge(22);

List<User> userList = Arrays.asList(user1, user2, user3);

boolean saveBatch = userService.saveOrUpdateBatch(userList);

System.out.println(saveBatch);

}

? ? //查詢

@Test?

public void chain(){

List<User> userList = userService.lambdaQuery().gt(User::getAge, 25).like(User::getName, "雨").list();

userList.forEach(System.out::println);

}

? ??

? ? //更新

? ? @Test?

public void chain1(){

boolean update = userService.lambdaUpdate().eq(User::getAge, 25).set(User::getAge, 26).update();

System.out.println(update);

}

? ? //刪除

@Test?

public void chain2(){

boolean remove = userService.lambdaUpdate().eq(User::getAge, 25).remove();

System.out.println(remove);

}

}

/**

?* @date 2020年2月23日??

?* @author 翁東州

?* @所有方法的代碼點擊查看全文，整理了一整天累死了

?*/

package first;

import java.time.LocalDateTime;

import java.util.Arrays;

import java.util.HashMap;

import java.util.List;

import java.util.Map;

import org.junit.Assert;

import org.junit.Test;

import org.junit.runner.RunWith;

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

import org.springframework.boot.test.context.SpringBootTest;

import org.springframework.test.context.junit4.SpringRunner;

import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;

import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;

import com.baomidou.mybatisplus.core.conditions.update.LambdaUpdateWrapper;

import com.baomidou.mybatisplus.core.conditions.update.UpdateWrapper;

import com.baomidou.mybatisplus.core.metadata.IPage;

import com.baomidou.mybatisplus.core.toolkit.StringUtils;

import com.baomidou.mybatisplus.core.toolkit.Wrappers;

import com.baomidou.mybatisplus.extension.plugins.pagination.Page;

import com.baomidou.mybatisplus.extension.service.additional.query.impl.LambdaQueryChainWrapper;

import com.baomidou.mybatisplus.extension.service.additional.update.impl.LambdaUpdateChainWrapper;

import com.mp.dao.UserMapper;

import com.mp.entity.User;

import com.mp.service.UserService;

/**

?* @date 2020年2月23日??

?* @author 翁東州

?* @方法中文名稱:

?*/

@RunWith(SpringRunner.class)

@SpringBootTest

public class SimpleTest {

@Autowired

private UserMapper userMapper;

//展示所有

@Test

public void select() {

List<User> list = userMapper.selectList(null);

Assert.assertEquals(5, list.size());

list.forEach(System.out::println);

System.out.println();

}

//傳統(tǒng)添加

public void insert() {

User user = new User();

user.setName("名字");

user.setAge(31);

user.setManagerId(123L);

user.setCreateTime(LocalDateTime.now());

int rows = userMapper.insert(user);

System.out.println("影響記錄數(shù)"+rows);

}

//單體展示

public void selectById() {

User user = userMapper.selectById(123L);

System.out.println(user);

}

//多條展示

public void selectByIds() {

List<Long> idList = Arrays.asList(123L,234L,345L);

List<User> users = userMapper.selectBatchIds(idList);

users.forEach(System.out::println);

}

//map形式查詢

public void selectByMap() {

Map<String, Object> columnMap = new HashMap<>();

columnMap.put("name", "王天風");

columnMap.put("age", 25);

List<User> users = userMapper.selectByMap(columnMap);

users.forEach(System.out::println);

}

//wrapper 名字包含雨且年齡小于40

public void selectByWrapper() {?

QueryWrapper<User> queryWrapper = new QueryWrapper<User>();

queryWrapper.eq("name", "雨").lt("age", 40);

List<User> userList = userMapper.selectList(queryWrapper);

userList.forEach(System.out::println);

}

//wrapper 名字包含雨，且年齡在20到40之間,email不為空

public void selectByWrapper2() {?

QueryWrapper<User> queryWrapper = new QueryWrapper<User>();

queryWrapper.eq("name", "雨").between("age", 20, 40).isNotNull("email");

List<User> userList = userMapper.selectList(queryWrapper);

userList.forEach(System.out::println);

}

//wrapper 名字包含王，年齡大于等于25，按年齡降序排序，而后再按id升序排序

public void selectByWrapper3() {?

QueryWrapper<User> queryWrapper = new QueryWrapper<User>();

queryWrapper.likeRight("name", "王").or().ge("age", 25).orderByDesc("age").orderByAsc("id");

List<User> userList = userMapper.selectList(queryWrapper);

userList.forEach(System.out::println);

}

//創(chuàng)建日期為2019年2月14日且直屬上級名字為王姓

public void selectByWrapper4() {?

QueryWrapper<User> queryWrapper = new QueryWrapper<User>();

queryWrapper.apply("date_format(create_time,'%Y-%m-%d')={0}", "2019-02-14 or true or true")

.inSql("manager_id", "select id from user where name like '王%'");

List<User> userList = userMapper.selectList(queryWrapper);

userList.forEach(System.out::println);

}

//名字為王姓，并且(年齡小于40或郵箱不為空)

public void selectByWrapper5() {?

QueryWrapper<User> queryWrapper = new QueryWrapper<User>();

queryWrapper.likeRight("name", "王").and(wq -> wq.lt("age", 40).or().isNotNull("email"));

List<User> userList = userMapper.selectList(queryWrapper);

userList.forEach(System.out::println);

}

//名字為王姓，或者(年齡小于40并且年齡大于20并且郵箱不為空)

public void selectByWrapper6() {?

QueryWrapper<User> queryWrapper = new QueryWrapper<User>();

queryWrapper.likeRight("name", "王").or(wq -> wq.between("age", 20, 40).isNotNull("email"));

//queryWrapper.likeRight("name", "王").or(wq -> wq.lt("age", 40).gt("age", 20).isNotNull("email"));

List<User> userList = userMapper.selectList(queryWrapper);

userList.forEach(System.out::println);

}

//名字為王姓，并且(年齡小于40或郵箱不為空)

public void selectByWrapper7() {?

QueryWrapper<User> queryWrapper = new QueryWrapper<User>();

queryWrapper.nested(wq -> wq.lt("age", 40).or().isNotNull("email")).likeRight("name", "王");

//queryWrapper.likeRight("name", "王").and(wq -> wq.lt("age", 40).or().isNotNull("email"));

List<User> userList = userMapper.selectList(queryWrapper);

userList.forEach(System.out::println);

}

//年齡為30，31，34，35

public void selectByWrapper8() {?

QueryWrapper<User> queryWrapper = new QueryWrapper<User>();

queryWrapper.in("age", Arrays.asList(30,31,34,35));

List<User> userList = userMapper.selectList(queryWrapper);

userList.forEach(System.out::println);

}

//只返回滿足條件的其中一條語句即可

public void selectByWrapper9() {?

QueryWrapper<User> queryWrapper = new QueryWrapper<User>();

queryWrapper.in("age", Arrays.asList(30,31,34,35)).last("limit 1");

List<User> userList = userMapper.selectList(queryWrapper);

userList.forEach(System.out::println);

}

//名字中包含雨并且年齡小于40,只展示id和名字

public void selectByWrapperSupper() {?

QueryWrapper<User> queryWrapper = new QueryWrapper<User>();

queryWrapper.select("id","name").like("name", "雨").lt("age", 40);

List<User> userList = userMapper.selectList(queryWrapper);

userList.forEach(System.out::println);

}

//名字中包含雨并且年齡小于40,展示不包括創(chuàng)建字段和上級id字段的其他字段

public void selectByWrapperSupper2() {?

QueryWrapper<User> queryWrapper = new QueryWrapper<User>();

queryWrapper.like("name", "雨").lt("age", 40)

.select(User.class, info -> !info.getColumn().equals("create_time")

&&!info.getColumn().equals("manager_id"));

List<User> userList = userMapper.selectList(queryWrapper);

userList.forEach(System.out::println);

}

//測試condition

@Test

public void testCondition() {?

String name = "王";

String email = "";

condition1(name,email);

}

//名字中包含王,當email為空時不查詢

public void condition1(String name,String email) {?

QueryWrapper<User> queryWrapper = new QueryWrapper<User>();

//傳統(tǒng)方法

//if (StringUtils.isNotColumnName(name)) {

// queryWrapper.like("name", name);

//}

//if (StringUtils.isNotColumnName(email)) {

// queryWrapper.like("email", email);

//}

queryWrapper.like(StringUtils.isNotEmpty(name), "name",name)

.like(StringUtils.isNotEmpty(email), "email",email);

List<User> userList = userMapper.selectList(queryWrapper);

userList.forEach(System.out::println);

}

//查找姓名為劉紅雨且年齡32歲的數(shù)據(jù)

public void selectByWrapperEntity() {?

User whereUser = new User();

whereUser.setName("劉紅雨");

whereUser.setAge(32);

QueryWrapper<User> queryWrapper = new QueryWrapper<User>(whereUser);

List<User> userList = userMapper.selectList(queryWrapper);

userList.forEach(System.out::println);

}

//allEq

public void selectByWrapperAllEq() {?

QueryWrapper<User> queryWrapper = new QueryWrapper<User>();

Map<String, Object> params = new HashMap<String, Object>();

//姓名為王天風,年齡25

//params.put("name", "王天風");

//params.put("age", 25);

//queryWrapper.allEq(params);

//姓名為王天風,年齡為空則忽略

params.put("name", "王天風");

params.put("age", null);

//queryWrapper.allEq(params,false);

//剔除name查詢條件

queryWrapper.allEq((k,v)->!k.equals("name"), params);

List<User> userList = userMapper.selectList(queryWrapper);

userList.forEach(System.out::println);

}

//Map格式,查詢姓名包含雨，年齡小于40的數(shù)據(jù)

public void selectByWrapperMaps() {?

QueryWrapper<User> queryWrapper = new QueryWrapper<User>();

queryWrapper.like("name", "雨").lt("age", 40);

List<Map<String, Object>> userList = userMapper.selectMaps(queryWrapper);

userList.forEach(System.out::println);

}

//Map格式,按照直屬上級id分組，查詢每組的平均年齡，最大年齡，最小年齡，只去年齡總和小于500的組

public void selectByWrapperMaps2() {?

QueryWrapper<User> queryWrapper = new QueryWrapper<User>();

queryWrapper.select("avg(age) avg_age","min(age) min_age","max(age) max_age")

.groupBy("manager_id").having("sum(age)<{0}",500);

List<Map<String, Object>> userList = userMapper.selectMaps(queryWrapper);

userList.forEach(System.out::println);

}

//obj格式，查詢姓名包含雨，年齡小于40的數(shù)據(jù)

public void selectByWrapperobjs() {?

QueryWrapper<User> queryWrapper = new QueryWrapper<User>();

queryWrapper.select("id","name").like("name", "雨").lt("age", 40);

List<Object> userList = userMapper.selectObjs(queryWrapper);

userList.forEach(System.out::println);

}

//查詢姓名包含雨，年齡小于40的數(shù)據(jù)條數(shù)的總條數(shù)

public void selectByWrapperCount() {?

QueryWrapper<User> queryWrapper = new QueryWrapper<User>();

queryWrapper.like("name", "雨").lt("age", 40);

Integer count = userMapper.selectCount(queryWrapper);

System.out.println("總記錄數(shù)"+ count);

}

//查詢姓名包含雨，年齡小于40的數(shù)據(jù)條數(shù)的一條數(shù)據(jù)

public void selectByWrapperOne() {?

QueryWrapper<User> queryWrapper = new QueryWrapper<User>();

queryWrapper.like("name", "雨").lt("age", 40);

User user = userMapper.selectOne(queryWrapper);

System.out.println(user);

}

//lambda,三種起手

public void selectLambda() {?

//LambdaQueryWrapper<User> lambda = new QueryWrapper<User>().lambda();

//LambdaQueryWrapper<User> lambdaQueryWrapper = new LambdaQueryWrapper<User>();

LambdaQueryWrapper<User> lambdaQuery = Wrappers.<User>lambdaQuery();

lambdaQuery.like(User::getName, "雨").lt(User::getAge, 40);

List<User> userList = userMapper.selectList(lambdaQuery);

userList.forEach(System.out::println);

}

//lambda,名字為王姓，并且(年齡小于40或郵箱不為空)

public void selectLambda2() {?

LambdaQueryWrapper<User> lambdaQuery = Wrappers.<User>lambdaQuery();

lambdaQuery.likeRight(User::getName, "王")

.and(lqw ->lqw.lt(User::getAge, 40).or().isNotNull(User::getEmail));

List<User> userList = userMapper.selectList(lambdaQuery);

userList.forEach(System.out::println);

}

//lambda,名字為王姓，并且(年齡小于40或郵箱不為空)，LambdaQueryChainWrapper一氣呵成

public void selectLambda3() {?

List<User> userList = new LambdaQueryChainWrapper<User>(userMapper).like(User::getName, "雨").ge(User::getAge, 20).list();

userList.forEach(System.out::println);

}

//分頁

public void selectPage() {?

QueryWrapper<User> queryWrapper = new QueryWrapper<User>();

queryWrapper.ge("age", 26);

Page<User> page = new Page<User>(1,10);//1為第一頁，10為一頁10行

IPage<User> iPage = userMapper.selectPage(page, queryWrapper);

System.out.println("總頁數(shù)"+iPage.getPages());

System.out.println("總記錄數(shù)"+iPage.getTotal());

List<User> userList = iPage.getRecords();

userList.forEach(System.out::println);

}

//傳統(tǒng)根據(jù)id更新,根據(jù)id更新數(shù)據(jù)

public void updateById() {?

User user = new User();

user.setId(123L);

user.setAge(25);

user.setEmail("wtf2@baomidou.com");

int rows = userMapper.updateById(user);

System.out.println("影響記錄數(shù)"+ rows);

}

//傳統(tǒng)根據(jù)Wrapper更新，姓名為李藝偉且年齡為28的數(shù)據(jù)，更改其id，年齡和郵箱

public void updateByWrapper2() {?

UpdateWrapper<User> updateWrapper = new UpdateWrapper<User>();

updateWrapper.eq("name", "李藝偉").eq("age", 28);

User user = new User();

user.setId(123L);

user.setAge(25);

user.setEmail("wtf2@baomidou.com");

int rows = userMapper.update(user,updateWrapper);

System.out.println("影響記錄數(shù)"+ rows);

}

//Wrapper更新，姓名為李藝偉且年齡為29的數(shù)據(jù)，更改年齡為30

public void updateByWrapper3() {?

UpdateWrapper<User> updateWrapper = new UpdateWrapper<User>();

updateWrapper.eq("name", "李藝偉").eq("age", 29).set("age", 30);

int rows = userMapper.update(null,updateWrapper);

System.out.println("影響記錄數(shù)"+ rows);

}

//lambda的Wrapper更新，姓名為李藝偉且年齡為29的數(shù)據(jù)，更改年齡為30

public void updateByWrapperLambda() {?

LambdaUpdateWrapper<User> lambdaUpdate = Wrappers.<User>lambdaUpdate();

lambdaUpdate.eq(User::getName, "李藝偉").eq(User::getAge, 30).set(User::getAge, 31);

int rows = userMapper.update(null,lambdaUpdate);

System.out.println("影響記錄數(shù)"+ rows);

}

//lambda的Wrapper更新，姓名為李藝偉且年齡為29的數(shù)據(jù)，更改年齡為30,一氣呵成

public void updateByWrapperLambdaChain() {?

boolean update = new LambdaUpdateChainWrapper<User>(userMapper)

.eq(User::getName, "李藝偉").eq(User::getAge, 29).set(User::getAge, 31).update();

System.out.println(update);

}

//根據(jù)id刪除數(shù)據(jù)

public void deleteById() {

int rows = userMapper.deleteById(123L);

System.out.println("刪除條數(shù)"+rows);

}

//根據(jù)map中名稱為向后，年齡25刪除數(shù)據(jù)

public void deleteByMap() {

Map<String, Object> columnMap = new HashMap<>();

columnMap.put("name", "向后");

columnMap.put("age",25);

int rows = userMapper.deleteByMap(columnMap);

System.out.println("刪除條數(shù)"+rows);

}

//根據(jù)id刪除多條數(shù)據(jù)

public void deleteByBatchIds() {

int rows = userMapper.deleteBatchIds(Arrays.asList(123L,234L,345L));

System.out.println("刪除條數(shù)"+rows);

}

//根據(jù)wrapper刪除數(shù)據(jù)

public void deleteByWrapper() {

LambdaQueryWrapper<User> lambdaQueryWrapper = Wrappers.<User>lambdaQuery();

lambdaQueryWrapper.eq(User::getAge, 27).or().gt(User::getAge, 41);

int rows = userMapper.delete(lambdaQueryWrapper);

System.out.println("刪除條數(shù)"+rows);

}

//AR模式添加

public void insert2() {

User user = new User();

user.setName("劉華");

user.setAge(29);

user.setEmail("lh@baomidou.com");

user.setManagerId(123L);

user.setCreateTime(LocalDateTime.now());

boolean insert = user.insert();//類繼承Model

System.out.println(insert);

}

//AR模式查找

public void selectById2() {

User user = new User();

user.setId(123L);

User selectById = user.selectById();

System.out.println(selectById);

}

//AR模式更新

public void updateById2() {

User user = new User();

user.setId(123L);

user.setName("劉華");

user.setAge(29);

user.setEmail("lh@baomidou.com");

user.setManagerId(123L);

user.setCreateTime(LocalDateTime.now());

boolean updateById = user.updateById();//類繼承Model

System.out.println(updateById);

}

//AR模式添加或更新

public void insertOrUpdate() {

User user = new User();

user.setName("劉華");

user.setAge(29);

user.setEmail("lh@baomidou.com");

user.setManagerId(123L);

user.setCreateTime(LocalDateTime.now());

boolean insertOrUpdate = user.insertOrUpdate();//類繼承Model

System.out.println(insertOrUpdate);

}

@Autowired

private UserService userService;

//使用service，獲取一條數(shù)據(jù)

public void getOne() {

User one = userService.getOne(Wrappers.<User>lambdaQuery().gt(User::getAge, 25));//多條報錯

System.out.println(one);

}

//使用service，獲取一條數(shù)據(jù)

public void batch() {

User user1 = new User();

user1.setName("徐麗1");

user1.setAge(28);

User user2 = new User();

user2.setId(123L);

user2.setName("徐麗2");

user2.setAge(29);

List<User> users = Arrays.asList(user1,user2);

boolean saveBatch = userService.saveBatch(users);

//保存或更新

//userService.saveOrUpdateBatch(users);

System.out.println(saveBatch);

}

//使用service，lambda查詢年齡大于25且名字包含雨的數(shù)據(jù)，一氣呵成

public void chain1() {

List<User> users = userService.lambdaQuery().gt(User::getAge, 25).like(User::getName, "雨").list();

users.forEach(System.out::println);

}

//使用service，lambda更新年齡為25的數(shù)據(jù)為26，一氣呵成

public void chain2() {

boolean update = userService.lambdaUpdate().eq(User::getAge, 25).set(User::getAge, 26).update();

System.out.println(update);

}

//使用service，lambda刪除年齡為25的數(shù)據(jù)，一氣呵成

public void chain3() {

boolean remove = userService.lambdaUpdate().gt(User::getAge, 25).remove();

System.out.println(remove);

}

}

屬性配置

主鍵策略

1、MP支持的主鍵策略介紹

默認主鍵策略是基于雪花算法的自增ID

2、局部主鍵策略實現(xiàn)，IdType.class

定義六種：AUTO? NONE? INPUT(2)? ? ID_WORKER(3)-雪花算法? UUID(4)? ?ID_WORKER_STR(5)

@TableId(type=IdType.AUTO).......數(shù)據(jù)庫主鍵改成自增/或者非自增

@TableId(type=IdType.UUID)

private String id;

數(shù)據(jù)庫對應(yīng)改成varchar類型32

注意：主鍵類型和主鍵策略類型要一致，如果設(shè)定了主鍵，那么不會自動填充主鍵策略

3、全局主鍵策略實現(xiàn)全局策略配置，全局用UUID ，局部策略優(yōu)先于全局策略

屬性文件配置：mybatis-plus.global-config.db-config.id-type:uuid

public class MybatisplusInsertTest{

@Autowired

private UserMapper userMapper;

@Test

public void insert(){

//這里的id是自增的

//@TableId(type=IdType.AUTO)

User user = new User();

user.setName("長江水");

user.setAge(28);

user.setEmail("9834273096@qq.com");

user.setManagerId(1000002);

int insert = userMapper.insert(user);

System.out.println("insert = " + insert);

System.out.println("主鍵：" + user.getId());

}

? ??

? ? @Test

public void insert1(){

//這里的id是UUID

// @TableId(type=IdType.UUID)

User user = new User();

user.setName("大浪淘金");

user.setAge(28);

user.setEmail("9834273096@qq.com");

user.setManagerId(1000002);

int insert = userMapper.insert(user);

System.out.println("insert = " + insert);

System.out.println("主鍵：" + user.getId());

}

? ? ?@Test

public void insert2(){

//這里的id是基于雪花算法生成

//? @TableId(type=IdType.ID_WORKER_STR)

User user = new User();

user.setName("滔滔江水");

user.setAge(25);

user.setEmail("9234273096@qq.com");

user.setManagerId(1000002);

int insert = userMapper.insert(user);

System.out.println("insert = " + insert);

System.out.println("主鍵：" + user.getId());

}

}

public class MybatisplusARTest{

@Test

public void insert(){

User user = new User();

user.setName("一點紅");

user.setAge(27);

user.setEmail("877673096@qq.com");

user.setManagerId(1000001);

boolean insert = user.insert(user);

System.out.println("insert = " + insert);

}

@Test

public void selectById(){

User user = new User();

User userSelect = user.selectById(10005);

System.out.println(userSelect);

}

@Test

public void selectById2(){

User user = new User();

user.setId(10005);

User userSelect = user.selectById();

System.out.println(userSelect);

}

@Test

public void updateById(){

User user = new User();

user.setId(10005);

user.setName("雪花飄");

boolean userUpdate = user.updateById();

System.out.println(userUpdate);

}

@Test

public void deleteById(){

User user = new User();

user.setId(10005);

boolean userDelete = user.deleteById();

System.out.println(userDelete);

}

@Test

public void insertOrUpdate(){

User user = new User();

user.setName("花兒紅");

user.setAge(27);

user.setEmail("877673096@qq.com");

user.setManagerId(1000001);

? ? ? ? //如果不設(shè)置Id，就是insert，如果設(shè)置了Id，就會先查詢，存在就update，不存在就insert

boolean insertOrUpdate = user.insertOrUpdate();

System.out.println(insertOrUpdate);

}

}