JAVA连接ORACLE数据库的步骤

最新推荐文章于 2021-03-27 20:51:05 发布

weixin_30920091

最新推荐文章于 2021-03-27 20:51:05 发布

阅读量81

点赞数

CC 4.0 BY-SA版权

文章标签： java 数据库

原文链接：http://www.cnblogs.com/android-html5/archive/2012/04/12/2533896.html

import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; public class TestJDBC { public static void main(String[] args) { Connection conn = null; ResultSet rs = null; Statement state = null; try { Class.forName("oracle.jdbc.OracleDriver"); conn = DriverManager.getConnection("jdbc:oracle:" + "thin:@127.0.0.1:1521:ORCL","scott","tiger"); state = conn.createStatement(); rs = state.executeQuery("select * from dept"); while(rs.next()){ String s = rs.getString("dname"); System.out.println(s.toLowerCase()); } } catch (ClassNotFoundException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } finally { try { if(rs != null) rs.close(); if(state != null) state.close(); if(conn != null) conn.close(); } catch (SQLException e) { e.printStackTrace(); } } } }

转载于:https://www.cnblogs.com/android-html5/archive/2012/04/12/2533896.html