SSM框架整合

原始方式整合

1. 創建數據庫和表

2. 創建Maven工程

3. 導入maven坐標

    <dependencies>
       <!--        上下文-->
       <dependency>
         <groupId>org.springframework</groupId>
         <artifactId>spring-context</artifactId>
         <version>5.3.6</version>
       </dependency>
       <!--        AOP-->
       <dependency>
         <groupId>org.aspectj</groupId>
         <artifactId>aspectjweaver</artifactId>
         <version>1.9.19</version>
       </dependency>
       <!--        jdbc模板-->
       <dependency>
         <groupId>org.springframework</groupId>
         <artifactId>spring-jdbc</artifactId>
         <version>5.3.6</version>
       </dependency>
       <!--        事務-->
       <dependency>
         <groupId>org.springframework</groupId>
         <artifactId>spring-tx</artifactId>
         <version>5.3.6</version>
       </dependency>
       <!--        測試-->
       <dependency>
         <groupId>org.springframework</groupId>
         <artifactId>spring-test</artifactId>
         <version>5.3.6</version>
       </dependency>
       <!--        SpringMVC-->
       <dependency>
         <groupId>org.springframework</groupId>
         <artifactId>spring-webmvc</artifactId>
         <version>5.3.6</version>
       </dependency>
       <!--        servlet和jsp-->
       <dependency>
         <groupId>javax.servlet</groupId>
         <artifactId>servlet-api</artifactId>
         <version>2.5</version>
       </dependency>
       <dependency>
         <groupId>javax.servlet.jsp</groupId>
         <artifactId>jsp-api</artifactId>
         <version>2.1</version>
       </dependency>
   
       <!--        MyBatis相關-->
       <dependency>
         <groupId>mysql</groupId>
         <artifactId>mysql-connector-java</artifactId>
         <version>8.0.28</version>
       </dependency>
       <dependency>
         <groupId>org.mybatis</groupId>
         <artifactId>mybatis</artifactId>
         <version>3.4.6</version>
       </dependency>
   
       <!--        分頁管理插件-->
       <dependency>
         <groupId>com.github.pagehelper</groupId>
         <artifactId>pagehelper</artifactId>
         <version>3.7.5</version>
       </dependency>
       <dependency>
         <groupId>com.github.jsqlparser</groupId>
         <artifactId>jsqlparser</artifactId>
         <version>0.9.1</version>
       </dependency>
   
       <!--        測試-->
       <dependency>
         <groupId>junit</groupId>
         <artifactId>junit</artifactId>
         <version>4.13.2</version>
       </dependency>
       <!--        日志-->
       <dependency>
         <groupId>log4j</groupId>
         <artifactId>log4j</artifactId>
         <version>1.2.12</version>
       </dependency>
       <dependency>
         <groupId>org.mybatis</groupId>
         <artifactId>mybatis-spring</artifactId>
         <version>2.0.5</version>
       </dependency>
     </dependencies>
   
   

4. 編寫實體類

   public class Account {
       private Integer id;
       private  String name;
       private  Double money;
   
       public void setId(Integer id) {
           this.id = id;
       }
   
       public void setName(String name) {
           this.name = name;
       }
   
       public void setMoney(Double money) {
           this.money = money;
       }
   }
   

5. 編寫mapper接口

   public interface AccountMapper {
       public  void  save(Account account);
       public List<Account> findAll();
   }
   

6. 創建service接口

   public interface AccountService {
     public void save(Account account);//保存賬戶數據
     public  List<Account> findAll();//查詢賬戶數據
   }
   

7. 創建service接口的實現類

   public class AccountServiceImpl implements AccountService{
   
       @Override
       public void save(Account account) {
           try {
               InputStream resourceAsStream = Resources.getResourceAsStream("sqlMapConfig.xml");
               SqlSessionFactory build = new SqlSessionFactoryBuilder().build(resourceAsStream);
               SqlSession sqlSession = build.openSession();
               AccountMapper mapper = sqlSession.getMapper(AccountMapper.class);
               mapper.save(account);
               sqlSession.commit();
               sqlSession.close();
           }catch (IOException e){
               e.printStackTrace();
           }
       }
   
       @Override
       public List<Account> findAll() {
           try {
               InputStream resourceAsStream = Resources.getResourceAsStream("sqlMapConfig.xml");
               SqlSessionFactory build = new SqlSessionFactoryBuilder().build(resourceAsStream);
               SqlSession sqlSession = build.openSession();
               AccountMapper mapper = sqlSession.getMapper(AccountMapper.class);
               List<Account> all = mapper.findAll();
               sqlSession.close();
               return all;
           }catch (IOException e){
               e.printStackTrace();
           }
           return null;
       }
   }
   

8. 編寫controller

   @Controller
   @RequestMapping("/account")
   public class AccountController {
       @Autowired
       private AccountService accountService;
   
       //保存
       @RequestMapping("/save")
       @ResponseBody
       public String save(Account account){
           accountService.save(account);
           return  "保存成功";
       }
   //    查詢
       public ModelAndView findAll(){
           List<Account> all = accountService.findAll();
           ModelAndView modelAndView = new ModelAndView();
           modelAndView.addObject("accountList",all);
           modelAndView.setViewName("accountList");
           return modelAndView;
       }
   }
   

9. 編寫頁面

10. 編寫相關配置文件

    配起來太繁瑣了，根據自己的需求和之前學的老老實實配置吧

原始的方式整合弊端很多

mybatis整合spring整合

將sqlsessionFactory配置到spring容器中

一個新的配置文件sqlMapConfig-spring.xml

聲明事務控制

還是上面那個配置文件：

<!--    平臺事務管理器-->
    <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
        <property name="dataSource" ref="dataSouce"></property>
    </bean>
<!--    配置事務增強-->
    <tx:advice id="txAdvice">
        <tx:attributes>
            <tx:method name="*"/>
        </tx:attributes>
    </tx:advice>
    
<!--    事務的aop織入-->
    <aop:config>
        <aop:advisor advice-ref="txAdvice" pointcut="execution(* com.xxx.service.*(..))"></aop:advisor>
    </aop:config>
        
        
        <!--    掃描mapper所在的包，為mapper創建實現類-->
    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
        <property name="basePackage" value="com.xxx.mapper"></property>
    </bean>