JDBC封装的过程：

• 1、引入驱动jar;(ohdbc6.jar,)
  该jar包在oracle数据库自带的，具体路径如下：

  D:\Softwares\OracleXE\app\oracle\product\11.2.0\server\jdbc\lib
  

• 2、加载驱动

  String url="jdbc:oracle:thin:@localhost:1521:xe";
  

• 3、得到connection连接对象

• 4、建立statement

• 5、执行SQL语句

• 6、处理结果

• 7、关闭资源

使用oracle数据库。
– 创建表空间

create tableSpace STUDENTdatafile 'D:\Softwares\OracleXE\app\oracle\oradata\XE\STUDENT.dbf'size 5Mautoextend on next 1m;

–创建示例用户

create user studentidentified by rootdefault tablespace STUDENT;

–授权

grant connect,resource to student;   

– 注意：创建完用户值后要推出sys用户，重新登陆student用户******************
建表：

create table student(id number(9) primary key, name varchar2(30), birthday date
);

com.bennett.model

package com.bennett.model;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.Date;/*** @Version: * @Description:SM-1* @Author: bennett* @Date: 2021年10月22日 下午9:15:59*/
public class Student {private int id;private String name;private Date birthday;public Student() {}private final SimpleDateFormat dateFormat =new SimpleDateFormat("yyyy-MM-dd");public Student(int id, String name, Date birthday) {super();this.id = id;this.name = name;this.birthday = birthday;}public Student(int id, String name, String birthday) {super();this.id = id;this.name = name;try {this.birthday = dateFormat.parse(birthday);} catch (ParseException e) {e.printStackTrace();}}@Overridepublic String toString() {return "Student [id=" + id + ", name=" + name + ", birthday=" + birthday + ", dateFormat=" + dateFormat + "]";}@Overridepublic int hashCode() {final int prime = 31;int result = 1;result = prime * result + id;return result;}@Overridepublic boolean equals(Object obj) {if (this == obj)return true;if (obj == null)return false;if (getClass() != obj.getClass())return false;Student other = (Student) obj;if (id != other.id)return false;return true;}public int getId() {return id;}public void setId(int id) {this.id = id;}public String getname() {return name;}public void setname(String name) {this.name = name;}public Date getBirthday() {return birthday;}public void setBirthday(Date birthday) {this.birthday = birthday;}
}

com.bennett.dao

注意：不是两个以上的人进行共同开发时不需要定义接口（规则/规范）。

StudentDao

package com.bennett.dao;
import java.util.List;
import com.bennett.model.Student;
/*** @Version: * @Description:SM-1* @Author: bennett* @Date: 2021年10月22日 下午9:17:24*/
public interface StudentDao {boolean add(Student student);boolean delete(int id);boolean update(Student student);Student get(int id);List<Student> getAll();
}

package com.bennett.dao;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.text.SimpleDateFormat;
import java.util.Date;
import java.util.LinkedList;
import java.util.List;
import com.bennett.model.Student;
import com.bennett.util.JdbcUtil;/*** @Version: * @Description:SM-1* @Author: bennett* @Date: 2021年10月22日 下午9:17:52*/
public class StudentImplJdbc implements StudentDao {private JdbcUtil jdbcUtil =new JdbcUtil();private final SimpleDateFormat dateFormat =new SimpleDateFormat("yyyy-MM-dd");@Overridepublic boolean add(Student student){int id = student.getId();String naem = student.getname();Date birthday = student.getBirthday();String bir = dateFormat.format(birthday);String sql="insert into student"+ " (id, name, birthday)"+ " values"+ " (?, ?, ?)";return jdbcUtil.executeUpdate(sql,student.getId(),student.getname(),student.getBirthday())==1;}@Overridepublic boolean delete(int id) {String sql="delete from student "+ "where id = '"+id+"'";return jdbcUtil.executeUpdate(sql,id)==1;}@Overridepublic boolean update(Student student) {int id = student.getId();String naem = student.getname();Date birthday = student.getBirthday();String bir = dateFormat.format(birthday);String sql="update Student "+ "set name = '"+naem+"',birthday = date'"+bir+"' "+ "where id = '"+id+"'";return jdbcUtil.executeUpdate(sql,student.getId(),student.getname(),student.getBirthday())==1;}@Overridepublic Student get(int id) {String sql = "select id,name,birthday from student "+ "where id = '"+id+"'";ResultSet rs = jdbcUtil.executeQuery(sql);try {while (rs.next()) {return new Student(rs.getInt("id"), rs.getString("name"), rs.getDate("birthday"));}} catch (SQLException e) {e.printStackTrace();}return null;}@Overridepublic List<Student> getAll() {String sql = "select id,name,birthday from student";ResultSet rs = jdbcUtil.executeQuery(sql);try {List<Student> results = new LinkedList<Student>();while (rs.next()) {results.add(new Student(rs.getInt("id"), rs.getString("name"), rs.getDate("birthday")));}return results;} catch (SQLException e) {e.printStackTrace();}finally {try {if (rs != null) {rs.close();}} catch (SQLException e) {e.printStackTrace();}}return null;}
}

