修改
package cn.itcast.jdbc;
import java.sql.*;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;
public class JdbcDemo01 {
public static void main(String[] args) throws Exception {
//1.导入驱动jar包
Class.forName("com.mysql.cj.jdbc.Driver");
//2.获取数据库连接对象
Connection conn= DriverManager.getConnection("jdbc:mysql://localhost:3306/learn?&useSSL=false&serverTimezone=GMT","root","root");
//4.定义SQL语句
String sql="update account1 set balance=1000 where id=1 ";
//5.获取执行SQL的对象 Statement
Statement stmt=conn.createStatement();
//6.执行sql
int count=stmt.executeUpdate(sql);
//处理结果
System.out.println(count);
//8.释放资源
stmt.close();
conn.close();
}
}
添加
package cn.itcast.jdbc;
import java.sql.*;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
public class JDBCDemo02 {
public static void main(String[] args) {
Statement stmt=null;
Connection conn=null;
try {
Class.forName("com.mysql.cj.jdbc.Driver");
//定义sql
String sql="insert into account1 values(null,'wangwu',3000)";
//获取Connnection对象
conn= DriverManager.getConnection("jdbc:mysql://localhost:3306/learn?&useSSL=false&serverTimezone=GMT","root","root");
//获取执行SQL的对象Statement
stmt=conn.createStatement();
//执行sql
int count=stmt.executeUpdate(sql);//影响的行数
//处理结果
System.out.println(count);
if (count>0){
System.out.println("添加成功");
}else{
System.out.println("添加失败");
}
} catch (ClassNotFoundException | SQLException e) {
e.printStackTrace();
}finally {
//7.释放资源
//避免空指针异常
if (stmt!=null){
try {
stmt.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if (conn!=null){
try {
stmt.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}
}
修改(2)
package cn.itcast.jdbc;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
public class JDBCDemo03 {
public static void main(String[] args) {
Statement stmt=null;
Connection conn=null;
try {
Class.forName("com.mysql.cj.jdbc.Driver");
//定义sql
String sql="update account1 set balance=1500 where id=2";
//获取Connnection对象
conn= DriverManager.getConnection("jdbc:mysql://localhost:3306/learn?&useSSL=false&serverTimezone=GMT&allowPublicKeyRetrieval=true","root","root");
//获取执行SQL的对象Statement
stmt=conn.createStatement();
//执行sql
int count=stmt.executeUpdate(sql);//影响的行数
//处理结果
System.out.println(count);
if (count>0){
System.out.println("修改成功");
}else{
System.out.println("修改失败");
}
} catch (ClassNotFoundException | SQLException e) {
e.printStackTrace();
}finally {
//7.释放资源
//避免空指针异常
if (stmt!=null){
try {
stmt.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if (conn!&