作业：
用户与身份信息展示分析：
用户和身份信息添加分析：
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&characterEncoding=UTF-8&serverTimezone=UTC&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服务器进行测试
部署项目：
测试页面：
最终项目结构：
扫一扫
147
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
