//注册驱动
Class.forName("com.mysql.jdbc.Driver");
//获取链接
String url = "jdbc:mysql://127.0.0.1:3306/itheima?useUnicode=true&characterEncoding=utf-8&useSSL=false&serverTimezone=GMT%2B8&allowPublicKeyRetrieval=true";
String uname = "root";
String pwd = "123456";
Connection conn = DriverManager.getConnection(url, uname, pwd);
//定义SQL语句
String sql = "update account set money = 1000 where id = 1";
//获取执行sql对象
Statement stmt = conn.createStatement();
//执行SQL
int i = stmt.executeUpdate(sql);
//处理返回结果
System.out.println(i);
//释放资源
stmt.close();
conn.close();
注意:在获取mysql数据库的链接地址时,传入的URL:
jdbc:mysql://127.0.0.1:3306/数据库名?useUnicode=true&characterEncoding=utf-8&useSSL=false&serverTimezone=GMT%2B8&allowPublicKeyRetrieval=true
否则将会报错