JAVA使用Oracle数据库实现CRUD
一、数据库建表
-- Create table
create table EMP
(
username VARCHAR2(10),
password VARCHAR2(9),
age NUMBER(4),
id VARCHAR2(9)
)
tablespace USER_TS_DATA
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
);
-- Add comments to the table
comment on table EMP
is '测试表';
二、Java连接Oracle数据库jar包
链接:https://pan.baidu.com/s/1OeyYbCnWo50ruVuQfi2Ksw
提取码:3nte
三、代码
1、封装连接数据库代码
package CRUD;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
/*
* 数据库连接类
*/
public class DBUtil {
public static Connection getConnection()
{
Connection connection = null;
String USERNAME = ""; //数据库用户名
String PASSWORD = ""; //密码
String DRIVER = "oracle.jdbc.driver.OracleDriver";
String URL = "jdbc:oracle:thin:@主机ip:1521:test"; //thin:小型驱动,驱动方式;test代表SERVICENAME(数据库的SID)
try {
Class.forName(DRIVER);
connection = DriverManager.getConnection(URL,USERNAME,PASSWORD);
System.out.println("数据库连接成功!");
} catch (ClassNotFoundException e) {
throw new RuntimeException(e);
}catch (SQLException e) {
throw new RuntimeException(e);
}
return connection;
}
//关闭资源
public static void close(Connection conn) {
try {
if(conn != null) {
conn.close();
}
} catch (Exception