JDBCTemplate的基本使用方法

最新推荐文章于 2025-04-24 08:45:00 发布

解矣。

最新推荐文章于 2025-04-24 08:45:00 发布

阅读量346

点赞数

分类专栏： JAVA学习文章标签： mysql jdbc

本文链接：https://blog.youkuaiyun.com/qq_44939973/article/details/108607585

版权

JAVA学习专栏收录该内容

4 篇文章

订阅专栏

JDBCTemplate使用

1、添加Maven依赖

    <dependency>
        <groupId>commons-logging</groupId>
        <artifactId>commons-logging</artifactId>
        <version>1.2</version>
    </dependency>

    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-jdbc</artifactId>
        <version>5.1.2.RELEASE</version>
    </dependency>

    <!-- https://mvnrepository.com/artifact/org.junit.platform/junit-platform-launcher -->
    <dependency>
        <groupId>org.junit.platform</groupId>
        <artifactId>junit-platform-launcher</artifactId>
        <version>1.7.0</version>
        <scope>test</scope>
    </dependency>

2、创建对象

    JdbcTemplate template = new JdbcTemplate(JDBCUtils.getDataSource());

3、调用方法完成CRUD操作

1、update()：执行DML语句。增删改语句

@Test	//改
    public void test(){
        String sql = "update user set password = 666 where username = 'tom'"; 
        int count = template.update(sql);
        System.out.println(count);
    }

@Test	//增
    public void test(){
        String sql = "insert into user(username,password) values('Alice','77889')";
        int count = template.update(sql);
        System.out.println(count);
    }

@Test	//删
    public void test(){
        String sql = "delete from user where username = ?";
        int count = template.update(sql,"Alice");
        System.out.println(count);
    }

2、queryForMap()：将单一查询结果封装为map集合

	@Test
    public void test(){
        String sql = "select * from user where username = ?";
        Map<String, Object> tom = template.queryForMap(sql, "tom");
        System.out.println(tom);
    }

3、queryForList()：将查询结果集封装为list集合(包含多个map对象)

	@Test
    public void test(){
        String sql = "select * from user";
        List<Map<String, Object>> mapList = template.queryForList(sql);
        System.out.println(mapList);
    }

4、query()：将查询结果封装为JavaBean对象

    @Test
    public void test(){
        String sql = "select * from user";
        List<User> query = template.query(sql, new BeanPropertyRowMapper<>(User.class));
        System.out.println(query);
    }

5、queryForObject()：查询单一结果，将结果封装为对象

    @Test
    public void test(){
        String sql = "select count(*) from user";
        Long count = template.queryForObject(sql, Long.class);
        System.out.println(count);
    }