《java中的JDBC纯驱动方式连接Oracle数据库》由会员分享，可在线阅读，更多相关《java中的JDBC纯驱动方式连接Oracle数据库（6页珍藏版）》请在金锄头文库上搜索。
1、java中的JDBC纯驱动方式连接 Oracle数据库一、下载数据库厂商提供的驱动程序包二、将驱动程序包引入工程中，步骤如下1 选中项目单击右键Build PathConfigure Build Pathi-avd - Jdbc/src/jidbc/1 Jdbctettjava - MyEclips# Enterprise Workbench2、在打开的构建路径对话框中，点击 Libraries选项卡，然后点击 Add External JARs ,按钮3、选择ojdbc6.jar，然后点击打开”Q JAR Selection. 11.2.0 dbhome_l jdbc libj-bfi更 t
2、fi 曲 D g*椿改日期M E (E:)qjdlbcS.jar2010/3/4 4:37Executable Jar FileK F (F：.ojdbcS.gjar2010/3/4 4：37Executable Jar FileJ. 12qjdbcSdmsjar2010/3/4 4:37Executable日r Alel-TTML ojdbc5 d msg jar2010/3/d 4:37Executable Jar FileJ2SE3&；qjdbf6.jar2010/3/4 4:37Executable Jar FileJAVA、一 ojdbc6jgjar2010/3/4 4:37Exec
3、utableatKle.java S en pt,cjdbcSdmijar2010/3/4 4:37Executable Jar File丿鸚合55載qjdbc5dms_g.jar2010/3/4 4:37Executable Jar Fi怙s liunx,simpltfanjar2010/3/d 4：37Executable Jar FileOracle.OraclegcgPI s- J L rL文彳ifrS (NJ ojdbcSjr冋4、可以看到驱动文件已经被添加到项目的库文件中，点击OK，添加驱动结束。三、编程，通过纯 Java驱动方式与数据库建立连接。关键代码：jdbc:oracle:
4、thin:ip 地址:监听端口 ：数据库 sid具体步骤如下:type filter textJava Build PathResourceBuildersJav Buildi PathJave Code StyleJav Compiler测吊Editor Javadoc LocationMyiEclipsProject References Run/Debug SettingsSource L_ Projects 岂、Libraries 七心 Order arid ExportJARe and cl sass foldeins on the build path: 0 | 川 oidbcSJ
5、ar - Jdbc/lb J RE System Library JavaSE-1.6Add JARsm-Add External JARs.Add Variable.Add Library.Add Class Folder.Add EKternal Class Folder,ET it,”RemoveMigrate JAR File.Class .(driver);那载马童五OKCancel1导入数据库连接所需的包 import java.sql.C onn ecti on;import java.sql.DriverMa nager;import java.sql.ResultSet;im
6、port java.sql.SQLExcepti on;import java.sql.PreparedStateme nt;2、定义连接所需的字符串String driver=oracle.jdbc.OracleDriver; / 驱动字符串String url=jdbc:oracle:thin:localhost:1521:orcl11g; / 链接字符串String user= scott ; / 用户名String password= tiger ; / 密码3、加载JDBC驱动程序Class. forName (driver);4、分配一个Conn ection对象Conn ecti
7、 on con=DriverMa nager.getC onn ecti on(url, user, password);完成以上步骤即可连接上数据库，为下一步操作数据库做好准备5、分配一个 PreparedStatement对象，执行查询 SQL ( DQL )语句String sql= select * from emp;PreparedStateme nt pstm=con. prepareStateme nt(sql);6从返回的ResultSet对象中检索数据，类似迭代器ResultSet rs= _ null ; rs =pstm.executeQuery();while (rs.
8、 next()empno);ename);sal);hiredate ); dept no);t +en ame+ t +sal+ t +hiredate);对象，关闭 PreparedStatement对象，关int emp no=rs.getI nt(String en ame=rs.getStri ng( double sal=rs.getDouble( Date hiredate=rs.getDate( int dept no=rs.getI nt(System. out .println(empno+7.按顺序依次关闭 ResultSetConnection 对象整理好所有源码如下:
9、importjava.sql.C onnection;importjava.sql.DriverMa nager;importjava.sql.ResultSet;importjava.sql.SQLExceptio n;importjava.sql.PreparedStateme nt;importjava.util.Date;public class Jdbctest * param args*/public static void main( Stri ng args) /TODO Auto-ge nerated method stubString driver =oracle.jdbc
10、.OracleDriver; /驱动字符串Stringurl = jdbc:oracle:thin:localhost:1521:orcl11g; /接字符串String user =String password =Conn ecti on con =scott ; / tiger n ull ;用户名PreparedStateme nt pstm =;/ 密码null ;ResultSet rs =nullboolea n flag= false try Class. forName (driver);con = DriverMa nager.getC onnection(url, use
11、r, password);String sql =select * from emp;pstm = con .prepareStateme nt(sql);rs = pstm.executeQuery();while (rs. next() int empno = rs.getlnt(empno);Stri ng en ame = rs.getStri ng(en ame);+ sal +double sal = rs.getDouble( Date hiredate = rs.getDate( int deptno = rs.getl nt( System. out .println(emp
12、no +sal);hiredate );dept no);t+ en ame +tt+ hiredate);flag= true ; catch (ClassNotFoundException e) /TODOAuto-ge nerated catch blocke.pri ntStackTrace(); catch (SQLException e) /TODOAuto-ge nerated catch blocke.pri ntStackTrace(); fin allyif (rs!=null )try rs.close(); catch (SQLException e) /TODOAut
13、o-ge nerated catch blocke.pri ntStackTrace();/关闭执行通道if (pstm!= null )try pstm.close(); catch (SQLException e) / TODOAuto-ge nerated catch blocke.pri ntStackTrace();/关闭连接通道try if (con!= null &(!con.isClosed()try con. close(); catch (SQLException e) /TODO Auto-ge nerated catch blocke.pri ntStackTrace(); catch (SQLException e) /TODOAuto-ge nerated catch blocke.pri ntStackTrace();if (flag)System. out .println(” 执行成功！”)； else System. out .println(” 执行失败！”)；
