Spring中jdbc工具类_spring jdbc工具类-优快云博客

本文链接：https://blog.youkuaiyun.com/qq_36943809/article/details/103500434

本文详细探讨了Spring框架中的JDBC工具类，包括其如何简化数据库操作，使用示例，以及与直接使用JDBC相比的优势。通过学习，读者将能够更好地理解和应用Spring JDBC进行数据访问。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

import Day01.Text03.Student;
import Day02.Text02.My_JdbcUtils;
import org.junit.jupiter.api.Test;
import org.springframework.jdbc.core.BeanPropertyRowMapper;
import org.springframework.jdbc.core.JdbcTemplate;

import java.beans.JavaBean;
import java.util.List;
import java.util.Map;

public class Deom {
    private static JdbcTemplate jdbcTemplate = new JdbcTemplate(My_JdbcUtils.getDataSource());
    private static String sql;

    @Test
    public void test1() {
        sql = "update student set Sname= ? where Sno = ?";
        int s = jdbcTemplate.update(sql, "李军", "101");
        System.out.println(s);
    }

    @Test
    public void test2() {
        sql = "select * from student";
        List<Map<String, Object>> maps = jdbcTemplate.queryForList(sql);
        for (Map<String, Object> list : maps) {
            System.out.println(list);
        }
    }

    @Test
    public void test3() {
        sql = "insert into  users values(?,?)";
        int s = jdbcTemplate.update(sql, "aiya", "zhen");
        System.out.println(s);
    }

    @Test
    public void test6() {
        sql = "select * from student";
        List<Student> list = jdbcTemplate.query(sql, new BeanPropertyRowMapper<Student>(Student.class));
        for (Student emp : list) {
            System.out.println(emp);
        }
    }
}