SSM(Spring+Springmvc+Mybatis)增删改查的创建及整合步骤

我叫刘米加啊啊啊啊

于 2018-07-23 23:20:08 发布

阅读量317

点赞数 2

文章标签： ssm 框架 java

本文链接：https://blog.csdn.net/weixin_42774102/article/details/81175864

版权

1、创建web工程

2、导入相关jar包

在WebContext/WEB-INF/lib中导入jar包

3、创建User类

创建Getter和setter方法

public class User {
	
	private Integer userId;
	private String userName;
	private String userPwd;
	private Integer userAge;
	private String userHobby;
	public Integer getUserId() {
		return userId;
	}
	public void setUserId(Integer userId) {
		this.userId = userId;
	}
	public String getUserName() {
		return userName;
	}
	public void setUserName(String userName) {
		this.userName = userName;
	}
	public String getUserPwd() {
		return userPwd;
	}
	public void setUserPwd(String userPwd) {
		this.userPwd = userPwd;
	}
	public Integer getUserAge() {
		return userAge;
	}
	public void setUserAge(Integer userAge) {
		this.userAge = userAge;
	}
	public String getUserHobby() {
		return userHobby;
	}
	public void setUserHobby(String userHobby) {
		this.userHobby = userHobby;
	}

}

4、编写Mapper接口

public interface UserMapper {
	
	/**
	 * 注册用户
	 * @param user
	 * @return
	 */
	public int reg(User user);
	
	/**
	 * 删除用户
	 * @param user
	 * @return
	 */
	public int delUser(User user);
	
	/**
	 * 修改用户
	 * @param user
	 * @return
	 */
	public int updateUser(User user);
	
	/**
	 * 获取所有用户
	 * @return
	 */
	public List<User> getAllUser();
	
	/**
	 * 根据id查询用户
	 * @param user
	 * @return
	 */
	public User getUserById(User user);
	
	/**
	 * 登录
	 * @param user
	 * @return
	 */
	public User login(User user);

}

5、编写Mapper.xml文件

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
  PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
  "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
  <mapper namespace="com.hxzy.user.mapper.UserMapper">

    <!-- 增加用户 -->
     <insert id="reg" parameterType="User">
         sql语句
     </insert>
     
    <!-- 删除用户 -->
     <delete id="delUser" parameterType="User">
        sql语句
     </delete>
     
    <!-- 修改用户 -->
     <update id="updateUser" parameterType="User">
     	sql语句
     </update>
     
    <!-- 查询所有用户 -->
     <select id="getAllUser" resultType="User">
     	sql语句
     </select>
     
    <!-- 根据ID查询用户 -->
     <select id="getUserById" parameterType="User" resultType="User">
     	sql语句
     </select>
     
    <!-- 用户登录 -->
     <select id="login" parameterType="User" resultType="User">
     	sql语句
     </select>
  </mapper>

6、编写控制层Service层

public interface UserService {
	
	/**
	 * 增加用户
	 * @param user
	 * @return
	 */
	public int reg(User user);
	
	/**
	 * 删除用户
	 * @param user
	 * @return
	 */
	public int delUser(User user);
	
	/**
	 * 修改用户
	 * @param user
	 * @return
	 */
	public int updateUser(User user);
	
	/**
	 * 获取所有用户
	 * @return
	 */
	public List<User> getAllUser();
	
	/**
	 * 根据id查询用户
	 * @param user
	 * @return
	 */
	public User getUserById(User user);
	
	/**
	 * 登录
	 * @param user
	 * @return
	 */
	public User login(User user);

}

7、编写Service的实现类ServiceImp，继承Service接口

@Autowired注解代表注入。

public class UserServiceImp implements UserService {

    //在实现类ServiceImp中注入Mapper接口
	@Autowired
	private UserMapper userMapper;
	
	public int reg(User user) {
		System.out.println("reg");
		return userMapper.reg(user);
	}

	public int delUser(User user) {
		System.out.println("delUser");
		return userMapper.delUser(user);
	}

	public int updateUser(User user) {
		System.out.println("updateUser");
		return userMapper.updateUser(user);
	}

	public List<User> getAllUser() {
		System.out.println("getAllUser");
		return userMapper.getAllUser();
	}

	public User getUserById(User user) {
		System.out.println("getUserById");
		return userMapper.getUserById(user);
	}

	public User login(User user) {
		System.out.println("login");
		return userMapper.login(user);
	}

}

8、编写控制层Controller

1、@Controller注解用于指示该类是一个控制器

2、@RequestMapping是一个用来处理请求地址映射的注解，可用于类或方法上。用于类上，表示类中的所有响应请求的方法都是以该地址作为父路径。

