Spring.xml+jdbcTemplate完成CRUD
一、目录结构
二、代码详解
1、bean.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"xsi:schemaLocation="http://www.springframework.org/schema/beanshttp://www.springframework.org/schema/beans/spring-beans.xsdhttp://www.springframework.org/schema/contexthttp://www.springframework.org/schema/context/spring-context.xsd"><!--获取数据源配置文件--><context:property-placeholder location="classpath:db.properties"/><!--加载数据源--><bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource" destroy-method="close"><property name="driverClass" value="${jdbc.driverClass}"/><property name="JdbcUrl" value="${jdbc.jdbcUrl}"/><property name="user" value="${jdbc.user}"/><property name="password" value="${jdbc.password}"/></bean><!--创建JdbcTemplate--><bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate"><!--添加dataSource依赖/构造方法依赖注入--><constructor-arg name="dataSource" ref="dataSource"></constructor-arg></bean><!--创建userService--><bean id="userService" class="com.mollen.service.impl.UserServiceImpl"><!--添加userDao依赖/seteter依赖注入--><property name="userDao" ref="userDao"></property></bean><!--创建userDao--><bean id="userDao" class="com.mollen.dao.impl.UserDaoImpl"><!--添加jdbcTemplate依赖--><property name="jdbcTemplate" ref="jdbcTemplate"></property></bean></beans>
2.pom.xml
<?xml version="1.0" encoding="UTF-8"?><project xmlns="http://maven.apache.org/POM/4.0.0"xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd"><modelVersion>4.0.0</modelVersion><groupId>com.mollen</groupId><artifactId>spring_exam</artifactId><version>1.0-SNAPSHOT</version><dependencies><dependency><groupId>junit</groupId><artifactId>junit</artifactId><version>4.12</version></dependency><dependency><groupId>mysql</groupId><artifactId>mysql-connector-java</artifactId><version>5.1.38</version></dependency><dependency><groupId>org.springframework</groupId><artifactId>spring-jdbc</artifactId><version>5.0.2.RELEASE</version></dependency><dependency><groupId>c3p0</groupId><artifactId>c3p0</artifactId><version>0.9.1.2</version></dependency><dependency><groupId>org.springframework</groupId><artifactId>spring-context</artifactId><version>5.0.2.RELEASE</version></dependency></dependencies><build><plugins><plugin><groupId>org.apache.maven.plugins</groupId><artifactId>maven-compiler-plugin</artifactId><version>3.7.0</version><configuration><target>1.8</target><source>1.8</source></configuration></plugin></plugins></build>
3、数据库表：user
4、数据源配置：db.properties
jdbc.driverClass=com.mysql.jdbc.Driverjdbc.jdbcUrl=jdbc:mysql://localhost:3306/mybatis_day01jdbc.user=rootjdbc.password=root
5、service层
1、Userservice.java
package com.mollen.service;import com.mollen.bean.User;import java.util.Date;import java.util.List;/*** @ClassName: UserService* @Auther: Mollen* @CreateTime: 2018-11-03 19:40:55* @Description:*/public interface UserService {/*** 1.添加/更新用户*/public void addOrSaveUser(User user);/*** 2.删除用户*/public void removeUser(Integer id);/*** 3.根据id查询用户*/public User findById(Integer id);/*** 4.查询所有用户*/public List<User> findAll();}
2、UserserviceImpl.java
package com.mollen.service.impl;import com.mollen.bean.User;import com.mollen.dao.UserDao;import com.mollen.service.UserService;import java.util.List;/*** @ClassName: UserServiceImpl* @Auther: Mollen* @CreateTime: 2018-11-03 19:41:22* @Description:*/public class UserServiceImpl implements UserService{private UserDao userDao;public void setUserDao(UserDao userDao) {this.userDao = userDao;}@Overridepublic void addOrSaveUser(User user) {userDao.addOrSaveUser(user);}@Overridepublic void removeUser(Integer id) {userDao.removeUser(id);}@Overridepublic User findById(Integer id) {return userDao.findById(id);}@Overridepublic List<User> findAll() {return userDao.findAll();}}
6、dao层：
1、UserDao.java
package com.mollen.dao;import com.mollen.bean.User;import java.util.List;/*** @ClassName: UserDao* @Auther: Mollen* @CreateTime: 2018-11-03 19:40:36* @Description:*/public interface UserDao {/*** 1.添加/更新用户*/public void addOrSaveUser(User user);/*** 2.删除用户*/public void removeUser(Integer id);/*** 3.根据id查询用户*/public User findById(Integer id);/*** 4.全查用户*/public List<User> findAll();}
2、UserDaoImpl.java
package com.mollen.dao.impl;import com.mollen.bean.User;import com.mollen.dao.UserDao;import org.springframework.jdbc.core.BeanPropertyRowMapper;import org.springframework.jdbc.core.JdbcTemplate;import java.util.List;/*** @ClassName: UserDaoImpl* @Auther: Mollen* @CreateTime: 2018-11-03 19:41:46* @Description:*/public class UserDaoImpl implements UserDao {private JdbcTemplate jdbcTemplate;public void setJdbcTemplate(JdbcTemplate jdbcTemplate) {this.jdbcTemplate = jdbcTemplate;}@Overridepublic void addOrSaveUser(User user) {jdbcTemplate.update("INSERT INTO user VALUES (null,?,?,?,?)",user.getUsername(),user.getBirthday(),user.getSex(),user.getAddress());}@Overridepublic void removeUser(Integer id) {jdbcTemplate.update("DELETE FROM user where id = ?",id);}@Overridepublic User findById(Integer id) {try {return jdbcTemplate.queryForObject("SELECT * FROM user WHERE id = ?",new BeanPropertyRowMapper<User>(User.class), id);}catch (Exception e){e.printStackTrace();return null;}}@Overridepublic List<User> findAll() {return jdbcTemplate.query("select * from user",new BeanPropertyRowMapper<User>(User.class));}}
7、测试类:Test.java
package com.mollen.test;import com.mollen.bean.User;import com.mollen.service.UserService;import org.junit.After;import org.junit.Before;import org.junit.Test;import org.springframework.context.ApplicationContext;import org.springframework.context.support.ClassPathXmlApplicationContext;import java.text.ParseException;import java.text.SimpleDateFormat;import java.util.Date;import java.util.List;/*** @ClassName: test* @Auther: Mollen* @CreateTime: 2018-11-05 10:17:54* @Description:*/public class MyTest {private UserService userService;@Beforepublic void init(){//创建web容器ApplicationContext applicationContext = new ClassPathXmlApplicationContext("beans.xml");//获取业务层bean对象userService = (UserService) applicationContext.getBean("userService");}@Testpublic void test01(){List<User> users = userService.findAll();for (User user : users) {System.out.println(user);}}@Testpublic void test02(){User user = userService.findById(41);System.out.println(user);}@Testpublic void test03(){userService.removeUser(49);}@Testpublic void test04() throws ParseException {Date birthday = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").parse("2018-02-27 17:47:08");User user = new User();user.setUsername("里斯");user.setBirthday(birthday);user.setSex("男");user.setAddress("杭州");userService.addOrSaveUser(user);}@Afterpublic void destory(){}}
注：多数据源配置可以根据${ }里面的名字 和 db.properties配置文件里面的名字进行对应来区分
原文：https://blog.csdn.net/mollen/article/details/83748041
水深无声
àì夳堔傛蜴生んèń
港控/mmm°
还没有评论，来说两句吧...