SSM简单项目搭建

╰+攻爆jí腚メ 2022-06-03 05:57 264阅读 0赞

Spring+SpringMVC+Mybatis  
（1）为了直观了解，我们画一下ssm整体流程草图：  
![这里写图片描述][SouthEast]  
（2）创建相关的表（此处采用MySQL，略）  
（3）创建一个web工程  
（4）导入SSM相应的jar包：

aopalliance-1.0.jar
    asm-3.3.1.jar
    cglib-2.2.2.jar
    com.springsource.org.aspectj.weaver-1.6.8.RELEASE.jar
    commons-fileupload-1.2.2.jar
    commons-io-2.0.1.jar
    commons-lang3-3.1.jar
    commons-logging-1.1.1.jar
    ehcache-core-2.6.5.jar
    freemarker-2.3.19.jar
    javassist-3.11.0.GA.jar
    junit-4.9.jar
    jstl-1.2.jar
    log4j-1.2.16.jar
    mybatis-3.2.2.jar
    mybatis-ehcache-1.0.2.jar
    mybatis-spring-1.2.0.jar
    mysql-connector-java-5.1.10-bin.jar
    ognl-3.0.6.jar
    slf4j-api-1.6.2.jar
    slf4j-log4j12-1.6.2.jar
    spring-aop-3.2.2.jar
    spring-beans-3.2.2.jar
    spring-context-3.2.2.jar
    spring-core-3.2.2.jar
    spring-expression-3.2.2.jar
    spring-jdbc-3.2.2.jar
    spring-orm-3.2.2.jar
    spring-tx-3.2.2.jar
    spring-web-3.2.2.jar
    spring-webmvc-3.2.2sar

（5）创建po实体对象（可以根据myb逆向工程生成，或者使用powerdesingner）

package ssm.domain;
    
    import java.io.Serializable;
    
    public class Person implements Serializable { 
    
        private int pid;
        private String name;
        private int age;
        private String remark;
    
        public int getPid() {
            return pid;
        }
    
        public void setPid(int pid) {
            this.pid = pid;
        }
    
        public String getName() {
            return name;
        }
    
        public void setName(String name) {
            this.name = name;
        }
    
        public int getAge() {
            return age;
        }
    
        public void setAge(int age) {
            this.age = age;
        }
    
        public String getRemark() {
            return remark;
        }
    
        public void setRemark(String remark) {
            this.remark = remark;
        }
    
        @Override
        public String toString() {
            return "Person [pid=" + pid + ", name=" + name + ", age=" + age + ", remark=" + remark + "]";
        }
    
    }

（6）创建mapper映射文件

