【编程不良人】MyBatis从入门到精通学习笔记05---Spring+Mybatis+Struts2练习项目

系统管理员 2023-10-09 14:04 27阅读 0赞

**作业：**

**![watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBAQ29kZXJfQ3Vp_size_20_color_FFFFFF_t_70_g_se_x_16][]**

**用户与身份信息展示分析：**

**![watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBAQ29kZXJfQ3Vp_size_20_color_FFFFFF_t_70_g_se_x_16 1][]**

**用户和身份信息添加分析：**

**![watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBAQ29kZXJfQ3Vp_size_20_color_FFFFFF_t_70_g_se_x_16 2][]**

### 1. 创建Maven-webapp项目，新建java、resources目录以及test目录下的java、resources ###

### 2. 在pom.xml中引入依赖 ###

<dependency>
        <groupId>junit</groupId>
        <artifactId>junit</artifactId>
        <version>4.11</version>
        <scope>test</scope>
      </dependency>
      
      
      <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-core</artifactId>
        <version>4.3.2.RELEASE</version>
      </dependency>
      <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-beans</artifactId>
        <version>4.3.2.RELEASE</version>
      </dependency>
      <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-web</artifactId>
        <version>4.3.2.RELEASE</version>
      </dependency>
      <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-expression</artifactId>
        <version>4.3.2.RELEASE</version>
      </dependency>
      <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-aop</artifactId>
        <version>4.3.2.RELEASE</version>
      </dependency>
      <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-context</artifactId>
        <version>4.3.2.RELEASE</version>
      </dependency>
      <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-context-support</artifactId>
        <version>4.3.2.RELEASE</version>
      </dependency>
      <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-aspects</artifactId>
        <version>4.3.2.RELEASE</version>
      </dependency>
      <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-jdbc</artifactId>
        <version>4.3.2.RELEASE</version>
      </dependency>
      
      
      <dependency>
        <groupId>org.mybatis</groupId>
        <artifactId>mybatis</artifactId>
        <version>3.5.4</version>
      </dependency>
      
      
      <dependency>
        <groupId>org.mybatis</groupId>
        <artifactId>mybatis-spring</artifactId>
        <version>2.0.4</version>
      </dependency>
      
      
      <dependency>
        <groupId>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
        <version>5.1.38</version>
      </dependency>
      
      
      <dependency>
        <groupId>com.alibaba</groupId>
        <artifactId>druid</artifactId>
        <version>1.1.19</version>
      </dependency>
      
      
      <dependency>
        <groupId>org.apache.struts</groupId>
        <artifactId>struts2-core</artifactId>
        <version>2.3.16</version>
      </dependency>
      
      
      <dependency>
        <groupId>org.apache.struts</groupId>
        <artifactId>struts2-spring-plugin</artifactId>
        <version>2.3.16</version>
      </dependency>
      
      
      <dependency>
        <groupId>javax.servlet</groupId>
        <artifactId>servlet-api</artifactId>
        <version>2.5</version>
        <scope>provided</scope>
      </dependency>
      
      
      <dependency>
        <groupId>jstl</groupId>
        <artifactId>jstl</artifactId>
        <version>1.2</version>
      </dependency>
      
      
      <dependency>
        <groupId>com.alibaba</groupId>
        <artifactId>fastjson</artifactId>
        <version>1.2.62</version>
      </dependency>
      
      
      <dependency>
        <groupId>org.apache.logging.log4j</groupId>
        <artifactId>log4j-core</artifactId>
        <version>2.10.0</version>
      </dependency>
      <dependency>
        <groupId>org.slf4j</groupId>
        <artifactId>slf4j-log4j12</artifactId>
        <version>1.7.25</version>
      </dependency>

###  ###

### 3. 建表 ###

