DbUtil.java'
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
public class DbUtil {
public static Connection getConnection() throws Exception {
Connection con = null;
try {
Class.forName("com.mysql.jdbc.Driver");
String url = "jdbc:mysql://localhost:3306/db_book";
con = DriverManager.getConnection(url, "root", "123456");
} catch (Exception e) {
e.printStackTrace();
}
return con;
}
public static void close(Connection con,Statement stat){
try {
stat.close();
} catch (SQLException e) {
e.printStackTrace();
}
try {
con.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
DataDelete.java
import java.sql.Connection;
import java.sql.Statement;
public class DataDelete {
private static void delete(int id) throws Exception {
Connection con = null;
Statement stat = null;
try {
con = DbUtil.getConnection();
stat = con.createStatement();
String sql = "delete from t_user where id="+id;
stat.executeUpdate(sql);
} catch (Exception e) {
e.printStackTrace();
} finally {
DbUtil.close(con, stat);
}
}
public static void main(String[] args) throws Exception {
delete(5);
}
}
数据删除之前
数据删除之后