一、环境配置

• IntelliJ IDEA版本：IntelliJ IDEA 2019.1 x64
• Maven版本：apache-maven-3.6.1
• Spring版本：4.2.5.RELEASE
• mybatis版本：3.2.8

二、项目需求

我从朋友正在做的实训项目上随便找了一个简单的小模块，大致功能是公司人员信息管理，需要实现的功能有①人员信息的插入②人员信息的查询（分为自己查询和他人查询）。

需求

三、项目实现

项目下载地址：https://pan.baidu.com/s/1n9SyDGFLHSqeo5Pl_tlUGw 提取码：fnzt
首先我们使用IDEA创建一个maven项目，具体项目类型如下图所示。

maven

root

然后我们在pom.xml中添加maven依赖。

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
  <modelVersion>4.0.0</modelVersion>

  <groupId>Webapp</groupId>
  <artifactId>web</artifactId>
  <version>1.0-SNAPSHOT</version>
  <packaging>war</packaging>

  <name>web Maven Webapp</name>
  <!-- FIXME change it to the project's website -->
  <url>http://www.example.com</url>

  <properties>
    <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
    <project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding>
    <maven.compiler.source>1.7</maven.compiler.source>
    <maven.compiler.target>1.7</maven.compiler.target>
    <!-- spring版本号 -->
    <spring.version>4.2.5.RELEASE</spring.version>

    <!-- mybatis版本号 -->
    <mybatis.version>3.2.8</mybatis.version>

    <!-- mysql驱动版本号 -->
    <mysql-driver.version>5.1.29</mysql-driver.version>

    <!-- log4j日志包版本号 -->
    <slf4j.version>1.7.18</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>

    <!-- 添加jstl依赖,jsp标准标签库 -->
    <dependency>
      <groupId>jstl</groupId>
      <artifactId>jstl</artifactId>
      <version>1.2</version>
    </dependency>

    <!--javax 环境-->
    <dependency>
      <groupId>javax</groupId>
      <artifactId>javaee-api</artifactId>
      <version>7.0</version>
    </dependency>

    <!-- 添加junit4依赖 -->
    <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-web</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-webmvc</artifactId>
      <version>${spring.version}</version>
    </dependency>
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-context</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-aop</artifactId>
      <version>${spring.version}</version>
    </dependency>

    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-test</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>

    <!-- 添加mysql驱动依赖 -->
    <dependency>
      <groupId>mysql</groupId>
      <artifactId>mysql-connector-java</artifactId>
      <version>${mysql-driver.version}</version>
    </dependency>
    <!-- 添加数据库连接池依赖 -->
    <dependency>
      <groupId>commons-dbcp</groupId>
      <artifactId>commons-dbcp</artifactId>
      <version>1.2.2</version>
    </dependency>

    <!-- 添加日志相关jar包 -->
    <dependency>
      <groupId>log4j</groupId>
      <artifactId>log4j</artifactId>
      <version>${log4j.version}</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>

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

    <!--三个json的包必须要导入，否则在服务启动时会出错-->
    <dependency>
      <groupId>com.fasterxml.jackson.core</groupId>
      <artifactId>jackson-core</artifactId>
      <version>2.1.0</version>
    </dependency>
    <dependency>
      <groupId>com.fasterxml.jackson.core</groupId>
      <artifactId>jackson-databind</artifactId>
      <version>2.1.0</version>
    </dependency>
    <dependency>
      <groupId>com.fasterxml.jackson.core</groupId>
      <artifactId>jackson-annotations</artifactId>
      <version>2.1.0</version>
    </dependency>
  </dependencies>

  <build>
    <finalName>web</finalName>
    <pluginManagement><!-- lock down plugins versions to avoid using Maven defaults (may be moved to parent pom) -->
      <plugins>
        <plugin>
          <artifactId>maven-clean-plugin</artifactId>
          <version>3.1.0</version>
        </plugin>
        <!-- see http://maven.apache.org/ref/current/maven-core/default-bindings.html#Plugin_bindings_for_war_packaging -->
        <plugin>
          <artifactId>maven-resources-plugin</artifactId>
          <version>3.0.2</version>
        </plugin>
        <plugin>
          <artifactId>maven-compiler-plugin</artifactId>
          <version>3.8.0</version>
        </plugin>
        <plugin>
          <artifactId>maven-surefire-plugin</artifactId>
          <version>2.22.1</version>
        </plugin>
        <plugin>
          <artifactId>maven-war-plugin</artifactId>
          <version>3.2.2</version>
        </plugin>
        <plugin>
          <artifactId>maven-install-plugin</artifactId>
          <version>2.5.2</version>
        </plugin>
        <plugin>
          <artifactId>maven-deploy-plugin</artifactId>
          <version>2.8.2</version>
        </plugin>
      </plugins>
    </pluginManagement>
  </build>
