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驱动包就可以了。

郑重声明:本站内容如果来自互联网及其他传播媒体,其版权均属原媒体及文章作者所有。转载目的在于传递更多信息及用于网络分享,并不代表本站赞同其观点和对其真实性负责,也不构成任何其他建议。