首页 > 代码库 > 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
声明:以上内容来自用户投稿及互联网公开渠道收集整理发布,本网站不拥有所有权,未作人工编辑处理,也不承担相关法律责任,若内容有误或涉及侵权可进行投诉: 投诉/举报 工作人员会在5个工作日内联系你,一经查实,本站将立刻删除涉嫌侵权内容。