SpringBoot 整合 JDBC 数据库操作-003-实现增加数据操作

qianmoQ

上篇文章我们讲到了如何配置服务的DataSource数据库数据源,方便其对数据库进行操作.这篇文章主要讲解一下我们使用整合的JDBC进行简单的数据增加操作.

创建用于做测试数据的模拟数据表

    USE test;
 
    CREATE TABLE article (
      id          INT(10) AUTO_INCREMENT,
      title       VARCHAR(100) NOT NULL,
      description VARCHAR(200),
      PRIMARY KEY (id)
    );

创建数据表对应实体类(在源码目录下新建bean文件夹, 并在该文件夹下创建相应的Article类文件)

    /**
     * Licensed to the Apache Software Foundation (ASF) under one
     * or more contributor license agreements.  See the NOTICE file
     * distributed with this work for additional information
     * regarding copyright ownership.  The ASF licenses this file
     * to you under the Apache License, Version 2.0 (the
     * "License"); you may not use this file except in compliance
     * with the License.  You may obtain a copy of the License at
     * <p>
     * http://www.apache.org/licenses/LICENSE-2.0
     * <p>
     * Unless required by applicable law or agreed to in writing, software
     * distributed under the License is distributed on an "AS IS" BASIS,
     * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
     * See the License for the specific language governing permissions and
     * limitations under the License.
     */
    package com.edurt.bean;
     
    /**
     * Article <br/>
     * 描述 : Article <br/>
     * 作者 : qianmoQ <br/>
     * 版本 : 1.0 <br/>
     * 创建时间 : 2018-03-26 下午4:51 <br/>
     * 联系作者 : <a href="mailTo:shichengoooo@163.com">qianmoQ</a>
     */
    public class Article {
     
        private Integer id;
        private String title;
        private String description;
     
        public Integer getId() {
            return id;
        }
     
        public void setId(Integer id) {
            this.id = id;
        }
     
        public String getTitle() {
            return title;
        }
     
        public void setTitle(String title) {
            this.title = title;
        }
     
        public String getDescription() {
            return description;
        }
     
        public void setDescription(String description) {
            this.description = description;
        }
     
        @Override
        public String toString() {
            return "Article{" +
                    "id=" + id +
                    ", title='" + title + '\'' +
                    ", description='" + description + '\'' +
                    '}';
        }
     
    }

创建数据表底层数据库操作Repository(在源码目录下创建repository文件夹, 并在该目录下创建ArticleRepository类文件)

    /**
     * Licensed to the Apache Software Foundation (ASF) under one
     * or more contributor license agreements.  See the NOTICE file
     * distributed with this work for additional information
     * regarding copyright ownership.  The ASF licenses this file
     * to you under the Apache License, Version 2.0 (the
     * "License"); you may not use this file except in compliance
     * with the License.  You may obtain a copy of the License at
     * <p>
     * http://www.apache.org/licenses/LICENSE-2.0
     * <p>
     * Unless required by applicable law or agreed to in writing, software
     * distributed under the License is distributed on an "AS IS" BASIS,
     * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
     * See the License for the specific language governing permissions and
     * limitations under the License.
     */
    package com.edurt.repository;
     
    import com.edurt.bean.Article;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.jdbc.core.JdbcTemplate;
    import org.springframework.stereotype.Component;
     
    /**
     * ArticleRepository <br/>
     * 描述 : ArticleRepository <br/>
     * 作者 : qianmoQ <br/>
     * 版本 : 1.0 <br/>
     * 创建时间 : 2018-03-26 下午4:54 <br/>
     * 联系作者 : <a href="mailTo:shichengoooo@163.com">qianmoQ</a>
     */
    @Component
    public class ArticleRepository {
     
        @Autowired
        private JdbcTemplate jdbcTemplate; // 引入数据库操作模型
     
        /**
         * 创建文章信息
         *
         * @param article 文章信息
         */
        public void createArticle(Article article) {
            String sql = "INSERT INTO article(title, description) VALUES(?, ?)";
            jdbcTemplate.update(sql, article.getTitle(), article.getDescription());
        }
     
    }

创建数据库业务层Service (在源码目录下创建service文件夹, 并在该目录下创建ArticleService)

    package com.edurt.service;
 
    import com.edurt.bean.Article;
     
    public interface ArticleService {
     
        void createArticle(Article article);
     
    }

