Structs2+Mybatis+Spring框架整合
Structs+mybatis+Spring整合及增删改查测试。话不多说,直接上教程。
-
maven安装及项目创建
-
在pom中下载jar包
-
配置文件,5个xml和一个db.property
-
创建package和类
-
webapp创建对应jsp页面,maven中的WEB-INF文件,需要我们自己创建
-
创建好项目的截图
以上是我们需要操作的大概步骤,下面我将会为大家一一操作。
以下代码可直接复制。
一、maven安装及项目创建
请参考,Maven的安装与配置及创建Maven项目:https://blog.csdn.net/suquan7457/article/details/81448580
二、在pom中下载jar包 pom.xml
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
<modelVersion>4.0.0</modelVersion>
<groupId>com</groupId>
<artifactId>ssm_Maven</artifactId>
<version>0.0.1-SNAPSHOT</version
<properties>
<struts.version>2.3.28</struts.version>
<spring.version>3.0.5.RELEASE</spring.version>
<mybatis.version>3.2.6</mybatis.version>
<log4j.version>1.2.17</log4j.version>
</properties>
<dependencies>
<!-- struts包 -->
<dependency>
<groupId>org.apache.struts</groupId>
<artifactId>struts2-core</artifactId>
<version>${struts.version}</version>
</dependency>
<dependency>
<groupId>org.apache.struts</groupId>
<artifactId>struts2-spring-plugin</artifactId>
<version>${struts.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-jdbc</artifactId>
<version>${spring.version}</version>
</dependency>
<!-- mybatis核心包 -->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>${mybatis.version}</version>
</dependency>
<!-- mybatis-spring包 -->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis-spring</artifactId>
<version>1.2.2</version>
</dependency>
<!-- java ee 包 -->
<dependency>
<groupId>javax</groupId>
<artifactId>javaee-api</artifactId>
<version>7.0</version>
</dependency>
<!-- Mysql数据库链接jar包 -->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.30</version>
</dependency>
<dependency>
<groupId>commons-dbcp</groupId>
<artifactId>commons-dbcp</artifactId>
<version>1.2.2</version>
</dependency>
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>3.8.1</version>
<scope>test</scope>
</dependency>
</dependencies>
<build>
<finalName>javaweb</finalName>
</build>
</project>
导入后可以在这里查看jar包是否导入成功。
三、配置文件,5个xml和一个db.property 文件名字可随意
我会尽量给代码进行文字说明
applicationContext.xml、mybatis-config.xml、struct_user.xml
struts.xml、jdbc.properties
applicationContext.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:context="http://www.springframework.org/schema/context"
xsi:schemaLocation="
http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.0.xsd
http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-3.0.xsd">
<!-- 配置要扫描的包 -->
<context:component-scan base-package="action"></context:component-scan>
<context:component-scan base-package="service.impl"></context:component-scan>
<context:component-scan base-package="service"></context:component-scan>
<context:component-scan base-package="dao"></context:component-scan>
<!-- 指定数据源配置文件 -->
<context:property-placeholder location="classpath:jdbc.properties" />
<!-- 数据源 -->
<bean id="dataSource_dev" class="org.apache.commons.dbcp.BasicDataSource"
destroy-method="close">
<property name="driverClassName" value="${driver}" />
<property name="url" value="${url}" />
<property name="username" value="${username}" />
<property name="password" value="${password}" />
</bean>
<!-- 配置sqlSessionFactory -->
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<property name="dataSource" ref="dataSource_dev" />
<property name="mapperLocations" value="classpath:mapper/*.xml" />
</bean>
<!-- 指定DAO层 -->
<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<property name="basePackage" value="dao" />
<property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"></property>
</bean>
<!-- 使用Spring的事务管理器 -->
<bean id="transactionManager"
class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource" ref="dataSource_dev" />
</bean>
</beans>
mybatis-config.xml
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
<settings>
<!-- 开启二级缓存 默认值为true -->
<setting name="cacheEnabled" value="true" />
<!-- 全局启用或禁用延迟加载 -->
<setting name="lazyLoadingEnabled" value="true" />
<!-- 当启用时, 有延迟加载属性的对象在被 调用时将会完全加载任意属性。 -->
<setting name="aggressiveLazyLoading" value="true" />
</settings>
<typeAliases> </typeAliases>
</configuration>
struct_user.xml 用于获取action中返回值并跳转到对应页面
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE struts PUBLIC "-//Apache Software Foundation//DTD Struts Configuration 2.1//EN" "http://struts.apache.org/dtds/struts-2.1.dtd">
<struts>
<package name="user" namespace="/user" extends="struts-default">
<action name="*" class="action.UserAction" method="{1}">
<result name="list">/getAlluser.jsp</result>
<result name="ok">/success.jsp</result>
<result name="error">/success2.jsp</result>
</action>
</package>
</struts>
struts.xml
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE struts PUBLIC "-//Apache Software Foundation//DTD Struts Configuration 2.1//EN" "http://struts.apache.org/dtds/struts-2.1.dtd">
<struts>
<!-- 指定默认编码集 -->
<constant name="struts.i18n.encoding" value="UTF-8" />
<!-- 上传文件大小限制设置 -->
<constant name="struts.multipart.maxSize" value="99000000" />
<!-- 用来设置上传文件的临时目录 -->
<constant name="struts.multipart.saveDir" value="/tmp" />
<!-- 当struts配置文件修改时是否自动加载 -->
<constant name="struts.configuration.xmlreload" value="true" />
<!-- 开发模式下打印详细的错误信息 -->
<constant name="struts.devMode" value="false" />
<!-- 主题,将值设置为xhtml,默认,带一些struts2提供的模块 -->
<constant name="struts.ui.theme" value="xhtml" />
<!-- 使用动态方法调用 -->
<constant name="struts.enable.DynamicMethodInvocation" value="true"/>
<constant name="struts.objectFactory" value="spring"/>
<constant name="struts.objectFactory.spring.autoWire" value="true"/>
<include file="struct_user.xml"></include> //获取struct_user.xml文件内容
</struts>
web.xml
<!-- spring的配置文件位置 -->
<context-param>
<param-name>contextConfigLocation</param-name>
<param-value>classpath:applicationContext.xml</param-value>
</context-param>
<!-- struts2过滤器配置 -->
<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>
jdbc.properties 用于数据库连接
driver=com.mysql.jdbc.Driver //数据库驱动
url=jdbc:mysql://localhost:3306/ssm_test //ssm_test 数据库名
username=root //用户名
password=123456 //密码
# DBCP Pool settings
initialSize=0 //连接池自动创建的初始值
maxActive=20 // 同一时间内可分配的最大数量
maxIdle=20 //最大空闲连接
minIdle=1 //最小空闲连接
maxWait=60000 //最大等待时间
四、创建包和类
action:UserAction.java
beans:User.java
dao:IUserDao.java
service:IUserService.java
service.impl:UserService.java
action:UserAction.java
/**
* @author blz 调用service层方法,与前端交互
*/
@Controller
@Scope("prototype")
public class UserAction extends ActionSupport {
private static final long serialVersionUID = 1L;
private User user; //get和set方法,此处省略
private List<User> userlist; //get和set方法,此处省略
@Resource
private IUserService userService; // 调用service接口
UserAction useraction;
public String execute() throws Exception {
System.out.println("execute");
return SUCCESS;
}
/**
* @author blz
* 增加用户
* @return
*/
public String addUser() {
HttpServletRequest request = ServletActionContext.getRequest();
String name = request.getParameter("name");
String age = request.getParameter("age");
String email = request.getParameter("email");
String sex = request.getParameter("sex");
String phone = request.getParameter("phone");
String pwd = request.getParameter("pwd");
User user = new User();
user.setName(name);
user.setAge(age);
user.setEmail(email);
user.setSex(sex);
user.setPhone(phone);
user.setPwd(pwd);
userService.addUser(user);
return "ok";
}
/**
* 查询
* @author blz 查询所有用户信息
* @return
*/
public String queryAllUser() {
userlist = userService.queryAll();
System.out.println("userlist"+userlist);
if (userlist.size() != 0) {
return "list";
}
return "error";
}
// 根据id查询用户信息
public String queryUserNameByID() throws IOException {
HttpServletRequest request = ServletActionContext.getRequest();
String id = request.getParameter("id");
Integer id1 = Integer.valueOf(id);
userlist = userService.queryUserById(id1);
return "list";
}
/**
* @author blz
* 根据删除用户
* @return
*/
public String deleteUser() {
HttpServletRequest request = ServletActionContext.getRequest();
// String id = request.getParameter("id");
Integer id = Integer.valueOf(request.getParameter("id"));
userService.deleteUser(id);
userlist = userService.queryUserById(id);
if (userlist.size() != 0) {
return "error";
}
return "ok";
}
// 根据id更新用户信息
public String updateUser() {
HttpServletRequest request = ServletActionContext.getRequest();
String name = request.getParameter("name");
String pwd = request.getParameter("pwd");
String age = request.getParameter("age");
String email = request.getParameter("email");
String sex = request.getParameter("sex");
String phone = request.getParameter("phone");
User user = new User();
user.setName(name);
user.setAge(age);
user.setEmail(email);
user.setSex(sex);
user.setPhone(phone);
user.setPwd(pwd);
userService.updateUser(user);
return "ok";
}
beans:User.java
public class User {
private Integer id;
private String name;
private String pwd;
private String sex;
private String age;
private String email;
private String phone;
get和set方法省略.... 鼠标右键,选择source,点击getters和setters
}
dao:IUserDao.java 接口类
//执行相应的语句
public interface IUserDao {
@Insert("insert into f_user_t(name,pwd,sex,age,email,phone) values(#{name},#{pwd},#{age},#{email}, #{sex},#{phone})")
public void addUser(User user);
@Delete("delete from f_user_t where id=#{id}")
public void delUser(Integer userId);
@Select("select * from f_user_t where id=#{id}")
public List<User> queryUserById(Integer userId);
@Select("select * from f_user_t")
public List<User> queryAll();
@Update("update f_user_t set name=#{name}, age=#{age},email=#{email}, sex=#{sex} where phone=#{phone}")
public void updateUser(User user);
}
https://mp.csdn.net/postedit/79114665 这篇文章中有mybatis的专门说明与配置
service:IUserService.java 接口类
public interface IUserService {
public void addUser(User user);
public void deleteUser(Integer userId);
public List<User> queryUserById(Integer userId);
public List<User> queryAll();
public void updateUser(User user);
}
service.impl:UserService.java 接口实现类
@Service
@Transactional
public class UserService implements IUserService{
@Autowired
IUserDao userdao; //调用dao层接口
@Override
public void addUser(User user) {
userdao.addUser(user);
}
@Override
public void deleteUser(Integer userId) {
userdao.delUser(userId);
}
@Override
public List<User> queryUserById(Integer userId) {
return userdao.queryUserById(userId);
}
@Override
public List<User> queryAll() {
return userdao.queryAll();
}
@Override
public void updateUser(User user) {
userdao.updateUser(user);
}
}
五:webapp创建对应jsp页面,maven中的WEB-INF文件,需要我们自己创建
上图为表中数据,下面将会进行曾删改查。
test1.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8"
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" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>test</title>
</head>
<body>
<s:form action="UserAction!addUser.action" method="post" namespace="/user" >
添加用户:<input type="submit" value="添加"/>
</s:form>
<s:form action="UserAction!queryUserNameByID.action" method="post" namespace="/user" >
修改用户:<input type="text" name="id"/>
<input type="submit" value="修改"/>
</s:form>
<s:form action="UserAction!deleteUser.action" method="post" namespace="/user" >
删除用户:<input type="text" name="id"/>
<input type="submit" value="删除"/>
</s:form>
<s:form action="UserAction!queryAllUser.action" method="post" namespace="/user" >
查询所有用户:<input type="submit" value="查询所有"/>
</s:form>
<%-- 若传递的值固定可用该方法
<s:a action="deleteUser" namespace="/user">
<s:param name="id" value="1" />删除</s:a>
<s:a action="queryUserNameByID" namespace="/user">
<s:param name="id" value="2" />查询</s:a> --%>
</body>
</html>
getAlluser.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8"
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" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>test 用户列表</title>
<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
</head>
<body>
<center>
<h2 align="center">用户列表</h2>
<h3>
<s:a action="toadd" namespace="/user">添加新用户</s:a>
</h3>
<table width="90%" border="1">
<tr>
<th>用户id</th>
<th>用户名称</th>
<th>用户密码</th>
<th>age</th>
<th>email</th>
<th>sex</th>
<th>phone</th>
<th>操作</th>
</tr>
<s:iterator value="userlist">
<tr align="center">
<td><s:property value="id" /></td>
<td><s:property value="name" /></td>
<td><s:property value="pwd" /></td>
<td><s:property value="age" /></td>
<td><s:property value="email" /></td>
<td><s:property value="sex" /></td>
<td><s:property value="phone" /></td>
<td>
<a href="<%=basePath %>detail.jsp">添加</a>
/ <s:a action="deleteUser" namespace="/user">
<s:param name="id" value='id' />删除</s:a>
</td>
</tr>
</s:iterator>
</table>
</center>
</body>
</html>
detail.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@ taglib prefix="s" uri="/struts-tags"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<link rel="stylesheet" href="WEB-INF/lib/icon.css" />
<link rel="stylesheet" href="WEB-INF/lib/easyui.css" />
<script type="text/javascript" src="WEB-INF/lib/easyui-lang-zh_CN.js" ></script>
<script type="text/javascript" src="WEB-INF/lib/jquery.easyui.min.js" ></script>
<script type="text/javascript" src="WEB-INF/lib/jquery.min.js" ></script>
<title>修改页</title>
</head>
<body>
<div style="padding: 3px 2px; border-bottom: 1px solid #ccc">修改</div>
修改用户
<s:form id="ff" action="UserAction!updateUser.action" method="post" namespace="/user">
<div>
<label for="name">name:</label>
<input class="easyui-validatebox" type="text" name="name" required="true"></input>
</div>
<div>
<label for="age">age:</label>
<input class="easyui-validatebox" type="text" name="age" required="true"></input>
</div>
<div>
<label for="email">email:</label>
<input class="easyui-validatebox" type="text" name="email" required="true" validType="email"></input>
</div>
<div>
<label for="sex">sex:</label>
<input class="easyui-validatebox" type="text" name="sex" required="true"></input>
</div>
<div>
<label for="phone">phone:</label>
<input class="easyui-validatebox" type="text" name="phone" required="true"></input>
</div>
<div>
<label for="pwd">password:</label>
<input class="easyui-validatebox" type="text" name="pwd" required="true"></input>
</div>
<div>
<input type="submit" value="修改">
</div>
</s:form>
</body>
</html>
PS:说明:在这里我修改和添加用的都是detail.jsp页面,UserAction!updateUser.action跳转到修改用户方法,若改成UserAction!addUser.action,则会跳转到添加用户方法。
success.jsp
<title>成功页面</title>
</head>
<body>
Success!
</body>
success2.jsp
<title>查询失败</title>
</head>
<body>
失败!
</body>
增删改查,页面和结果显示。
-
查询所有用户
此时数据库表中没有任何数据,因此会跳转到失败页面。
当我们加上数据后,查询结果:
2、删除id为1的用户
删除前:
删除后:
页面显示:
3、修改用户id为2的用户:
点击修改: 此处修改条件 是根据手机号进行修改 语句在IUserDao 接口中。
填入数据:
修改成功:
我们再把该用户删除,点击删除
该用户已被删除
4、最后我们再把用户2添加:
点击查询所有用户或者修改用户
点击添加:
再查询一次所有用户:
说明:Mysql中我的id设置为自增长,因此用户id为14。
到此,Structs2+Mybatis+Spring框架整合完毕。