-- 一对一
      -- 用户表
      CREATE TABLE IF NOT EXISTS `table_user`(
          `id` VARCHAR(36) PRIMARY KEY,
          `name` VARCHAR(40),
          `age` INTEGER,
          `bir` DATE
      )ENGINE=INNODB DEFAULT CHARSET=utf8;
      
      -- 身份信息表
      CREATE TABLE IF NOT EXISTS `table_card`(
          `id` VARCHAR(36) PRIMARY KEY,
          `code` VARCHAR(18),
          `address` VARCHAR(100),
          `fork` VARCHAR(30),
          `userId` VARCHAR(36) REFERENCES `table_user`(`id`)  -- 关系属性
      )ENGINE=INNODB DEFAULT CHARSET=utf8;
      
      -- 插入数据
      INSERT INTO table_user VALUES
      ('1','张三',20,CURDATE()),
      ('2','李四',30,CURDATE());
      INSERT INTO table_card VALUES
      ('1','111111111111111111','北京市','汉族','1'),
      ('2','222222222222222222','上海市','满族','2');
      
      -- 查询数据
      SELECT * FROM table_user;
      SELECT * FROM table_card;
      
      -- 连接查询用户信息+身份信息SQL语句
      select
          u.id,u.name,u.age,u.bir,
          c.id cid,c.code,c.address,c.fork
      from table_user u
      left join table_card c
      on u.id=c.userId;

###  ###

### 4.创建实体类 ###

> User

package com.study.entity;
      
      import java.util.Date;
      
      /**
       * @ClassName User
       * @Description TODO
       * @Author Jiangnan Cui
       * @Date 2022/4/17 20:32
       * @Version 1.0
       */
      public class User {
          private String id;
          private String name;
          private Integer age;
          private Date bir;
      
          //关系属性
          private Card card = new Card();//实例化
      
          public Card getCard() {
              return card;
          }
      
          public void setCard(Card card) {
              this.card = card;
          }
      
          public User() {
          }
      
          public User(String id, String name, Integer age, Date bir) {
              this.id = id;
              this.name = name;
              this.age = age;
              this.bir = bir;
          }
      
          public String getId() {
              return id;
          }
      
          public void setId(String id) {
              this.id = id;
          }
      
          public String getName() {
              return name;
          }
      
          public void setName(String name) {
              this.name = name;
          }
      
          public Integer getAge() {
              return age;
          }
      
          public void setAge(Integer age) {
              this.age = age;
          }
      
          public Date getBir() {
              return bir;
          }
      
          public void setBir(Date bir) {
              this.bir = bir;
          }
      
          @Override
          public String toString() {
              return "User{" +
                      "id='" + id + '\'' +
                      ", name='" + name + '\'' +
                      ", age=" + age +
                      ", bir=" + bir +
                      '}';
          }
      }

> Card

package com.study.entity;
      
      /**
       * @ClassName Card
       * @Description TODO
       * @Author Jiangnan Cui
       * @Date 2022/4/17 20:32
       * @Version 1.0
       */
      public class Card {
          private String id;
          private String code;
          private String address;
          private String fork;
      
          //关系属性
          private User user;
      
          public User getUser() {
              return user;
          }
      
          public void setUser(User user) {
              this.user = user;
          }
      
          public Card() {
          }
      
          public Card(String id, String code, String address, String fork) {
              this.id = id;
              this.code = code;
              this.address = address;
              this.fork = fork;
          }
      
          public String getId() {
              return id;
          }
      
          public void setId(String id) {
              this.id = id;
          }
      
          public String getCode() {
              return code;
          }
      
          public void setCode(String code) {
              this.code = code;
          }
      
          public String getAddress() {
              return address;
          }
      
          public void setAddress(String address) {
              this.address = address;
          }
      
          public String getFork() {
              return fork;
          }
      
          public void setFork(String fork) {
              this.fork = fork;
          }
      
          @Override
          public String toString() {
              return "Card{" +
                      "id='" + id + '\'' +
                      ", code='" + code + '\'' +
                      ", address='" + address + '\'' +
                      ", fork='" + fork + '\'' +
                      '}';
          }
      }

###  ###

### 5.创建DAO接口 ###

> UserDAO

