使用java datasource 进行 oracle jdbc 连接

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Properties;
import oracle.jdbc.pool.OracleDataSource;

public class Main {
    public static void main(String[] args) {
        try{
            OracleDataSource ods = new OracleDataSource();
            ods.setDriverType ( "thin" ); // type of driver
            ods.setNetworkProtocol("tcp"); // tcp is the default anyway
            ods.setServerName ( "127.0.0.1" ); // database server name
            ods.setDatabaseName("TEST"); // Oracle SID
            ods.setPortNumber(1521); // listener port number
            ods.setUser("user"); // username
            ods.setPassword("123456"); // password

            Connection conn=ods.getConnection();
            PreparedStatement ps=conn.prepareStatement("select * from pipe");
            ResultSet rs=ps.executeQuery();
            while (rs.next())
            {
                String source = rs.getString("SOURCE_ID");
                System.out.println( source );
            }
            System.in.read();
        }
        catch(Exception e)
        {
            System.out.println(e.getMessage());
        }

（编辑：源码网）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!