java 連接配接oracle 進行增删改查

1、在DAO層新增類OraclePersionDao

package com.test.dao;

import java.sql.*;

/**
 * Created by wdw on 2017/9/16.
 */
public class OraclePersionDao {

    // 資料庫驅動類
    private String dbDriver = "oracle.jdbc.driver.OracleDriver";
    // 連接配接資料庫url
    private String dbURL = "jdbc:oracle:thin:@192.168.31.128:1521:orcl";
    // 連接配接資料庫使用者名
    private String dbUser = "PHIP";
    // 連接配接資料庫密碼
    private String dbPwd = "PHIP";
    // 擷取資料庫連接配接方法, 傳回Connection對象
    private Connection con = null;
    //資料執行語句
    private Statement stat = null;
    private String sql = null;
    private ResultSet rs = null;

    //建立資料庫連接配接
    public Connection getDBConnect() {
        try {
// 加載資料庫驅動
            Class.forName(dbDriver);
            con = DriverManager.getConnection(dbURL, dbUser, dbPwd);
        } catch (Exception e) {
            System.out.println(e);
        }
        return con;
    }

    //增加
    public void Add() {
        con = getDBConnect();
        sql = "insert into sys_users(id,code,name)" +
                "values('1','lucy','w')";
        try {
            stat = con.createStatement();
            stat.executeUpdate(sql);
        }
        catch (SQLException e) {
// TODO Auto-generated catch block
            e.printStackTrace();
        }
    }

    //删除
    public void Delete() {
        con = getDBConnect();
        sql = "delete  from sys_users " +
                "where ID=1";
        try {
            stat = con.createStatement();
            stat.executeUpdate(sql);
        } catch (SQLException e) {
// TODO Auto-generated catch block
            e.printStackTrace();
        }

    }

    //修改
    public void Update() {
        con = getDBConnect();
        sql = "update sys_users set code='c2' where id='1'";
        try {
            stat = con.createStatement();
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }

    //查詢
    public void Search() {
        con = getDBConnect();
// 建立表的sql語句
        sql = "SELECT * FROM sys_users";
        try {
            stat = con.createStatement();
            rs = stat.executeQuery(sql);
            while (rs.next()) {
                String id = rs.getString(1);
                String stuname = rs.getString(2);
                String stusex = rs.getString(3);
                System.out.println(id + "," + stuname + "," + stusex);
            }
        } catch (SQLException e) {
// TODO Auto-generated catch block
            e.printStackTrace();
        }
    }
//功能:關閉資料庫的連接配接

    public void close() {//6.釋放資源
        try { // 捕捉異常
            try {
                if (rs != null) { // 當ResultSet對象的執行個體rs不為空時

                    rs.close(); // 關閉ResultSet對象
                }
            } finally {
                try {
                    if (stat != null) { // 當Statement對象的執行個體stmt不為空時

                        stat.close(); // 關閉Statement對象
                    }
                } finally {
                    if (con != null) { // 當Connection對象的執行個體conn不為空時
                        con.close(); // 關閉Connection對象
                    }
                }
            }
        } catch (Exception e) {
            e.printStackTrace(System.err); // 輸出異常資訊
        }
    }

}      

View Code

2、main

private static void MySqlOperator() {
           
        OraclePersionDao oracl = new OraclePersionDao();

        oracl.Add();
        oracl.Search();
        oracl.Update();
        oracl.Delete();

    }      

View Code

3、增加oracle驅動到本項目

找到安裝oracle的目錄x:\oracle\product\10.2.0\db_1\jdbc\lib\ojdbc14.jar  (注，不同版本會有不同名稱）

複制該檔案，點選WEB-INFO，Ctrl+v粘貼檔案，點OKOKOK

右鍵粘貼的檔案，Add  as library 一直點OK。，

3、測試