IDEA使用Maven搭建SSM框架或使用单个框架

下面的内容随着学习会不断更新的哇,不要捉急 ·_·

1.新建一个工程或者Module(此处以Module为例)

新建步骤在上面的博文已经介绍过,此处不再赘述。

2.搭建项目文件结构框架

在这里插入图片描述

3.编辑配置文件

3.1配置pom.xml文件
  1. 各种jar包及maven依赖寻找地: http://repository.sonatype.org/
  2. 常用的一些依赖
	<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>
  1. 如果粘贴完报红,则参考这篇博文进行解决https://www.cnblogs.com/babystudy/p/13357748.html
  2. 如果target中无mapper.xml文件,则按下图操作
    在这里插入图片描述
3.3 配置mybatis环境

mybatis官方文档:http://www.mybatis.org/mybatis-3/zh/index.html

3.3.1 编辑配置文件sqlMapConfig.xml
  1. 只使用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>
  1. 使用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接口文件
  1. 不使用通用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);
}
  1. 使用通用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

开始编写项目

  1. 编写po实体类,给主键属性设置好@id标识
  2. 编写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>
  1. 编写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);
	}
}
  1. 编写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");
	}
}

运行测试

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值