JAVA连接Oracle

import java.sql.*;

public class ConnectOracle {
    public static void main(String[] args) {
        testOracle();
    }

    public static void testOracle() {
        Connection con = null;
        PreparedStatement pre = null;
        ResultSet result = null;
        try {
            Class.forName("oracle.jdbc.driver.OracleDriver");
            System.out.println("开始尝试连接数据库！");
            //jdbc:oracle:thin:@地址:端口:SID
            String url = "jdbc:oracle:thin:@192.168.100.100:1521:sid";
            //用户名
            String user = "JIAN";
            //密码
            String password = "123456";
            con = DriverManager.getConnection(url, user, password);
            System.out.println("连接成功！");
            String sql = "select * from tablename where id=?";
            pre = con.prepareStatement(sql);
            //sql中第一个“?”传入参数1
            pre.setString(1, "1");
            result = pre.executeQuery();
            while (result.next()) {
                System.out.println("FIRST_LEVEL_TAG : " + result.getString("FIRST_LEVEL_TAG"));
            }
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            try {
                //逐一关闭流，后打开的流先关闭
                if (result != null) {
                    result.close();
                }
                if (pre != null) {
                    pre.close();
                }
                if (con != null) {
                    con.close();
                }
                System.out.println("数据库连接已经关闭！");
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }
}