SSM框架之Spring层–》业务层框架
环境:jdk 1.8 mysql 8.0.20 maven 3.6.3 mybatis 3.5.2
-
创建数据库
create table User_msg( User_id int not null primary key, User_name varchar(40), User_sex varchar(10), User_email varchar(40), User_number varchar(40) ) insert into User_msg(User_id,User_name,User_sex,User_email,User_number) values (1,'小明','男','1767471@qq.com','12345611'), (2,'花花','男','1762427@qq.com','12345632'), (3,'亮亮','男','176743@qq.com','12345612'), (4,'小光','男','1767447@qq.com','12345634'), (5,'小妹','男','1767457@qq.com','12345654'), (6,'莹莹','男','1767467@qq.com','12345655'), (7,'喜喜','男','1767467@qq.com','11234421')
-
打开idea新建一个maven项目
[外链图片转存失败,源站可能有防盗链机制,建议将图片保存下来直接上传(img-xp4sH9EF-1605800063189)(D:\桌面\笔记\书城项目\mybatis层.assets\image-20201031020053386.png)]
-
导入项目依赖
<!--Junit--> <dependency> <groupId>junit</groupId> <artifactId>junit</artifactId> <version>4.12</version> </dependency> <!--数据库驱动--> <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <version>5.1.47</version> </dependency> <!-- 数据库连接池 --> <dependency> <groupId>com.mchange</groupId> <artifactId>c3p0</artifactId> <version>0.9.5.2</version> </dependency> <!--Servlet - JSP --> <dependency> <groupId>javax.servlet</groupId> <artifactId>servlet-api</artifactId> <version>2.5</version> </dependency> <dependency> <groupId>javax.servlet.jsp</groupId> <artifactId>jsp-api</artifactId> <version>2.2</version> </dependency> <dependency> <groupId>javax.servlet</groupId> <artifactId>jstl</artifactId> <version>1.2</version> </dependency> <!--Mybatis--> <dependency> <groupId>org.mybatis</groupId> <artifactId>mybatis</artifactId> <version>3.5.2</version> </dependency> <dependency> <groupId>org.mybatis</groupId> <artifactId>mybatis-spring</artifactId> <version>2.0.2</version> </dependency> <!--Spring--> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-webmvc</artifactId> <version>5.1.9.RELEASE</version> </dependency> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-jdbc</artifactId> <version>5.1.9.RELEASE</version> </dependency> <dependency> <groupId>org.projectlombok</groupId> <artifactId>lombok</artifactId> <version>1.16.10</version> </dependency>
-
配置资源过滤器
<!--配置资源过滤器--> <build> <resources> <resource> <directory>src/main/java</directory> <includes> <include>**/*.properties</include> <include>**/*.xml</include> </includes> <filtering>false</filtering> </resource> <resource> <directory>src/main/resources</directory> <includes> <include>**/*.properties</include> <include>**/*.xml</include> </includes> <filtering>false</filtering> </resource> </resources> </build>
com.liang.dao
- UserMapper
package com.liang.dao; import com.liang.pojo.UserMessage; import java.util.List; public interface UserMapper { UserMessage queryUserById(int id); List<UserMessage> queryAllUser(); }
- UserMapper.xml
<?xml version="1.0" encoding="UTF-8" ?> <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> <mapper namespace="com.liang.dao.UserMapper"> <!--根据id查询,返回一个Book--> <select id="queryUserById" resultType="UserMessage"> select * from bookstore.user_msg where User_id = #{User_id} </select> <!--查询全部Book--> <select id="queryAllUser" resultType="UserMessage"> SELECT * from bookstore.user_msg </select> </mapper>
com.liang.pojo
- UserMessage
package com.liang.pojo;
public class UserMessage {
private int User_id;
private String User_name;
private String User_sex;
private String User_email;
private String User_number;
public UserMessage() {
}
public UserMessage(int user_id, String user_name, String user_sex, String user_email, String user_number) {
User_id = user_id;
User_name = user_name;
User_sex = user_sex;
User_email = user_email;
User_number = user_number;
}
public int getUser_id() {
return User_id;
}
public void setUser_id(int user_id) {
User_id = user_id;
}
public String getUser_name() {
return User_name;
}
public void setUser_name(String user_name) {
User_name = user_name;
}
public String getUser_sex() {
return User_sex;
}
public void setUser_sex(String user_sex) {
User_sex = user_sex;
}
public String getUser_email() {
return User_email;
}
public void setUser_email(String user_email) {
User_email = user_email;
}
public String getUser_number() {
return User_number;
}
public void setUser_number(String user_number) {
User_number = user_number;
}
@Override
public String toString() {
return "UserMessage{" +
"User_id=" + User_id +
", User_name='" + User_name + '\'' +
", User_sex='" + User_sex + '\'' +
", User_email='" + User_email + '\'' +
", User_number='" + User_number + '\'' +
'}';
}
}
com.liang.service
- UserService接口
package com.liang.service;
import com.liang.dao.UserMapper;
import com.liang.pojo.UserMessage;
import java.util.List;
public interface UserService {
UserMessage queryUserById(int id);
List<UserMessage> queryAllUser();
}
- UserServiceImpl.xml
package com.liang.service;
import com.liang.dao.UserMapper;
import com.liang.pojo.UserMessage;
import java.util.List;
public class UserServiceImpl implements UserService{
private UserMapper userMapper;
public void setUserMapper(UserMapper userMapper) {
this.userMapper = userMapper;
}
@Override
public UserMessage queryUserById(int id) {
return userMapper.queryUserById(id);
}
@Override
public List<UserMessage> queryAllUser() {
return userMapper.queryAllUser();
}
}
resources目录下
- applicationContext.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/beans
http://www.springframework.org/schema/beans/spring-beans.xsd http://www.springframework.org/schema/context https://www.springframework.org/schema/context/spring-context.xsd">
<import resource="classpath:spring-dao.xml"/>
<import resource="classpath:spring-service.xml"/>
</beans>
- database.properties
jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/ssmbuild?useSSL=false&useUnicode=true&characterEncoding=utf8
jdbc.username=root
jdbc.password=1234
- mybatis-config.xml
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration
PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
<!--取别名-->
<typeAliases>
<package name="com.liang.pojo"/>
</typeAliases>
<mappers>
<!-- <mapper resource="com/liang/dao/UserMapper.xml"></mapper>-->
<mapper class="com.liang.dao.UserMapper"></mapper>
<!-- <package name="com.liang.dao"/>-->
</mappers>
<!--去掉了原来的数据库环境-->
</configuration>
- spring-dao.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/beans
http://www.springframework.org/schema/beans/spring-beans.xsd
http://www.springframework.org/schema/context
https://www.springframework.org/schema/context/spring-context.xsd">
<!--关联一下数据库文件-->
<context:property-placeholder location="database.properties"></context:property-placeholder>
<!--数据库连接池-->
<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
<property name="driverClass" value="${jdbc.driver}"/>
<property name="jdbcUrl" value="${jdbc.url}"/>
<property name="user" value="${jdbc.username}"/>
<property name="password" value="${jdbc.password}"/>
<!--私有属性-->
<!-- c3p0连接池的私有属性 -->
<property name="maxPoolSize" value="30"/>
<property name="minPoolSize" value="10"/>
<!-- 关闭连接后不自动commit -->
<property name="autoCommitOnClose" value="false"/>
<!-- 获取连接超时时间 -->
<property name="checkoutTimeout" value="10000"/>
<!-- 当获取连接失败重试次数 -->
<property name="acquireRetryAttempts" value="2"/>
</bean>
<!--配置SqlSessionFactory对象-->
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<!-- 注入数据库连接池 -->
<property name="dataSource" ref="dataSource"/>
<!-- 配置MyBaties全局配置文件:mybatis-config.xml -->
<property name="configLocation" value="classpath:mybatis-config.xml"/>
</bean>
<!-- 4.配置扫描Dao接口包,动态实现Dao接口注入到spring容器中 -->
<!--解释 :https://www.cnblogs.com/jpfss/p/7799806.html-->
<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<!-- 注入sqlSessionFactory -->
<property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/>
<!-- 给出需要扫描Dao接口包 -->
<property name="basePackage" value="com.liang.dao"/>
</bean>
</beans>
- spring-service.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/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">
<!--扫描service相关的bean-->
<context:component-scan base-package="com.liang.service"></context:component-scan>
<!--UserServiceImpl注入到ioc容器中-->
<bean id="UserServiceImpl" class="com.liang.service.UserServiceImpl">
<property name="userMapper" ref="userMapper"></property>
</bean>
<!--s配置事务管理-->
<bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource" ref="dataSource"></property>
</bean>
</beans>