@Controller
@RequestMapping("user")
public class UserController {
	
    //注入UserService
	@Autowired
	private UserService userServiceImp;
	
	/**
	 * 增加用户
	 * @param user
	 * @return
	 */
	@RequestMapping("reg")
	public ModelAndView reg(User user) {
        //调用增加方法
		int i = userServiceImp.reg(user);
        //创建ModelAndView对象
		ModelAndView mav = new ModelAndView();
		if(i==0) {
            //设置跳转页面名称，交由图形解析器
			mav.setViewName("reg");
			return mav;
		}
        //跳转登录页面
		mav.setViewName("forward:/Login.jsp");
		return mav;
	}
	
	/**
	 * 用户删除
	 * @param user
	 * @return
	 */
	@RequestMapping("delUser")
	public ModelAndView delUser(User user) {
        //调用删除方法
		userServiceImp.delUser(user);
        //创建ModelAndView对象
		ModelAndView mav = new ModelAndView();
        //跳转至查询所有用户方法
		mav.setViewName("forward:/user/getAllUser.action");
		return mav;
	}
	
	/**
	 * 用户更新
	 * @param user
	 * @return
	 */
	@RequestMapping("updateUser")
	public ModelAndView updateUser(User user) {
        //调用修改方法
		userServiceImp.updateUser(user);
        //创建ModelAndView对象
		ModelAndView mav = new ModelAndView();
        //跳转至查询所有用户方法
		mav.setViewName("forward:/user/getAllUser.action");
		return mav;
	}

	/**
	 * 获取所有用户
	 * @param user
	 * @return
	 */
	@RequestMapping("getAllUser")
	public ModelAndView getAllUser() {
        //创建ModelAndView对象
		ModelAndView mav = new ModelAndView();
        //调用查询所有用户方法，用List接住
		List<User> allUser = userServiceImp.getAllUser();
        放入ModelAndView中，标识为list
		mav.addObject("list", allUser);
        
		mav.setViewName("showAll");
		return mav;
	}

	/**
	 * 根据id查询用户
	 * @param user
	 * @return
	 */
	@RequestMapping("getUserById")
	public ModelAndView getUserById(User user) {
        //调用查询所有用户方法
		User userss = userServiceImp.getUserById(user);
        //创建ModelAndView对象
		ModelAndView mav = new ModelAndView();
        放入ModelAndView中，标识为list
		mav.addObject("user", userss);
        //设置跳转页面名称，交由图形解析器
		mav.setViewName("updatePage");
		return mav;
	}

	/**
	 * 登录
	 * @param user
	 * @return
	 */
	@RequestMapping("login")
	public ModelAndView login(User user) {
		ModelAndView mav = new ModelAndView();
		User users = userServiceImp.login(user);
		if(users==null) {
			mav.addObject("ma","账户或密码错误" );
			mav.setViewName("Login");
		}
		mav.addObject("user", users);
		mav.setViewName("forward:/user/getAllUser.action");
		return mav;
	}

}

9、编写springmvc.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:p="http://www.springframework.org/schema/p"
	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/context
        http://www.springframework.org/schema/context/spring-context.xsd">
	<!-- 注解扫描 -->
	<context:component-scan base-package="com.hxzy.*.controller" />

	<!-- 视图解析器 -->
	<bean id="ViewResolver"
		class="org.springframework.web.servlet.view.InternalResourceViewResolver">
		<!-- 前缀 -->
		<property name="prefix" value="/WEB-INF/jsp/" />
		<!-- 后缀 -->
		<property name="suffix" value=".jsp" />
	</bean>
</beans>

10、编写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>
	<!-- 指定包名，mybatis自动扫描扫描pojo类 -->
	<typeAliases>
		<package name="com.hxzy.user.pojo" />
	</typeAliases>
</configuration>

11、编写applicationContext.xml文件

1、applicationContext-service.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:p="http://www.springframework.org/schema/p"
    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/context
        http://www.springframework.org/schema/context/spring-context.xsd">
        
        <!-- 创建ServiceImp的实例 -->
        <bean id="userServiceImp" class="com.hxzy.user.service.imp.UserServiceImp"></bean>
 </beans>

