public class ExcuteSql{
@Resource
private SqlSessionTemplate sqlSessionTemplate;
public boolean excute(String sql) {
SqlSession sqlSession = sqlSessionTemplate.getSqlSessionFactory().openSession(ExecutorType.SIMPLE, false);
Configuration configuration = sqlSessionTemplate.getSqlSessionFactory().getConfiguration();
try {
String sqlUuid = UUID.fastUUID().toString(true);
RawSqlSource rawSqlSource = new RawSqlSource(configuration, sql, Object.class);
MappedStatement.Builder builder = new MappedStatement.Builder(configuration, sqlUuid, rawSqlSource, SqlCommandType.INSERT);
MappedStatement mappedStatement = builder.build();
configuration.addMappedStatement(mappedStatement);
sqlSession.insert(sqlUuid);
} catch (Exception e) {
throw e;
} finally {
if (sqlSession != null) {
sqlSession.close();
}
}
}
}
mybatis使用sqlSessionTemplate执行sql
最新推荐文章于 2024-06-18 15:44:14 发布