JDBC编程步骤:
----java与Oracle数据的连接(lomboz_eclipse环境下)
1.在Oracle数据库安装文件夹中找到jdbc文件夹→lib文件夹→classesl2.jar
2.lomboz_eclipse中导入此Jar包
导入方法:
建立一个项目,在项目名称上右键鼠标选择Build Path→Add External Archives→
选择classesl2.jar进行导入
3.新建一程序编写与Oracle连接的代码
步骤如下:
1.实例话驱动类
class.forName("Oracle.jdbc.driver.OracleDriver");
2.建立到数据库的连接
Connection conn = DriverManager.getConnection("jdbc:oracle:thin:
@192.168.8.1:1521:yuewei","scott","tiger");
3.将数据发送到数据库中
Statement stm = conn.CreatStatement();
4.执行语句(select语句)
ResultSet rs = stm.executeQuery(select * from dept);
5.显示语句
rs.getString("deptno");
完整代码如下:
- importjava.sql.*;
- publicclassTestJDBC{
- publicstaticvoidmain(String[]args){
- ResultSetrs=null;
- Statementstmt=null;
- Connectionconn=null;
- try{
- Class.forName("oracle.jdbc.driver.OracleDriver");
- //neworacle.jdbc.driver.OracleDriver();
- conn=DriverManager.getConnection("jdbc:oracle:thin:@192.168.0.1:1521:yuewei","scott","tiger");
- stmt=conn.createStatement();
- rs=stmt.executeQuery("select*fromdept");
- while(rs.next()){
- System.out.println(rs.getString("deptno"));
- //System.out.println(rs.getInt("deptno"));
- }
- }catch(ClassNotFoundExceptione){
- e.printStackTrace();
- }catch(SQLExceptione){
- e.printStackTrace();
- }finally{
- try{
- if(rs!=null){
- rs.close();
- rs=null;
- }
- if(stmt!=null){
- stmt.close();
- stmt=null;
- }
- if(conn!=null){
- conn.close();
- conn=null;
- }
- }catch(SQLExceptione){
- e.printStackTrace();
- }
- }
- }
- }