import java.sql.*;
/**
* @author zzw
* @create 2020/11/05-16:51
*/
public class JDBCtest02 {
public static void main(String[] args) {
Connection conn=null;
Statement stmt=null;
try {
//1.注册驱动
DriverManager.registerDriver(new com.mysql.jdbc.Driver());
//2.获取连接
conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/jdbc","root","a");
//3.获取数据库操作对象
stmt=conn.createStatement();
//4.执行sql语句
//jdbc中的sql语句不需要写分号
//String sql="delete from jdbc01 where 语文=0";
String sql="update jdbc01 set 语文='1',数学='1' where 英语='0'";
int count=stmt.executeUpdate(sql);
System.out.println(count==1?"删除成功":"删除失败");
}catch (SQLException e){
e.printStackTrace();
}finally {
//6.释放资源
if (stmt != null) {
try {
stmt.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if (conn != null) {
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}
}
JDBC学习----JDBC执行删除和更新
最新推荐文章于 2022-09-09 16:05:24 发布