</project>

然后我们在resources资源目录下创建jdbc连接配置文件jdbc.properties，和log4j配置文件log4j.properties。

#jdbc配置文件
driverClasss=com.mysql.jdbc.Driver
#记得改成你自己的！！！！
jdbcUrl=jdbc:mysql://localhost:3306/employee?useUnicode=true&characterEncoding=utf-8&zeroDateTimeBehavior=convertToNull
username=root
password=123456
#初始连接数
initialSize=0
#最大连接数
maxActive=20
#最大空闲
maxIdle=20
#最小空闲
minIdle=1
#最长等待时间
maxWait=60000

#log4j配置文件
log4j.rootLogger=INFO,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=[%p][%t][%d{yyyy-MM-dd HH\:mm\:ss}][%C] - %m%n
#普通文件日志
log4j.appender.File=org.apache.log4j.RollingFileAppender
log4j.appender.File.File=logs/ssm.log
log4j.appender.File.MaxFileSize=10MB
#输出日志，如果换成DEBUG表示输出DEBUG以上级别日志
log4j.appender.File.Threshold=ALL
log4j.appender.File.layout=org.apache.log4j.PatternLayout
log4j.appender.File.layout.ConversionPattern=[%p][%t][%d{yyyy-MM-dd HH\:mm\:ss}][%C] - %m%n

之后我们来配置webapp/WEB-INF目录下的web.xml即web项目配置文件。

<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns="http://java.sun.com/xml/ns/javaee"
         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://java.sun.com/xml/ns/javaee
          http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd"
         version="3.0">

  <display-name>web-ssm</display-name>

  <!--设置spring-mybatis配置文件位置-->
  <context-param>
    <param-name>contextConfigLocation</param-name>
    <param-value>classpath:spring-mybatis.xml</param-value>
  </context-param>

  <!--设置log4j配置文件位置-->
  <context-param>
    <param-name>log4jConfigLocation</param-name>
    <param-value>classpath:log4j.properties</param-value>
  </context-param>

  <!-- 编码过滤器 -->
  <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>

  <!-- spring监听器 -->
  <listener>
    <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
  </listener>

  <!-- 防止spring内存溢出监听器，比如quartz -->
  <listener>
    <listener-class>org.springframework.web.util.IntrospectorCleanupListener</listener-class>
  </listener>


  <!--设置spring-mvc配置文件位置-->
  <!-- spring mvc servlet-->
  <servlet>
    <servlet-name>SpringMVC</servlet-name>
    <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
    <init-param>
      <param-name>contextConfigLocation</param-name>
      <param-value>classpath:spring-mvc.xml</param-value>
    </init-param>
    <load-on-startup>1</load-on-startup>
    <async-supported>true</async-supported>
  </servlet>
  <servlet-mapping>
    <servlet-name>SpringMVC</servlet-name>
    <!-- 此处也可以配置成 *.do 形式 -->
    <url-pattern>/</url-pattern>
  </servlet-mapping>

  <!--这里设置启动服务器时浏览器打开的界面，即主页-->
  <welcome-file-list>
    <welcome-file>/index.jsp</welcome-file>
  </welcome-file-list>

  <!-- session配置 -->
  <session-config>
    <session-timeout>15</session-timeout>
  </session-config>

</web-app>