2、applicationContext-dao.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:aop="http://www.springframework.org/schema/aop"
	xmlns:tx="http://www.springframework.org/schema/tx"
	xsi:schemaLocation="http://www.springframework.org/schema/beans
        http://www.springframework.org/schema/beans/spring-beans.xsd
        http://www.springframework.org/schema/aop
        http://www.springframework.org/schema/aop/spring-aop.xsd
        http://www.springframework.org/schema/tx
        http://www.springframework.org/schema/tx/spring-tx.xsd">
	<!--1, 配置c3p0数据源 -->
	<bean id="dataSource"
		class="com.mchange.v2.c3p0.ComboPooledDataSource">
		<property name="jdbcUrl"
			value="jdbc:mysql://localhost:3306/数据库名"></property>
		<property name="driverClass" value="com.mysql.jdbc.Driver"></property>
		<property name="user" value="root"></property>
		<property name="password" value="数据库密码"></property>
	</bean>

	<!-- 配置mybatis中创建SqlSessionFactory -->
	<bean id="sqlSessionFactory"
		class="org.mybatis.spring.SqlSessionFactoryBean">
		<!-- 连接池 -->
		<property name="dataSource" ref="dataSource" />
		<!-- 加载mybatis配置 -->
		<property name="configLocation"
			value="classpath:mybatis/mybatis-config.xml" />
		<!-- mapper.xml扫描 -->
		<property name="mapperLocations" value="classpath:mybatis/UserMapper.xml" />
	</bean>

	<!-- 通过包扫描方式加载所有的mapper(dao接口) -->
	<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
		<property name="basePackage" value="com.hxzy.*.mapper" />
	</bean>
</beans>

12、配置web.xml文件

<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xmlns="http://java.sun.com/xml/ns/javaee"
	xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd"
	id="WebApp_ID" version="2.5">
	<display-name>ssm01</display-name>
	<welcome-file-list>
		<welcome-file>index.html</welcome-file>
		<welcome-file>index.htm</welcome-file>
		<welcome-file>index.jsp</welcome-file>
		<welcome-file>default.html</welcome-file>
		<welcome-file>default.htm</welcome-file>
		<welcome-file>default.jsp</welcome-file>
	</welcome-file-list>

    <!-- springmvc前端控制器配置 -->
	<servlet>
		<servlet-name>ssm1</servlet-name>
		<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
	    <init-param>
	    <param-name>contextConfigLocation</param-name>
	    <param-value>classpath:spring/springmvc.xml</param-value>
	    </init-param>
	    <load-on-startup>1</load-on-startup>
	</servlet>

	<servlet-mapping>
		<servlet-name>ssm1</servlet-name>
        //访问方法时需加上后缀
		<url-pattern>*.action</url-pattern>
	</servlet-mapping>
	
	<!-- Spring监听器 -->
	<listener>
		<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
	</listener>
	<!-- Spring配置文件位置 -->
	<context-param>
		<param-name>contextConfigLocation</param-name>
		<param-value>classpath*:spring/applicationContext-*.xml</param-value>
	</context-param>
</web-app>

13、增加用户jsp页面

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!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>Insert title here</title>
</head>
<body>
<form action="user/reg.action">
	用户名:<input type="text" name="userName"><br>
	密码:<input type="password" name="userPwd"/><br>
	确认密码:<input type="password" name="reUserPwd"><br>
	年龄:<input type="text" name="userAge"><br>
	兴趣:<input type="text" name="userHobby"><br>
	<input type="submit" value="注册">
</form>
</body>
</html>

14、获取所有用户jsp页面

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<%@taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
</head>
<body>
<table border="1" align="center">
	<tr>
		<td>userId</td>
		<td>userName</td>
		<td>userAge</td>
		<td>userHobby</td>
	</tr>

    <!-- ${list}要与Controller内ModelAndView设置的标识名一致 -->
	<c:forEach items="${list}" var="user">
		<tr>
			<td>${user.userId}</td>
			<td>${user.userName}</td>
			<td>${user.userAge}</td>
			<td>${user.userHobby}</td>
			<td><a href="delUser.action?userId=${user.userId}">删除</a><a href="getUserById.action?userId=${user.userId}">修改</a></td>
		</tr>
	</c:forEach>
</table>
</body>
</html>

15、修改用户jsp页面

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!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>Insert title here</title>
</head>
<body>
	<form action="updateUser.action" method="post">
		<table>
			<input type="hidden" name="userId"
					value="${user.userId}">
			<tr>
				<td>用户名:<input type="text" name="userName"
					value="${user.userName}">
				</td>
			</tr>
			<tr>
				<td>年龄:<input type="text" name="userAge"
					value="${user.userAge}">
				</td>
			</tr>
			<tr>
				<td>爱好:<input type="text" name="userHobby"
					value="${user.userHobby}">
				</td>
			</tr>
			<tr>
				<td><input type="submit" name="add" value="提交"></td>
			</tr>
		</table>
	</form>
</body>
</html>