package com.study.dao;
      
      import com.study.entity.User;
      
      import java.util.List;
      
      /**
       * @ClassName UserDAO
       * @Description TODO
       * @Author Jiangnan Cui
       * @Date 2022/4/17 22:01
       * @Version 1.0
       */
      public interface UserDAO {
          /**
           * @MethodName selectAll
           * @Description 查询所有用户的同时一并查出用户的身份信息
           * @return: java.util.List<com.study.entity.User>
           * @Author Jiangnan Cui
           * @Date 2022/4/18 8:27
           */
          List<User> selectAll();
      
          /**
           * @MethodName insertUser
           * @Description 添加用户
           * @param: user
           * @Author Jiangnan Cui
           * @Date 2022/4/18 10:01
           */
          void insertUser(User user);
      
          /**
           * @MethodName selectUserNoCard
           * @Description 查询没有身份信息的用户，通过用户获得用户id用于添加身份信息
           * @return: java.util.List<com.study.entity.User>
           * @Author Jiangnan Cui
           * @Date 2022/4/18 15:35
           */
          List<User> selectUserByNoCard();
      
          /**
           * @MethodName selectUserByKeywords
           * @Description 根据关键字查询用户信息
           * @param: user 用作与关键字进行匹配
           * @return: java.util.List<com.study.entity.User>
           * @Author Jiangnan Cui
           * @Date 2022/4/19 16:05
           */
          List<User> selectUserByKeywords(User user);
      }

> CardDAO

package com.study.dao;
      
      import com.study.entity.Card;
      
      /**
       * @ClassName CardDAO
       * @Description TODO
       * @Author Jiangnan Cui
       * @Date 2022/4/18 15:16
       * @Version 1.0
       */
      public interface CardDAO {
          /**
           * @MethodName insertCard
           * @Description 添加身份信息
           * @Author Jiangnan Cui
           * @Date 2022/4/18 15:16
           */
          void insertCard(Card card);
      }

###  ###

### 6.创建Mapper配置文件 ###

> UserDAOMapper

