Mybatis (plus 也适用)原生直接执行某句SQL_mybatis plus 直接执行sql

场景

想要不论传入什么sql 都能直接执行

示例

    @Autowired
    private SqlSessionTemplate sqlSessionTemplate;

    public void executeSql(String replaceSql) {
        if (StringUtils.isEmpty(replaceSql)) {
            return;
        }
        try {
            SqlSession sqlSession = sqlSessionTemplate.getSqlSessionFactory().openSession();
            sqlSession.getConnection().prepareStatement(replaceSql).execute(replaceSql);
            sqlSession.commit();
            sqlSession.close();
        } catch (SQLException e) {
            log.error("异常:" ,e);
        }
    }

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17