Posted on 2008-08-13 13:23
☆ 阅读(152)
评论(0) 编辑 收藏 所属分类:
JDBC
JDBC和ORACLE数据库链接步骤
1)jdk环境变量设置
(1)JAVA_HOME= C:\Program Files\Java\jdk1.5.0_03
(2)CLASSPATH=.;%JAVA_HOME%\lib\dt.jar;%JAVA_HOME%\lib\tools.jar;
(3)PATH=%JAVA_HOME%\bin
2)设置和oracle链接的各种参数
String url="jdbc:oracle:thin:@172.31.255.21:1521:orcl";
String user="training";
String password="123456";
3)打开一个链接，执行查询，返回到一个结果集
Connection con = DriverManager.getConnection(url, user, password);
Statement stmt=con.createStatement();
ResultSet res = stmt.executeQuery("select * from RESUME0136");
4)循环取出数据
while(res.next()){
String SN=res.getString(1);
String NAME = res.getString(2);
String JOBSN = res.getString(3);
String DEGREESN = res.getString(4);
}
5)关闭结果集，关闭查询，关闭链接
res.close();
stmt.close();
con.close();