java 串連oracle 進行增刪改查

標籤：建表   輸出   out   建立資料庫   try   異常   exception   drive   result   

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、測試

 

java 串連oracle 進行增刪改查