服务端程序链接oracle数据库

关注

原创最新推荐文章于 2026-02-27 04:32:15 发布 439 阅读 AI 写同款· GEO 优化 ›

【Oracle数据库】Oracle11g数据库下载与安装教程（超详细安装图解) Oracle11g是Oracle公司出的一个比较轻量版的数据库,这里重点说一下在window系统上如何安装Oracle11g， Oracle11g是很早之前的安装包，win7 系统安装时不会遇到环境不满足最低要求的提示，win11系统安装时会提醒环境不满足，修改配置文件即可（注意：先安装oracle服务端/oracle客户端，再安装第三方工具（PL/ SQL Developer，DBeaver等）服务器端环境概述：ORACLE数据库版本：Oracle 11g 64位（11.2.0）阅读详情

首先创建一个数据库链接类：GetCon

package com.db;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;



public class GetCon {
    public static final String driver ="oracle.jdbc.driver.OracleDriver";//oracle驱动
    public static final String url ="jdbc:oracle:thin:@127.0.0.1:1521:orcl";//url地址
    public static final String userName ="wh6y";//用户名
    public static final String passWord ="r1";//密码




    private static Connection conn;//链接对象
    private static GetCon getCon = null;
    private GetCon() {

    }

    public static GetCon getInstance(){//单例模式
        if (getCon == null) {
            getCon = new GetCon();
        }
        return getCon;
    }
    static {
        try {
            Class.forName(driver);//可以了解一下为什么这么写有个链接http://blog.youkuaiyun.com/gaoqida/article/details/61920739?utm_source=itdadao&utm_medium=referral
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        }
    }

    private void initConnection(){
        try {
            conn = DriverManager.getConnection(url,userName,passWord);
            conn.setAutoCommit(true);
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
    public Connection getCon(){
            initConnection();
        return conn;
    }

}

新建一个测试类Test2



public class Test2 {



    private static StringBuffer sb=new StringBuffer();

    public static void main(String[] args) {
        String sql="select * from pda_user t ";
         Connection con =GetCon.getInstance().getCon();
         try {
             PreparedStatement prepareStatement = con.prepareStatement(sql);
            ResultSet executeQuery = prepareStatement.executeQuery();
            while (executeQuery.next()) {
                 String dbuser = executeQuery.getString(1);
                    String user_id = executeQuery.getString(2);
                    String user_name = executeQuery.getString(3);

                    sb.append("dbuser:"+dbuser+" user_id："+user_id+" user_name："+user_name);
                    System.out.println("dbuser:"+dbuser+" user_id："+user_id+" user_name："+user_name);

            }



        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }



    }

}