欢迎访问悦橙教程(wld5.com),关注java教程。悦橙教程  java问答|  每日更新
页面导航 : > > 文章正文

Java 使用JDBC链接Oracle,javajdbc链接oracle,public class

来源: javaer 分享于  点击 44067 次 点评:98

Java 使用JDBC链接Oracle,javajdbc链接oracle,public class


public class OracleJdbcTest {     String driverClass = "oracle.jdbc.driver.OracleDriver";     Connection con;     public void init(FileInputStream fs) throws Exception     {         Properties props = new Properties();         props.load(fs);         String url = props.getProperty("db.url");         String userName = props.getProperty("db.user");         String password = props.getProperty("db.password");         Class.forName(driverClass);         con=DriverManager.getConnection(url, userName, password);     }     public void fetch() throws SQLException, IOException     {         PreparedStatement ps = con.prepareStatement("select SYSDATE from dual");         ResultSet rs = ps.executeQuery();         while (rs.next())         {             // do the thing you do         }         rs.close();         ps.close();     }     public static void main(String[] args)     {         OracleJdbcTest test = new OracleJdbcTest();         test.init();         test.fetch();     } }//该片段来自于http://byrx.net
相关栏目:

用户点评