JDBCDruidUtils工具类使用

JDBCDruidUtils工具类使用

JDBCDruidUtils工具类：☞点此进入

public class DruidDemo {
    public static void main(String[] args) {
        Connection conn = null;
        PreparedStatement pstmt = null;
        try {
            //调用JDBCDruidUtils工具类获取连接对象
            conn = JDBCDruidUtils.getConnection();
            //创建sql语句
            String sql = "insert into account values(null,?,?)";
            //获取执行预编译sql的对象
            pstmt = conn.prepareStatement(sql);
            //给?赋值
            pstmt.setString(1, "coco");
            pstmt.setDouble(2, 10000000);
            //执行sql
            int count = pstmt.executeUpdate();
            //查看几条记录有变动
            System.out.println(count);
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            //释放(归还)资源
            JDBCDruidUtils.close(pstmt, conn);
        }
    }
}