动力节点笔记
- import java.sql.*;
- //采用Statement删除数据
- public class DeleteTest01 {
- public static void main(String[] args) {
- if (args.length != 1) {
- throw new IllegalArgumentException("参数非法,正确使用为InsertTest01 值");
- }
- Connection conn = null;
- Statement stmt = 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 = " + empno;
- System.out.println("sql = " + sql);
- stmt = conn.createStatement();
- stmt.executeUpdate(sql);
- System.out.println("删除员工成功, 员工代码:【" + empno +"】");
- } catch (ClassNotFoundException e) {
- e.printStackTrace();
- } catch (SQLException e) {
- e.printStackTrace();
- } finally {
- //注意关闭原则:从里到外
- try {
- if (stmt != null) {
- stmt.close();
- }
- if (conn != null) {
- conn.close();
- }
- } catch(SQLException e) {
- }
- }
- }
- }
- /*
- 注意在pl/sql developer中,修改数据后要commit后,在其他终端下才能对相应的记录操作
- */
转载于:https://blog.51cto.com/6636785/1183717