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