Java连接Oracle数据库的简单示例

Java连接Oracle数据库的简单示例

Oracle JDBC Drivers下载地址：http://www.oracle.com/technetwork/database/features/jdbc/index-091264.html

1. 右键项目 –> 属性 –> Java Build Path –> Libraries –> Add External JARS，然后选择自己下载的JDBC驱动即可。

2. 以下为示例代码：

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

public class DataReaderThread extends Thread {

    @Override
    public void run(){
        //System.out.println("Begin to read <foo_table> records...");

        Connection conn = null;
        PreparedStatement statement = null;
        ResultSet result = null;
        try{
            Class.forName("oracle.jdbc.driver.OracleDriver");
            System.out.println("开始尝试连接数据库...");
            String url = "jdbc:oracle:thin:@localhost:1521:TMPord";
            String user = "TMPord";
            String password = "TMPord";
            conn = DriverManager.getConnection(url, user, password);
            System.out.println("数据库连接成功！");

            StringBuilder sql = new StringBuilder();
            sql.append("select * from foo_table LIMIT 1,50");
            statement = conn.prepareStatement(sql.toString());
            result = statement.executeQuery();
            int i = 0;
            while(result.next()){
                System.out.println(i + result.toString());
                i++;
            }
        }catch(Exception e){
            e.printStackTrace();
        }finally{
            try{
                if(result != null){
                    result.close();
                }

                if(statement != null){
                    statement.close();
                }

                if(conn != null){
                    conn.close();
                }
            }catch(Exception e){
                e.printStackTrace();
            }
        }
    }
}