BowenXu11的博客

java 数据源连接池C3P01.jar包c3p0https://mvnrepository.com/artifact/com.mchange/c3p0/0.9.5.5依赖com.mchange » mchange-commons-java2.配置文件xml<c3p0-config> <default-config> <property name="driverClass">com.mysql.jdbc.Driver</pro

dbcp2.01.导入jar包dbcp2-2.7.0https://mvnrepository.com/artifact/org.apache.commons/commons-dbcp2/2.7.0依赖commons-logging » commons-loggingorg.apache.commons » commons-pool22.dbcp.properties配置文件########DBCP配置文件###########驱动名driverClassName=com.mysql.

JDBC提交事务关键点connection.setAutoCommit(false);关闭自动提交，开启事务connection.commit(); 事务完毕，提交事务package com.myweb.lesson04;import com.myweb.lesson02.utils.JdbcUtils;import java.sql.Connection;import java.sql.PreparedStatement;import java.sql.SQLException;p

JDBC 之prepareStatement 执行CRUD增加package com.myweb.lesson03;import com.myweb.lesson02.utils.JdbcUtils;import java.sql.Connection;import java.sql.PreparedStatement;import java.sql.SQLException;public class TestInsert { public static void main(St

jdbc 之使用statement对象CRUD增加package com.myweb.lesson02;import com.myweb.lesson02.utils.JdbcUtils;import java.sql.Connection;import java.sql.SQLException;import java.sql.Statement;public class TestInsert { public static void main(String[] args)

封装JDBC工具类Db.propertiesproperties放在src目录下，反射可以直接读取driver=com.mysql.jdbc.Driverurl ="jdbc:mysql://localhost:8889/jdbcstudy?userUnicode=true&characterEncoding=utf8&useSSL=true"name = "root"password ="root"jdbc工具类package com.myweb.lesson02.uti

JDBC第一课第一个JDBC项目准备工作，创建一个数据库CREATE DATABASE jdbcStudy CHARACTER SET utf8 COLLATE utf8_general_ci;USE jdbcStudy;CREATE TABLE `users`(id INT PRIMARY KEY,NAME VARCHAR(40),PASSWORD VARCHAR(40),email VARCHAR(60),birthday DATE);INSERT INTO `users`