package junbin.demo.tx;


import org.apache.commons.dbcp2.BasicDataSource;

import javax.naming.NamingException;
import javax.sql.DataSource;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

/**
 * Created by wujunbin on 6/12/17.
 */
public class Main {

    static String driver = "com.mysql.jdbc.Driver";
    static String url = "jdbc:mysql://localhost:3306/test";
    static String user = "root";
    static String password = "123456";

    public static void main(String[] args) throws ClassNotFoundException, SQLException, NamingException {
//        Class.forName(driver);
//        Connection conn = DriverManager.getConnection(url, user, password);
//        Statement statement = conn.createStatement();
//        ResultSet rs = statement.executeQuery("select * from `user`");
//        while (rs.next()) {
//            System.out.println(rs.getString("id"));
//        }
//        conn.close();
        // Construct BasicDataSource
        BasicDataSource bds = new BasicDataSource();
        bds.setDriverClassName(driver);
        bds.setUrl(url);
        bds.setUsername(user);
        bds.setPassword(password);
        DataSource ds = bds;
        Connection conn = ds.getConnection();
        Statement statement = conn.createStatement();
        ResultSet rs = statement.executeQuery("select * from `user`");
        while (rs.next()) {
            System.out.println(rs.getString("id"));
        }
        conn.close();

    }
}