网站开发专利,asp网站发邮件,微信群推广平台,网络推广代理目录
1.项目结构
2.项目的pom.xml文件
3.spring.xml和springMVC配置文件
4.database.properties和mybatis.xml配置文件
5. 代码编写
6.测试整合结果 1.项目结构
首先创建一个名为ssm_pro的Mavew项目#xff0c;然后再在主目录和资源目录下#xff0c;创建如下所示的结…目录
1.项目结构
2.项目的pom.xml文件
3.spring.xml和springMVC配置文件
4.database.properties和mybatis.xml配置文件
5. 代码编写
6.测试整合结果 1.项目结构
首先创建一个名为ssm_pro的Mavew项目然后再在主目录和资源目录下创建如下所示的结构。任务是通过ssm框架查询出所有的图书信息。 2.项目的pom.xml文件
其次导入本次项目需要的依赖在pom.xml中其中大概有几个方面的依赖分别是 mybatis的相关依赖spring框架有关的依赖spring和mybatis整合的依赖springMVC的依赖数据库的依赖还有一些工具类的依赖比如lombokjunit等 project xmlnshttp://maven.apache.org/POM/4.0.0 xmlns:xsihttp://www.w3.org/2001/XMLSchema-instancexsi:schemaLocationhttp://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsdmodelVersion4.0.0/modelVersiongroupIdcom.its/groupIdartifactIdssm_pro/artifactIdpackagingwar/packagingversion1.0-SNAPSHOT/versionnamessm_pro Maven Webapp/nameurlhttp://maven.apache.org/urldependencies!--01 mybatis相关依赖 --dependencygroupIdorg.mybatis/groupIdartifactIdmybatis/artifactIdversion3.5.16/version/dependency!--02 spring相关依赖 --dependencygroupIdorg.springframework/groupIdartifactIdspring-core/artifactIdversion5.3.26/version/dependencydependencygroupIdorg.springframework/groupIdartifactIdspring-beans/artifactIdversion5.3.26/version/dependencydependencygroupIdorg.springframework/groupIdartifactIdspring-context/artifactIdversion5.3.26/version/dependencydependencygroupIdorg.springframework/groupIdartifactIdspring-test/artifactIdversion5.3.26/versionscopetest/scope/dependencydependencygroupIdorg.springframework/groupIdartifactIdspring-aop/artifactIdversion5.3.26/version/dependencydependencygroupIdorg.springframework/groupIdartifactIdspring-tx/artifactIdversion5.3.26/version/dependencydependencygroupIdorg.springframework/groupIdartifactIdspring-jdbc/artifactIdversion5.3.26/version/dependency!-- 03 spring和mybatis整合包 --dependencygroupIdorg.mybatis/groupIdartifactIdmybatis-spring/artifactIdversion2.0.6/version/dependency!--04 springMvc依赖--dependencygroupIdorg.springframework/groupIdartifactIdspring-webmvc/artifactIdversion5.3.26/version/dependency!--05 数据库相关 --dependencygroupIdcom.mysql/groupIdartifactIdmysql-connector-j/artifactIdversion8.0.33/version/dependencydependencygroupIdorg.apache.commons/groupIdartifactIdcommons-dbcp2/artifactIdversion2.1.1/version/dependencydependencygroupIdorg.apache.commons/groupIdartifactIdcommons-pool2/artifactIdversion2.4.2/version/dependency!--06 工具类 --dependencygroupIdorg.projectlombok/groupIdartifactIdlombok/artifactIdversion1.18.24/versionscopeprovided/scope/dependencydependencygroupIdjunit/groupIdartifactIdjunit/artifactIdversionRELEASE/version/dependencydependencygroupIdlog4j/groupIdartifactIdlog4j/artifactIdversion1.2.17/version/dependency/dependenciesbuildfinalNamessm_pro/finalName/build
/project3.spring.xml和springMVC配置文件
mybatis和spring的整合主要是将mybatis的配置信息整合到spring的配置信息中下面是spring的配置信息spring.xml文件的内容。
?xml version1.0 encodingUTF-8?
beans xmlnshttp://www.springframework.org/schema/beansxmlns:xsihttp://www.w3.org/2001/XMLSchema-instancexmlns:contexthttp://www.springframework.org/schema/contextxmlns:aophttp://www.springframework.org/schema/aopxmlns:txhttp://www.springframework.org/schema/txxsi:schemaLocationhttp://www.springframework.org/schema/beanshttp://www.springframework.org/schema/beans/spring-beans.xsdhttp://www.springframework.org/schema/contexthttp://www.springframework.org/schema/context/spring-context.xsdhttp://www.springframework.org/schema/aophttp://www.springframework.org/schema/aop/spring-aop.xsdhttp://www.springframework.org/schema/txhttp://www.springframework.org/schema/tx/spring-tx.xsd!--01 开启注解扫描,用于扫描com.its下的所有类用于IOC的管理--context:component-scan base-packagecom.its/!--02 数据源这里是用于连接数据库是原来mybatis配置文件的内容在这里配置--!--context标签用于引入外部的database.xml文件。--context:property-placeholder locationclasspath:database.properties/bean iddataSource classorg.apache.commons.dbcp2.BasicDataSourceproperty namedriverClassName value${jdbc.driver}/property nameurl value${jdbc.url}/property nameusername value${jdbc.username}/property namepassword value${jdbc.password}/!--连接池信息--property namemaxIdle value100//bean!--03 事务相关配置--bean idtransactionManger classorg.springframework.jdbc.datasource.DataSourceTransactionManagerproperty namedataSource refdataSource//bean!--开启事务注解--tx:annotation-driven transaction-managertransactionManger/!--04 Mybatis基础配置--bean idsqlSessionFactoryBean classorg.mybatis.spring.SqlSessionFactoryBean!--数据源--property namedataSource refdataSource/!--自动扫描mapper.xml文件然后映射com/its/mapper下的所有xml文件不用像以前那样一个一个配置映射--property namemapperLocations valueclasspath:com/its/mapper/*xml/!--别名这里是映射的实体类--property nametypeAliasesPackage valuecom.its.pojo/!--引入mybatis.xml文件--property nameconfigLocation valueclasspath:mybatis.xml//bean
!-- 05 Mapper代理开发使用spring自动映射Mybatis的接口并装配--bean classorg.mybatis.spring.mapper.MapperScannerConfigurerproperty namebasePackage valuecom.its.mapper/property namesqlSessionFactoryBeanName valuesqlSessionFactoryBean//bean
/beans
由于还要使用springMVC的功能所以需要springMVC的配置文件如下
beans xmlnshttp://www.springframework.org/schema/beans xmlns:xsihttp://www.w3.org/2001/XMLSchema-instance xmlns:contexthttp://www.springframework.org/schema/context xmlns:mvchttp://www.springframework.org/schema/mvc xsi:schemaLocationhttp://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 http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc.xsd!-- 扫描 --context:component-scan base-packagecom.its.controller/
/beans
4.database.properties和mybatis.xml配置文件
在spring.xml中又引入database.properties和mybatis.xml配置文件配置文件内容分别如下
jdbc.driver com.mysql.cj.jdbc.Driver
jdbc.url jdbc:mysql:///demo_test
jdbc.username root
jdbc.password root
?xml version1.0 encodingUTF-8 ?
!DOCTYPE configurationPUBLIC -//mybatis.org//DTD Config 3.0//ENhttps//mybatis.org/dtd/mybatis-3-config.dtd
!--核心配置文件--
configuration!--设置--settings!--输出日志--setting namelogImpl valueSTDOUT_LOGGING/!--驼峰映射--setting namemapUnderscoreToCamelCase valuetrue//settings
/configuration
mapper层接口的映射文件BooksMapper.xml文件如下
?xml version1.0 encodingUTF-8 ?
!DOCTYPE mapperPUBLIC -//mybatis.org//DTD Mapper 3.0//ENhttp://mybatis.org/dtd/mybatis-3-mapper.dtd
mapper namespacecom.its.mapper.BooksMapperselect idselectAllBooks resultTypecom.its.pojo.Booksselect * from demo_test.books/select
/mapper
5. 代码编写
1.数据库表如下 2.Controller层的BooksController类的的代码如下
package com.its.controller;import com.its.pojo.Books;
import com.its.service.BooksService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;import java.util.List;Controller
RequestMapping(/books)
public class BooksController {AutowiredBooksService booksService;RequestMapping(/list)public void getAllBooks(){ListBooks list booksService.getAllBooks();list.forEach(System.out::println);}
}3.service层的BookService接口和BookServiceImp代码如下
package com.its.service;import com.its.pojo.Books;import java.util.List;public interface BooksService {ListBooks getAllBooks();
}package com.its.service.Impl;import com.its.mapper.BooksMapper;
import com.its.pojo.Books;
import com.its.service.BooksService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;import java.util.List;Service
public class BooksServiceImpl implements BooksService {AutowiredBooksMapper booksMapper;Overridepublic ListBooks getAllBooks() {return booksMapper.selectAllBooks();}
}4..mapper层下的BooksMapper类的代码如下
package com.its.mapper;import com.its.pojo.Books;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;import java.util.List;Mapper
public interface BooksMapper {ListBooks selectAllBooks();
}5.用于查询数据户的映射文件BooksMapper.xml文件代码如下
?xml version1.0 encodingUTF-8 ?
!DOCTYPE mapperPUBLIC -//mybatis.org//DTD Mapper 3.0//ENhttp://mybatis.org/dtd/mybatis-3-mapper.dtd
mapper namespacecom.its.mapper.BooksMapperselect idselectAllBooks resultTypecom.its.pojo.Booksselect * from demo_test.books/select
/mapper
6.测试整合结果
1先编写mybatis和spring整合的测试代码如下
package com.its;import com.its.controller.BooksController;
import org.junit.Test;
import org.junit.runner.RunWith;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.test.context.ContextConfiguration;
import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;RunWith(SpringJUnit4ClassRunner.class)
ContextConfiguration(locations {classpath:spring.xml})
public class Test01 {Autowiredprivate BooksController booksController;Testpublic void test(){booksController.getAllBooks();}
}
结果输出了所有的图书信息mybatis和spring整合测试成功。 2再测试springMVC是否整合成功这里首先要配置一下tomacat服务器再在空着层提供相应的访问路径如果服务器启动成功再地址栏输入访问地址后控制台依然能够打印出相同的结果则springMVC整合成功
配置tomacat 启动tomacat在地址栏输入http://localhost:8080/books/list控制台显示所有图书springMVC整合成功。 总结mybatis整合spring和springMVC主要有以下几个步骤 设置项目结构分为主文件下controllerservicemapperpojo几个包。资源目录下设置同包同名的sql映射文件编写spring.xmlmybatis.xmldatabase.propertiesspringMvc.xml配置文件编写各个层代码。执行测试。
