content: package com.alibaba.druid.pool.mysql;
  
  import com.alibaba.druid.pool.DruidDataSource;
  import junit.framework.TestCase;
  import org.junit.Assert;
  
  import java.sql.Connection;
  import java.sql.ResultSet;
  import java.sql.Statement;
  
  /**
   * Created by wenshao on 16/8/5.
   */
  public class MySqlTest extends TestCase {
      private DruidDataSource dataSource;
  
      protected void setUp() throws Exception {
          dataSource = new DruidDataSource();
          dataSource.setUrl("jdbc:mysql://127.0.0.1:3306/druid_test_db?allowMultiQueries=true");
          dataSource.setUsername("druid_test");
          dataSource.setPassword("druid_test");
          dataSource.setFilters("log4j");
          dataSource.setValidationQuery("SELECT 1");
          dataSource.setTestOnBorrow(true);
          dataSource.setTestWhileIdle(true);
      }
  
      protected void tearDown() throws Exception {
          dataSource.close();
      }
  
      public void test_mysql() throws Exception {
          Connection connection = dataSource.getConnection();
  
          System.out.println("----------- : " + connection.unwrap(Connection.class).getClass());
  
          Statement stmt = connection.createStatement();
          stmt.execute("select 1;select 1");
  
          ResultSet rs = stmt.getResultSet();
          Assert.assertFalse(rs.isClosed());
  
          Assert.assertTrue(stmt.getMoreResults());
          Assert.assertTrue(rs.isClosed());
  
          ResultSet rs2 = stmt.getResultSet();
          Assert.assertFalse(rs2.isClosed());
          rs2.close();
          Assert.assertTrue(rs2.isClosed());
  
          stmt.close();
  
          connection.close();
      }
  }
  