动力节点笔记
- import java.sql.*;
- import java.text.*;
- import java.util.*;
- //采用PreparedStatement删除数据
- public class DeleteTest02 {
- public static void main(String[] args) {
- if (args.length != 1) {
- throw new IllegalArgumentException("参数非法,正确使用为InsertTest01 ...");
- }
- Connection conn = null;
- PreparedStatement pstmt = null;
- try {
- //第一步,加载数据库驱动,不同的数据库驱动程序不一样
- Class.forName("oracle.jdbc.driver.OracleDriver");
- //第二部,得到数据库连接
- String dburl = "jdbc:oracle:thin:@localhost:1521:orcl";
- //String dburl = "jdbc:oracle:thin:@192.168.21.1:1521:orcl";
- //String dburl = "jdbc:oracle:thin:@127.0.0.1:1521:orcl";
- String userName = "system";
- String password = "wanwan";
- conn = DriverManager.getConnection(dburl, userName, password);
- //System.out.println(conn);
- //取得输入参数
- int empno = Integer.parseInt(args[0]);
- //第三步,创建Statement,执行SQL语句
- //采用占位符的方式
- //最好将比较复杂的sql调通,再将sql语句和程序相结合,进行连调
- String sql = "delete from enp where empno = ?";
- pstmt = conn.prepareStatement(sql);
- //为占位符赋值
- pstmt.setInt(1, empno);
- pstmt.executeUpdate();
- System.out.println("删除员工成功, 员工编号:【"+ empno +"】");
- } catch (ClassNotFoundException e) {
- e.printStackTrace();
- } catch (SQLException e) {
- e.printStackTrace();
- } finally {
- //注意关闭原则:从里到外
- try {
- if (pstmt != null) {
- pstmt.close();
- }
- if (conn != null) {
- conn.close();
- }
- } catch(SQLException e) {
- }
- }
- }
- }