<?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.study.dao.UserDAO">
          
          <resultMap id="userMap" type="User">
              <id column="id" property="id"/>
              <result column="name" property="name"/>
              <result column="age" property="age"/>
              <result column="bir" property="bir"/>
              
              <association property="card" javaType="Card">
                  <id column="cid" property="id"/>
                  <result column="code" property="code"/>
                  <result column="address" property="address"/>
                  <result column="fork" property="fork"/>
              </association>
          </resultMap>
      
          
          <select id="selectAll" resultMap="userMap">
              select
                  u.id,u.name,u.age,u.bir,
                  c.id cid,c.code,c.address,c.fork
              from table_user u
              left join table_card c
              on u.id=c.userId;
          </select>
      
          
          <insert id="insertUser" parameterType="User">
              insert into table_user values (#{id},#{name},#{age},#{bir})
          </insert>
      
          
          <select id="selectUserByNoCard" resultMap="userMap">
              select u.id,u.name,u.age,u.bir
              from table_user u
              left join table_card c
              on u.id=c.userId
              where c.userId is null;
          </select>
      
          
          <select id="selectUserByKeywords" parameterType="User" resultMap="userMap">
              select u.id,u.name,u.age,u.bir,
              c.id cid,c.address,c.code,c.fork
              from table_user u
              left join table_card c
              on u.id = c.userId
              <where>
                  <if test="name!=null and name!=''">
                      u.name like "%"#{name}"%"
                  </if>
                  <if test="age!=null">
                      or u.age = #{age}
                  </if>
                  <if test="bir!=null">
                      or u.bir = #{bir}
                  </if>
                  <if test="card.address!=null and card.address!=''">
                      or c.address like "%"#{card.address}"%"
                  </if>
                  <if test="card.fork!=null and card.fork!=''">
                      or c.fork = #{card.fork}
                  </if>
                  <if test="card.code!=null and card.code!=''">
                      or c.code = #{card.code}
                  </if>
              </where>
          </select>
      </mapper>

> CardDAOMapper

<?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.study.dao.CardDAO">
          
          <insert id="insertCard" parameterType="Card">
              insert into table_card values(#{id},#{code},#{address},#{fork},#{user.id,jdbcType=VARCHAR})
          </insert>
      
      </mapper>

###  ###

### 7.创建Service接口及其实现类 ###

> UserService

package com.study.service;
      
      import com.study.entity.User;
      
      import java.util.List;
      
      /**
       * @ClassName UserService
       * @Description TODO
       * @Author Jiangnan Cui
       * @Date 2022/4/17 22:11
       * @Version 1.0
       */
      public interface UserService {
          /**
           * @MethodName selectAll
           * @Description 查询用户信息的同时一并查出身份信息
           * @return: java.util.List<com.study.entity.User>
           * @Author Jiangnan Cui
           * @Date 2022/4/18 8:28
           */
          List<User> selectAll();
      
          /**
           * @MethodName insertUser
           * @Description 插入用户
           * @param: user
           * @Author Jiangnan Cui
           * @Date 2022/4/18 10:05
           */
          void insertUser(User user);
      
          /**
           * @MethodName selectUserByNoCard
           * @Description 查询没有身份信息的用户
           * @return: java.util.List<com.study.entity.User>
           * @Author Jiangnan Cui
           * @Date 2022/4/18 16:21
           */
          List<User> selectUserByNoCard();
      }

> UserServiceImpl

package com.study.service;
      
      
      import com.study.dao.UserDAO;
      import com.study.entity.User;
      import org.springframework.beans.factory.annotation.Autowired;
      import org.springframework.stereotype.Service;
      import org.springframework.transaction.annotation.Propagation;
      import org.springframework.transaction.annotation.Transactional;
      
      import java.util.List;
      
      /**
       * @ClassName UserServiceImpl
       * @Description TODO
       * @Author Jiangnan Cui
       * @Date 2022/4/17 22:13
       * @Version 1.0
       */
      @Service("userService")
      @Transactional
      public class UserServiceImpl implements  UserService{
          //UserService依赖UserDAO组件
          @Autowired
          private UserDAO userDAO;
      
          @Override
          @Transactional(propagation = Propagation.SUPPORTS)
          public List<User> selectAll() {
              //处理业务
              return userDAO.selectAll();
          }
      
          @Override
          public void insertUser(User user) {
              //处理插入用户业务
              user.setId(UUID.randomUUID().toString());
              userDAO.insertUser(user);
          }
      
          @Override
          @Transactional(propagation = Propagation.SUPPORTS)
          public List<User> selectUserByNoCard() {
              //处理查询没有身份信息的用户
              return userDAO.selectUserByNoCard();
          }
      }

> CardService

package com.study.service;
      
      import com.study.entity.Card;
      
      /**
       * @ClassName CardService
       * @Description TODO
       * @Author Jiangnan Cui
       * @Date 2022/4/18 15:20
       * @Version 1.0
       */
      public interface CardService {
          /**
           * @MethodName insertCard
           * @Description 插入身份信息
           * @param: card
           * @Author Jiangnan Cui
           * @Date 2022/4/18 15:21
           */
          void insertCard(Card card);
      }

> CardServiceImpl

package com.study.service;
      
      import com.study.dao.CardDAO;
      import com.study.entity.Card;
      import org.springframework.beans.factory.annotation.Autowired;
      import org.springframework.stereotype.Service;
      import org.springframework.transaction.annotation.Transactional;
      
      import java.util.UUID;
      
      /**
       * @ClassName CardServiceImpl
       * @Description TODO
       * @Author Jiangnan Cui
       * @Date 2022/4/18 15:21
       * @Version 1.0
       */
      @Service("cardService")
      @Transactional
      public class CardServiceImpl implements CardService{
          @Autowired
          private CardDAO cardDAO;
      
          @Override
          public void insertCard(Card card) {
              card.setId(UUID.randomUUID().toString());
              cardDAO.insertCard(card);
          }
      }

###  ###

### 8.编写spring.xml ###

<?xml version="1.0" encoding="UTF-8"?>
      <beans xmlns="http://www.springframework.org/schema/beans"
             xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:tx="http://www.springframework.org/schema/tx"
             xmlns:aop="http://www.springframework.org/schema/aop"
             xmlns:context="http://www.springframework.org/schema/context"
             xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx.xsd http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd">
      
          
          <context:component-scan base-package="com.study"/>
      
          
          <bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource">
              <property name="driverClassName" value="com.mysql.jdbc.Driver"/>
              <property name="url" value="jdbc:mysql://localhost:3306/mybatis?
              useUnicode=true&characterEncoding=UTF-8&serverTimezone=UTC&useSSL=false"/>
              <property name="username" value="root"/>
              <property name="password" value="123456"/>
          </bean>
      
          
          <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
              <property name="dataSource" ref="dataSource"/>
              <property name="mapperLocations" value="classpath:com/study/mapper/*.xml"/>
              <property name="typeAliasesPackage" value="com.study.entity"/>
          </bean>
      
          
          <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
              <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/>
              <property name="basePackage" value="com.study.dao"/>
          </bean>
      
          
          <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
              <property name="dataSource" ref="dataSource"/>
          </bean>
      
          
          <tx:annotation-driven transaction-manager="transactionManager"/>
      </beans>

###  ###

### 9.测试Spring与Mybatis是否整合成功 ###

package com.study.test;
      
      import com.study.service.UserService;
      import org.springframework.context.ApplicationContext;
      import org.springframework.context.support.ClassPathXmlApplicationContext;
      
      /**
       * @ClassName TestSpringMybatis
       * @Description TODO
       * @Author Jiangnan Cui
       * @Date 2022/4/18 8:36
       * @Version 1.0
       */
      public class TestSpringMybatis {
          public static void main(String[] args) {
              ApplicationContext context = new ClassPathXmlApplicationContext("spring.xml");
              UserService userService = (UserService) context.getBean("userService");
              userService.selectAll().forEach(user-> System.out.println("user = " + user + " " + user.getCard()));
          }
      }

###  ###

### 10. 配置web.xml ###

<!DOCTYPE web-app PUBLIC
       "-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN"
       "http://java.sun.com/dtd/web-app_2_3.dtd" >
      
      <web-app>
        <display-name>Archetype Created Web Application</display-name>
      
        
        <context-param>
          <param-name>contextConfigLocation</param-name>
          <param-value>classpath:spring.xml</param-value>
        </context-param>
      
        
        <filter>
          <filter-name>struts2</filter-name>
          <filter-class>org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter</filter-class>
        </filter>
        <filter-mapping>
          <filter-name>struts2</filter-name>
          <url-pattern>/*</url-pattern>
        </filter-mapping>
      
        
        <listener>
          <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
        </listener>
      </web-app>

###  ###

### 11.创建Action组件 ###

> UserAction

package com.study.action;
      
      import com.opensymphony.xwork2.Action;
      import com.opensymphony.xwork2.ActionSupport;
      import com.study.entity.User;
      import com.study.service.UserService;
      import com.study.service.UserServiceImpl;
      import org.springframework.beans.factory.annotation.Autowired;
      import org.springframework.context.annotation.Scope;
      import org.springframework.stereotype.Controller;
      import org.springframework.stereotype.Repository;
      
      import java.beans.ConstructorProperties;
      import java.lang.reflect.InvocationTargetException;
      import java.text.ParseException;
      import java.util.List;
      import java.util.UUID;
      
      /**
       * @ClassName UserAction
       * @Description TODO
       * @Author Jiangnan Cui
       * @Date 2022/4/17 22:16
       * @Version 1.0
       */
      @Controller("userAction")
      @Scope("prototype")
      public class UserAction extends ActionSupport {
          @Autowired
          private UserService userService;
      
          //接收参数
          private List<User> users;
          public List<User> getUsers() {
              return users;
          }
          public void setUsers(List<User> users) {
              this.users = users;
          }
      
          private User user;
          public User getUser() {
              return user;
          }
          public void setUser(User user) {
              this.user = user;
          }
      
          //接收搜索的选中列
          private List<String> cols;
          public List<String> getCols() {
              return cols;
          }
          public void setCols(List<String> cols) {
              this.cols = cols;
          }
      
          //搜索条件，多个条件之间使用“,”分隔
          private String keywords;
          public String getKeywords() {
              return keywords;
          }
          public void setKeywords(String keywords) {
              this.keywords = keywords;
          }
      
          /**
           * @MethodName selectAll
           * @Description 处理查询用户所有信息
           * @return: java.lang.String
           * @Author Jiangnan Cui
           * @Date 2022/4/18 10:47
           */
          public String selectAll() {
              this.users = userService.selectAll();
              return Action.SUCCESS;
          }
      
          /**
           * @MethodName insertUser
           * @Description 插入用户信息
           * @return: java.lang.String
           * @Author Jiangnan Cui
           * @Date 2022/4/18 10:47
           */
          public String insertUser(){
              userService.insertUser(user);
              return Action.SUCCESS;
          }
      
          /**
           * @MethodName selectUserByNoCard
           * @Description 查询没有身份信息的用户
           * @return: java.lang.String
           * @Author Jiangnan Cui
           * @Date 2022/4/18 16:23
           */
          public String selectUserByNoCard(){
              this.users = userService.selectUserByNoCard();
              return Action.SUCCESS;
          }
      
          /**     
           * @MethodName selectUserByKeywords    
           * @Description 根据关键字查找用户信息     
           * @return: java.lang.String     
           * @Author Jiangnan Cui     
           * @Date 2022/4/18 16:23     
           */
          public String selectUserByKeywords() throws InvocationTargetException, NoSuchMethodException, IllegalAccessException, ParseException, NoSuchFieldException {
              this.users = userService.selectUserByKeywords(cols,keywords);
              return Action.SUCCESS;
          }
      }

> CardAction

package com.study.action;
      
      import com.opensymphony.xwork2.Action;
      import com.opensymphony.xwork2.ActionSupport;
      import com.study.entity.Card;
      import com.study.service.CardService;
      import org.springframework.beans.factory.annotation.Autowired;
      import org.springframework.stereotype.Controller;
      
      /**
       * @ClassName CardAction
       * @Description TODO
       * @Author Jiangnan Cui
       * @Date 2022/4/18 15:26
       * @Version 1.0
       */
      @Controller("cardAction")
      public class CardAction extends ActionSupport {
          @Autowired
          private CardService cardService;
          private Card card;
      
          public Card getCard() {
              return card;
          }
      
          public void setCard(Card card) {
              this.card = card;
          }
      
          /**
           * @MethodName insertCard
           * @Description 插入身份信息
           * @return: java.lang.String
           * @Author Jiangnan Cui
           * @Date 2022/4/18 15:28
           */
          public String insertCard(){
              cardService.insertCard(card);
              return Action.SUCCESS;
          }
      }

###  ###

### 12. 引入struts.xml ###

<?xml version="1.0" encoding="UTF-8"?>
      
      <!DOCTYPE struts PUBLIC
              "-//Apache Software Foundation//DTD Struts Configuration 2.3//EN"
              "http://struts.apache.org/dtds/struts-2.3.dtd">
      
      <struts>
          
          <package name="user" extends="struts-default" namespace="/user">
              
              <action name="selectAll" class="userAction" method="selectAll">
                  <result name="success">/user/showAllUsers.jsp</result>
              </action>
      
              
              <action name="insertUser" class="userAction" method="insertUser">
                  <result name="success" type="redirectAction">/user/selectAll</result>
              </action>
      
              
              <action name="selectUserByNoCard" class="userAction" method="selectUserByNoCard">
                  <result name="success">/card/addUserCard.jsp</result>
              </action>
      
              
              <action name="selectUserByKeywords" class="userAction" method="selectUserByKeywords">
                  <result name="success">/user/showAllUsers.jsp</result>
              </action>
          </package>
      
          
          <package name="card" extends="struts-default" namespace="/card">
              
              <action name="insertCard" class="cardAction" method="insertCard">
                  <result name="success" type="redirectAction">
                      
                      <param name="namespace">/user</param>
                      <param name="actionName">selectAll</param>
                  </result>
              </action>
          </package>
      </struts>

###  ###

### 13.jsp文件 ###

> addUser.jsp

> showAllUsersCard.jsp

<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
      <%@ taglib prefix="s" uri="/struts-tags" %>
      <%
      String path = request.getContextPath();
      String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
      %>
      
      <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
      <html>
        <head>
          <base href="<%=basePath%>">
          
          <title>My JSP 'index.jsp' starting page</title>
          <meta http-equiv="pragma" content="no-cache">
          <meta http-equiv="cache-control" content="no-cache">
          <meta http-equiv="expires" content="0">    
          <meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
          <meta http-equiv="description" content="This is my page">
          
          <style>
              select{
                  width:120px;
              }
              input[type="text"]{
                  width:400px;
              }
          </style>
        </head>
        <body>
        <h1>搜索:</h1>
        <form action="<s:url value="/user/selectUserByKeywords"/>" method="post">
            选择搜索的列:
            <select name="cols" multiple="multiple">
                <option value="name">用户名</option>
                <option value="age">年龄</option>
                <option value="bir">生日</option>
                <option value="fork">民族</option>
                <option value="code">身份证号</option>
                <option value="address">住址</option>
            </select>
            <input type="text" name="keywords" />
            <input type="submit" value="搜索"/>
        </form>
        <hr>
        <h1>所有用户信息如下:</h1>
        <table>
            <tr>
                <td>用户id</td>
                <td>用户名</td>
                <td>年龄</td>
                <td>生日</td>
                <td>身份证号</td>
                <td>民族</td>
                <td>住址</td>
            </tr>
            <s:iterator value="users">
                <tr>
                    <td><s:property value="id"/></td>
                    <td><s:property value="name"/></td>
                    <td><s:property value="age"/></td>
                    <td><s:date name="bir" format="yyyy-MM-dd"/></td>
                    <td><s:property value="card.code"/></td>
                    <td><s:property value="card.fork"/></td>
                    <td><s:property value="card.address"/></td>
                </tr>
            </s:iterator>
        </table>
        <hr>
        <a href="<s:url value="/user/addUser.jsp"/>">添加用户信息</a>
        <a href="<s:url value="/user/selectUserByNoCard"/>">添加身份信息</a>
        </body>
      </html>

> addUserCard.jsp

###  ###

### 14.引入log4j.properties ###

## 根日志
      ## 日志级别
      log4j.rootLogger=ERROR,stdout
      ## 输出位置
      log4j.appender.stdout=org.apache.log4j.ConsoleAppender
      ## 布局
      log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
      ## 格式
      log4j.appender.stdout.layout.conversionPattern=[%p] %d{yyyy-MM-dd} %m%n
      
      
      ## 子日志
      ## 日志级别
      log4j.logger.com.study.dao=DEBUG
      ## 监听spring框架的日志级别
      ## log4j.logger.org.springframework=ERROR

###  ###

### 15.部署项目到tomcat服务器进行测试 ###

**部署项目：**

**![watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBAQ29kZXJfQ3Vp_size_20_color_FFFFFF_t_70_g_se_x_16 3][]**

**测试页面：**

**![watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBAQ29kZXJfQ3Vp_size_20_color_FFFFFF_t_70_g_se_x_16 4][]**

**最终项目结构：**

**![watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBAQ29kZXJfQ3Vp_size_13_color_FFFFFF_t_70_g_se_x_16][]**

![watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBAQ29kZXJfQ3Vp_size_13_color_FFFFFF_t_70_g_se_x_16 1][]

### 【完结】 ###

[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBAQ29kZXJfQ3Vp_size_20_color_FFFFFF_t_70_g_se_x_16]: https://img-blog.csdnimg.cn/0c06f11734b04db4b20331566d073079.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBAQ29kZXJfQ3Vp,size_20,color_FFFFFF,t_70,g_se,x_16
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBAQ29kZXJfQ3Vp_size_20_color_FFFFFF_t_70_g_se_x_16 1]: https://img-blog.csdnimg.cn/81d6102b1f104507961f14f545f6da5c.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBAQ29kZXJfQ3Vp,size_20,color_FFFFFF,t_70,g_se,x_16
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBAQ29kZXJfQ3Vp_size_20_color_FFFFFF_t_70_g_se_x_16 2]: https://img-blog.csdnimg.cn/9da82dcd795c44bf99dac82582e45f00.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBAQ29kZXJfQ3Vp,size_20,color_FFFFFF,t_70,g_se,x_16
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBAQ29kZXJfQ3Vp_size_20_color_FFFFFF_t_70_g_se_x_16 3]: https://img-blog.csdnimg.cn/aad585d5f2d743ba910f8b12450f582a.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBAQ29kZXJfQ3Vp,size_20,color_FFFFFF,t_70,g_se,x_16
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBAQ29kZXJfQ3Vp_size_20_color_FFFFFF_t_70_g_se_x_16 4]: https://img-blog.csdnimg.cn/c09274c1b1f64928855e356acd767864.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBAQ29kZXJfQ3Vp,size_20,color_FFFFFF,t_70,g_se,x_16
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBAQ29kZXJfQ3Vp_size_13_color_FFFFFF_t_70_g_se_x_16]: https://img-blog.csdnimg.cn/1b417747e6254f9795abc6f16a7a9945.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBAQ29kZXJfQ3Vp,size_13,color_FFFFFF,t_70,g_se,x_16
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBAQ29kZXJfQ3Vp_size_13_color_FFFFFF_t_70_g_se_x_16 1]: https://img-blog.csdnimg.cn/4fd51e4e3e2346fdaaec210193c4c426.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBAQ29kZXJfQ3Vp,size_13,color_FFFFFF,t_70,g_se,x_16