首页 > 代码库 > Java连接Oracle

Java连接Oracle

import java.sql.Connection;import java.sql.DriverManager;import java.sql.SQLException;import java.sql.ResultSet;import java.sql.Statement;public class DB {    private static Connection con = null;    private static Statement sql = null;    private static ResultSet rs = null;    public static void main(String[] args) throws SQLException {       int no;       String dep;       String sal;       try {           con = dbConn("snpw1", "welcome1");           if (con == null) {              System.out.print("连接失败");              System.exit(0);           }           sql = con.createStatement();           rs = sql.executeQuery("select empid, deptid, salary from oracle_employee");           System.out.println("工号" + "            " + "部门号" + "             "+ "薪水");           while (rs.next()) {              no = rs.getInt(1);              dep = rs.getString(2);              sal = rs.getString(3);              System.out.println(no + "         " + dep + "         " + sal);           }       } catch (Exception e) {           e.printStackTrace();        } finally {           con.close();       }    }    public static Connection dbConn(String name, String pass) {        Connection c = null;        try {            Class.forName("oracle.jdbc.driver.OracleDriver");        } catch (ClassNotFoundException e) {            e.printStackTrace();        }        try {            c = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl", name, pass);        } catch (SQLException e) {            e.printStackTrace();        }        return c;     }}

注意:要导入JDBC驱动,鼠标右键JRE System Libray->Build Path->Configure Build Path->Add External JARs,然后选择要导入的JDBC驱动包就可以了。

Java连接Oracle