import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;
/**
* JDBC快速入门
*/
public class JDBCQuickStart {
public static void main(String[] args) throws Exception {
// 1.注册驱动(mysql8.0)
// 可省略
// Class.forName("com.mysql.cj.jdbc.Driver");
// 2.获取连接
String url = "jdbc:mysql://127.0.0.1:3306/db1?serverTimezone=UTC&useSSL=false";
String name = "root";
String pwd = "123456";
Connection connection = DriverManager.getConnection(url, name, pwd);
// 3.定义语句
String sql = "update account set money = 400 where id = 1";
// 4.获取执行sql对象
Statement statement = connection.createStatement();
// 5.执行sql
int count = statement.executeUpdate(sql);
System.out.println(count);
// 6.释放资源
statement.close();
connection.close();
}
}
JDBC:JDBC快速入门
最新推荐文章于 2024-07-19 17:37:28 发布