之路 on it Road.com
Java 数据库删除操作示例:
package com.onitroad.jdbc.demo;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;
public class DeleteDataDemo {
public static void main(String[] args) {
Connection connection = null;
Statement stmt = null;
try
{
// 加载驱动
Class.forName("com.mysql.jdbc.Driver");
// 建立数据库连接
connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/JDBCDemo", "root", "password");
// 执行 SQL DELETE 查询
// 创建一个 Statement 对象,然后使用它的 execute() 方法
stmt = connection.createStatement();
stmt.execute("DELETE FROM POSTS WHERE ID = 100;");
}
catch (Exception e) {
e.printStackTrace();
}finally {
try {
stmt.close();
connection.close();
} catch (Exception e) {
e.printStackTrace();
}
}
}
}
日期:2020-09-17 00:09:49 来源:oir作者:oir
