package com.jdbc.study;
import java.sql.*;
public class Demo01 {
//mysql驱动包名
// private static final String DRIVER_NAME = "com.mysql.jdbc.Driver";
// 新版本驱动包用法
private static final String DRIVER_NAME = "com.mysql.cj.jdbc.Driver";
//数据库连接地址
private static final String URL = "jdbc:mysql:///test";
//用户名
private static final String USER_NAME = "root";
//密码
private static final String PASSWORD = "123456";
public static void main(String[] args) {
Connection connection = null;
try {
// 注册驱动jar包
Class.forName(DRIVER_NAME);
// 获取数据库连接对象
connection = DriverManager.getConnection(URL, USER_NAME, PASSWORD);
// 定义sql
String sql = "update users set balance=? where id=?";
// 获取执行sql语句的对象
PreparedStatement prst = connection.prepareStatement(sql);
prst.setInt(1, 555);
prst.setInt(2, 1);
// 执行sql, 接收返回结果
Integer count = prst.executeUpdate();
System.out.println(count);
// 资源释放
prst.close();
} catch (Exception e) {
e.printStackTrace();
} finally {
if (connection != null) {
try {
connection.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}
}
结果是不管运行多少次, 结果都是1
但其实影响行数为0
mysql5.7版本