基于SpringMVC+Mybatis搭建简单的前后台交互系统

2023-08-14 19:42:28

一、摘要

　　1、所需软件列表：

　　　　1) tomcat : apache-tomcat-7.0.54　服务端容器

　　　　2) Intellij： Intellij IDEA 2016.3.1 开发工具　　

　　　　3) Syslog: SQLyog Community 　数据库工具

　　2. 步骤简述：

　　　1）新建一个 Java 项目，依次选择Spring--->Spring MVC--->Finish；

　　　2） web目录下新建前台页面相关目录（css/js/page等）；

　　 3） WEB-INF文件夹下新建如下两个文件夹：
　　　　lib: 用于存放项目相关jar包，项目如已导入maven可无视该步骤；
　　　　resources: 用于存放Spring,Mybatis等相关配置文件。
　　 4）src目录下用于存放服务端相关代码

　　完成后的工程目录如下：

二、Spring配置：

1、需要导入的包如下：

2、相关配置文件

　　1）web.xml配置（用于配置Spring 相关配置项：上下文、日志、字符集、监听器等）

<?xml version="1.0" encoding="UTF-8"?>

<web-app xmlns="http://xmlns.jcp.org/xml/ns/javaee"

         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

         xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_3_1.xsd"

         version="3.1">

    <!-- 告知javaEE容器，哪些内容需要添加到上下文中去 -->

    <context-param>

        <param-name>contextConfigLocation</param-name>

        <param-value>

            classpath:applicationContext.xml

        </param-value>

    </context-param>

    <!-- 加载LOG4J -->

    <context-param>

        <param-name>log4jConfigLocation</param-name>

        <param-value>classpath:log4j.xml</param-value>

    </context-param>

    <context-param>

        <param-name>log4jRefreshInterval</param-name>

        <param-value>60000</param-value>

    </context-param>

    <!-- 动态设置项目的运行路径 -->

    <context-param>

        <param-name>webAppRootKey</param-name>

        <param-value>mvc.root</param-value>

    </context-param>

    <!-- 配置静态资源 -->

    <servlet-mapping>

        <servlet-name>default</servlet-name>

        <url-pattern>/static/*</url-pattern>

    </servlet-mapping>

    <!-- 配置springmvc的前端控制器 -->

    <servlet>

        <servlet-name>mvc</servlet-name>

        <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>

        <!-- 默认情况下：DispatcherServlet会寻找WEB-INF下，命名规范为[servlet-name]-servlet.xml文件。

        如：在上例中，它就会找/WEB-INF/mvc-servlet.xml

         如果需要修改，需要在web.xml中的<servlet>标记中增加 <init-param>。。。</init-param>：-->

        <init-param>

            <param-name>contextConfigLocation</param-name>

            <param-value>classpath:mvc-servlet.xml</param-value>

        </init-param>

    </servlet>

    <servlet-mapping>

        <servlet-name>mvc</servlet-name>

        <url-pattern>/</url-pattern>

    </servlet-mapping>

    <!-- spring框架提供的字符集过滤器 -->

    <!-- spring Web MVC框架提供了org.springframework.web.filter.CharacterEncodingFilter用于解决POST方式造成的中文乱码问题  -->

    <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>

        <init-param>

            <param-name>forceEncoding</param-name>

            <param-value>true</param-value>

        </init-param>

    </filter>

    <filter-mapping>

        <filter-name>encodingFilter</filter-name>

        <url-pattern>/*</url-pattern>

    </filter-mapping>

    <!-- 监听器 -->

    <listener>

        <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>

    </listener>

    <listener>

        <listener-class>org.springframework.web.util.Log4jConfigListener</listener-class>

    </listener>

    <welcome-file-list>

        <welcome-file>/page/index.html</welcome-file>

    </welcome-file-list>

</web-app>

　　2）spring-servlet.xml配置（用于配置SpringMVC相关：注解、视图解析器、自动扫描等）

<?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:mvc="http://www.springframework.org/schema/mvc"

       xsi:schemaLocation="http://www.springframework.org/schema/beans

    http://www.springframework.org/schema/beans/spring-beans-3.0.xsd

    http://www.springframework.org/schema/context   http://www.springframework.org/schema/context/spring-context-3.0.xsd

    http://www.springframework.org/schema/mvc

    http://www.springframework.org/schema/mvc/spring-mvc-4.3.xsd">

    <bean id="fastJsonHttpMessageConverter"

          class="com.alibaba.fastjson.support.spring.FastJsonHttpMessageConverter">

        <property name="supportedMediaTypes">

            <list>

                <value>text/html;charset=UTF-8</value>

                <value>application/json</value>

            </list>

        </property>

        <property name="features">

            <list>

                <!-- 输出key时是否使用双引号 -->

                <value>QuoteFieldNames</value>

                <!-- 是否输出值为null的字段 -->

                <value>WriteMapNullValue</value>

                <!-- 数值字段如果为null,输出为0,而非null -->

                <value>WriteNullNumberAsZero</value>

                <!-- List字段如果为null,输出为[],而非null -->

                <value>WriteNullListAsEmpty</value>

                <!-- 字符类型字段如果为null,输出为"",而非null -->

                <value>WriteNullStringAsEmpty</value>

                <!-- Boolean字段如果为null,输出为false,而非null -->

                <value>WriteNullBooleanAsFalse</value>

                <!-- null String不输出  -->

                <value>WriteNullStringAsEmpty</value>

                <!-- Date的日期转换器 -->

                <value>WriteDateUseDateFormat</value>

            </list>

        </property>

    </bean>

    <!-- 启动注解，注册服务，如验证框架、全局类型转换器-->

    <mvc:annotation-driven>

        <mvc:message-converters>

            <ref bean="fastJsonHttpMessageConverter" />

        </mvc:message-converters>

    </mvc:annotation-driven>

    <!-- 静态资源默认servlet配置

        (1)加入对静态资源的处理：js,gif,png

        (2)允许使用"/"做整体映射

        会自动注册DefaultAnnotationHandlerMapping与AnnotationMethodHandlerAdapter 两个bean,

        是spring MVC为@Controllers分发请求所必须的。

        并提供了：数据绑定支持，@NumberFormatannotation支持，@DateTimeFormat支持，@Valid支持，

        读写XML的支持（JAXB，读写JSON的支持（Jackson

     -->

    <mvc:default-servlet-handler/>

    <!-- 启动自动扫描 -->

    <context:component-scan base-package="com.test">

        <!-- 制定扫包规则 ,只扫描使用@Controller注解的JAVA类 -->

        <context:include-filter type="annotation" expression="org.springframework.stereotype.Controller"/>

    </context:component-scan>

    <!-- 配置视图解析器 -->

    <!--prefix和suffix：查找视图页面的前缀和后缀（前缀[逻辑视图名]后缀），

       比如传进来的逻辑视图名为WEB-INF/page/hello，则该该jsp视图页面应该存放在“WEB-INF/page/hello.html”； -->

    <bean class="org.springframework.web.servlet.view.UrlBasedViewResolver">

        <property name="viewClass" value="org.springframework.web.servlet.view.JstlView"></property>

        <property name="prefix" value="/page"></property>

        <property name="suffix" value=".html"></property>

    </bean>

</beans>

　　3） datasource.properties(用于配置数据库文件）

jdbc.driver= com.mysql.jdbc.Driver

jdbc.url= jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=UTF-8

jdbc.username= root

jdbc.password= root

　　4) log4j.xml(用于配置记录日志文件)

<?xml version="1.0" encoding="UTF-8" ?>

<!DOCTYPE log4j:configuration SYSTEM "F:\SpringMybatis测试\SpringMVC_Mybatis\src\webapp\WEB-INF\conf\log4j.dtd">

<log4j:configuration xmlns:log4j='http://jakarta.apache.org/log4j/'

					 xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

					 xsi:schemaLocation="http://jakarta.apache.org/log4j/ ">

	<appender name="STDOUT" class="org.apache.log4j.ConsoleAppender">

		<layout class="org.apache.log4j.PatternLayout">

			<param name="ConversionPattern" value="%c %d{yyyy-MM-dd HH:mm:ss} -- %p -- %m%n"/>

		</layout>

	</appender>

	<appender name="DEBUG" class="org.apache.log4j.RollingFileAppender">

		<param name="File" value="${ssm.root}/ssm-debug.log"/>

		<param name="Append" value="true"/>

		<param name="MaxFileSize" value="10240KB"/>

		<param name="MaxBackupIndex" value="1000"/>

		<layout class="org.apache.log4j.PatternLayout">

			<param name="ConversionPattern" value="%c %d{yyyy-MM-dd HH:mm:ss} -- %p -- %m%n"/>

		</layout>

		<filter class="org.apache.log4j.varia.LevelRangeFilter">

			<param name="LevelMin" value="DEBUG"/>

			<param name="LevelMax" value="DEBUG"/>

		</filter>

	</appender>

	<appender name="INFO" class="org.apache.log4j.RollingFileAppender">

		<param name="File" value="${ssm.root}/ssm-info.log"/>

		<param name="Append" value="true"/>

		<param name="MaxFileSize" value="10240KB"/>

		<param name="MaxBackupIndex" value="1000"/>

		<layout class="org.apache.log4j.PatternLayout">

			<param name="ConversionPattern" value="%c %d{yyyy-MM-dd HH:mm:ss} -- %p -- %m%n"/>

		</layout>

		<filter class="org.apache.log4j.varia.LevelRangeFilter">

			<param name="LevelMin" value="INFO"/>

			<param name="LevelMax" value="INFO"/>

		</filter>

	</appender>

	<appender name="WARN" class="org.apache.log4j.RollingFileAppender">

		<param name="File" value="${ssm.root}/ssm-warn.log"/>

		<param name="Append" value="true"/>

		<param name="MaxFileSize" value="10240KB"/>

		<param name="MaxBackupIndex" value="1000"/>

		<layout class="org.apache.log4j.PatternLayout">

			<param name="ConversionPattern" value="%c %d{yyyy-MM-dd HH:mm:ss} -- %p -- %m%n"/>

		</layout>

		<filter class="org.apache.log4j.varia.LevelRangeFilter">

			<param name="LevelMin" value="WARN"/>

			<param name="LevelMax" value="WARN"/>

		</filter>

	</appender>

	<appender name="ERROR" class="org.apache.log4j.RollingFileAppender">

		<param name="File" value="${ssm.root}/ssm-error.log"/>

		<param name="Append" value="true"/>

		<param name="MaxFileSize" value="10240KB"/>

		<param name="MaxBackupIndex" value="1000"/>

		<layout class="org.apache.log4j.PatternLayout">

			<param name="ConversionPattern" value="%c %d{yyyy-MM-dd HH:mm:ss} -- %p -- %m%n"/>

		</layout>

		<filter class="org.apache.log4j.varia.LevelRangeFilter">

			<param name="LevelMin" value="ERROR"/>

			<param name="LevelMax" value="ERROR"/>

		</filter>

	</appender>

	<root>

		<priority value="INFO"/>

		<appender-ref ref="STDOUT"/>

		<appender-ref ref="DEBUG"/>

		<appender-ref ref="INFO"/>

		<appender-ref ref="WARN"/>

		<appender-ref ref="ERROR"/>

	</root>

</log4j:configuration>

　　5） log4j,dtd(主要是对相应.xml进行约束验证用的)

<?xml version="1.0" encoding="UTF-8" ?>

<!ELEMENT log4j:configuration (renderer*, throwableRenderer?,

                               appender*,plugin*, (category|logger)*,root?,

                               (categoryFactory|loggerFactory)?)>

<!ATTLIST log4j:configuration

  xmlns:log4j              CDATA #FIXED "http://jakarta.apache.org/log4j/"

  threshold                (all|trace|debug|info|warn|error|fatal|off|null) "null"

  debug                    (true|false|null)  "null"

  reset                    (true|false) "false"

>

<!ELEMENT renderer EMPTY>

<!ATTLIST renderer

  renderedClass  CDATA #REQUIRED

  renderingClass CDATA #REQUIRED

>

<!ELEMENT throwableRenderer (param*)>

<!ATTLIST throwableRenderer

  class  CDATA #REQUIRED

>

<!ELEMENT appender (errorHandler?, param*,

      rollingPolicy?, triggeringPolicy?, connectionSource?,

      layout?, filter*, appender-ref*)>

<!ATTLIST appender

  name 		CDATA 	#REQUIRED

  class 	CDATA	#REQUIRED

>

<!ELEMENT layout (param*)>

<!ATTLIST layout

  class		CDATA	#REQUIRED

>

<!ELEMENT filter (param*)>

<!ATTLIST filter

  class		CDATA	#REQUIRED

>

<!ELEMENT errorHandler (param*, root-ref?, logger-ref*,  appender-ref?)>

<!ATTLIST errorHandler

   class        CDATA   #REQUIRED

>

<!ELEMENT root-ref EMPTY>

<!ELEMENT logger-ref EMPTY>

<!ATTLIST logger-ref

  ref CDATA #REQUIRED

>

<!ELEMENT param EMPTY>

<!ATTLIST param

  name		CDATA   #REQUIRED

  value		CDATA	#REQUIRED

>

<!ELEMENT priority (param*)>

<!ATTLIST priority

  class   CDATA	#IMPLIED

  value	  CDATA #REQUIRED

>

<!ELEMENT level (param*)>

<!ATTLIST level

  class   CDATA	#IMPLIED

  value	  CDATA #REQUIRED

>

<!ELEMENT category (param*,(priority|level)?,appender-ref*)>

<!ATTLIST category

  class         CDATA   #IMPLIED

  name		CDATA	#REQUIRED

  additivity	(true|false) "true"

>

<!ELEMENT logger (param*,level?,appender-ref*)>

<!ATTLIST logger

  class         CDATA   #IMPLIED

  name		CDATA	#REQUIRED

  additivity	(true|false) "true"

>

<!ELEMENT categoryFactory (param*)>

<!ATTLIST categoryFactory

   class        CDATA #REQUIRED>

<!ELEMENT loggerFactory (param*)>

<!ATTLIST loggerFactory

   class        CDATA #REQUIRED>

<!ELEMENT appender-ref EMPTY>

<!ATTLIST appender-ref

  ref CDATA #REQUIRED

>

<!-- plugins must have a name and class and can have optional parameters -->

<!ELEMENT plugin (param*, connectionSource?)>

<!ATTLIST plugin

  name 		CDATA 	   #REQUIRED

  class 	CDATA  #REQUIRED

>

<!ELEMENT connectionSource (dataSource?, param*)>

<!ATTLIST connectionSource

  class        CDATA  #REQUIRED

>

<!ELEMENT dataSource (param*)>

<!ATTLIST dataSource

  class        CDATA  #REQUIRED

>

<!ELEMENT triggeringPolicy ((param|filter)*)>

<!ATTLIST triggeringPolicy

  name 		CDATA  #IMPLIED

  class 	CDATA  #REQUIRED

>

<!ELEMENT rollingPolicy (param*)>

<!ATTLIST rollingPolicy

  name 		CDATA  #IMPLIED

  class 	CDATA  #REQUIRED

>

<!ELEMENT root (param*, (priority|level)?, appender-ref*)>

<!ELEMENT log4j:eventSet (log4j:event*)>

<!ATTLIST log4j:eventSet

  xmlns:log4j             CDATA #FIXED "http://jakarta.apache.org/log4j/"

  version                (1.1|1.2) "1.2"

  includesLocationInfo   (true|false) "true"

>

<!ELEMENT log4j:event (log4j:message, log4j:NDC?, log4j:throwable?,

                       log4j:locationInfo?, log4j:properties?) >

<!ATTLIST log4j:event

    logger     CDATA #REQUIRED

    level      CDATA #REQUIRED

    thread     CDATA #REQUIRED

    Date  CDATA #REQUIRED

    time       CDATA #IMPLIED

>

<!ELEMENT log4j:message (#PCDATA)>

<!ELEMENT log4j:NDC (#PCDATA)>

<!ELEMENT log4j:throwable (#PCDATA)>

<!ELEMENT log4j:locationInfo EMPTY>

<!ATTLIST log4j:locationInfo

  class  CDATA	#REQUIRED

  method CDATA	#REQUIRED

  file   CDATA	#REQUIRED

  line   CDATA	#REQUIRED

>

<!ELEMENT log4j:properties (log4j:data*)>

<!ELEMENT log4j:data EMPTY>

<!ATTLIST log4j:data

  name   CDATA	#REQUIRED

  value  CDATA	#REQUIRED

>

　6）applicationContext.xml(Mybatis sqlSessionFactoryBuilder相关配置及Spring AOP等)

<?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-3.0.xsd

    http://www.springframework.org/schema/aop

    http://www.springframework.org/schema/aop/spring-aop-3.0.xsd

    http://www.springframework.org/schema/tx

    http://www.springframework.org/schema/tx/spring-tx-3.1.xsd

    http://www.springframework.org/schema/context

    http://www.springframework.org/schema/context/spring-context-4.2.xsd">

    <!-- 开启自动扫包 -->

    <context:component-scan base-package="com.test">

        <!--制定扫包规则，不扫描@Controller注解的JAVA类，其他的还是要扫描  -->

        <context:exclude-filter type="annotation" expression="org.springframework.stereotype.Controller"/>

    </context:component-scan>

    <!-- 启动AOP支持 -->

    <aop:aspectj-autoproxy/>

    <!-- 引入外部数据源配置信息 -->

    <bean class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">

        <property name="locations">

            <value>classpath:datasource.properties</value>

        </property>

    </bean>

    <!-- 配置数据源 -->

    <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">

        <property name="driverClassName" value="${jdbc.driver}"></property>

        <property name="url" value="${jdbc.url}"></property>

        <property name="username" value="${jdbc.username}"></property>

        <property name="password" value="${jdbc.password}"></property>

    </bean>

    <!-- 配置Session工厂 -->

    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">

        <property name="dataSource" ref="dataSource"></property>

        <!-- 加载mybatis.mapper.xml文件 -->

        <property name="mapperLocations" value="classpath*:UserMapper.xml"></property>

        <!-- 自动扫描需要定义类别名的包，将包内的JAVA类的类名作为类别名 -->

        <property name="typeAliasesPackage" value="com.test.pojo"></property>

    </bean>

    <!-- 自动扫描所的Mapper接口与文件 -->

    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">

        <property name="basePackage" value="com.test.dao"></property>

        <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"></property>

    </bean>

    <!-- 配置事务管理器 -->

    <bean id="txManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">

        <property name="dataSource" ref="dataSource"></property>

    </bean>

    <!-- 定义操作通知，指定事务管理器 -->

    <tx:advice id="txAdvice" transaction-manager="txManager">

        <tx:attributes>

            <tx:method name="delete*" propagation="REQUIRED" read-only="false"

                       rollback-for="java.lang.Exception" />

            <tx:method name="save*" propagation="REQUIRED" read-only="false"

                       rollback-for="java.lang.Exception" />

            <tx:method name="insert*" propagation="REQUIRED" read-only="false"

                       rollback-for="java.lang.Exception" />

            <tx:method name="update*" propagation="REQUIRED" read-only="false"

                       rollback-for="java.lang.Exception" />

            <tx:method name="load*" propagation="SUPPORTS" read-only="true"/>

            <tx:method name="find*" propagation="SUPPORTS" read-only="true"/>

            <tx:method name="search*" propagation="SUPPORTS" read-only="true"/>

            <tx:method name="select*" propagation="SUPPORTS" read-only="true"/>

            <tx:method name="get*" propagation="SUPPORTS" read-only="true"/>

        </tx:attributes>

    </tx:advice>

    <aop:config>

        <!-- 配置一个切入点 -->

        <aop:pointcut id="serviceMethods" expression="execution(* com.test.service.impl.*ServiceImpl.*(..))" />

        <aop:advisor advice-ref="txAdvice" pointcut-ref="serviceMethods" />

    </aop:config>

</beans>

　　7) UserMapper.xml(Mybatis 配置文件，用于生成所需的SQL)

<?xml version="1.0" encoding="UTF-8"?>

<!DOCTYPE mapper PUBLIC "-//mybatis.org/DTD Mapper 3.0" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">

<mapper namespace="com.test.dao.UserDAO">

    <!-- 自定义返回结果集 -->

    <resultMap id="userMap" type="com.test.pojo.UserBean" >

        <id property="id" column="id" javaType="java.lang.Integer"></id>

        <result property="name" column="name" javaType="java.lang.String"></result>

        <result property="age" column="age" javaType="java.lang.Integer"></result>

    </resultMap>

    <!--查-->

    <select id="selectAllUser" resultMap="userMap">

		select * from user

	</select>

    <!--#{}：占位符，可用于替换动态内容，防止SQL注入

    %{}：拼接sql串，可用于替换静态内容，如表名，数据库连接方式等，不能防止sql注入-->

    <!--根据id查询单个用户-->

    <select id="selectSingleUser" parameterType="java.lang.Integer" resultMap="userMap">

        select * from user

        <if test=" id != null">

            where id=#{id,jdbcType=INTEGER}

        </if>

    </select>

    <select id="countUsers" resultType="int">

		select count(*) from user where 1=1

	</select>

    <!--choose, when, otherwise: 等价于swicth case条件执行查询语句

    bind: 用于执行左右模糊匹配字段的查询-->

    <select id="selectOneUserInfo" resultMap="userMap">

        select * from user

        <!--<choose>-->

        <!--<when test="id != null">-->

        <!--where id=#{id,jdbcType=INTEGER}-->

        <!--</when>-->

        <!--<when test="name != null">-->

        <!--where name like #{name}-->

        <!--</when>-->

        <!--<otherwise>-->

        <!--where 1=1-->

        <!--</otherwise>-->

        <!--</choose>-->

        <where>

            <if test="id != null">

                id=#{id,jdbcType=INTEGER}

            </if>

            <if test="name != null">

                <bind name="username" value="'%' + name + '%'" />

                and name like #{username}

            </if>

        </where>

    </select>

    <!--增-->

    <!--如果数据库支持自动生成主键的字段，可以使用useGeneratedKys+keyProperty字段来制定主键-->

    <insert id="insertUser" parameterType="java.util.List" useGeneratedKeys="true"

            keyProperty="id">

        insert into user (id, name, age) values

        <foreach collection="list" item="user" separator=",">

            (#{user.id},#{user.name},#{user.age})

        </foreach>

    </insert>

    <!--改-->

    <update id="updateUserInfo">

        update user

        <set>

            <if test="user.id != null">id=#{user.id},</if>

            <if test="user.name != null">name=#{user.name},</if>

            <if test="user.age != null">age=#{user.age}</if>

        </set>

        where id=#{id}

    </update>

    <!--删-->

    <delete id="deleteUser">

        delete from user

        <trim prefix="WHERE" prefixOverrides="AND | OR">

            <if test="id != null">

                WHERE id = #{id,jdbcType=INTEGER}

            </if>

            <!--<if test="name != null and name.length()>0">-->

                <!--AND WHERE name = #{name}-->

            <!--</if>-->

        </trim>

    </delete>

</mapper>

　三、服务端代码

　　服务端代码使用MVC模式，使得视图（界面显示）、模型（数据）及控制器（业务逻辑）三者分离的方式组织代码，将业务逻辑聚集到一个部件里，在改进和个性化定制界面及用户交互的同时，不需要重新编写业务逻辑。
具体的编码实现如下：

1）User实体类：

package com.test.pojo;

public class UserBean{

    private int id;

    private String name;

    private int age;

    public int getId() {

        return id;

    }

    public void setId(int id) {

        this.id = id;

    }

    public String getName() {

        return name;

    }

    public void setName(String name) {

        this.name = name;

    }

    public int getAge() {

        return age;

    }

    public void setAge(int age) {

        this.age = age;

    }

    @Override

    public String toString() {

        return "UserBean{" +

                "id=" + id +

                ", name='" + name + '\'' +

                ", age=" + age +

                '}';

    }

}

　2）控制器类：

package com.test.controller;

import com.test.pojo.UserBean;

import com.test.service.UserService;

import org.apache.ibatis.annotations.Param;

import org.springframework.beans.factory.annotation.Autowired;

import org.springframework.stereotype.Controller;

import org.springframework.web.bind.annotation.*;

import javax.jws.WebMethod;

import java.lang.annotation.Target;

import java.util.ArrayList;

import java.util.Collections;

import java.util.List;

@RestController()

public class UserController {

    @Autowired

    private UserService userService;

    @RequestMapping(value = "/getUserInfo", method = RequestMethod.GET)

    public List getUserInfo() throws Exception {

        return userService.getAllUsers();

    }

    @RequestMapping(value = "/getSingleUser", method = RequestMethod.GET)

    public UserBean getSingleUser(@Param("id") String id) throws Exception {

        //return userService.getSingleUsers(id);

        return userService.getUserInfo(id);

    }

    @RequestMapping(value = "/getOneUserInfo", method = RequestMethod.GET)

    public UserBean getSingleUser(@Param("id") String id, @Param("name") String name) throws Exception {

        return userService.getOneUserInfo(id, name);

    }

    @RequestMapping(value = "/getUserCount", method = RequestMethod.GET)

    public int getUserCountForAllUsers() throws Exception {

        return userService.getUsersCount();

    }

    @RequestMapping(value = "updateUser")

    public void updateUserInfo(){

        userService.updateUserInfo();

    }

    @RequestMapping(value = "/addUsers", method = RequestMethod.GET)

    public void addUsers(List<UserBean> list) throws Exception {

        List<UserBean> users = new ArrayList<>();

        UserBean user1 = new UserBean();

        user1.setAge(28);

        user1.setId(12);

        user1.setName("Mr One");

        UserBean user2 = new UserBean();

        user2.setAge(31);

        user2.setId(11);

        user2.setName("Mr Two");

        users.add(user1);

        users.add(user2);

        userService.addUsers(list);

    }

    @RequestMapping(value = "/deleteUser", method = RequestMethod.GET)

    public void deleteUser(@Param("id") String id, @Param("name")String name) throws Exception {

        userService.deleteUser(id, name);

    }

}

　　3）数据库操作类UserDAO：（定义为接口方式，serviceImpl用来实现具体的增删改查操作，可以使用Mybatis映射器方式直接拼写SQL（注释掉的@Select("")等）, 也可以定义UserMapper.xml文件用来通过配置文件生成SQL）

package com.test.dao;

import com.test.pojo.UserBean;

import org.apache.ibatis.annotations.Delete;

import org.apache.ibatis.annotations.Param;

import org.apache.ibatis.annotations.Select;

import org.springframework.context.ApplicationContext;

import org.springframework.context.support.ClassPathXmlApplicationContext;

import org.springframework.jdbc.core.BeanPropertyRowMapper;

import org.springframework.jdbc.core.JdbcTemplate;

import org.springframework.jdbc.core.RowMapper;

import java.util.List;

public interface UserDAO {

    List<UserBean> selectAllUser() throws Exception;

    //@Select("select * from user where id=#{id}") ---映射器方式：入参需要改为String类型

    UserBean selectSingleUser(@Param("id") Integer id);

    //@Select("select * from user where id=#{id} and name=#{name}") ---映射器方式：入参需要改为String类型

    UserBean selectOneUserInfo(@Param("id") Integer id, @Param("name") String name);

    int countUsers();

    void insertUser(@Param("list") List<UserBean> list);

//    @Delete("delete from user where id=#{id}")

    void deleteUser(@Param("id") Integer id, @Param("name") String name) throws Exception;

    void updateUserInfo(@Param("id")Integer id, @Param("user") UserBean user);

    @Select("select * from user where id=#{id}")

    UserBean getUserInfo(@Param("id") String id);

}

　　4） UserService(数据库操作接口类)

package com.test.service;

import com.test.pojo.UserBean;

import java.util.List;

public interface UserService {

    List<UserBean> getAllUsers() throws Exception;

    void addUsers(List<UserBean> list);

    void deleteUser(String id, String name) throws Exception;

    UserBean getSingleUsers(String id);

    int getUsersCount();

    UserBean getOneUserInfo(String id, String name);

    void updateUserInfo();

    UserBean getUserInfo(String id);

}

　　5）UserServiceImpl(UserService的实现类)

package com.test.service.impl;

import com.test.dao.UserDAO;

import com.test.pojo.UserBean;

import com.test.service.UserService;

import org.springframework.beans.factory.annotation.Autowired;

import org.springframework.stereotype.Service;

import java.util.List;

@Service("user")

public class UserServiceImpl implements UserService {

    @Autowired(required = false)

    UserDAO userDAO;

    @Override

    public List<UserBean> getAllUsers() throws Exception {

        return userDAO.selectAllUser();

    }

    @Override

    public UserBean getSingleUsers(String id) {

        return userDAO.selectSingleUser(Integer.parseInt(id));

    }

    @Override

    public int getUsersCount() {

        return userDAO.countUsers();

    }

    @Override

    public void addUsers(List<UserBean> list) {

        userDAO.insertUser(list);

    }

    @Override

    public void deleteUser(String id, String name) throws Exception {

        userDAO.deleteUser(Integer.parseInt(id), name);

    }

    @Override

    public UserBean getOneUserInfo(String id, String name) {

        if(id != null && !"".equals(id)){

            if(name != null){

                return userDAO.selectOneUserInfo(Integer.parseInt(id), name);

            }else{

                return userDAO.selectOneUserInfo(Integer.parseInt(id), null);

            }

        }else {

            return userDAO.selectOneUserInfo(null, name);

        }

    }

    @Override

    public void updateUserInfo() {

        UserBean user = new UserBean();

        user.setId(3);

        user.setAge(33);

        user.setName("haha");

        userDAO.updateUserInfo(1, user);

    }

    @Override

    public UserBean getUserInfo(String id) {

        return userDAO.getUserInfo(id);

    }

}

四、客户端文件：

　　本例只使用了静态页面作为初始化加载的界面展示，路径为：web/page/index.html

<!DOCTYPE html>

<html>

<head>

    <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />

</head>

<body>

<h1>This is a test Page for Spring Test</h1>

</body>

</html>

　　本例中的返回信息使用了Alibaba的fastJson作为返回对象（未使用视图解析器），故界面ajax请求返回数据可根据返回值作为数据填充，具体的界面设计需要*发挥。

五、 Tomcat配置：

　　两种方式查看：

　　1. 配置Tomcat文件：

　　　　1）将web文件夹放入 tomcat 解压包的 apache-tomcat-7.0.54\webapps\ 目录下;

　　　　2) 将编译后的jar包放入 WEB-INF 目录下的lib文件夹下

　　　　3）启动Tomcat

　　2. IntelliJ 集成了Tomcat 插件，可以直接启动，具体配置路径如下：
　　　　Run--->Edit Configurations--->"+"--->Tomcat Server--->Local 或者 Remote选项配置
　　　　（注意Deployment Tab页下要将对应的war包导入）
　　　　然后启动即可

码农公寓

相关文章