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";// 连接数据库urlprivate 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 blocke.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 blocke.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 blocke.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();}}