SSM整合的小项目（简单单表CRUD操作）

港控/mmm° 2021-12-13 02:35 377阅读 0赞

## 标题Spring+SpingMVC+Mybatis的集成 ##

**1.创建项目**  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2RwZjM3MzUyMQ_size_16_color_FFFFFF_t_70]

这个小项目是简单的单表的CRUD，没用到vo包，它只是继承了domian里面的类。

**2.导包**  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2RwZjM3MzUyMQ_size_16_color_FFFFFF_t_70 1]  
log4j  
![在这里插入图片描述][20190713112235896.png]  
mybatis以及mysql驱动包  
![在这里插入图片描述][20190713112259341.png]  
![在这里插入图片描述][20190713112321182.png]  
**3.创建springmvc.xml**  
spring+springmvc集成配置

<?xml version="1.0" encoding="UTF-8"?>

<context:component-scan
    	base-package="com.sxt.controller"></context:component-scan>
    
    
    <mvc:annotation-driven></mvc:annotation-driven>
    
    
    <bean
    	class="org.springframework.web.servlet.view.InternalResourceViewResolver">
    	
    	<property name="prefix" value="/WEB-INF/view/"></property>
    	<property name="suffix" value=".jsp"></property>
    </bean>  
    
    <mvc:default-servlet-handler/>

\*\*4.配置web.xml\*\* <?xml version="1.0" encoding="UTF-8"?> ssm

<filter>
    	<filter-name>EncodingFilter</filter-name>
    	<filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
    	
    	<init-param>
    		<param-name>encoding</param-name>
    		<param-value>UTF-8</param-value>
    	</init-param>
    </filter>
    
    <filter-mapping>
    	<filter-name>EncodingFilter</filter-name>
    	
    	<servlet-name>springmvc</servlet-name>
    </filter-mapping>
    
    
    
    <listener>
    	<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
    </listener>
    <context-param>
    	<param-name>contextConfigLocation</param-name>
    	<param-value>classpath:applicationContext.xml</param-value>
    </context-param>
    
    
    
    
    
    
    <servlet>
    	<servlet-name>springmvc</servlet-name>
    	<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
    	
    	<init-param>
    		<param-name>contextConfigLocation</param-name>
    		<param-value>classpath:springmvc.xml</param-value>
    	</init-param>
    	
    	<load-on-startup>1</load-on-startup>
    </servlet>
    
    <servlet-mapping>
    	<servlet-name>springmvc</servlet-name>
    	
    	<url-pattern>*.action</url-pattern>
    </servlet-mapping>

index.html index.htm index.jsp default.html default.htm default.jsp

**5.整合mybatis配置**  
创建log4j  
![在这里插入图片描述][20190713112833969.png]  
创建db.properties  
![在这里插入图片描述][20190713112906955.png]  
**6.创建application-dao.xml**

<?xml version="1.0" encoding="UTF-8"?>