<?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="ssm.mapper.PersonMapper">
      <resultMap type="ssm.domain.Person" id="PersonSM">
            <id property="pid" column="PID"></id>
            <result property="name" column="NAME" />
             <result property="age" column="AGE" />
             <result property="remark" column="REAMRK" />
    </resultMap>
    
        <select id="findBy" parameterType="map" resultMap="PersonSM">
           select * from person 
           <where>
             <if test="name!=null"> and name like #{name}</if>
             
             <if test="ageStart!=null">  <![CDATA[and age >= #{ageStart}]]></if>
             <if test="ageEnd!=null">  <![CDATA[and age <= #{ageEnd}]]></if>
           </where>
        </select>
    </mapper>

（7）创建Mapper接口  
规则：1）mapper接口的文件名与mapper映射文件名相同；  
2）mapper接口文件 的路径 与相应的命名空间的路径相同；  
3）apper接口文件中的方法名与 映射文件中的id相同；  
4）接口文件中的参数 ，返回值等按照java规则编写。

package ssm.mapper;
    
    import java.util.List;
    import java.util.Map;
    
    import ssm.domain.Person;
    
    public interface PersonMapper { 
    
        // 查询
        public List<Person> findBy(Map<String, Object> map);
    }

（8）创建PersonDao接口

package ssm.dao;
    
    import java.util.List;
    import java.util.Map;
    
    import ssm.domain.Person;
    
    public interface PersonDao { 
    
        public List<Person> findBy(Map<String, Object> map);
    }

（9）创建PersonDaoImpl 实现personDaao

package ssm.dao.impl;
    
    import java.util.List;
    import java.util.Map;
    
    import javax.annotation.Resource;
    
    import org.apache.ibatis.session.SqlSessionFactory;
    import org.mybatis.spring.support.SqlSessionDaoSupport;
    import org.springframework.stereotype.Repository;
    
    import ssm.dao.PersonDao;
    import ssm.domain.Person;
    import ssm.mapper.PersonMapper;
    
    /** * * * @author zero * */
    @Repository
    public class PersonDaoImpl extends SqlSessionDaoSupport implements PersonDao { 
    
        @Resource
        public void setSqlSessionFactory(SqlSessionFactory sqlSessionFactory) {
            super.setSqlSessionFactory(sqlSessionFactory);
    
        }
    
        /** * 查询记录 * * @param map * @return */
        public List<Person> findBy(Map<String, Object> map) {
            PersonMapper mapper = this.getSqlSession().getMapper(PersonMapper.class);
            return mapper.findBy(map);
        }
    }

（10）创建PersonService

package ssm.service;
    
    import java.util.List;
    import java.util.Map;
    
    import ssm.domain.Person;
    
    public interface PersonService { 
    
        public List<Person> findBy(Map<String, Object> map);
    }

（11）创建Person ServiceImpl 调用personDao

package ssm.service.impl;
    
    import java.util.List;
    import java.util.Map;
    
    import javax.annotation.Resource;
    
    import org.springframework.stereotype.Service;
    
    import ssm.dao.PersonDao;
    import ssm.domain.Person;
    import ssm.service.PersonService;
    
    @Service
    public class PersonServiceImpl implements PersonService { 
    
        @Resource
        private PersonDao personDao;
    
        @Override
        public List<Person> findBy(Map<String, Object> map) {
            return personDao.findBy(map);
        }
    
    }

（12）创建相应的PersonController

import java.util.List;
    
    import javax.annotation.Resource;
    
    import org.springframework.stereotype.Controller;
    import org.springframework.ui.Model;
    import org.springframework.web.bind.annotation.RequestMapping;
    
    import ssm.domain.Person;
    import ssm.service.PersonService;
    
    @Controller
    public class PersonController { 
    
        @Resource
        private PersonService personService;
    
        /** * 查询，将查询结果传递到页面 * * @param model * @return */
        @RequestMapping("/jpersonList")
        public String personList(Model model) { // controller加载时 会自动创建访问路径
    
            List<Person> personList = personService.findBy(null);
            // 传递到页面
            model.addAttribute("personList", personList);
            return "/person/jpersonList";
        }
    
    }

（13）创建mybatis的核心配置文件：sqlMapConfig.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>
    
      
      </configuration>

（14）配置jdbc.properties 数据库连接

driverClassName=com.mysql.jdbc.Driver
    url=jdbc\:mysql\://localhost\:3306/datasourceTest
    username=root
    password=123

（15）配置spring核心配置文件：beans.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" 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-3.0.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-3.0.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-3.0.xsd http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-3.0.xsd">
    
    <context:annotation-config />
    
    <context:component-scan base-package="ssm.dao,ssm.service,ssm.domain" /> 
    
    <context:property-placeholder location="classpath:jdbc.properties" />
    
     
     <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="configLocation" value="classpath:sqlMapConfig.xml"/>
        
        <property name="mapperLocations" value="classpath:ssm/mapper/*.xml"></property>
    </bean>
    
    <bean id="txManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
        <property name="dataSource" ref="dataSource"></property>
    </bean>
    
    
    <tx:advice id="txadvice" transaction-manager="txManager">
      <tx:attributes>
         <tx:method name="save*" propagation="REQUIRED"/>
         <tx:method name="insert*" propagation="REQUIRED"/>
         <tx:method name="update*" propagation="REQUIRED"/>
         <tx:method name="delete*" propagation="REQUIRED"/>
    
         <tx:method name="select*" read-only="true"/>
         <tx:method name="view*" read-only="true"/>
         <tx:method name="find*" read-only="true"/>
    
      </tx:attributes>
    </tx:advice>
    <aop:config>
      <aop:pointcut expression="execution(* domain.service.*.*(..))" id="poincut"/>
      <aop:advisor advice-ref="txadvice" pointcut-ref="poincut"/>
    </aop:config>
    </beans>

（16）配置springMVC核心配置文件：springmvc-servlet.xml

（17）配置web.xml

<?xml version="1.0" encoding="UTF-8"?>
    <web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://xmlns.jcp.org/xml/ns/javaee" xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_3_1.xsd" version="3.1">
      <display-name>SSM1</display-name>
    
      
      <context-param>
         <param-name>contextConfigLocation</param-name>
         <param-value>classpath:beans.xml</param-value>
      </context-param>
      <listener>
         <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
      </listener>
        
      <servlet>
         <servlet-name>action</servlet-name>
         <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
         <init-param>
            <param-name>contextConfigLocation</param-name>
            <param-value>classpath:springmvc-servlet.xml</param-value>
         </init-param>
      </servlet>
      <servlet-mapping>
        <servlet-name>action</servlet-name>
        <url-pattern>/</url-pattern>   
      </servlet-mapping>
        <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>
    </web-app>

（18）建立jsp页面  
路径：![这里写图片描述][SouthEast 1]

<%@ page language="java" contentType="text/html; charset=utf8" pageEncoding="utf8"%>
    <%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
    <!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=ISO-8859-1">
    <title>Insert title here</title>
    </head>
    <body>
    人员列表：<br/>
    
    <a href="${pageContext.request.contextPath}/person/tocreate">asas</a>
    <table border="1" cellpadding="0" cellspacing="0">
      <tr>
         <td>编号</td>
         <td>姓名</td>
         <td>年龄</td>
         <td>备注</td>
      </tr>
      <c:forEach items="${personList}" var="p" varStatus="status">
           <tr>
             <td>${status.index+1}</td>
             <td>${p.name}</td>
             <td>${p.age }</td>
             <td>${p.remark}</td>
          </tr>
      </c:forEach>
    
    </table>
    </body>
    </html>

测试：  
![这里写图片描述][SouthEast 2]

PS:码字很辛苦，转载就注明~

[SouthEast]: /images/20220603/3802a5b7ba8347e89c22d853140c6443.png
[SouthEast 1]: /images/20220603/3782707051ab407eb7e08fc21a4dcba8.png
[SouthEast 2]: /images/20220603/4e549d6822c44cc5a67cbe36ad7e51ae.png