创建接口实现ArticleServiceImpl类文件

    /**
     * Licensed to the Apache Software Foundation (ASF) under one
     * or more contributor license agreements.  See the NOTICE file
     * distributed with this work for additional information
     * regarding copyright ownership.  The ASF licenses this file
     * to you under the Apache License, Version 2.0 (the
     * "License"); you may not use this file except in compliance
     * with the License.  You may obtain a copy of the License at
     * <p>
     * http://www.apache.org/licenses/LICENSE-2.0
     * <p>
     * Unless required by applicable law or agreed to in writing, software
     * distributed under the License is distributed on an "AS IS" BASIS,
     * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
     * See the License for the specific language governing permissions and
     * limitations under the License.
     */
    package com.edurt.service;
     
    import com.edurt.bean.Article;
    import com.edurt.repository.ArticleRepository;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.stereotype.Service;
     
    /**
     * ArticleServiceImpl <br/>
     * 描述 : ArticleServiceImpl <br/>
     * 作者 : qianmoQ <br/>
     * 版本 : 1.0 <br/>
     * 创建时间 : 2018-03-26 下午5:01 <br/>
     * 联系作者 : <a href="mailTo:shichengoooo@163.com">qianmoQ</a>
     */
    @Service(value = "articleService")
    public class ArticleServiceImpl implements ArticleService {
     
        @Autowired
        private ArticleRepository articleRepository;
     
        @Override
        public void createArticle(Article article) {
            articleRepository.createArticle(article);
        }
     
    }

创建API接口层Controller (在源码目录下创建controller文件夹, 并在该目录下创建ArticleController类文件)

    /**
     * Licensed to the Apache Software Foundation (ASF) under one
     * or more contributor license agreements.  See the NOTICE file
     * distributed with this work for additional information
     * regarding copyright ownership.  The ASF licenses this file
     * to you under the Apache License, Version 2.0 (the
     * "License"); you may not use this file except in compliance
     * with the License.  You may obtain a copy of the License at
     * <p>
     * http://www.apache.org/licenses/LICENSE-2.0
     * <p>
     * Unless required by applicable law or agreed to in writing, software
     * distributed under the License is distributed on an "AS IS" BASIS,
     * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
     * See the License for the specific language governing permissions and
     * limitations under the License.
     */
    package com.edurt.controller;
     
    import com.edurt.bean.Article;
    import com.edurt.service.ArticleService;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.web.bind.annotation.RequestBody;
    import org.springframework.web.bind.annotation.RequestMapping;
    import org.springframework.web.bind.annotation.RequestMethod;
    import org.springframework.web.bind.annotation.RestController;
     
    /**
     * ArticleController <br/>
     * 描述 : ArticleController <br/>
     * 作者 : qianmoQ <br/>
     * 版本 : 1.0 <br/>
     * 创建时间 : 2018-03-26 下午5:08 <br/>
     * 联系作者 : <a href="mailTo:shichengoooo@163.com">qianmoQ</a>
     */
    @RestController
    @RequestMapping(value = "article")
    public class ArticleController {
     
        @Autowired
        private ArticleService articleService;
     
        @RequestMapping(value = "create", method = RequestMethod.POST)
        String create(@RequestBody Article article) {
            articleService.createArticle(article);
            return "SUCCESS";
        }
     
    }

使用RestAPI测试工具测试添加数据我用的是PostMan软件

查看数据表是否已经写入该数据

小助手

标题：SpringBoot整合JDBC数据库操作-003-实现增加数据操作引发的争议

观点：
在SpringBoot整合JDBC数据库操作过程中，实现增加数据操作引发了一些争议。一方面，有人认为采用原生的JDBC方式操作数据库能够更加灵活、高效，因为可以直接控制SQL语句的编写和执行。另一方面，也有人提出使用ORM框架来简化数据库操作的代码，提高开发效率。

谁参与了讨论：
在这场讨论中，参与者主要包括具有不同经验和观点的开发者、架构师和数据库专家。一些参与者是传统的JDBC支持者，他们认为使用JDBC能够更好地掌控数据库操作的细节，尤其是在对性能和安全性有严格要求的场景下。

另一方面，也有一些参与者是ORM框架的拥护者。他们认为使用ORM框架可以简化开发流程，减少开发人员编写大量重复的数据库操作代码的时间和精力。ORM框架还提供了对数据库的映射和事务管理等功能，使得开发过程更加简单和高效。

讨论的争议主要集中在以下几个方面：

性能：JDBC支持者认为使用原生JDBC可以更好地控制数据库操作过程，提高性能。而ORM框架的支持者则认为，ORM框架提供的缓存和延迟加载等特性能够优化性能，而且现代的ORM框架已经在底层做了很多优化工作。
维护：JDBC支持者认为，使用原生JDBC可以更加直观地理解和维护代码，因为可以直接查看和修改SQL语句。而ORM框架的支持者则认为，使用ORM框架可以使得代码更加简洁和易于维护，减少了人为错误的可能性。
灵活性：JDBC支持者认为，使用原生JDBC可以更加灵活地处理复杂的数据库操作，因为可以直接控制SQL语句的执行。而ORM框架的支持者则认为，ORM框架的查询语言和API已经足够强大和灵活，可以应对绝大部分的数据库操作需求。

需要指出的是，争议的存在是好事，因为这可以促使开发者们思考和讨论各种技术选择的优缺点，最终选择适合自己项目需求的技术方案。无论是使用JDBC还是ORM框架，关键是根据实际情况权衡利弊，选择最合适的方式来实现实际的数据库操作。