原生jdbc层删改查操作

 public void jdbcText() {
        /*
         * 加载驱动
         * 创建数据库连接
         * 创建执行sql的语句
         * 执行语句
         * 处理执行结果
         * 释放资源*/
        String url = "jdbc:mysql://127.0.0.1:3306/one?characterEncoding=utf-8";
        String user = "root";
        String pwd = "123456";
        Connection connection = null;
        PreparedStatement prep = null;
        ResultSet res = null;
        try {
//            加载驱动
            Class.forName("com.mysql.jdbc.Driver");
//            获取数据库连接
            connection = DriverManager.getConnection(url, user, pwd);
//            String sql2 = "insert into book(bookName,price,typeid) VALUES('我的老千生涯',52,1007)";//增加
            String sql2 = "delete from book where price = 566";//删除
//            String sql2 = "update book set price=58 WHERE bookId = 25";//修改
            PreparedStatement pe2 = connection.prepareStatement(sql2);
            int i = pe2.executeUpdate();
            System.out.println("更新条数为" + i + "条");
            //            创建要执行的SQL语句
            String sql = "select * from book";//查
//            执行SQL语句
            prep = connection.prepareStatement(sql);
//            处理结果集
            res = prep.executeQuery();
            while (res.next()) {
                System.out.print(res.getString(1));
                System.out.print(res.getString(2));
                System.out.print(res.getString(3));
                System.out.print(res.getString(4));
                System.out.print(res.getString(5));
                System.out.println(res.getString(6));
            }
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        } catch (SQLException throwables) {
            throwables.printStackTrace();
        } finally {
//            释放资源
            try {
                res.close();
            } catch (SQLException throwables) {
                throwables.printStackTrace();
            }
            try {
                prep.close();
            } catch (SQLException throwables) {
                throwables.printStackTrace();
            }
            try {
                connection.close();
            } catch (SQLException throwables) {
                throwables.printStackTrace();
            }
        }
    }

区别：

        增删改

                int i = pe2.executeUpdate();

                返回值为操作的条数不需要处理结果集

        查

                res = prep.executeQuery();

                返回查询出的结果集并需要处理

注意关闭流的顺序

        关闭的顺序为使用的顺序相反

            try {
                res.close();
            } catch (SQLException throwables) {
                throwables.printStackTrace();
            }
            try {
                prep.close();
            } catch (SQLException throwables) {
                throwables.printStackTrace();
            }
            try {
                connection.close();
            } catch (SQLException throwables) {
                throwables.printStackTrace();
            }

用到的jar包maven配置

        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.17</version>
        </dependency>