ToB企服应用市场:ToB评测及商务社交产业平台

标题: Spring5——JdbcTemplate笔记 [打印本页]

作者: 半亩花草 时间: 2022-6-24 03:11
标题: Spring5——JdbcTemplate笔记
Spring5——JdbcTemplate笔记

概念

template，翻译过来是模板的意思，顾名思义，JdbcTemplate就是一个JDBC的模板，它对JDBC进行了封装，可以很方便地实现对数据库的CRUD（增、删、改、查）的操作。
JdbcTemplate准备工作

引入相关的依赖

druid-1.1.9.jar
mysql-connector-java-5.1.7-bin.jar
spring-tx-5.2.6.RELEASE.jar
spring-orm-5.2.6.RELEASE.jar
在这里要注意相关jar包的版本，比如说Java连接MySQL的驱动包的版本应该与目的数据库的版本一致

配置数据库连接池、在JdbcTemplate对象中注入DataSource（数据源）

这里用xml配置文件来配置相关的信息

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:context="http://www.springframework.org/schema/context"
xmlns:aop="http://www.springframework.org/schema/aop"
xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd
http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd
http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop.xsd">
<context:component-scan base-package="com.ws.spring"></context:component-scan>
<bean id="dataSource"
destroy-method="close">
<property name="url" value="jdbc:mysql:///study" />
<property name="username" value="root" />
<property name="password" value="123" />
<property name="driverClassName" value="com.mysql.jdbc.Driver" />
</bean>
<bean id="jdbcTemplate" >
<property name="dataSource" ref="dataSource"></property>
</bean>
</beans>

复制代码

JdbcTemplate的使用

创建service类、创建dao类

package com.spring.service;
// service类
@Service
public class UserService {
}

复制代码

package com.spring.dao;
// dao类
public interface UserDao {
}

复制代码

package com.spring.dao;
// dao的实现类
@Repository
public class UserDaoImpl implements UserDao {
}

复制代码

在service类中注入dao类的对象属性

package com.spring.service;
@Service
public class UserService {
//注入dao对象
@Autowired
private UserDao userDao;
}

复制代码

在dao类中注入JdbcTemplate对象

package com.spring.dao;
@Repository
public class UserDaoImpl implements UserDao {
//注入jdbcTemplate对象
@Autowired
private JdbcTemplate jdbcTemplate;
}

复制代码

增删改查