这里会提示缺少spring-mybatis.xml和spring-mvc.xml文件，是因为我们还没有创建，看配置文件中的这一段：

 <!--设置spring-mybatis配置文件位置-->
  <context-param>
    <param-name>contextConfigLocation</param-name>
    <param-value>classpath:spring-mybatis.xml</param-value>
  </context-param>

我们需要在项目的classpath路径下创建这个spring-mybatis.xml文件，该classpath指的是项目在编译后生成的target/classes目录，我们这里直接放在resources资源目录下即可，在项目编译后该文件就会出现在target/classes路径下，同理我们也在resources目录下创建spring-mvc.xml文件。

<?xml version="1.0" encoding="UTF-8"?>
<!--mybatis配置文件-->
<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:tx="http://www.springframework.org/schema/tx"
       xsi:schemaLocation="http://www.springframework.org/schema/beans
                        http://www.springframework.org/schema/beans/spring-beans-3.1.xsd
                        http://www.springframework.org/schema/context
                        http://www.springframework.org/schema/context/spring-context-3.1.xsd
                        http://www.springframework.org/schema/tx
                        http://www.springframework.org/schema/tx/spring-tx.xsd">

    <!-- 自动扫描 -->
    <!--这里需要改成自己的-->
    <context:component-scan base-package="com.myapp.EmployeeManager"/>

    <!-- 加载一个properties文件 -->
    <bean id="propertyConfigurer" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
        <property name="location" value="classpath:jdbc.properties"/>
    </bean>



    <!-- 配置数据源 -->
    <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource"
          destroy-method="close">
        <property name="driverClassName" value="${driverClasss}"/>
        <property name="url" value="${jdbcUrl}"/>
        <property name="username" value="${username}"/>
        <property name="password" value="${password}"/>
        <!-- 初始化连接大小 -->
        <property name="initialSize" value="${initialSize}"></property>
        <!-- 连接池最大数量 -->
        <property name="maxActive" value="${maxActive}"></property>
        <!-- 连接池最大空闲 -->
        <property name="maxIdle" value="${maxIdle}"></property>
        <!-- 连接池最小空闲 -->
        <property name="minIdle" value="${minIdle}"></property>
        <!-- 获取连接最大等待时间 -->
        <property name="maxWait" value="${maxWait}"></property>
    </bean>

    <!-- mybatis和spring完美整合，不需要mybatis的配置映射文件 -->
    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
        <property name="dataSource" ref="dataSource"/>
        <!-- 自动扫描mapping.xml文件 -->
        <property name="mapperLocations" value="classpath:mapping/*.xml"></property>
    </bean>

    <!-- DAO接口所在包名，Spring会自动查找其下的类 -->
    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
        <!--这里需要改成自己的-->
        <property name="basePackage" value="com.myapp.EmployeeManager.dao"/>
        <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"></property>
    </bean>


    <!-- (事务管理)transaction manager, use JtaTransactionManager for global tx -->
    <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
        <property name="dataSource" ref="dataSource"/>
    </bean>

    <!-- (事务管理)transaction manager, use JtaTransactionManager for global tx -->
    <tx:annotation-driven transaction-manager="transactionManager"/>
</beans>

<?xml version="1.0" encoding="UTF-8"?>
<!--spring-mvc配置文件-->
<beans xmlns="http://www.springframework.org/schema/beans"
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:p="http://www.springframework.org/schema/p"
       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-4.0.xsd
                        http://www.springframework.org/schema/context
                        http://www.springframework.org/schema/context/spring-context-4.0.xsd
                        http://www.springframework.org/schema/mvc
                        http://www.springframework.org/schema/mvc/spring-mvc-4.0.xsd">

    <!-- 自动扫描  @Controller 这里要改成你自己的！！！-->
    <context:component-scan base-package="com.myapp.EmployeeManager.controller"/>

    <!--避免IE执行AJAX时，返回JSON出现下载文件 -->
    <bean id="mappingJacksonHttpMessageConverter"
          class="org.springframework.http.converter.json.MappingJackson2HttpMessageConverter">
        <property name="supportedMediaTypes">
            <list>
                <value>text/html;charset=UTF-8</value>
            </list>
        </property>
    </bean>
    <!-- 启动SpringMVC的注解功能，完成请求和注解POJO的映射 -->
    <bean class="org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter">
        <property name="messageConverters">
            <list>
                <ref bean="mappingJacksonHttpMessageConverter"/> <!-- JSON转换器 -->
            </list>
        </property>
    </bean>


    <!-- 定义跳转的文件的前后缀 ，视图模式配置 -->
    <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
        <property name="prefix" value="/WEB-INF/jsp/" />
        <property name="suffix" value=".jsp"/>
    </bean>

