java连接Oracle数据库

java连接Oracle数据库

首先需要ojdbc.jar的包，拖入项目中之后右击选择add buildpath

之后建立JDBCUtil类，代码如下

package com.oracle.jdbc.util;

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

public class JDBCUtil {

    private static String url="jdbc:oracle:thin:@127.0.0.1:1521:BADOGYAN";
    private static String user="blogUser";
    private static String password = "asdfg520";

    static {
        try{
            Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
            System.out.println("oracle驱动加载中。。。");
        } catch (IllegalAccessException e) {
            e.printStackTrace();
        } catch (InstantiationException e) {
            e.printStackTrace();
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        }
    }

    public static Connection getConnection(){
        Connection connection = null;

        System.out.println("开始尝试连接数据库");
        try {
            connection = DriverManager.getConnection(url, user, password);
        } catch (SQLException e) {
            e.printStackTrace();
        }
        System.out.println(url);
        System.out.println("用户名" + user + "密码：******");
        System.out.println("数据库连接成功");
        return connection;
    }
}

然后开始测试

package com.oracle.jdbc;

import com.oracle.jdbc.util.JDBCUtil;

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

public class Main {

    public static void main(String[] args) {
	// write your code here
        Connection connection = null;
        PreparedStatement ps = null;
        ResultSet result = null;
        try {
            connection = JDBCUtil.getConnection();
            String sql = "select * from t_blogger where userid = 61";
            ps = connection.prepareStatement(sql);
            //ps.setInt(1, 1);
            result = ps.executeQuery();
            while (result.next()) {
                System.out.println(result.getInt("userid") + " 用户名:"
                        + result.getString("uname"));
            }
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            try {
                if (result != null) {
                    result.close();
                }
                if (ps != null) {
                    ps.close();
                }
                if (connection != null) {
                    connection.close();
                }
                System.out.println("数据库连接已关闭！");
            } catch (Exception e) {
                e.printStackTrace();
            }
        }
    }
}