/** * Copyright (c) 2011-2020, hubin (jobob@qq.com). * * 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 * * http://www.apache.org/licenses/LICENSE-2.0 * * 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.mapper; import org.apache.ibatis.session.ExecutorType; import org.apache.ibatis.session.SqlSession; import com.baomidou.mybatisplus.entity.GlobalConfiguration; import com.baomidou.mybatisplus.entity.TableInfo; import com.baomidou.mybatisplus.exceptions.MybatisPlusException; import com.baomidou.mybatisplus.toolkit.TableInfoHelper; /** *

* SQL 辅助类 *

* * @author hubin * @Date 2016-11-06 */ public class SqlHelper { /** * 获取Session 默认自动提交 *

* 特别说明:这里获取SqlSession时这里虽然设置了自动提交但是如果事务托管了的话 是不起作用的 切记!! *

* * @return SqlSession */ public static SqlSession sqlSession(Class clazz) { return sqlSession(clazz, true); } /** *

* 批量操作 SqlSession *

* * @param clazz * 实体类 * @return SqlSession */ public static SqlSession sqlSessionBatch(Class clazz) { return GlobalConfiguration.currentSessionFactory(clazz).openSession(ExecutorType.BATCH, false); } /** *

* 获取Session *

* * @param clazz * 实体类 * @param autoCommit * true自动提交false则相反 * @return SqlSession */ public static SqlSession sqlSession(Class clazz, boolean autoCommit) { return GlobalConfiguration.currentSessionFactory(clazz).openSession(autoCommit); } /** * 获取TableInfo * * @return TableInfo */ public static TableInfo table(Class clazz) { TableInfo tableInfo = TableInfoHelper.getTableInfo(clazz); if (null == tableInfo) { throw new MybatisPlusException("Error: Cannot execute table Method, ClassGenricType not found ."); } return tableInfo; } /** *

* 判断数据库操作是否成功 *

* * @param result * 数据库操作返回影响条数 * @return boolean */ public static boolean retBool(int result) { return result >= 1; } }