Mybatis 中获得 connection

转：

Mybatis 中获得 connection

2012年07月30日 19:02:21 dqsweet 阅读数：13861

 

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. 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");

转载于:https://www.cnblogs.com/libin6505/p/10757303.html