JDBC与Oracle的连接

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");
完整代码如下：

import java.sql.*;

public class TestJDBC {

 public static void main(String[] args) {
  ResultSet rs = null;
  Statement stmt = null;
  Connection conn = null;
  try {
   Class.forName("oracle.jdbc.driver.OracleDriver");
   //new oracle.jdbc.driver.OracleDriver();
   conn = DriverManager.getConnection("jdbc:oracle:thin:@192.168.0.1:1521:yuewei", "scott", "tiger");
   stmt = conn.createStatement();
   rs = stmt.executeQuery("select * from dept");
   while(rs.next()) {
    System.out.println(rs.getString("deptno"));
    //System.out.println(rs.getInt("deptno"));
   }
  } catch (ClassNotFoundException e) {
   e.printStackTrace();
  } catch (SQLException e) {
   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 (SQLException e) {
    e.printStackTrace();
   }
  }
 }

}

JDBC与Oracle的连接 增删该查的功能

package com.db.conn;


import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;


public class ConOracl {


// 数据库驱动类
private String dbDriver = "oracle.jdbc.driver.OracleDriver";
// 连接数据库url
private String dbURL = "jdbc:oracle:thin:@localhost:1521:xe";
// 连接数据库用户名
private String dbUser = "system";
// 连接数据库密码
private String dbPwd = "123";
// 获取数据库连接方法, 返回Connection对象
private Connection con = null;
//数据执行语句
private Statement  stat = null;
private String sql=null;
private ResultSet rs=null;
//创建数据库连接
public Connection getDBConnect() {
try {
// 加载数据库驱动
Class.forName(dbDriver);
con = DriverManager.getConnection(dbURL, dbUser, dbPwd);
} catch (Exception e) {
System.out.println(e);
}
return con;
}
//增加
public void Add()
{
con=getDBConnect();
sql="insert into student(stuno,stuname,stusex)" +
"values('1','lucy','w')";
try {
stat=con.createStatement();
stat.executeUpdate(sql);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
//删除
public void Delete()
{
con=getDBConnect();
sql="delete  from student " +
"where stuno=1";
try {
stat=con.createStatement();
stat.executeUpdate(sql);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}

}
//修改
public void Update()
{
con=getDBConnect();
sql="update student set stuname='ben' where stuno='2'";
try {
stat=con.createStatement();
} catch (SQLException e) {
e.printStackTrace();
}
}
//查询
public void Search() {
con = getDBConnect();
// 创建表的sql语句
sql = "SELECT * FROM student";
try {
stat = con.createStatement();
rs= stat.executeQuery(sql);
while (rs.next()) {
String stuno = rs.getString(1);
String stuname = rs.getString(2);
String stusex = rs.getString(3);
System.out.println(stuno + "," + stuname + "," + stusex);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
//功能:关闭数据库的连接
 
    public void close() {//6.释放资源
      try { // 捕捉异常
           try {
               if (rs!= null) { // 当ResultSet对象的实例rs不为空时
               rs.close(); // 关闭ResultSet对象
              }
            } finally {
              try {
                    if (stat != null) { // 当Statement对象的实例stmt不为空时
                   stat.close(); // 关闭Statement对象
                    }
              } finally {
                   if (con!= null) { // 当Connection对象的实例conn不为空时
                        con.close(); // 关闭Connection对象
                }
              }
         }
       } catch (Exception e) {
           e.printStackTrace(System.err); // 输出异常信息
       }
   }
public static void main(String[] args) {
ConOracl oracl = new ConOracl();
System.out.println("操作之前：");
oracl.Search();
oracl.Add();
oracl.Delete();
oracl.Update();
System.out.println("操作之后：");
oracl.Search(); 
oracl.close();
}
}