</beans>

编写完spring-mybatis.xml文件后，发现还有一句话报错：

<!-- mybatis和spring完美整合，不需要mybatis的配置映射文件 -->
    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
        <property name="dataSource" ref="dataSource"/>
        <!-- 自动扫描mapping.xml文件 -->
        <property name="mapperLocations" value="classpath:mapping/*.xml"></property>
    </bean>

编译器找不到classpath:mapping目录下的任意xml文件，我们先在resources目录下创建一个mapping文件夹，这个文件夹用来存放项目dao层和数据库之间的xml映射文件，这些xml文件等我们编写好项目的dao层代码后再来编写。

到这里为止，我们的ssm项目配置文件已经基本上完成了，我们开始进行程序的编码部分。项目的代码实现部分不多，整体结构如下图所示：

image.png

package com.myapp.EmployeeManager.model;

/**
 * @author whx
 * @date 2019/6/21 14:13
 */

public class Employee {
    private String employeeID;
    private String password;
    private String employeeName;
    private String sex;
    private int age;
    private String department;
    private String introduction;
    private String phoneNum;
    private String actor;

    //无论是否需要一定要加一个空的构造器，否则mybatis可能会无法识别
    public Employee() {
    }

    public Employee(String employeeID, String password, String name, String sex, int age, String department, String introduction, String phoneNum, String actor) {
        this.employeeID = employeeID;
        this.password = password;
        this.employeeName = name;
        this.sex = sex;
        this.age = age;
        this.department = department;
        this.introduction = introduction;
        this.phoneNum = phoneNum;
        this.actor = actor;
    }

    public String getEmployeeID() {
        return employeeID;
    }

    public void setEmployeeID(String employeeID) {
        this.employeeID = employeeID;
    }

    public String getPassword() {
        return password;
    }

    public void setPassword(String password) {
        this.password = password;
    }

    public String getEmployeeName() {
        return employeeName;
    }

    public void setEmployeeName(String employeeName) {
        this.employeeName = employeeName;
    }

    public String getSex() {
        return sex;
    }

    public void setSex(String sex) {
        this.sex = sex;
    }

    public int getAge() {
        return age;
    }

    public void setAge(int age) {
        this.age = age;
    }

    public String getDepartment() {
        return department;
    }

    public void setDepartment(String department) {
        this.department = department;
    }

    public String getIntroduction() {
        return introduction;
    }

    public void setIntroduction(String introduction) {
        this.introduction = introduction;
    }

    public String getPhoneNum() {
        return phoneNum;
    }

    public void setPhoneNum(String phoneNum) {
        this.phoneNum = phoneNum;
    }

    public String getActor() {
        return actor;
    }

    public void setActor(String actor) {
        this.actor = actor;
    }

    @Override
    public String toString() {
        return "Employee{" +
                "employeeID='" + employeeID + '\'' +
                ", password='" + password + '\'' +
                ", employeeName='" + employeeName + '\'' +
                ", sex='" + sex + '\'' +
                ", age=" + age +
                ", department='" + department + '\'' +
                ", introduction='" + introduction + '\'' +
                ", phoneNum='" + phoneNum + '\'' +
                ", actor='" + actor + '\'' +
                '}';
    }
}

EmployeeDao.java

package com.myapp.EmployeeManager.dao;

import com.myapp.EmployeeManager.model.Employee;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;

/**
 * @author whx
 * @date 2019/6/21 14:17
 */

//@Repository标签用来标注数据访问组件，即dao层
@Repository
public interface EmployeeDao {
    //向数据库中插入员工信息
    void insertEmployee(@Param("employee")Employee employee);

