com.baomidou.mybatisplus.test.mysql.LogicDeleteTest.java Source code

Java tutorial

Introduction

Here is the source code for com.baomidou.mybatisplus.test.mysql.LogicDeleteTest.java

Source

/**
 * Copyright (c) 2011-2014, hubin (jobob@qq.com).
 * <p>
 * Licensed under the Apache License, Version 2.0 (the "License"); you may not
 * use this file except in compliance with the License. You may obtain a copy of
 * the License at
 * <p>
 * http://www.apache.org/licenses/LICENSE-2.0
 * <p>
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS, WITHOUT
 * WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the
 * License for the specific language governing permissions and limitations under
 * the License.
 */
package com.baomidou.mybatisplus.test.mysql;

import java.io.InputStream;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;

import com.baomidou.mybatisplus.MybatisSessionFactoryBuilder;
import com.baomidou.mybatisplus.entity.GlobalConfiguration;
import com.baomidou.mybatisplus.mapper.LogicSqlInjector;
import com.baomidou.mybatisplus.test.mysql.entity.User;
import com.baomidou.mybatisplus.test.mysql.mapper.UserMapper;
import com.baomidou.mybatisplus.toolkit.IdWorker;

/**
 * <p>
 * 
 * </p>
 *
 * @author hubin
 * @date 2017-09-09
 */
public class LogicDeleteTest {

    public static void main(String[] args) {
        // ?
        InputStream in = UserMapperTest.class.getClassLoader().getResourceAsStream("mysql-config.xml");
        MybatisSessionFactoryBuilder mf = new MybatisSessionFactoryBuilder();
        GlobalConfiguration gc = new GlobalConfiguration(new LogicSqlInjector());// ?
        gc.setLogicDeleteValue("-1");//  -1  type
        mf.setGlobalConfig(gc);
        SqlSessionFactory sessionFactory = mf.build(in);
        SqlSession session = sessionFactory.openSession();
        UserMapper userMapper = session.getMapper(UserMapper.class);
        System.err.println(" debug run  user ??? ");
        long id = IdWorker.getId();
        int rlt = userMapper.insert(new User(id, "logic-delete-1", 18, 1));
        System.err.println("??" + rlt);
        rlt = userMapper.deleteById(id);
        System.err.println("? ID ?" + rlt);
        User user = userMapper.selectById(id);
        System.out.println("" + user.getTestType());

        User uu = new User();
        uu.setId(user.getId());
        uu.setTestType(1);
        rlt = userMapper.updateById(user);
        System.err.println("testType  1 ?" + rlt);
        rlt = userMapper.insert(new User(IdWorker.getId(), "logic-delete-2", 28, 2));
        System.err.println("????" + rlt);
        rlt = userMapper.delete(null);
        System.err.println("?" + rlt);
        List<User> userList = userMapper.selectList(null);
        for (User u : userList) {
            System.out.println(" ( id= " + u.getId() + " ) " + u.getTestType());
        }

        rlt = userMapper.updateById(uu);
        System.err.println("testType  1 ?" + rlt);
        Map<String, Object> map = new HashMap<>();
        map.put("test_id", id);
        rlt = userMapper.deleteByMap(map);
        System.err.println(" ByMap ?" + rlt);
        userList = userMapper.selectList(null);
        for (User u : userList) {
            System.out.println(" ( id= " + u.getId() + " ) " + u.getTestType());
        }
    }
}