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

使用JDBC链接Oracle代码,jdbc链接oracle, public c

来源: javaer 分享于  点击 22831 次 点评:50

使用JDBC链接Oracle代码,jdbc链接oracle, public c


    public class OracleJdbcTest        {            String driverClass = "oracle.jdbc.driver.OracleDriver";            Connection con;            public void init(FileInputStream fs) throws ClassNotFoundException, SQLException, FileNotFoundException, IOException            {                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();            }        }   
相关栏目:

用户点评