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();
}
}