~~~ package cn.itcast.datasource.druid; import com.alibaba.druid.pool.DruidDataSourceFactory; import javax.sql.DataSource; import java.io.IOException; import java.io.InputStream; import java.sql.Connection; import java.util.Properties; /** * @author: hcf * @qq: 46914685 * @email: 46914685@qq.com */ public class DruidDemo1 { public static void main(String[] args) throws Exception { //1.導入jar包 //2.定義配置文件 //3.加載配置文件 Properties pro = new Properties(); InputStream is = DruidDemo1.class.getClassLoader().getResourceAsStream("druid.properties"); pro.load(is); //4.獲取連接池對象 DataSource ds = DruidDataSourceFactory.createDataSource(pro); //5.獲取連接 Connection conn = ds.getConnection(); System.out.println(conn); } } ~~~ ***** ~~~ package cn.itcast.datasource.druid; /** * @author: hcf * @qq: 46914685 * @email: 46914685@qq.com */ import cn.itcast.datasource.utils.DruidUtils; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.SQLException; /** * 使用工具類 DruidUtils */ public class DruidDemo2 { public static void main(String[] args) { /** * 完成添加操作:給account表添加一條記錄 * */ Connection conn = null; PreparedStatement pstmt = null; try { //1.獲取連接 conn = DruidUtils.getConnection(); //2.定義sql String sql = "insert into account(name,balance) values(?,?)"; //3.獲取執行sql對象 pstmt = conn.prepareStatement(sql); //4.給?賦值 pstmt.setString(1, "喬峰"); pstmt.setDouble(2, 1856.56); //5.執行sql int count = pstmt.executeUpdate(); System.out.println(count); } catch (SQLException throwables) { throwables.printStackTrace(); } finally { //釋放資源 DruidUtils.close(pstmt, conn); } } } ~~~