Java链接oracle数据库

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.SQLException;

 

public class DBConnection {

    public static Connection dbConn(String name, String pass) {

       Connection c = null;

       try {

           Class.forName("oracle.jdbc.driver.OracleDriver");

           // 要是导入驱动没有成功的话都是会出现classnotfoundException.自己看看是不是哪里错了,例如classpath这些设置

       } catch (ClassNotFoundException e) {

           e.printStackTrace();

       }

       try {

           c = DriverManager.getConnection(

                  "jdbc:oracle:thin:@nx6330:1523:orcl", name, pass);

           // 连接数据的方法有四种, 这个属于最简单的,一般用网页程序

           // "jdbc:oracle:thin:@计算机名称:监听端口:系统实例名", username, password,

           // 计算机名称,要是自己不知道可以在计算机属性查知.

           // 监听端口一般默认是1521, 要是改变了就看自己的监听文件listener.ora

           // 系统实例名一般是默认orcl, 要是不是的话就用 select name from v$database; 看看当前的实例名.

           // username,password,就是登陆数据库的用户名和密码.

 

       } catch (SQLException e) {

           e.printStackTrace();

       }

       return c;

    }

}

 

 

 

 

 

import java.sql.Connection;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

 

public class DB extends DBConnection {

    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 name;

       String job;

       try {

           con = dbConn("scott", "tiger");

           if (con == null) {

              System.out.print("连接失败");

              System.exit(0);

           }

           sql = con.createStatement();

           rs = sql.executeQuery("select empno, ename, job from emp");

           System.out.println("工号" + "            " + "姓名" + "             "+ "工种");

           while (rs.next()) {

              no = rs.getInt(1);

              name = rs.getString(2);

              job = rs.getString(3);

              System.out.println(no + "         " + name + "         " + job);

           }

           // String url = "select empno from emp";

           // PreparedStatement pres = con.prepareStatement(url);

           // System.out.print(pres.executeUpdate());

       } catch (Exception e) {

           e.printStackTrace();

 

       } finally {

           con.close();

       }

    }

}