java使用jdbc链接Oracle示例类分享
java使用jdbc链接Oracle示例类分享
发布时间:2016-12-28 来源:查字典编辑
摘要:复制代码代码如下:publicclassOracleJdbcTest{StringdriverClass="oracle.jdbc.driv...

复制代码 代码如下:

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();

}

}

推荐文章
猜你喜欢
附近的人在看
推荐阅读
拓展阅读
相关阅读
网友关注
最新Java学习
热门Java学习
编程开发子分类