Mybatis 中获得 connection

@Autowired  
    private SqlSession sqlSession; 


    public Connection getConnection(){  
            Connection conn = null;  
            try {  
                conn =  sqlSession.getConfiguration().getEnvironment().getDataSource().getConnection();  
                logger.info("===This Connection isClosed ? "+conn.isClosed());  
            } catch (Exception e) {  
                e.printStackTrace();  
            }  
            return conn;  
        }  

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


posted on 2012-07-30 19:02  dqsweet  阅读(506)  评论(0编辑  收藏  举报

导航