Java如何使用 JDBC 执行 SQL Delete删除操作
之路 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