com.bennett.util

package com.bennett.util;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;/*** @Version: * @Description:SM-1* @Author: bennett* @Date: 2021年10月22日 下午9:20:13*/
public class JdbcUtil {public int executeUpdate(String sql, Object... params){String url="jdbc:oracle:thin:@localhost:1521:xe";//数据库的连接字符串String user="scott";//注意不允许使用sys,system,root这样的高权限用户，不安全String password="root";Connection connection = null;PreparedStatement statement = null;try {connection = DriverManager.getConnection(url, user, password);statement = connection.prepareStatement(sql);return statement.executeUpdate();} catch (SQLException e) {e.printStackTrace();}finally {try {if (statement!=null) {statement.close();}} catch (SQLException e) {e.printStackTrace();}try {connection.close();} catch (SQLException e) {if (statement!=null) {e.printStackTrace();}}}return -1;}public ResultSet executeQuery(String sql, Object... params) {String url="jdbc:oracle:thin:@localhost:1521:xe";//数据库的连接字符串String user="scott";//注意不允许使用sys,system,root这样的高权限用户，不安全String password="root";Connection connection = null;
//		Statement statement = null;PreparedStatement statement=null;try {connection = DriverManager.getConnection(url, user, password);
//			statement = connection.createStatement();statement = connection.prepareStatement(sql,ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);ResultSet rs = statement.executeQuery(sql);return rs;} catch (SQLException e) {e.printStackTrace();}finally {try {if (statement!=null) {statement.close();}} catch (SQLException e) {e.printStackTrace();}try {connection.close();} catch (SQLException e) {if (statement!=null) {e.printStackTrace();}}}return null;}
}

com.bennett.dao.test

package com.bennett.dao.test;import static org.junit.jupiter.api.Assertions.*;import java.sql.Date;
import java.sql.SQLException;
import java.util.List;
import org.junit.jupiter.api.Test;
import com.bennett.dao.StudentImplJdbc;
import com.bennett.model.Student;/*** @Version: * @Description:SM-1* @Author: bennett* @Date: 2021年10月22日 下午9:19:08*/
class StudentImplJdbcTest {private StudentImplJdbc studentImplJdbc = new StudentImplJdbc();@Testvoid testAdd(){
//		assertTrue(studentImplJdbc.add(new Student(1001, "张恒", Date.valueOf("2000-12-12"))));assertTrue(studentImplJdbc.add(new Student(1002, "LIU",Date.valueOf("2000-12-12"))));
//		assertTrue(studentImplJdbc.add(new Student(1003, "柳絮", Date.valueOf("2000-12-12"))));
//		assertTrue(studentImplJdbc.add(new Student(1004, "杨川", Date.valueOf("2000-12-12"))));
//		assertTrue(studentImplJdbc.add(new Student(1005, "红包", Date.valueOf("2000-12-12"))));
//		assertTrue(studentImplJdbc.add(new Student(1006, "点击", Date.valueOf("2000-12-12"))));}@Testvoid testDelete() {assertTrue(studentImplJdbc.delete(111));}@Testvoid testUpdate() {assertTrue(studentImplJdbc.update(new Student(1003, "张恒	", Date.valueOf("2000-12-12"))));}@Testvoid testGet() {System.out.println(studentImplJdbc.get(1003));}@Testvoid testGetAll() {List<Student> showResults = studentImplJdbc.getAll();for (Student student : showResults) {System.out.println(student.toString());}}
}