/** * 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; } }