    //查询自己的信息
    Employee searchMyInform(@Param("employeeID")String employeeID);

    //通过部门和姓名查询其他人的信息
    Employee searchOthersInform(@Param("department")String department,@Param("name")String name);

}

EmployeeService.java

package com.myapp.EmployeeManager.service;

import com.myapp.EmployeeManager.model.Employee;

/**
 * @author whx
 * @date 2019/6/21 14:24
 */

//service接口中方法与dao中方法对应，但不需要加注释
public interface EmployeeService {
    //向数据库中插入员工信息
    void insertEmployee( Employee employee);

    //查询自己的信息
    Employee searchMyInform(String employeeID);

    //通过部门和姓名查询其他人的信息
    Employee searchOthersInform(String department,String name);

}

EmployeeServiceImpl.java

package com.myapp.EmployeeManager.service.impl;

import com.myapp.EmployeeManager.dao.EmployeeDao;
import com.myapp.EmployeeManager.model.Employee;
import com.myapp.EmployeeManager.service.EmployeeService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;

/**
 * @author whx
 * @date 2019/6/21 14:27
 */

//EmployeeService接口的实现类
//需要加Service注解表示是服务类以及Transactional注解处理事务
@Service
@Transactional(rollbackFor = Exception.class)
public class EmployeeServiceImpl implements EmployeeService {

    @Autowired
    private EmployeeDao employeeDao;

    //该类中的方法实现均与dao类对应即可
    @Override
    public void insertEmployee(Employee employee) {
        employeeDao.insertEmployee(employee);
    }

    @Override
    public Employee searchMyInform(String employeeID) {
        return employeeDao.searchMyInform(employeeID);
    }

    @Override
    public Employee searchOthersInform(String department, String name) {
        return employeeDao.searchOthersInform(department,name);
    }
}

EmployeeController.java

package com.myapp.EmployeeManager.controller;

import com.myapp.EmployeeManager.model.Employee;
import com.myapp.EmployeeManager.service.EmployeeService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;

import org.apache.log4j.Logger;

import javax.servlet.http.HttpServletRequest;

/**
 * @author whx
 * @date 2019/6/21 14:15
 */

//在controller类中加注释，表明这是控制类，且设置请求路径
@Controller
@RequestMapping("/employee")
public class EmployeeController {

    private Logger log=Logger.getLogger(EmployeeController.class);

    @Autowired
    private EmployeeService employeeService;

    @RequestMapping("/insert")
    public String insertEmployee(HttpServletRequest request, Model model){
        log.info("插入员工信息！");
        Employee employee=new Employee(request.getParameter("id"),request.getParameter("pw"),request.getParameter("name"),request.getParameter("sex"),
                Integer.parseInt(request.getParameter("age")),request.getParameter("depart"),request.getParameter("intro"),request.getParameter("phone")
                ,request.getParameter("actor"));
        employeeService.insertEmployee(employee);
        return "insert";//这里表示跳转到insert.jsp界面
    }

    @RequestMapping("/search")
    public String searchMyInform(HttpServletRequest request, Model model){
        log.info("查询个人信息！");
        Employee employee=employeeService.searchMyInform(request.getParameter("employeeID"));
        System.out.println(employee.toString());
        model.addAttribute("employee",employee);
        return "search";//这里表示跳转到search.jsp界面
    }

    @RequestMapping("/others")
    public String searchOthers(HttpServletRequest request, Model model){
        log.info("查询他人信息！");
        Employee employee=employeeService.searchOthersInform(request.getParameter("department"),request.getParameter("name"));
        System.out.println(employee.toString());
        model.addAttribute("department",employee.getDepartment());//向前端jsp传输请求内容
        model.addAttribute("introduction",employee.getIntroduction());//向前端jsp传输请求内容
        return "others";//这里表示跳转到others.jsp界面
    }
}

上述5个java文件的程序代码即大概(没必要要求那么细致)完成了需求中的功能，包括插入员工信息、通过员工ID查询员工信息、通过部门和姓名查询员工信息。我们再写几个简易的jsp界面用来接收结果。

insert.jsp

<html>
<body>
<h2>Insert OK!</h2>
</body>
</html>