<context:property-placeholder location="classpath:db.properties" system-properties-mode="FALLBACK"/>
    
    
    <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
    	
    	<property name="driverClassName" value="${driverClassName}"></property>
    	<property name="url" value="${url}"></property>
    	<property name="username" value="${username}"></property>
    	<property name="password" value="${password}"></property>
    </bean>
    
    
    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
    	
    	<property name="dataSource" ref="dataSource"></property>
    	
    	<property name="mapperLocations">
    		<array>
    			<value>classpath:mapper/*Mapper.xml</value>
    		</array>
    	</property>
    	
    	<property name="plugins">
    		<array>
    			<bean class="com.github.pagehelper.PageInterceptor"></bean>
    		</array>
    	</property>
    	
    	<property name="typeAliasesPackage" value="com.sxt.domain"></property>
    </bean>
    
    
    
    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
    	
    	
    	<property name="basePackage" >
    		<value>
    			com.sxt.mapper
    		</value>
    	</property>
    	
    	<property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"></property>
    </bean>

**7.创建application-service.xml**

<?xml version="1.0" encoding="UTF-8"?>

<context:component-scan base-package="com.sxt.service.impl"></context:component-scan>
    
    
    <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
    	 <property name="dataSource" ref="dataSource"></property>
    </bean>	
    
    
    
    <tx:advice id="advise" transaction-manager="transactionManager">
    	<tx:attributes>
    		
    		<tx:method name="add*" propagation="REQUIRED"/>
    		<tx:method name="save*" propagation="REQUIRED"/>
    		<tx:method name="update*" propagation="REQUIRED"/>		
    		<tx:method name="delete*" propagation="REQUIRED"/>		
    		<tx:method name="change*" propagation="REQUIRED"/>		
    		<tx:method name="reset*" propagation="REQUIRED"/>	
    		<tx:method name="get*" read-only="true"/>
    		<tx:method name="load*" read-only="true"/>
    		<tx:method name="*" read-only="true"/>	
    	</tx:attributes>
    </tx:advice>
    
    <aop:config>
    	
    	<aop:pointcut expression="execution(* com.sxt.service.impl.*.*(..))" id="pc1"/>
    	
    	<aop:advisor advice-ref="advise" pointcut-ref="pc1"/>
    </aop:config>

**8.创建application-context**  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2RwZjM3MzUyMQ_size_16_color_FFFFFF_t_70 2]  
**9.完成用户的CRUD操作**  
9.1.创建实体类  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2RwZjM3MzUyMQ_size_16_color_FFFFFF_t_70 3]  
9.2.生成UserMapper  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2RwZjM3MzUyMQ_size_16_color_FFFFFF_t_70 4]  
9.3.生成UserMapper.xml  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2RwZjM3MzUyMQ_size_16_color_FFFFFF_t_70 5]  
9.4.生成UserService

public interface UserService \{

public List<User> queryAllUser( UserVo userVo);
    
    public void addUser(UserVo userVo);
    
    public User queryUserById(Integer id);
    
    public void updateUser(UserVo userVo);
    
    public void deleteUser(Integer id);

\}  
9.5.创建UserService.impl

@Service  
public class UserServiceImpl implements UserService \{

@Autowired
    private UserMapper userMapper;
    
    @Override
    public List<User> queryAllUser(UserVo userVo) {
    	return this.userMapper.queryAllUser( userVo);
    }
    
    @Override
    public void addUser(UserVo userVo) {
    
    	this.userMapper.insertSelective(userVo);
    }
    
    @Override
    public User queryUserById(Integer id) {
    	return this.userMapper.selectByPrimaryKey(id);
    }
    
    @Override
    public void updateUser(UserVo userVo) {
    	this.userMapper.updateByPrimaryKeySelective(userVo);
    }
    
    @Override
    public void deleteUser(Integer id) {
    	userMapper.deleteByPrimaryKey(id);
    }

9.6.生成Controller  
package com.sxt.controller;

import java.util.List;

import org.springframework.beans.factory.annotation.Autowired;  
import org.springframework.stereotype.Controller;  
import org.springframework.ui.Model;  
import org.springframework.web.bind.annotation.RequestMapping;

import com.sxt.domain.User;  
import com.sxt.service.UserService;  
import com.sxt.vo.UserVo;

/\*\*

*  用户控制类  
    \*/  
    @Controller  
    @RequestMapping(“user”)  
    public class UserController \{
    
    @Autowired  
    private UserService userService;
    
    /\*\*
    
     *  全查询  
        \*/  
        @RequestMapping(“queryAllUser”)  
        public String queryAllUser(UserVo userVo, Model model) \{  
        List list = userService.queryAllUser(userVo);  
        model.addAttribute(“list”, list);  
        return “list”;  
        \}
    
    /\*\*
    
     *  跳转到添加页面  
        \*/  
        @RequestMapping(“toAddUser”)  
        public String toAddUser() \{  
        return “add”;  
        \}
    
    /\*\*
    
     *  添加用户  
        \*/  
        @RequestMapping(“addUser”)  
        public String addUser(UserVo userVo) \{  
        // 调用添加方法  
        System.err.println(userVo.toString());  
        userService.addUser(userVo);
        
        return “redirect:queryAllUser.action”;  
        \}
    
    /\*\*
    
     *  跳转到修改页面  
        \*/  
        @RequestMapping(“toUpdateUser”)  
        public String toUpdateUser(Integer id, Model model) \{  
        // 根据id查询用户对象  
        User user = this.userService.queryUserById(id);  
        model.addAttribute(“user”, user);  
        return “update”;  
        \}
    
    /\*\*
    
     *  修改用户  
        \*/  
        @RequestMapping(“updateUser”)  
        public String updateUser(UserVo userVo) \{  
        // 调用添加方法  
        userService.updateUser(userVo);  
        return “redirect:queryAllUser.action”;  
        \}
    
    /\*\*
    
     *  删除用户  
        \*/  
        @RequestMapping(“deleteUser”)  
        public String deleteUser(Integer id) \{  
        // 调用添加方法  
        userService.deleteUser(id);  
        return “redirect:queryAllUser.action”;  
        \}

9.7.创建index.jsp  
![在这里插入图片描述][20190713113925998.png]  
9.8.用户主页list.jsp  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2RwZjM3MzUyMQ_size_16_color_FFFFFF_t_70 6]  
9.9.添加页面add.jsp  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2RwZjM3MzUyMQ_size_16_color_FFFFFF_t_70 7]  
9.10.修改页面update.jsp  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2RwZjM3MzUyMQ_size_16_color_FFFFFF_t_70 8]  
**10.发布测试**  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2RwZjM3MzUyMQ_size_16_color_FFFFFF_t_70 9]  
![在这里插入图片描述][20190713114610294.png]  
![在这里插入图片描述][20190713114626828.png]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2RwZjM3MzUyMQ_size_16_color_FFFFFF_t_70]: /images/20211210/8768044d1d124c889be6f93c8d74086a.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2RwZjM3MzUyMQ_size_16_color_FFFFFF_t_70 1]: /images/20211210/386b8b4650864cb994c2dcac04338e66.png
[20190713112235896.png]: /images/20211210/c9d1f9a5967d45efb2b94314cf8dee1a.png
[20190713112259341.png]: /images/20211210/3a5d2e9ad7434a39a64e476a7b57a792.png
[20190713112321182.png]: /images/20211210/92a49c68697d4e0cb6a42a4614a803f5.png
[20190713112833969.png]: /images/20211210/57c55b32d0e04ceab476c824b083220c.png
[20190713112906955.png]: /images/20211210/aea61b81601d4e288e3453cf5c166d7b.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2RwZjM3MzUyMQ_size_16_color_FFFFFF_t_70 2]: /images/20211210/7e11a45e0df64613868a145c6fbb8eec.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2RwZjM3MzUyMQ_size_16_color_FFFFFF_t_70 3]: /images/20211210/bc4ee26f52bc44c88fd04586b9dc37b7.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2RwZjM3MzUyMQ_size_16_color_FFFFFF_t_70 4]: /images/20211210/dcca82a166e749b2af278199583b142f.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2RwZjM3MzUyMQ_size_16_color_FFFFFF_t_70 5]: /images/20211210/a31d6a3813794f0a88057a08b449d389.png
[20190713113925998.png]: /images/20211210/497b8936e3c6420ab2a6a9f857c6a8f3.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2RwZjM3MzUyMQ_size_16_color_FFFFFF_t_70 6]: /images/20211210/6d83b4d704c34e59aac8684d0d977bf4.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2RwZjM3MzUyMQ_size_16_color_FFFFFF_t_70 7]: /images/20211210/aeb26a33c46d4f0793fa6a7098706583.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2RwZjM3MzUyMQ_size_16_color_FFFFFF_t_70 8]: /images/20211210/212e0a8e6c1443b7863a343f9419b256.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2RwZjM3MzUyMQ_size_16_color_FFFFFF_t_70 9]: /images/20211210/af41ea68b2d9459e8f2c90afc3034bc8.png
[20190713114610294.png]: /images/20211210/7929f010807645a7908bf4c5885f3b14.png
[20190713114626828.png]: /images/20211210/e624f1620093480899c3d9a1c9a07549.png