转：

Mybatis 中获得 connection

1. @Autowired
2. private SqlSession sqlSession;

1. public Connection getConnection(){
2. Connection conn = null;
3. try {
4. conn = sqlSession.getConfiguration().getEnvironment().getDataSource().getConnection();
5. logger.info( "===This Connection isClosed ? "+conn.isClosed());
6. } catch (Exception e) {
7. e.printStackTrace();
8. }
9. return conn;
10. }

1. String resource = "SqlMap.xml"; Reader reader = Resources.getResourceAsReader(resource);
2. SqlMapClient sqlMap = SqlMapClientBuilder.buildSqlMapClient(reader);
3. Connection db = sqlMap.getDataSource().getConnection();
4. Statement st = db.createStatement();
5. ResultSet rs = st.executeQuery( "show tables");

扫码关注我们

微信号：SRE实战

拒绝背锅 运筹帷幄

×

选择打赏方式：

微信 QQ钱包 支付宝

打赏

打赏

打赏

多少都是心意！谢谢大家！！！