MySql驱动(jar包)下载:https://pan.baidu.com/s/19BYnGbO3l5MOOic5K4Ooaw 密码:mwoh
第三方插件(commons-dbutils)下载:https://pan.baidu.com/s/17cyAXHZLgiayx5Y_VHvawQ 密码:6om2
连接池DBCP下载(jar包):https://pan.baidu.com/s/1U3dGaAb26yUMTr4NI3HF3g 密码:40z1参考:https://blog.csdn.net/houyanhua1/article/details/80785743
TestDBCP.java(测试类):
package cn.xxx.jdbc.test;
import java.sql.Connection;
import java.sql.PreparedStatement;
import cn.xxx.jdbc.utils.DBCPUtils; // 自定义的连接池工具类
public class TestDBCP {
public static void main(String[] args) {
Connection conn = null;
PreparedStatement pstmt = null;
try {
conn = DBCPUtils.getConnection(); // 通过工具类获取数据库连接
String sql ="update tbl_user set upassword=? where uid=?";
pstmt= conn.prepareStatement(sql);
pstmt.setString(1, "张三");
pstmt.setInt(2, 20);
int rows = pstmt.executeUpdate();
if(rows>0){
System.out.println("更新成功!");
}else{
System.out.println("更新失败!");
}
} catch (Exception e) {
throw new RuntimeException(e);
}
}
}
DBCPUtils(DBCP连接池工具类):
package cn.xxx.jdbc.utils;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.SQLException;
import java.util.Properties;
import javax.sql.DataSource;
import org.apache.commons.dbcp.BasicDataSourceFactory;
public class DBCPUtils {
private static DataSource dataSource;
static{
try {
//1.加载找properties文件输入流。 配置文件(db.properties)在src目录下
InputStream is = DBCPUtils.class.getClassLoader().getResourceAsStream("db.properties");
Properties props = new Properties();
props.load(is); // 配置信息加载到Properties集合中
dataSource = BasicDataSourceFactory.createDataSource(props); // 通过配置信息创建连接池对象
} catch (Exception e) {
throw new RuntimeException(e);
}
}
public static DataSource getDataSource(){
return dataSource;
}
public static Connection getConnection(){
try {
return dataSource.getConnection(); // 获取数据库连接对象
} catch (SQLException e) {
throw new RuntimeException(e);
}
}
}
db.properties(src目录下的配置文件):
driver=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost:3306/web08?useUnicode=true&characterEncoding=utf8
username=root
password=123