search.jsp

<html>
<body>
<h2>Search OK!</h2>
<h1>
employee:${employee.toString()}
</h1>
</body>
</html>

others.jsp

<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<body>
<h2>Search others OK!</h2>
<p>
<h1>
    Department:${department}
    Introduction:${introduction}
</h1>
</p>
</body>
</html>

然后我们来完成dao层数据库的映射，即mapping目录下的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.myapp.EmployeeManager.dao.EmployeeDao">
    <!--这里id要与dao中的一致-->             <!--这里要改成自己的！！！-->
    <insert id="insertEmployee" parameterType="com.myapp.EmployeeManager.model.Employee">
        INSERT INTO empl (employeeID,password,employeeName,sex,age,department,introduction,phoneNum,actor)
              VALUES   (#{employee.employeeID},#{employee.password},#{employee.employeeName},#{employee.sex},#{employee.age},#{employee.department},#{employee.introduction},#{employee.phoneNum},#{employee.actor})
    </insert>
</mapper>

注意，这里的namespace和parameterType一定要是类的全路径，不能只写Employee这样的。还有insert标签中的id一定要与你想要对应dao层中的方法同名。

通过员工ID查询员工信息

<?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.myapp.EmployeeManager.dao.EmployeeDao">
    <resultMap id="EmployeeBaseMap" type="com.myapp.EmployeeManager.model.Employee">
        <id column="employeeID" property="employeeID" jdbcType="VARCHAR"/>
        <result column="password" property="password" jdbcType="VARCHAR"/>
        <result column="employeeName" property="employeeName" jdbcType="VARCHAR"/>
        <result column="sex" property="sex" jdbcType="VARCHAR"/>
        <result column="age" property="age" jdbcType="INTEGER"/>
        <result column="department" property="department" jdbcType="VARCHAR"/>
        <result column="introduction" property="introduction" jdbcType="VARCHAR"/>
        <result column="phoneNum" property="phoneNum" jdbcType="VARCHAR"/>
        <result column="actor" property="actor" jdbcType="VARCHAR"/>
    </resultMap>

    <select id="searchMyInform" resultMap="EmployeeBaseMap" parameterType="java.lang.String">
        SELECT * FROM empl
        WHERE employeeID=#{employeeID};
    </select>
</mapper>

通过部门和姓名查询员工信息

<?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.myapp.EmployeeManager.dao.EmployeeDao">
    <resultMap id="EmployeeOtherMap" type="com.myapp.EmployeeManager.model.Employee">
        <id column="employeeID" property="employeeID" jdbcType="VARCHAR"/>
        <result column="password" property="password" jdbcType="VARCHAR"/>
        <result column="employeeName" property="employeeName" jdbcType="VARCHAR"/>
        <result column="sex" property="sex" jdbcType="VARCHAR"/>
        <result column="age" property="age" jdbcType="INTEGER"/>
        <result column="department" property="department" jdbcType="VARCHAR"/>
        <result column="introduction" property="introduction" jdbcType="VARCHAR"/>
        <result column="phoneNum" property="phoneNum" jdbcType="VARCHAR"/>
        <result column="actor" property="actor" jdbcType="VARCHAR"/>
    </resultMap>

    <select id="searchOthersInform" resultMap="EmployeeOtherMap" >
        SELECT * FROM empl
        WHERE department=#{department} and employeeName=#{name};
    </select>
</mapper>

大功告成！

到目前为止，整个项目已经完成，部署了tomcat服务器后我们运行该项目(记得配好数据库)。
访问下列网址:

//向数据库中插入一条员工信息
http://localhost:8080/web_war/employee/insert?id=1&pw=123456&name=WANG&sex=male&age=20&intro=i am 20 years old.&phone=8888666&depart=123&actor=123
//查询员工ID为1的员工信息
http://localhost:8080/web_war/employee/search?employeeID=1
//查询部门为123，姓名为WANG的员工
http://localhost:8080/web_war/employee/others?department=123&name=WANG

结果如下图所示：
数据库

数据库

insert

search

others

     若有不规范或错误之处欢迎指正，谢谢！