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

Coder_Cui

已于 2022-05-01 15:48:29 修改

阅读量391

点赞数

分类专栏： Mybatis 文章标签： mysql spring struts2

于 2022-04-19 19:42:25 首次发布

本文链接：https://blog.csdn.net/xiaocui1995/article/details/124281478

版权

Mybatis 专栏收录该内容

6 篇文章 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>
  
  <!--spring相关-->
  <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>
  
  <!--mybatis-->
  <dependency>
    <groupId>org.mybatis</groupId>
    <artifactId>mybatis</artifactId>
    <version>3.5.4</version>
  </dependency>
  
  <!--mybatis-spring-->
  <dependency>
    <groupId>org.mybatis</groupId>
    <artifactId>mybatis-spring</artifactId>
    <version>2.0.4</version>
  </dependency>
  
  <!--mysql-->
  <dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>5.1.38</version>
  </dependency>
  
  <!--druid-->
  <dependency>
    <groupId>com.alibaba</groupId>
    <artifactId>druid</artifactId>
    <version>1.1.19</version>
  </dependency>
  
  <!--struts相关 2.3.16版本一致-->
  <dependency>
    <groupId>org.apache.struts</groupId>
    <artifactId>struts2-core</artifactId>
    <version>2.3.16</version>
  </dependency>
  
  <!--struts2-spring-plugin 2.3.16版本一致-->
  <dependency>
    <groupId>org.apache.struts</groupId>
    <artifactId>struts2-spring-plugin</artifactId>
    <version>2.3.16</version>
  </dependency>
  
  <!--servlet-api-->
  <dependency>
    <groupId>javax.servlet</groupId>
    <artifactId>servlet-api</artifactId>
    <version>2.5</version>
    <scope>provided</scope>
  </dependency>
  
  <!--jstl-->
  <dependency>
    <groupId>jstl</groupId>
    <artifactId>jstl</artifactId>
    <version>1.2</version>
  </dependency>
  
  <!--fastjson-->
  <dependency>
    <groupId>com.alibaba</groupId>
    <artifactId>fastjson</artifactId>
    <version>1.2.62</version>
  </dependency>
  
  <!--log4j-->
  <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">
      <!--userMap-->
      <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>
  
      <!--selectAll-->
      <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>
  
      <!--insertUser-->
      <insert id="insertUser" parameterType="User">
          insert into table_user values (#{id},#{name},#{age},#{bir})
      </insert>
  
      <!--selectUserByNoCard-->
      <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>
  
      <!--selectUserByKeywords-->
      <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">
      <!--insertCard-->
      <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&amp;characterEncoding=UTF-8&amp;serverTimezone=UTC&amp;useSSL=false"/>
          <property name="username" value="root"/>
          <property name="password" value="123456"/>
      </bean>
  
      <!--创建SqlSessionFactory-->
      <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>
  
      <!--创建DAO组件-->
      <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>
  
    <!--配置struts2中核心filter-->
    <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>
  
    <!--配置spring监听器-->
    <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">
          <!--selectAll：http://localhost:8888/mybatis2/user/selectAll-->
          <action name="selectAll" class="userAction" method="selectAll">
              <result name="success">/user/showAllUsers.jsp</result>
          </action>
  
          <!--insertUser：http://localhost:8888/mybatis2/user/insertUser-->
          <action name="insertUser" class="userAction" method="insertUser">
              <result name="success" type="redirectAction">/user/selectAll</result>
          </action>
  
          <!--selectUserByNoCard：http://localhost:8888/mybatis2/user/selectUserByNoCard-->
          <action name="selectUserByNoCard" class="userAction" method="selectUserByNoCard">
              <result name="success">/card/addUserCard.jsp</result>
          </action>
  
          <!--selectUserByKeywords：http://localhost:8888/mybatis2/user/selectUserByKeywords-->
          <action name="selectUserByKeywords" class="userAction" method="selectUserByKeywords">
              <result name="success">/user/showAllUsers.jsp</result>
          </action>
      </package>
  
      <!--处理身份信息模块-->
      <package name="card" extends="struts-default" namespace="/card">
          <!--insertCard：http://localhost:8888/mybatis2/card/insertCard-->
          <action name="insertCard" class="cardAction" method="insertCard">
              <result name="success" type="redirectAction">
                  <!--跨包跳转，注意上面是redirectAction而不是redirect-->
                  <param name="namespace">/user</param>
                  <param name="actionName">selectAll</param>
              </result>
          </action>
      </package>
  </struts>

13.jsp文件

addUser.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">
      <!--
      <link rel="stylesheet" type="text/css" href="styles.css">
      -->
    </head>
    <body>
      <form action="<s:url value="/user/insertUser"/>" method="post">
          用户名:<input type="text" name="user.name"/>
          年龄:<input type="text" name="user.age"/>
          生日:<input type="text" name="user.bir"/><!-- struts2 默认接收日期格式   yyyy-MM-dd -->
          性别:<input type="text" name="user.sex"/>
          <input type="submit" value="提交"/>
      </form>
    </body>
  </html>

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">
      <!--
      <link rel="stylesheet" type="text/css" href="styles.css">
      -->
      <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

  <%@ 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">
      <!--
      <link rel="stylesheet" type="text/css" href="styles.css">
      -->
    </head>
    <body>
      <form action="<s:url value="/card/insertCard"/>" method="post">
          请选择用户信息:
          <select name="card.user.id">
              <s:iterator value="users">
                  <option value="<s:property value="id"/>"><s:property value="name"/></option>
              </s:iterator>
          </select>
          身份编号:<input type="text" name="card.code"/>
          地址:<input type="text" name="card.address"/>
          民族:<input type="text" name="card.fork"/><!-- struts2 默认接收日期格式   yyyy-MM-dd -->
          <input type="submit" value="提交"/>       
      </form>
    </body>
  </html>

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服务器进行测试

部署项目：

测试页面：

最终项目结构：

【完结】

Coder_Cui

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
【编程不良人】MyBatis从入门到精通学习笔记05---Spring+Mybatis+Struts2练习项目

作业：用户与身份信息展示分析：用户和身份信息添加分析：1. 创建Maven-webapp项目，新建java、resources目录以及test目录下的java、resources2. 在pom.xml中引入依赖 <dependency> <groupId>junit</groupId> <artifactId>junit</artifactId> <version&...
复制链接

扫一扫

专栏目录