下面的内容随着学习会不断更新的哇,不要捉急 ·_·
1.新建一个工程或者Module(此处以Module为例)
新建步骤在上面的博文已经介绍过,此处不再赘述。
2.搭建项目文件结构框架
3.编辑配置文件
3.1配置pom.xml文件
- 各种jar包及maven依赖寻找地: http://repository.sonatype.org/
- 常用的一些依赖
<properties>
<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
<maven.compiler.source>1.7</maven.compiler.source>
<maven.compiler.target>1.7</maven.compiler.target>
<!-- spring版本号 -->
<spring.version>4.0.2.RELEASE</spring.version>
<!-- mybatis版本号 -->
<mybatis.version>3.2.6</mybatis.version>
<!-- log4j日志文件管理包版本 -->
<slf4j.version>1.7.7</slf4j.version>
<log4j.version>1.2.17</log4j.version>
</properties>
<dependencies>
<!-- 测试包 -->
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>4.11</version>
<scope>test</scope>
</dependency>
<!-- spring核心包 -->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-core</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-oxm</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-tx</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-jdbc</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-aop</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-context-support</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-test</artifactId>
<version>${spring.version}</version>
</dependency>
<!--springmvc包-->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-webmvc</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-web</artifactId>
<version>${spring.version}</version>
</dependency>
<!-- mybatis核心包 -->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>${mybatis.version}</version>
</dependency>
<!-- mybatis/spring包 -->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis-spring</artifactId>
<version>1.2.2</version>
</dependency>
<!-- 导入java ee jar 包 -->
<dependency>
<groupId>javax</groupId>
<artifactId>javaee-api</artifactId>
<version>7.0</version>
</dependency>
<!-- 导入Mysql数据库链接jar包 -->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.30</version>
</dependency>
<!-- 导入dbcp的jar包,用来在applicationContext.xml中配置数据库 -->
<dependency>
<groupId>commons-dbcp</groupId>
<artifactId>commons-dbcp</artifactId>
<version>1.2.2</version>
</dependency>
<!-- JSTL标签类 -->
<dependency>
<groupId>jstl</groupId>
<artifactId>jstl</artifactId>
<version>1.2</version>
</dependency>
<!--c3p0连接池-->
<dependency>
<groupId>c3p0</groupId>
<artifactId>c3p0</artifactId>
<version>0.9.1.2</version>
</dependency>
<!--通用Mapper相关的jar包-->
<dependency>
<groupId>com.github.abel533</groupId>
<artifactId>mapper</artifactId>
<version>2.3.4</version>
</dependency>
<dependency>
<groupId>com.github.jsqlparser</groupId>
<artifactId>jsqlparser</artifactId>
<version>0.9.5</version>
</dependency>
<dependency>
<groupId>com.github.pagehelper</groupId>
<artifactId>pagehelper</artifactId>
<version>5.0.0</version>
</dependency>
<dependency>
<groupId>javax.persistence</groupId>
<artifactId>persistence-api</artifactId>
<version>1.0</version>
</dependency>
<!-- 日志文件管理包 -->
<!-- log start -->
<dependency>
<groupId>log4j</groupId>
<artifactId>log4j</artifactId>
<version>${log4j.version}</version>
</dependency>
<!-- 格式化对象,方便输出日志 -->
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>fastjson</artifactId>
<version>1.1.41</version>
</dependency>
<dependency>
<groupId>org.slf4j</groupId>
<artifactId>slf4j-api</artifactId>
<version>${slf4j.version}</version>
</dependency>
<dependency>
<groupId>org.slf4j</groupId>
<artifactId>slf4j-log4j12</artifactId>
<version>${slf4j.version}</version>
</dependency>
<!-- 映入JSON -->
<dependency>
<groupId>org.codehaus.jackson</groupId>
<artifactId>jackson-mapper-asl</artifactId>
<version>1.9.13</version>
</dependency>
<!-- 上传组件包 -->
<dependency>
<groupId>commons-fileupload</groupId>
<artifactId>commons-fileupload</artifactId>
<version>1.3.1</version>
</dependency>
<dependency>
<groupId>commons-io</groupId>
<artifactId>commons-io</artifactId>
<version>2.4</version>
</dependency>
<dependency>
<groupId>commons-codec</groupId>
<artifactId>commons-codec</artifactId>
<version>1.9</version>
</dependency>
</dependencies>
build标签下添加上下面resources里面的东西。
<build>
<resources>
<resource>
<directory>${basedir}/src/main/java</directory>
<includes>
<include>**/*Mapper.xml</include>
</includes>
</resource>
</resources>
</build>
- 如果粘贴完报红,则参考这篇博文进行解决https://www.cnblogs.com/babystudy/p/13357748.html
- 如果target中无mapper.xml文件,则按下图操作
3.3 配置mybatis环境
mybatis官方文档:http://www.mybatis.org/mybatis-3/zh/index.html
3.3.1 编辑配置文件sqlMapConfig.xml
- 只使用mybatis框架的时候配置如下:
<?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>
<!--加载外部properties文件-->
<properties resource="db.properties"></properties>
<!-- 设定类型的别名 -->
<typeAliases>
<!-- 1.自定义别名 -->
<!-- <typeAlias type="com.offcn.bean.Person" alias="per" -->
<!--2.扫描形式
扫描包下所有的bean类型java代码
在mapper.xml中使用当前类型的时候,我们只需要使用当前类型类名或者是类名首字母小写形式-->
<package name="com.clj.po"/>
</typeAliases>
<!-- mybatis使用环境 -->
<environments default="development">
<environment id="development">
<!-- 自动开启事务 -->
<transactionManager type="JDBC"/>
<!-- 数据源 -->
<dataSource type="POOLED">
<property name="driver" value="${driver}"/>
<property name="url" value="${url}"/>
<property name="username" value="${username}"/>
<property name="password" value="${password}"/>
</dataSource>
</environment>
</environments>
<!-- 扫描mapper.xml配置文件和接口 -->
<mappers>
<!-- 1.自定义配置文件 -->
<!-- <mapper resource="com/clj/mapper/UserMapper.xml"/> -->
<!-- 2.扫描方式加载 -->
<package name="com.clj.mapper"></package>
</mappers>
</configuration>
- 使用SSM框架的时候配置如下:
<?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>
</configuration>
3.3.2 编辑mapper接口文件
- 不使用通用mapper的时候接口如下:
public interface UserMapper {
/**
* 增加用户的方法
* @param user 用户信息
* @return 增加成功则返回1,失败返回0
*/
public int addUser(User user);
/**
* 根据用户名、性别删除用户信息的方法
* @param username 用户名
* @param sex 性别
* @return 删除成功返回受影响的行数,失败返回0
*/
public int deleteUser(@Param("username") String username, @Param("sex") String sex);
/**
* 根据map信息查询用户的方法
* @param map
* @return 用户信息集合
*/
public List<User> selectUserByMap(Map<String,Object> map);
/**
* 根据list查询用户的方法
* @param ids id集合
* @return 用户信息的集合
*/
public List<User> selectUserByResultMap(List<Integer> ids);
}
- 使用通用mapper的时候接口如下:
package com.clj.mapper;
import com.clj.po.User;
import com.github.abel533.mapper.Mapper;
public interface UserMapper1 extends Mapper<User> {
}
3.3.3 编辑mapper.xml文件
不使用通用mapper(只能解决单表的sql语句问题)的时候xml文件如下,使用通用mapper的时候无需编写xml文件:
<?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">
<mapper namespace="com.clj.mapper.UserMapper">
<!--增加用户信息-->
<insert id="addUser" parameterType="User">
/*返回自动增长列主键值(只适用于自动增长列)*/
<selectKey keyProperty="id" order="AFTER" resultType="java.lang.Integer">
SELECT @@IDENTITY
</selectKey>
INSERT INTO t_user(username,pwd,sex,love,birthday,address,email,createDate,updateDate)
VALUES(#{username},#{pwd},#{sex},#{love},#{birthday},#{address},#{email},#{createDate},#{updateDate})
</insert>
<!--删除用户信息-->
<delete id="deleteUser">
DELETE FROM t_user WHERE username LIKE '%${username}%' AND sex = #{sex}
</delete>
<!--根据map查询用户信息-->
<select id="selectUserByMap" parameterType="map" resultType="User">
SELECT * FROM t_user WHERE sex = #{sex}
</select>
<!--根据resultMap查询用户信息-->
<resultMap id="resultMap1" type="User">
<id column="id" property="id"></id>
<result column="name" property="username"></result>
<result column="password" property="pwd"></result>
</resultMap>
<sql id="idList">
<foreach collection="list" item="id" open="id IN(" separator="," close=")">
#{id}
</foreach>
</sql>
<select id="selectUserByResultMap" parameterType="list" resultMap="resultMap1">
SELECT username name,pwd password,sex FROM t_user WHERE
<include refid="idList"/>
</select>
</mapper>
3.3.4 测试方法
SqlSessionFactory sqlSessionFactory;
@Before
public void start() throws IOException {
String resource = "mybatis\\sqlMapConfig.xml";
InputStream inputStream = Resources.getResourceAsStream(resource);
sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
}
@Test
public void testSelectUserByList(){
SqlSession sqlSession = sqlSessionFactory.openSession();
UserMapper mapper = sqlSession.getMapper(UserMapper.class);
List<Integer> ids = new ArrayList<>();
ids.add(163);
ids.add(168);
List<User> users = mapper.selectUserByResultMap(ids);
sqlSession.commit();
sqlSession.close();
for (User user : users) {
System.out.println(user.toString());
}
}
3.4 配置spring
3.4.1 配置spring的配置文件applicationContext.xml
spring官方文档下载:http://docs.spring.io/spring/docs/4.3.3.RELEASE/spring-framework-reference/pdf/
<?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"
xmlns:tx="http://www.springframework.org/schema/tx"
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
http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx.xsd">
<!-- 1.加载外部资源文件 -->
<context:property-placeholder location="classpath:db.properties"/>
<!-- 2.配置数据源 -->
<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
<property name="driverClass" value="${jdbc.driver}"></property>
<property name="jdbcUrl" value="${jdbc.url}"></property>
<property name="user" value="${jdbc.username}"></property>
<property name="password" value="${jdbc.password}"></property>
</bean>
<!-- 3.配置sqlSessionFactory -->
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<!-- 配置mybatis核心配置文件的路径 -->
<property name="configLocation" value="classpath:mybatis/SqlMapConfig.xml"></property>
<!-- 指定数据源 -->
<property name="dataSource" ref="dataSource"></property>
<!-- 批量创建别名的包 -->
<!-- <property name="typeAliasesPackage" value="com.hpe.po"></property> -->
<!-- 通用Mapper实现单表操作 -->
<property name="plugins">
<array>
<!-- pagehelper分页配置 -->
<bean class="com.github.pagehelper.PageInterceptor">
<property name="properties">
<value>
helperDialect=mysql
offsetAsPageNum=true
<!-- 设置合理的分页,防止出现小于第一页,大于最后一页的异常情况出现。 -->
reasonable=true
</value>
</property>
</bean>
<!-- 配置mapper的拦截器 -->
<bean class="com.github.abel533.mapperhelper.MapperInterceptor">
<property name="properties">
<value>
<!-- 主键自增回写方法,默认值MYSQL -->
IDENTITY=MYSQL
mappers=com.github.abel533.mapper.Mapper
</value>
</property>
</bean>
</array>
</property>
</bean>
<!-- 4.配置mapper接口(使用mapper的扫描器) -->
<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<!-- 指定需要创建实现类的Mapper接口所在的包可以指定多个包,使用逗号隔开即可-->
<property name="basePackage" value="com.hpe.mapper"></property>
<!-- 需要指定SqlSessionFactory,使用sqlSessionFactoryBeanName
通过这种方式就可以等到Spring初始化完成后,再去构造SqlSessionFactory,否则无法连接数据库 -->
<property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"></property>
</bean>
<!-- 5.开启注解扫描 -->
<context:component-scan base-package="com.hpe.service"></context:component-scan>
<!-- 6.spring声明式事务:注解方式 -->
<!-- 6.1配置事务管理器 -->
<bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource" ref="dataSource"></property>
</bean>
<!-- 6.2注册事务注解驱动;transaction-manager:自动检测事务处理 -->
<tx:annotation-driven transaction-manager="transactionManager"/>
</beans>
3.4.2 po类中使用注解
@Repository(value = "user")
public class User{...}
3.4.3 service
public interface UserService {
/**
* 增加用户的方法
* @param user 用户信息
* @return 增加成功则返回1,失败返回0
*/
public int addUser(User user);
}
3.4.4 serviceImpl中使用注解
@Service("userService")
public class UserServiceImpl implements UserService {
@Autowired
private UserMapper userMapper;
@Override
public int addUser(User user) {
return userMapper.addUser(user);
}
}
3.4.5 测试方法
@Test
public void testSpringMybatis(){
ApplicationContext context = new ClassPathXmlApplicationContext("spring/applicationContext.xml");
UserService userService = context.getBean(UserService.class);
Date date = new Date();
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
String now = sdf.format(date);
User user = new User("113","113","0","113","2018-01-01","113","113",now,now);
int result = userService.addUser(user);
System.out.println(result);
}
3.5 配置spring mvc的配置文件
<?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"
xmlns:mvc="http://www.springframework.org/schema/mvc"
xmlns:tx="http://www.springframework.org/schema/tx"
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
http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx.xsd
http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc.xsd">
<!-- 1.开启注解扫描 -->
<context:component-scan base-package="com.hpe.controller"></context:component-scan>
<!-- 2.注解驱动:自动注册注解的处理器映射器和处理器适配器
conversionService:装配自定义类型的转化器 -->
<mvc:annotation-driven conversion-service="conversionService"></mvc:annotation-driven>
<!-- 3.视图解析器 -->
<bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
<property name="prefix" value="/"></property>
<property name="suffix" value=".jsp"></property>
</bean>
<!-- 4.自定义参数绑定
4.1 自定义类型转化器配置 -->
<bean id="conversionService" class="org.springframework.context.support.ConversionServiceFactoryBean">
<property name="converters">
<set>
<bean class="com.hpe.convert.DateConvert"></bean>
</set>
</property>
</bean>
<!-- 5.文件上传(配置文件上传的解析器)
文件上传解析器的bean的id默认值是multipartResolver -->
<bean id="multipartResolver" class="org.springframework.web.multipart.commons.CommonsMultipartResolver">
<!-- 设置编码格式 -->
<property name="defaultEncoding" value="UTF-8"></property>
<!-- 设置上传文件的最大限制2M -->
<property name="maxUploadSize" value="2097152"></property>
</bean>
<!-- 静态资源解析 包括:js、img、css
/js/**:访问js下的所有资源
可以添加多个静态资源解析 -->
<mvc:resources location="/js/" mapping="/js/**"></mvc:resources>
<!-- 6.配置拦截器 -->
<mvc:interceptors>
<!-- 登录认证的拦截器 -->
<mvc:interceptor>
<mvc:mapping path="/**"/>
<bean class="com.hpe.interceptor.LoginInterceptor"></bean>
</mvc:interceptor>
<!-- 拦截器1 -->
<mvc:interceptor>
<!-- 配置拦截器作用的路径。/**表示所有的url地址和子路径 -->
<mvc:mapping path="/**"/>
<!-- 配置拦截器不需要拦截的路径 -->
<mvc:exclude-mapping path=""/>
<!-- 对指定的路径进行拦截 -->
<bean class="com.hpe.interceptor.HandlerInteceptor1"></bean>
</mvc:interceptor>
<!-- 拦截器2,可以配置多个 -->
<mvc:interceptor>
<mvc:mapping path="/**"/>
<bean class="com.hpe.interceptor.HandlerInteceptor2"></bean>
</mvc:interceptor>
</mvc:interceptors>
</beans>
3.6 配置web.xml文件
<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://xmlns.jcp.org/xml/ns/javaee" xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_3_1.xsd" id="WebApp_ID" version="3.1">
<display-name>ssm01</display-name>
<!-- 加载spring的配置文件,在应用程序启动时初始化IOC容器,使用spring监听器 -->
<context-param>
<param-name>contextConfigLocation</param-name>
<!-- spring配置文件地址 -->
<!-- 如果加载多个配置文件,可以使用*或者逗号分隔开 -->
<param-value>classpath:spring/applicationContext.xml</param-value>
</context-param>
<!-- 配置监听spring配置文件的监听器 -->
<listener>
<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
</listener>
<!-- 配置前端控制器 -->
<servlet>
<servlet-name>dispatcherServlet</servlet-name>
<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
<!-- 初始化时,加载配置文件(处理器映射器、处理器适配器、视图解析器) -->
<init-param>
<!-- contextConfigLocation:指定springmvc配置文件的位置 -->
<param-name>contextConfigLocation</param-name>
<param-value>classpath:spring/springmvc.xml</param-value>
</init-param>
<!-- servlet容器启动时加载此servlet -->
<load-on-startup>1</load-on-startup>
</servlet>
<servlet-mapping>
<servlet-name>dispatcherServlet</servlet-name>
<!-- 第一种方式:*.action,所有url地址是以.action结尾才能被前端控制器进行处理 -->
<!-- 第二种方式: /,所有的地址都会被前端控制器进行处理,使用此种方式可以实现restful的url-->
<url-pattern>*.action</url-pattern>
</servlet-mapping>
<!-- 配置前端控制器,支持Restful风格的url -->
<servlet>
<servlet-name>dispatcher_restful</servlet-name>
<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
<init-param>
<!-- contextConfigLocation:指定springmvc配置文件的位置 -->
<param-name>contextConfigLocation</param-name>
<param-value>classpath:spring/springmvc.xml</param-value>
</init-param>
<!-- servlet容器启动时加载此servlet -->
<load-on-startup>1</load-on-startup>
</servlet>
<servlet-mapping>
<servlet-name>dispatcher_restful</servlet-name>
<url-pattern>/</url-pattern>
</servlet-mapping>
<!-- 配置编码格式的过滤器 -->
<filter>
<filter-name>EncodingFilter</filter-name>
<filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
<init-param>
<param-name>encoding</param-name>
<param-value>UTF-8</param-value>
</init-param>
</filter>
<filter-mapping>
<filter-name>EncodingFilter</filter-name>
<url-pattern>/*</url-pattern>
</filter-mapping>
</web-app>
3.7 配置log4j.properties文件
log4j.rootLogger=DEBUG,Console,File
log4j.appender.Console=org.apache.log4j.ConsoleAppender
log4j.appender.Console.Target=System.out
log4j.appender.Console.layout = org.apache.log4j.PatternLayout
log4j.appender.Console.layout.ConversionPattern=[%c] - %m%n
log4j.appender.File = org.apache.log4j.RollingFileAppender
log4j.appender.File.File = logs/ssm.log
log4j.appender.File.MaxFileSize = 10MB
log4j.appender.File.Threshold = ALL
log4j.appender.File.layout = org.apache.log4j.PatternLayout
log4j.appender.File.layout.ConversionPattern =[%p] [%d{yyyy-MM-dd HH\:mm\:ss}][%c]%m%n
3.8 配置db.properties文件
db.driver=com.mysql.jdbc.Driver
db.url=jdbc:mysql://localhost:3306/mybatis?characterEncoding=utf-8
db.username=root
db.password=1234
开始编写项目
- 编写po实体类,给主键属性设置好@id标识
- 编写mapper接口及mapper.xml文件
<?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">
<mapper namespace="Mapper接口全类名">
</mapper>
- 编写Service及ServiceImpl,ServiceImpl如下:
@Service
@Transactional
public class UserServiceImpl implements UserService{
// 注入userMapper
@Autowired
private UserMapper userMapper;
@Override
public List<User> selectAllUser(User user) {
return userMapper.select(user);
}
@Override
public User selectUserById(Integer id) {
return userMapper.selectByPrimaryKey(id);
}
}
- 编写Controller
@Controller
// @RequestMapping加到类上用于对url进行分类化管理(窄化请求映射),
// 该类的所有方法映射到该路径下面,最终刚问路径:根路径+子路径
@RequestMapping(value="/user")
public class UserController {
@Autowired
private UserService userService;
// 查询所有用户,指定请求此方法的url地址
@RequestMapping(value="/selectAll")
public ModelAndView selectAll(){
// 1.调用service中的方法,得到所有用户的集合
List<User> users = userService.selectAllUser(new User());
// 2. 创建ModelAndView
ModelAndView modelAndView = new ModelAndView();
// 3.填充数据
modelAndView.addObject("users", users);
// 4.设置视图(逻辑视图)
modelAndView.setViewName("user/userList");
// 5. 返回ModelAndView
return modelAndView;
}
// 注解的属性
// 1.value:指定访问的路径,可以指定多个路径
// 2.method:指定访问次方法的请求类型,可以是get、post
@RequestMapping(value={"findAll","select"},method={RequestMethod.POST,RequestMethod.GET})
public ModelAndView findAll(){
// 1.调用service中的方法,得到所有用户的集合
List<User> users = userService.selectAllUser(new User());
// 2. 创建ModelAndView
ModelAndView modelAndView = new ModelAndView();
// 3.填充数据
modelAndView.addObject("users", users);
// 4.设置视图(逻辑视图)
modelAndView.setViewName("user/userList");
// 5. 返回ModelAndView
return modelAndView;
}
// 查询用户信息
/*@RequestMapping(value="/selectUser")
public ModelAndView selectUser(HttpServletRequest request){
// 得到查询用户的id
String value = request.getParameter("id");
Integer id = Integer.parseInt(value);
// 根据id查询用户信息
User user = userService.selectUserById(id);
// 将用户信息填充到请求域
ModelAndView modelAndView = new ModelAndView();
modelAndView.addObject("user", user);
// 请求转发到用户详情页面
modelAndView.setViewName("user/userInfo");
return modelAndView;
}*/
// 返回值是String,返回值代表逻辑视图名
// 参数绑定类型Model:Spring MVC的参数动态绑定
@RequestMapping(value="/selectUser")
public String selectUser(Model model){
// 得到查询用户的id
Integer id = 1;
// 根据id查询用户信息
User user = userService.selectUserById(id);
// 使用Model的方法将数据填充到request域
model.addAttribute("user", user);
// 返回逻辑视图名称
return "user/userInfo";
}
/**
* forward:转发
* 如果使用转发,区别视图解析器的返回值,视图解析器是不会拼接字符串
*/
@RequestMapping("/selectUser1")
public String selectUser1(Model model){
// 得到查询用户的id
Integer id = 1;
// 根据id查询用户信息
User user = userService.selectUserById(id);
// 使用Model的方法将数据填充到request域
model.addAttribute("user", user);
// 返回逻辑视图名称
return "forward:/user/userInfo.jsp";
}
/**
* redirect:重定向
* 是两次请求,不能共享数据
*/
@RequestMapping("/selectUser2")
public String selectUser2(HttpServletRequest request,HttpServletResponse response){
// 得到查询用户的id
Integer id = 1;
// 根据id查询用户信息
User user = userService.selectUserById(id);
// 使用Model的方法将数据填充到request域
request.getSession().setAttribute("user", user);
// 返回逻辑视图名称
return "redirect:/user/userInfo.jsp";
}
// 无返回值
@RequestMapping("/selectUser3")
public void selectUser3(HttpServletRequest request,HttpServletResponse response)
throws ServletException, IOException{
Integer id = Integer.parseInt(request.getParameter("id"));
User user = userService.selectUserById(id);
request.setAttribute("user", user);
request.getRequestDispatcher("/user/userInfo.jsp").forward(request, response);
}
// 无返回值
@RequestMapping("/selectUser4")
public void selectUser4(HttpServletRequest request,HttpServletResponse response)
throws ServletException, IOException{
Integer id = Integer.parseInt(request.getParameter("id"));
User user = userService.selectUserById(id);
request.getSession().setAttribute("user", user);
response.sendRedirect(request.getContextPath()+"/user/userInfo.jsp");
}
}
运行测试