实体类
1. package com.spring.entiey;
3. public class User {
4. private Integer id;
5. private String name;
6. private Integer age;
7. private String email;
9. public User() {
10. }
12. public User(Integer id, String name, Integer age, String email) {
13. this.id = id;
14. this.name = name;
15. this.age = age;
16. this.email = email;
17. }
19. @Override
20. public String toString() {
21. return "User{" +
22. "id=" + id +
23. ", name='" + name + '\'' +
24. ", age=" + age +
25. ", email='" + email + '\'' +
26. '}';
27. }
29. public Integer getId() {
30. return id;
31. }
33. public void setId(Integer id) {
34. this.id = id;
35. }
37. public String getName() {
38. return name;
39. }
41. public void setName(String name) {
42. this.name = name;
43. }
45. public Integer getAge() {
46. return age;
47. }
49. public void setAge(Integer age) {
50. this.age = age;
51. }
53. public String getEmail() {
54. return email;
55. }
57. public void setEmail(String email) {
58. this.email = email;
59. }
60. }
复制代码
UserDao
1. package com.spring.dao;
3. public interface UserDao {
4. //添加的方法
5. void add(User user);
7. //修改的方法
8. void updateUser(User user);
10. //删除的方法
11. void deleteUser(int id);
13. //查询表记录数
14. int selectCount();
16. //查询返回对象
17. User findUserInfo(int id);
19. //查询返回集合
20. List<User> findAllUser();
22. //批量添加数据
23. void batchAddUser(List<Object[]> batchArgs);
24. }
复制代码
UserDaoImpl
1. package com.spring.dao;
3. @Repository
4. public class UserDaoImpl implements UserDao {
5. //注入jdbcTemplate对象
6. @Autowired
7. private JdbcTemplate jdbcTemplate;
9. @Override
10. public void add(User user) {
11. //用jdbcTemplate来操作数据库
12. String sql = "insert into userinfo values (?,?,?,?)";
13. Object[] args = {user.getId(),user.getName(),user.getAge(),user.getEmail()};
14. int update = jdbcTemplate.update(sql,args);
15. System.out.println(update);
16. }
18. @Override
19. public void updateUser(User user) {
20. String sql = "update userinfo set name=? where id=?";
21. Object[] args = {user.getName(),user.getId()};
22. int update = jdbcTemplate.update(sql, args);
23. System.out.println("修改了："+update);
24. }
26. @Override
27. public void deleteUser(int id) {
28. String sql = "delete from userinfo where id=?";
29. int update = jdbcTemplate.update(sql, id);
30. System.out.println("删除了："+update);
31. }
33. //查询表中的记录数
34. @Override
35. public int selectCount() {
36. String sql = "select count(*) from userinfo";
37. Integer count = jdbcTemplate.queryForObject(sql, Integer.class);
38. return count;
39. }
41. //查询返回对象
42. @Override
43. public User findUserInfo(int id) {
44. String sql = "select * from userinfo where id=?";
45. User user = jdbcTemplate.queryForObject(sql, new BeanPropertyRowMapper<User>(User.class), id);
46. return user;
47. }
49. //查询返回集合
50. @Override
51. public List<User> findAllUser() {
52. String sql = "select * from userinfo";
53. List<User> users = jdbcTemplate.query(sql, new BeanPropertyRowMapper<User>(User.class));
54. return users;
55. }
57. //批量添加
58. @Override
59. public void batchAddUser(List<Object[]> batchArgs) {
60. String sql = "insert into userinfo values (?,?,?,?)";
61. int[] ints = jdbcTemplate.batchUpdate(sql, batchArgs);
62. System.out.println(Arrays.toString(ints));
63. }
66. }
复制代码
UserService
1. package com.spring.service;
3. @Service
4. public class UserService {
5. //注入dao对象
6. @Autowired
7. private UserDao userDao;
10. //添加数据的方法
11. public void addUser(User user){
12. userDao.add(user);
13. }
15. //修改数据的方法
16. public void updateUser(User user){
17. userDao.updateUser(user);
18. }
20. //删除数据的方法
21. public void deleteUser(int id){
22. userDao.deleteUser(id);
23. }
25. //查询表中记录数
26. public int findCount(){
27. int count = userDao.selectCount();
28. return count;
29. }
31. //查询返回对象
32. public User findOne(int id){
33. User userInfo = userDao.findUserInfo(id);
34. return userInfo;
35. }
37. //查询返回集合
38. public List<User> findAll(){
39. return userDao.findAllUser();
40. }
42. //批量添加数据
43. public void batchAdd(List<Object[]> batchArgs){
44. userDao.batchAddUser(batchArgs);
45. }
46. }
复制代码
测试类
1. package com.spring.testdemo;
3. @SuppressWarnings({"all"})
4. public class TestSpringDemo {
6. //添加单条数据
7. @Test
8. public void testAdd(){
9. ApplicationContext context =
10. new ClassPathXmlApplicationContext("bean.xml");
12. UserService userService = context.getBean("userService", UserService.class);
14. User user = new User();
15. user.setName("111");
16. user.setId(10);
17. user.setAge(18);
18. user.setEmail("shuaiwang2019@126.com");
19. System.out.println("user= "+user);
21. userService.addUser(user);
22. }
24. //修改单条数据
25. @Test
26. public void testUpdate(){
27. ApplicationContext context =
28. new ClassPathXmlApplicationContext("bean.xml");
30. UserService userService = context.getBean("userService", UserService.class);
32. User user = new User();
33. user.setName("test");
34. user.setId(1);
35. System.out.println("user= "+user);
37. userService.updateUser(user);
38. }
40. //删除单条数据
41. @Test
42. public void testDelete(){
43. ApplicationContext context =
44. new ClassPathXmlApplicationContext("bean.xml");
46. UserService userService = context.getBean("userService", UserService.class);
48. userService.deleteUser(1);
49. }
51. }
复制代码
1. package com.spring.testdemo;
3. public class TestJdbcTemplateSelect {
5. //查询记录数
6. @Test
7. public void testSelectCount(){
8. ApplicationContext context =
9. new ClassPathXmlApplicationContext("bean.xml");
11. UserService userService = context.getBean("userService", UserService.class);
13. int count = userService.findCount();
14. System.out.println(count);
15. }
17. //查询返回对象
18. @Test
19. public void testSelectUserInfo(){
20. ApplicationContext context =
21. new ClassPathXmlApplicationContext("bean.xml");
23. UserService userService = context.getBean("userService", UserService.class);
25. User userInfo = userService.findOne(10);
26. System.out.println(userInfo);
27. }
29. //查询返回集合
30. @Test
31. public void testSelectAll(){
32. ApplicationContext context =
33. new ClassPathXmlApplicationContext("bean.xml");
35. UserService userService = context.getBean("userService", UserService.class);
37. List<User> users = userService.findAll();
39. System.out.println(users);
40. }
42. //批量添加
43. @Test
44. public void testBatchAdd(){
45. ApplicationContext context =
46. new ClassPathXmlApplicationContext("bean.xml");
48. UserService userService = context.getBean("userService", UserService.class);
50. //要添加的集合
51. List<Object[]> batchArgs = new ArrayList<>();
52. Object[] o1 = {11,"java",24,"java@126.com"};
53. Object[] o2 = {12,"python",30,"python@126.com"};
54. Object[] o3 = {13,"c++",40,"c++@126.com"};
55. batchArgs.add(o1);
56. batchArgs.add(o2);
57. batchArgs.add(o3);
58. userService.batchAdd(batchArgs);
59. }
61. }
复制代码

免责声明：如果侵犯了您的权益，请联系站长，我们会及时删除侵权内容，谢谢合作！

欢迎光临 ToB企服应用市场:ToB评测及商务社交产业平台 (https://dis.qidao123.com/)