import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; public class DeleteDate { private static String url = "jdbc:mysql://localhost:3306/easilyj"; // 数据库地址 private static String userName = "root"; // 数据库用户名 private static String passWord = "123456"; // 数据库密码 private static Connection conn = null; public static Connection getConnection() { if (null == conn) { try { // 加载驱动 Class.forName("com.mysql.jdbc.Driver"); // 创建数据库连接 conn = DriverManager.getConnection(url, userName, passWord); } catch (Exception e) { e.printStackTrace(); } } return conn; } public static void main(String[] args) { // 准备sql String sql = "delete from user where user_id = 2"; Connection conn = getConnection(); PreparedStatement pst = null; try { // 创建预编译语句 pst = conn.prepareStatement(sql); // 执行SQL pst.executeUpdate(); System.out.println("JDBC 删除成功"); // 关闭资源 pst.close(); conn.close(); } catch (SQLException e) { e.printStackTrace(); System.out.println("JDBC 删除失败"); } } }
运行结果:
JDBC 删除成功