JDBC实现对数据库操作的具体实现（Oracle）

jdbc实现对数据库的具体操作

一、DBUtil类

package com.dbutil;

import java.sql.*;

/**
 * @author life
 * @create 2019-12-17 18:43
 * 数据库连接类
 */
public class DBUtil {
    //创建一个数据库连接
    public static Connection getConnection() throws ClassNotFoundException {
        Connection connection =null;
        String driver = "oracle.jdbc.OracleDriver";
        String url = "jdbc:oracle:thin:@localhost:1521:orcl";
        String user = "text";
        String pwd = "123";
        //加载驱动
        try {
            Class.forName(driver);
            connection = DriverManager.getConnection(url,user,pwd);
            System.out.println("连接数据库成功");
        }catch (Exception e){
            System.out.println("连接数据库失败");
            e.printStackTrace();
        }

        return connection;
    }
    //关闭资源集(等会写)
    public static void close(Connection connection){
        try {
            connection.close();
            System.out.println("connection关闭成功");
        } catch (SQLException e) {
            e.printStackTrace();
            System.out.println("connection关闭失败");
        }
    }
    public static void close(PreparedStatement preparedStatement){
        try {
            preparedStatement.close();
            System.out.println("preparedStatement关闭成功");
        } catch (SQLException e) {
            e.printStackTrace();
            System.out.println("preparedStatement关闭失败");
        }
    }
    public static void close(ResultSet resultSet){
        try {
            resultSet.close();
            System.out.println("resultset关闭成功");
        } catch (SQLException e) {
            e.printStackTrace();
            System.out.println("resultset关闭失败");
        }
    }

}

二、Model类

package com.dbutil;

/**
 * @author life
 * @create 2019-12-17 18:44
 * java层面对应Oracle的实体类
 */
public class Model {
    private int id;
    private String name;
    private String url;
    private String des;

    public Model(){};



    public int getId() {
        return id;
    }

    public void setId(int id) {
        this.id = id;
    }

    public Model(String name, String url, String des) {
        this.name = name;
        this.url = url;
        this.des = des;
    }

    public Model(int id, String name, String url, String des) {
        this.id = id;
        this.name = name;
        this.url = url;
        this.des = des;
    }
    public void update(int id,String name,String url,String des){
        this.id = id;
        this.name = name;
        this.url = url;
        this.des = des;
    }


    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public String getUrl() {
        return url;
    }

    public void setUrl(String url) {
        this.url = url;
    }

    public String getDes() {
        return des;
    }

    public void setDes(String des) {
        this.des = des;
    }

    @Override
    public String toString() {
        return "Model{" +
                "id=" + id +
                ", name='" + name + '\'' +
                ", url='" + url + '\'' +
                ", des='" + des + '\'' +
                '}';
    }



}

三、Method

package com.dbutil;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

/**
 * @author life
 * @create 2019-12-17 18:47
 * 定义增删改查的方法类
 */
public class Method {
    //添加数据
    public void add(Model model) throws ClassNotFoundException {

        Connection connection = DBUtil.getConnection();
        String sql = "insert into https(id,name,url,des) values(http_seq.nextval,?,?,?)";
        PreparedStatement preparedStatement = null;
        try {
            preparedStatement = connection.prepareStatement(sql);
            //preparedStatement.setInt(1, model.getId());
            preparedStatement.setString(1, model.getName());
            preparedStatement.setString(2, model.getUrl());
            preparedStatement.setString(3, model.getDes());
            preparedStatement.executeUpdate();
            System.out.println("插入成功");
        } catch (SQLException e) {
            System.out.println("插入失败");
            e.printStackTrace();
        } finally {
            DBUtil.close(preparedStatement);
            DBUtil.close(connection);
        }
    }

    public void update(Model model) throws ClassNotFoundException//修改数据
    {
        Connection connection = DBUtil.getConnection();
        String sql = "update https set name=?,url=?,desc =?";
        PreparedStatement preparedStatement = null;
        try {
            preparedStatement = connection.prepareStatement(sql);
            preparedStatement.setString(1, model.getName());
            preparedStatement.setString(2, model.getUrl());
            preparedStatement.setString(3, model.getDes());
            preparedStatement.executeUpdate();
        } catch (SQLException e) {
            System.out.println("修改失败");
            e.printStackTrace();
        } finally {
            DBUtil.close(preparedStatement);
            DBUtil.close(connection);
        }

    }

    public Model select(int id) throws ClassNotFoundException //查询数据
    {
        Connection connection = DBUtil.getConnection();
        //准备sql语句
        String sql = "select * from https  where id = ?";
        //创建语句传输对象
        PreparedStatement preparedStatement = null;
        ResultSet resultSet = null;
        Model model = null;
        try {
            preparedStatement = connection.prepareStatement(sql);
            preparedStatement.setInt(1, id);
            resultSet = preparedStatement.executeQuery();
            while (resultSet.next()) {
                model = new Model();
                model.setId(resultSet.getInt( "id"));
                model.setName(resultSet.getString("name"));
                model.setUrl(resultSet.getString("url"));
                model.setDes(resultSet.getString("des"));
            }
        } catch (SQLException e) {
            System.out.println("查询失败");
            e.printStackTrace();
        } finally {
            DBUtil.close(resultSet);
            DBUtil.close(preparedStatement);
            DBUtil.close(connection);
        }
        return model;
    }

    public void delete(int id) throws ClassNotFoundException//删除数据
    {
        Connection connection = DBUtil.getConnection();
        String sql = "delete from https where id = ?";
        PreparedStatement preparedStatement = null;
        try {
            preparedStatement = connection.prepareStatement(sql);
            preparedStatement.setInt(1, id);
            preparedStatement.executeQuery();
            System.out.println("删除成功");
        } catch (SQLException e) {
            System.out.println("删除失败");
            e.printStackTrace();
        } finally {
            DBUtil.close(preparedStatement);
            DBUtil.close(connection);
        }


    }
}

四、Test测试类

package com.dbutil;

/**
 * @author life
 * @create 2019-12-17 18:47
 * 测试操作数据库（增删改查）
 * //循环添加内容
 *
 *
 */
public class Test {
    public static void main(String[] args) throws ClassNotFoundException {
        //创建对象Method
        Method method = new Method();
        //创建Model对象
        //Model model = new Model("腾讯","www.qq.com","腾讯新闻");
        //添加数据
        //method.add(model);
        //查询数据
        for(int i=0;i<=5;i++) {
            System.out.println(method.select(i));
            System.out.println("-----------------");
        }


    }
}

五、数据库的操作