{"id":2870,"date":"2022-12-23T21:09:48","date_gmt":"2022-12-23T13:09:48","guid":{"rendered":"https:\/\/qaqaq.top\/?p=2870"},"modified":"2023-01-01T17:44:14","modified_gmt":"2023-01-01T09:44:14","slug":"jdbctemplate","status":"publish","type":"post","link":"https:\/\/qaqaq.top\/?p=2870","title":{"rendered":"JdbcTemplate"},"content":{"rendered":"\n

JdbcTemplate(\u6982\u5ff5\u548c\u51c6\u5907)<\/h2>\n\n\n\n

1\u3001\u4ec0\u4e48\u662f JdbcTemplate<\/p>\n\n\n\n

\uff081\uff09Spring \u6846\u67b6\u5bf9 JDBC \u8fdb\u884c\u5c01\u88c5\uff0c\u4f7f\u7528 JdbcTemplate \u65b9\u4fbf\u5b9e\u73b0\u5bf9\u6570\u636e\u5e93\u64cd\u4f5c<\/p>\n\n\n\n

2\u3001\u51c6\u5907\u5de5\u4f5c<\/p>\n\n\n\n

\uff081\uff09\u5f15\u5165\u76f8\u5173 jar \u5305<\/p>\n\n\n\n

\"\"<\/div><\/figure>\n\n\n\n

\uff082\uff09\u5728 spring \u914d\u7f6e\u6587\u4ef6\u914d\u7f6e\u6570\u636e\u5e93\u8fde\u63a5\u6c60<\/p>\n\n\n\n

    <!-- \u76f4\u63a5\u914d\u7f6e\u8fde\u63a5\u6c60 -->\n    <bean id=\"dataSource\" class=\"com.alibaba.druid.pool.DruidDataSource\" destroy-method=\"close\">\n        <property name=\"driverClassName\" value=\"com.mysql.cj.jdbc.Driver\"><\/property>\n        <property name=\"url\" value=\"jdbc:mysql:\/\/localhost:3306\/user_db\"><\/property>\n        <property name=\"username\" value=\"root\"><\/property>\n        <property name=\"password\" value=\"123456\"><\/property>\n    <\/bean><\/code><\/pre>\n\n\n\n
\uff083\uff09\u914d\u7f6e JdbcTemplate \u5bf9\u8c61\uff0c\u6ce8\u5165 DataSource<\/p>\n\n\n\n
    <!-- JdbcTemplate\u5bf9\u8c61 -->\n    <bean id=\"jdbcTemplate\" class=\"org.springframework.jdbc.core.JdbcTemplate\">\n        <!-- \u6ce8\u5165dataSource -->\n        <property name=\"dataSource\" ref=\"dataSource\"><\/property>\n    <\/bean><\/code><\/pre>\n\n\n\n
\uff084\uff09\u521b\u5efa service \u7c7b\uff0c\u521b\u5efa dao \u7c7b\uff0c\u5728 dao \u6ce8\u5165 jdbcTemplate \u5bf9\u8c61<\/p>\n\n\n\n
\u914d\u7f6e\u6587\u4ef6<\/p>\n\n\n\n
    <!-- \u7ec4\u4ef6\u626b\u63cf -->\n    <context:component-scan base-package=\"top.qaqaq\"><\/context:component-scan><\/code><\/pre>\n\n\n\n
Service<\/p>\n\n\n\n
\/**\n * @author RichieZhang\n * @create 2022-12-23 18:33\n *\/\n\n@Service\npublic class BookService {\n\n    \/\/\u6ce8\u5165dao\n    @Autowired\n    private BookDao bookDao;\n}<\/code><\/pre>\n\n\n\n
Dao<\/p>\n\n\n\n
\/**\n * @author RichieZhang\n * @create 2022-12-23 18:33\n *\/\npublic interface BookDao {\n}<\/code><\/pre>\n\n\n\n
\/**\n * @author RichieZhang\n * @create 2022-12-23 18:34\n *\/\n\n@Repository\npublic class BookDaoImpl implements BookDao{\n\n    \/\/\u6ce8\u5165JdbcTemplate\n    @Autowired\n    private JdbcTemplate jdbcTemplate;\n}<\/code><\/pre>\n\n\n\n
JdbcTemplate \u64cd\u4f5c\u6570\u636e\u5e93\uff08\u6dfb\u52a0\uff09<\/h2>\n\n\n\n
package top.qaqaq.spring5.entity;\n\n\/**\n * @author RichieZhang\n * @create 2022-12-23 18:51\n *\/\npublic class Book {\n\n    private String userId;\n    private String username;\n    private String ustatus;\n\n    public String getUserId() {\n        return userId;\n    }\n\n    public void setUserId(String userId) {\n        this.userId = userId;\n    }\n\n    public String getUsername() {\n        return username;\n    }\n\n    public void setUsername(String username) {\n        this.username = username;\n    }\n\n    public String getUstatus() {\n        return ustatus;\n    }\n\n    public void setUstatus(String ustatus) {\n        this.ustatus = ustatus;\n    }\n\n    @Override\n    public String toString() {\n        return \"Book{\" +\n                \"userId='\" + userId + '\\'' +\n                \", username='\" + username + '\\'' +\n                \", ustatus='\" + ustatus + '\\'' +\n                '}';\n    }\n}\n<\/code><\/pre>\n\n\n\n
2\u3001\u7f16\u5199 service \u548c dao<\/p>\n\n\n\n
\uff081\uff09\u5728 dao \u8fdb\u884c\u6570\u636e\u5e93\u6dfb\u52a0\u64cd\u4f5c
\uff082\uff09\u8c03\u7528 JdbcTemplate \u5bf9\u8c61\u91cc\u9762 update \u65b9\u6cd5\u5b9e\u73b0\u6dfb\u52a0\u64cd\u4f5c<\/p>\n\n\n\n
\"\"<\/div><\/figure>\n\n\n\n
\u26ab \u6709\u4e24\u4e2a\u53c2\u6570
\u26ab \u7b2c\u4e00\u4e2a\u53c2\u6570\uff1asql \u8bed\u53e5
\u26ab \u7b2c\u4e8c\u4e2a\u53c2\u6570\uff1a\u53ef\u53d8\u53c2\u6570\uff0c\u8bbe\u7f6e sql \u8bed\u53e5\u503c<\/p>\n\n\n\n
    \/\/\u6dfb\u52a0\u7684\u65b9\u6cd5\n    public void addBook(Book book) {\n        bookDao.add(book);\n    }<\/code><\/pre>\n\n\n\n
    \/\/\u6dfb\u52a0\u7684\u65b9\u6cd5\n    void add(Book book);<\/code><\/pre>\n\n\n\n
    \/\/\u6dfb\u52a0\u7684\u65b9\u6cd5\n    @Override\n    public void add(Book book) {\n        \/\/1. \u521b\u5efasql\u8bed\u53e5\n        String sql = \"insert into t_book values(?,?,?)\";\n        \/\/2. \u8c03\u7528\u65b9\u6cd5\u5b9e\u73b0\n        Object[] args = {book.getUserId(), book.getUsername(), book.getUstatus()};\n        int update = jdbcTemplate.update(sql, args);\n        System.out.println(update);\n    }<\/code><\/pre>\n\n\n\n
3\u3001\u6d4b\u8bd5\u7c7b<\/p>\n\n\n\n
    @Test\n    public void testJdbcTemplate() {\n        ApplicationContext context = new ClassPathXmlApplicationContext(\"bean1.xml\");\n        BookService bookService = context.getBean(\"bookService\", BookService.class);\n\n        \/\/\u6dfb\u52a0\n        Book book = new Book();\n        book.setUserId(\"1\");\n        book.setUsername(\"java\");\n        book.setUstatus(\"a\");\n\n        bookService.addBook(book);\n}<\/code><\/pre>\n\n\n\n
\"\"<\/div><\/figure>\n\n\n\n
JdbcTemplate \u64cd\u4f5c\u6570\u636e\u5e93\uff08\u4fee\u6539\u548c\u5220\u9664\uff09<\/h2>\n\n\n\n
1\u3001\u4fee\u6539<\/p>\n\n\n\n
    public void updateBook(Book book) {\n        bookDao.updateBook(book);\n\n    }<\/code><\/pre>\n\n\n\n
    \/\/\u4fee\u6539\u7684\u65b9\u6cd5\n    void updateBook(Book book);<\/code><\/pre>\n\n\n\n
    \/\/\u4fee\u6539\u7684\u65b9\u6cd5\n    @Override\n    public void updateBook(Book book) {\n        String sql = \"update t_book set username = ?,ustatus = ? where user_id = ?\";\n        Object[] args = {book.getUsername(), book.getUstatus(), book.getUserId()};\n        int update = jdbcTemplate.update(sql, args);\n        System.out.println(update);\n    }<\/code><\/pre>\n\n\n\n
        \/\/\u4fee\u6539\n        Book book1 = new Book();\n        book1.setUserId(\"1\");\n        book1.setUsername(\"javaupup\");\n        book1.setUstatus(\"abc\");\n\n        bookService.updateBook(book1);<\/code><\/pre>\n\n\n\n
2\u3001\u5220\u9664<\/p>\n\n\n\n
   \/\/\u5220\u9664\u7684\u65b9\u6cd5\n    public void deleteBook(String id) {\n        bookDao.delete(id);\n    }<\/code><\/pre>\n\n\n\n
    \/\/\u5220\u9664\u7684\u65b9\u6cd5\n    void delete(String id);<\/code><\/pre>\n\n\n\n
    \/\/\u5220\u9664\u7684\u65b9\u6cd5\n    @Override\n    public void delete(String id) {\n        String sql = \"delete from t_book where user_id = ?\";\n        int update = jdbcTemplate.update(sql, id);\n        System.out.println(update);\n    }<\/code><\/pre>\n\n\n\n
        \/\/\u5220\u9664\n        bookService.deleteBook(\"1\");<\/code><\/pre>\n\n\n\n
JdbcTemplate \u64cd\u4f5c\u6570\u636e\u5e93\uff08\u67e5\u8be2\u8fd4\u56de\u67d0\u4e2a\u503c\uff09<\/h2>\n\n\n\n
1\u3001\u67e5\u8be2\u8868\u91cc\u9762\u6709\u591a\u5c11\u6761\u8bb0\u5f55\uff0c\u8fd4\u56de\u662f\u67d0\u4e2a\u503c
2\u3001\u4f7f\u7528 JdbcTemplate \u5b9e\u73b0\u67e5\u8be2\u8fd4\u56de\u67d0\u4e2a\u503c\u4ee3\u7801<\/p>\n\n\n\n
\"\"<\/div><\/figure>\n\n\n\n
\u26ab \u6709\u4e24\u4e2a\u53c2\u6570
\u26ab \u7b2c\u4e00\u4e2a\u53c2\u6570\uff1asql \u8bed\u53e5
\u26ab \u7b2c\u4e8c\u4e2a\u53c2\u6570\uff1a\u8fd4\u56de\u7c7b\u578b Class<\/p>\n\n\n\n
    \/\/\u67e5\u8be2\u8868\u8bb0\u5f55\u6570\n    public int findCount() {\n        return bookDao.selectCount();\n    }<\/code><\/pre>\n\n\n\n
    \/\/\u67e5\u8be2\u8868\u8bb0\u5f55\u6570\n    int selectCount();<\/code><\/pre>\n\n\n\n
   \/\/\u67e5\u8be2\u8868\u8bb0\u5f55\u6570\n    @Override\n    public int selectCount() {\n        String sql = \"select count(*) from t_book\";\n        Integer count = jdbcTemplate.queryForObject(sql, Integer.class);\n        return count;\n\n    }<\/code><\/pre>\n\n\n\n
        \/\/\u67e5\u8be2\u8fd4\u56de\u67d0\u4e2a\u503c\n        int count = bookService.findCount();\n        System.out.println(count);<\/code><\/pre>\n\n\n\n
JdbcTemplate \u64cd\u4f5c\u6570\u636e\u5e93\uff08\u67e5\u8be2\u8fd4\u56de\u5bf9\u8c61\uff09<\/h2>\n\n\n\n
1\u3001\u573a\u666f\uff1a\u67e5\u8be2\u56fe\u4e66\u8be6\u60c5
2\u3001JdbcTemplate \u5b9e\u73b0\u67e5\u8be2\u8fd4\u56de\u5bf9\u8c61<\/p>\n\n\n\n
\"\"<\/div><\/figure>\n\n\n\n
\u26ab \u6709\u4e09\u4e2a\u53c2\u6570
\u26ab \u7b2c\u4e00\u4e2a\u53c2\u6570\uff1asql \u8bed\u53e5
\u26ab \u7b2c\u4e8c\u4e2a\u53c2\u6570\uff1aRowMapper \u662f\u63a5\u53e3\uff0c\u9488\u5bf9\u8fd4\u56de\u4e0d\u540c\u7c7b\u578b\u6570\u636e\uff0c\u4f7f\u7528\u8fd9\u4e2a\u63a5\u53e3\u91cc\u9762\u5b9e\u73b0\u7c7b\u5b8c\u6210
\u6570\u636e\u5c01\u88c5
\u26ab \u7b2c\u4e09\u4e2a\u53c2\u6570\uff1asql \u8bed\u53e5\u503c<\/p>\n\n\n\n
    \/\/\u67e5\u8be2\u8fd4\u56de\u5bf9\u8c61\n    public Book findOne(String id) {\n        return bookDao.findBookInfo(id);\n    }<\/code><\/pre>\n\n\n\n
    \/\/\u67e5\u8be2\u8fd4\u56de\u5bf9\u8c61\n    Book findBookInfo(String id);<\/code><\/pre>\n\n\n\n
    \/\/\u67e5\u8be2\u8fd4\u56de\u5bf9\u8c61\n    @Override\n    public Book findBookInfo(String id) {\n        String sql = \"select * from t_book where user_id = ?\";\n        \/\/\u8c03\u7528\u65b9\u6cd5\n        Book book = jdbcTemplate.queryForObject(sql, new BeanPropertyRowMapper<Book>(Book.class), id);\n        return book;\n    }<\/code><\/pre>\n\n\n\n
        \/\/\u67e5\u8be2\u8fd4\u56de\u5bf9\u8c61\n        Book book = bookService.findOne(\"1\");\n        System.out.println(book);<\/code><\/pre>\n\n\n\n
JdbcTemplate \u64cd\u4f5c\u6570\u636e\u5e93\uff08\u67e5\u8be2\u8fd4\u56de\u96c6\u5408\uff09<\/h2>\n\n\n\n
1\u3001\u573a\u666f\uff1a\u67e5\u8be2\u56fe\u4e66\u5217\u8868\u5206\u9875\u2026
2\u3001\u8c03\u7528 JdbcTemplate \u65b9\u6cd5\u5b9e\u73b0\u67e5\u8be2\u8fd4\u56de\u96c6\u5408<\/p>\n\n\n\n
\"\"<\/div><\/figure>\n\n\n\n
\u26ab \u6709\u4e09\u4e2a\u53c2\u6570
\u26ab \u7b2c\u4e00\u4e2a\u53c2\u6570\uff1asql \u8bed\u53e5
\u26ab \u7b2c\u4e8c\u4e2a\u53c2\u6570\uff1aRowMapper \u662f\u63a5\u53e3\uff0c\u9488\u5bf9\u8fd4\u56de\u4e0d\u540c\u7c7b\u578b\u6570\u636e\uff0c\u4f7f\u7528\u8fd9\u4e2a\u63a5\u53e3\u91cc\u9762\u5b9e\u73b0\u7c7b\u5b8c\u6210
\u6570\u636e\u5c01\u88c5
\u26ab \u7b2c\u4e09\u4e2a\u53c2\u6570\uff1asql \u8bed\u53e5\u503c<\/p>\n\n\n\n
    \/\/\u67e5\u8be2\u8fd4\u56de\u96c6\u5408\n    public List<Book> findAll() {\n        return bookDao.findAllBook();\n    }<\/code><\/pre>\n\n\n\n
    \/\/\u67e5\u8be2\u8fd4\u56de\u96c6\u5408\n    List<Book> findAllBook();<\/code><\/pre>\n\n\n\n
    \/\/\u67e5\u8be2\u8fd4\u56de\u96c6\u5408\n    @Override\n    public List<Book> findAllBook() {\n        String sql = \"select * from t_book\";\n        List<Book> bookList = jdbcTemplate.query(sql, new BeanPropertyRowMapper<Book>(Book.class));\n        return bookList;\n    }<\/code><\/pre>\n\n\n\n
        \/\/\u67e5\u8be2\u8fd4\u56de\u96c6\u5408\n        List<Book> all = bookService.findAll();\n        System.out.println(all);<\/code><\/pre>\n\n\n\n
JdbcTemplate \u64cd\u4f5c\u6570\u636e\u5e93\uff08\u6279\u91cf\u64cd\u4f5c\uff09<\/h2>\n\n\n\n
1\u3001\u6279\u91cf\u64cd\u4f5c\uff1a\u64cd\u4f5c\u8868\u91cc\u9762\u591a\u6761\u8bb0\u5f55
2\u3001JdbcTemplate \u5b9e\u73b0\u6279\u91cf\u6dfb\u52a0\u64cd\u4f5c<\/p>\n\n\n\n
\"\"<\/div><\/figure>\n\n\n\n
\u26ab \u6709\u4e24\u4e2a\u53c2\u6570
\u26ab \u7b2c\u4e00\u4e2a\u53c2\u6570\uff1asql \u8bed\u53e5
\u26ab \u7b2c\u4e8c\u4e2a\u53c2\u6570\uff1aList \u96c6\u5408\uff0c\u6dfb\u52a0\u591a\u6761\u8bb0\u5f55\u6570\u636e<\/p>\n\n\n\n
    \/\/\u6279\u91cf\u6dfb\u52a0\n    public void batchAdd(List<Object[]> batchArgs) {\n        bookDao.batchAddBook(batchArgs);\n\n    }<\/code><\/pre>\n\n\n\n
    \/\/\u6279\u91cf\u6dfb\u52a0\n    void batchAddBook(List<Object[]> batchArgs);<\/code><\/pre>\n\n\n\n
    \/\/\u6279\u91cf\u6dfb\u52a0\n    @Override\n    public void batchAddBook(List<Object[]> batchArgs) {\n        String sql = \"insert into t_book values(?,?,?)\";\n        int[] ints = jdbcTemplate.batchUpdate(sql, batchArgs);\n        System.out.println(Arrays.toString(ints));\n    }<\/code><\/pre>\n\n\n\n
        \/\/\u6279\u91cf\u6dfb\u52a0\u6d4b\u8bd5\n        List<Object[]> batchArgs = new ArrayList<>();\n        Object[] o1 = {\"3\",\"java\",\"a\"};\n        Object[] o2 = {\"4\",\"c++\",\"b\"};\n        Object[] o3 = {\"5\",\"MySQL\",\"c\"};\n        batchArgs.add(o1);\n        batchArgs.add(o2);\n        batchArgs.add(o3);\n        \/\/\u8c03\u7528\u6279\u91cf\u6dfb\u52a0\n        bookService.batchAdd(batchArgs);<\/code><\/pre>\n\n\n\n
3\u3001JdbcTemplate \u5b9e\u73b0\u6279\u91cf\u4fee\u6539\u64cd\u4f5c<\/p>\n\n\n\n
    \/\/\u6279\u91cf\u4fee\u6539\n    public void batchUpdate(List<Object []> batchArgs) {\n        bookDao.batchUpdateBook(batchArgs);\n    }<\/code><\/pre>\n\n\n\n
    \/\/\u6279\u91cf\u4fee\u6539\n    void batchUpdateBook(List<Object[]> batchArgs);<\/code><\/pre>\n\n\n\n
    \/\/\u6279\u91cf\u4fee\u6539\n    @Override\n    public void batchUpdateBook(List<Object[]> batchArgs) {\n        String sql = \"update t_book set username = ?,ustatus = ? where user_id = ?\";\n        int[] ints = jdbcTemplate.batchUpdate(sql, batchArgs);\n        System.out.println(Arrays.toString(ints));\n    }<\/code><\/pre>\n\n\n\n
        \/\/\u6279\u91cf\u4fee\u6539\n        List<Object[]> batchArgs = new ArrayList<>();\n        Object[] o1 = {\"java1\",\"a3\",\"3\"};\n        Object[] o2 = {\"c++2\",\"b4\",\"4\"};\n        Object[] o3 = {\"MySQL3\",\"c5\",\"5\"};\n        batchArgs.add(o1);\n        batchArgs.add(o2);\n        batchArgs.add(o3);\n        \/\/\u8c03\u7528\u65b9\u6cd5\u5b9e\u73b0\u6279\u91cf\u4fee\u6539\n        bookService.batchUpdate(batchArgs);<\/code><\/pre>\n\n\n\n
4\u3001JdbcTemplate \u5b9e\u73b0\u6279\u91cf\u5220\u9664\u64cd\u4f5c<\/p>\n\n\n\n
    \/\/\u6279\u91cf\u5220\u9664\n    public void batchDelete(List<Object []> batchArgs) {\n        bookDao.batchDeleteBook(batchArgs);\n    }<\/code><\/pre>\n\n\n\n
    \/\/\u6279\u91cf\u5220\u9664\n    void batchDeleteBook(List<Object[]> batchArgs);<\/code><\/pre>\n\n\n\n
    \/\/\u6279\u91cf\u5220\u9664\n    @Override\n    public void batchDeleteBook(List<Object[]> batchArgs) {\n        String sql = \"delete from t_book where user_id = ?\";\n        int[] ints = jdbcTemplate.batchUpdate(sql, batchArgs);\n        System.out.println(Arrays.toString(ints));\n    }<\/code><\/pre>\n\n\n\n
        \/\/\u6279\u91cf\u5220\u9664\n        List<Object[]> batchArgs = new ArrayList<>();\n        Object[] o1 = {\"3\"};\n        Object[] o2 = {\"4\"};\n        Object[] o3 = {\"5\"};\n        batchArgs.add(o1);\n        batchArgs.add(o2);\n        batchArgs.add(o3);\n        \/\/ \u8c03\u7528\u65b9\u6cd5\u5b9e\u73b0\u6279\u91cf\u5220\u9664\n        bookService.batchDelete(batchArgs);<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"
JdbcTemplate(\u6982\u5ff5\u548c\u51c6\u5907) 1\u3001\u4ec0\u4e48\u662f JdbcTemplate \uff081\uff09Spring \u6846\u67b6\u5bf9 JD […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[102],"tags":[113],"class_list":["post-2870","post","type-post","status-publish","format-standard","hentry","category-spring-code","tag-spring"],"_links":{"self":[{"href":"https:\/\/qaqaq.top\/index.php?rest_route=\/wp\/v2\/posts\/2870"}],"collection":[{"href":"https:\/\/qaqaq.top\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/qaqaq.top\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/qaqaq.top\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/qaqaq.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2870"}],"version-history":[{"count":2,"href":"https:\/\/qaqaq.top\/index.php?rest_route=\/wp\/v2\/posts\/2870\/revisions"}],"predecessor-version":[{"id":3071,"href":"https:\/\/qaqaq.top\/index.php?rest_route=\/wp\/v2\/posts\/2870\/revisions\/3071"}],"wp:attachment":[{"href":"https:\/\/qaqaq.top\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2870"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/qaqaq.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2870"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/qaqaq.top\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2870"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}