package lesson15_jdbc;

import com.mchange.v2.c3p0.ComboPooledDataSource;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

public class C3P0_lianjiechi {
  public static void main(String[] args) {
    //使用自定义配置
    ComboPooledDataSource dataSource1=new ComboPooledDataSource();
    //使用自定义配置
    //ComboPooledDataSource dataSource2 = new ComboPooledDataSource("");
    //建立连接
    try{
      Connection conn = dataSource1.getConnection();
      String sql="select * from 1_mytable1";
      PreparedStatement pst=conn.prepareStatement(sql);
      ResultSet res = pst.executeQuery();
      while(res.next()){
        System.out.println(res.getString("n")+"->"+res.getString("age")+"->"+res.getString("gender"));
      }
      res.close();
      pst.close();
      conn.close();
    }catch (SQLException e){
      e.printStackTrace();
    }
  }
}

  
  
   
   com.MySQL.jdbc.Driver
   jdbc:mysql://127.0.0.1:3306/1_mydata
   root
   123456
  
   
   30000
   30
   10
   30
   100
   10
   200
   
  
  
  
  
   com.mysql.jdbc.Driver
   jdbc:mysql://127.0.0.1:3306/1_mydata
   root
   123456
   
   
   
   5
   20
   10
   40
   20
   5