一个数据库连接类,一个针对某个表增删改查的类
一个与表相关的类,一个测试类
jar包
下面展示一些 内联代码片。
import java.sql.DriverManager;
import java.sql.SQLException;
public class BaseDao {
static {
//加载驱动
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
}
public static java.sql.Connection getConnection() throws SQLException {
return DriverManager.getConnection("jdbc:oracle:thin:@x.x.x.x:1521:tom","user","passwd");
}
public static void closeAll(java.sql.ResultSet rs,java.sql.Statement stmt,java.sql.Connection conn){
if (rs != null) {
try {
rs.close();
} catch (SQLException throwables) {
throwables.printStackTrace();
}
}
if (stmt != null) {
try {
stmt.close();
} catch (SQLException throwables) {
throwables.printStackTrace();
}
}
if (conn != null) {
try {
conn.close();
} catch (SQLException throwables) {
throwables.printStackTrace();
}
}
}
}
利用static 代码块,一次加载jar包Class.forName(“oracle.jdbc.driver.OracleDriver”);
eclipse中jdbc-oracle.jar选择Build Path,再选择Configure Build Path… IDEA直接将jdbc-oracle.jar 加入external libraries
第二步返回一个连接对象
public static java.sql.Connection getConnection() throws SQLException {
return DriverManager.getConnection("jdbc:oracle:thin:@x.x.x:x:1521:tom","user","passwd");
}
getConnection(url,用户,密码)
第三步 关闭资源 对特定表增删改查的类 连接对象conn调用prepareStatement(sql)方法,返回一个PreparedStatement(预处理状态)对象stmt;让stmt来处理插入数据,有效防止sql注入 stmt调用相应类型的set方法 (字段序号,相应表类的get方法) SQL和util都有Date类型,需要转换才不报错util.Date 和sqlDate格式转换
stmt.setLong(1,owners.getId());stmt执行 最后再finally里面写关闭资源的方法
import java.security.acl.Owner;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;
public class OwnerDao {
public static void add(Owners owners){
Connection conn =null;
PreparedStatement stmt=null; //预处理执行对象,防止sql注入
try {
conn = BaseDao.getConnection();
stmt = conn.prepareStatement("insert into T_OWNERS values(?,?,?,?,?,?,?) ");
stmt.setLong(1,owners.getId());
stmt.setString(2,owners.getName());
stmt.setLong(3,owners.getAddress());
stmt.setString(4,owners.getHouse_number());
stmt.setString(5,owners.getWater_meter());
stmt.setDate(6,new java.sql.Date(owners.getAdddate().getTime()));
//new java.sql.Date(owners.getAdddate().getTime()) util.Date 和sqlDate格式转换
stmt.setLong(7,owners.getOwnertypeid());//业主类型
stmt.execute();
} catch (SQLException throwables) {
throwables.printStackTrace();
}finally {
BaseDao.closeAll(null,stmt,conn);//关闭所有资源
}
}
}
一个与表相关的类
import java.util.Date;
public class Owners {
private Long id;
private String name; //业主名称
private Long address; //地址id
private String house_number; //门牌号
private String water_meter; //水表号
private java.util.Date adddate;//增加日期(登记日期)
private Long ownertypeid; //业主id
//后面写相应的get set 方法
}
注意这里的date是util的
测试类
import java.security.acl.Owner;
import java.util.Date;
public class Test1 {
public static void main(String[] args) {
Owners owners = new Owners();
owners.setId(2L);
owners.setName("李四");
owners.setAddress(2L);
owners.setHouse_number("12-2");
owners.setWater_meter("x2456");
owners.setAdddate(new Date());
owners.setOwnertypeid(2L);
OwnerDao.add(owners);
}
}
结果如下
1 王强 1 2-2 x3456 2022/6/4 1
1)jar包放置;
2)date处理;
3)Oracle 是thin连接;
4)oracle区分表名字大小写,在Oracle貌似都是大写,所以相应的Java程序再写sql时表名要大写;
5)测试类中漏写一个字段set就会nullpointexception空指针异常;



