public class Jdbc { public static void main(String[] args) throws Exception { // 注册驱动 Class.forName("com.mysql.cj.jdbc.Driver"); // 获取连接 String url = "jdbc:mysql://localhost:3306/itcast"; String username = "root"; String password = ""; Connection con = DriverManager.getConnection(url, username, password); // 定义sql String sql = "update account set money = money + 1000 where id = 1;"; // 获取sql执行的对象 Statement Statement st = con.createStatement(); int i = st.executeUpdate(sql); //处理结果 System.out.println(i); // 释放资源 st.close(); con.close(); } }
06-02