<dependencies><!-- junit jar 包--><dependency><groupId>junit</groupId><artifactId>junit</artifactId><version>4.12</version></dependency><!-- spring jar 包--><dependency><groupId>org.springframework</groupId><artifactId>spring-context</artifactId><version>5.2.4.RELEASE</version></dependency><!-- spring 测试jar 包--><dependency><groupId>org.springframework</groupId><artifactId>spring-test</artifactId><version>5.2.4.RELEASE</version></dependency><!--spring管理的 jdbc ,以及事务相关的--><dependency><groupId>org.springframework</groupId><artifactId>spring-jdbc</artifactId><version>5.2.4.RELEASE</version></dependency><!--spring 事 务--><dependency><groupId>org.springframework</groupId><artifactId>spring-tx</artifactId><version>5.2.4.RELEASE</version></dependency><!--aspect切面编程 jar包--><dependency><groupId>org.aspectj</groupId><artifactId>aspectjweaver</artifactId><version>1.9.5</version></dependency><!-- c3p0连接池--><dependency><groupId>com.mchange</groupId><artifactId>c3p0</artifactId><version>0.9.5.2</version></dependency><!-- mybatis jar 包--><dependency><groupId>org.mybatis</groupId><artifactId>mybatis</artifactId><version>3.5.3</version></dependency><!-- mybatis与spring整合的核心jar包--><dependency><groupId>org.mybatis</groupId><artifactId>mybatis-spring</artifactId><version>2.0.3</version></dependency><!-- mysql 的驱动包--><dependency><groupId>mysql</groupId><artifactId>mysql-connector-java</artifactId><version>8.0.22</version></dependency><!--日志打印相关的jar--><dependency><groupId>org.slf4j</groupId><artifactId>slf4j-log4j12</artifactId><version>1.7.2</version></dependency><dependency><groupId>org.slf4j</groupId><artifactId>slf4j-api</artifactId><version>1.7.2</version></dependency></dependencies>
<?xml version="1.0" encoding="UTF-8" ?><!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd"><mappernamespace="com.dl.dao.UserDao"><!--通过用户名查询--><selectid="queryUserByName"parameterType="string"resultType="com.dl.po.User">
select user_id userId,user_name userName from t_user where user_name = #{userName}
</select><insertid="insertUser">
insert into t_user(user_id,user_name)values(#{userId},#{userName})
</insert></mapper>
1.8 相关代码
/*用户接口类*/publicinterfaceUserDao{public User queryUserByName(String userName);publicintinsertUser(User user);}
@ServicepublicclassUserService{@Resourceprivate UserDao userDao;/*
* 通过用户名查询用户对象,返回user对象
* */public User queryUserByName(String name){
User user = userDao.queryUserByName(name);return user;}publicintinsertUser(User user ){return userDao.insertUser(user);}}
@ControllerpublicclassUserController{@Resourceprivate UserService userService;public User queryByName(String uname){return userService.queryUserByName(uname);}publicintinsertUser(User user){return userService.insertUser(user);}}