JDBC连接oracle数据库代码

需先配置好数据库驱动百度云下载 密码：w2wi
封装一个连接Oracle数据库的类

package com.muzi.unit;import java.sql.Connection;import java.sql.DriverManager;import java.sql.SQLException;public class DButil {    public Connection getconn() {        try {            Class.forName("oracle.jdbc.driver.OracleDriver");// 加载Oracle驱动程序            String url = "jdbc:oracle:thin:@localhost:1521:orcl";// localhost是本机地址，可更改为IP地址            String user = "muzi";// 用户名,系统默认的账户名            String password = "123465";// 你安装时选设置的密码            Connection conn = DriverManager.getConnection(url, user, password);// 获取连接            return conn;        } catch (Exception e) {            e.printStackTrace();        }        return null;    }    public void closeConn(Connection conn) {        try {            if (conn != null) {                conn.close();            }        } catch (SQLException e) {            e.printStackTrace();        }    }}

使用实例（查询）
根据自己数据库表更改

package com.muzi.dao;import java.sql.Connection;import java.sql.DriverManager;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.SQLException;import com.muzi.unit.DButil;public class UserDao {    public void getUserByUsername(String name) {        DButil util = new DButil();//new一个实例        Connection conn = util.getconn();        // sql?        String sql = "select * from users where u_name=?";//sql语句        try {            PreparedStatement pres = conn.prepareStatement(sql);//            pres.setString(1,"name");//参数            ResultSet res = pres.executeQuery();//获得结果集            while(res.next()) {                String id = res.getString("u_id");//u_id是数据库表列名                String username = res.getString("u_name");                String password = res.getString("u_pass");                System.out.println(id+username+password);//输出            }        } catch (SQLException e) {            e.printStackTrace();        }    }}

使用实例（更新数据）

package com.muzi.dao;import java.sql.Connection;import java.sql.PreparedStatement;import java.sql.SQLException;import com.muzi.unit.DButil;public class EditBrandDao {    public int editBrand() {        DButil util = new DButil();        Connection conn = util.getconn();        String sql = "update brand set b_name=?,b_phone=?,b_factory=? where b_id=?";        try {            PreparedStatement pres = conn.prepareStatement(sql);            pres.setString(1, "");            pres.setString(2, "");            pres.setString(3, "");            pres.setString(4, "");            int  res = pres.executeUpdate();            return res;        } catch (SQLException e) {            e.printStackTrace();        }        return 0;    }}