JDBC连接数据库（oracle）操作

最新推荐文章于 2024-09-09 08:00:00 发布

J1271820107

最新推荐文章于 2024-09-09 08:00:00 发布

阅读量393

点赞数

分类专栏：数据库文章标签：数据库 jdbc

本文链接：https://blog.csdn.net/J1271820107/article/details/49780441

版权

数据库专栏收录该内容

11 篇文章 0 订阅

订阅专栏

private final static String URL = "jdbc:oracle:thin:@127.0.0.1:1521:orcl";
private final static String USER = "bank";

private final static String PASS = "jfy12345";

Connection conn = null;
    PreparedStatement cmd = null;

       try {
           // 1.加载驱动
           new oracle.jdbc.driver.OracleDriver();

           // 2.建立连接
           conn = DriverManager.getConnection(URL, USER, PASS);

           // 3.准备语句

           cmd = conn.prepareStatement(sql);
           if (paras != null) {
               for (int i = 1; i <= paras.length; i++) {
                   cmd.setObject(i, paras[i - 1]);
               }
           }

           // 4.执行驱动
           cmd.executeUpdate();

          } catch (Exception e) {
           e.printStackTrace();

           throw new RuntimeException(e.getMessage());

          } finally {
          // 5.关闭资源
           try {

               if (cmd != null) {
                   cmd.close();
               }
               if (conn != null) {
                   conn.close();
               }

           } catch (Exception e) {
           }
       }