SSM框架mybatis的配置
spring的使用
获取spring容器中的对象,测试用
ApplicationContext applicationContext=new ClassPathXmlApplicationContext("config/applicationConfig.xml"); applicationContext.getBean("datasource");
spring配置文件关键词
service层 组件扫描器:context:component-scan 事务bean:DataSourceTransactionManager数据资源事务管理 mvc层 注解驱动:<mvc:annotation-driven/> 组件扫描器:context:component-scan 内部资源视图解析器bean:IntelnalResourceViewResolver 静态资源过滤器:<mvc:default-servlet-handler/> dao层 数据源bean:DataSource 创建session bean:SqlSessionFactoryBean 映射扫描配置:MapperScannerConfigurer
mybatis的使用
步骤:添加依赖,导入配置文件,编写接口,编写mapper,测试
主配置文件属性:properties、typeAliases(package)
1、导入依赖
<dependency> <groupId>org.mybatis</groupId> <artifactId>mybatis</artifactId> <version>3.4.5</version> </dependency> <build> <resources> <resource> <directory>src/main/java</directory><!--所在的目录--> <includes><!--包括目录下的.properties,.xml文件都会扫描到--> <include>**/*.properties</include> <include>**/*.xml</include> </includes> <filtering>false</filtering> </resource> <resource> <directory>src/main/resources</directory> <includes> <include>**/*.properties</include> <include>**/*.xml</include> </includes> <filtering>false</filtering> </resource> </resources> </build>
2、resources目录下导入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> <!-- <properties resource="jdbc.properties"/>--> <!--给resultType起别名--> <typeAliases> <!-- <package name="com.bjpowernode.crm.settings.domain"/>--> </typeAliases> <environments default="development"> <environment id="development"> <transactionManager type="JDBC"/> <dataSource type="POOLED"> <property name="driver" value="com.mysql.cj.jdbc.Driver"/> <property name="url" value="jdbc:mysql://localhost:3306/crm"/> <property name="username" value="root"/> <property name="password" value="123456"/> </dataSource> </environment> </environments> <mappers> <!--mapper.xml文件与dao接口放同一包--> <package name="com.youisme.ssm.setting.mapper"></package> </mappers> </configuration>
测试代码:读取mybatis配置文件,获取session,查询数据库
InputStream resourceAsStream = Resources.getResourceAsStream("config/mybatis-config.xml"); SqlSessionFactory build = new SqlSessionFactoryBuilder().build(resourceAsStream); UserMapper mapper = build.openSession().getMapper(UserMapper.class); User user = mapper.test(1);
注意别忘
-
dao接口添加Mapper注解
-
mapper文件要注册到mybatis配置文件中
spring集成mybatis
spring-dao层配置文件关键词
DataSource:数据源,参数(驱动,url,username,pwd) SqlSessionFactoryBean:session工厂,参数(数据源,主配置文件) MapperScannerConfigurer:映射扫描配置,参数(session工场,基础包)
1、导入依赖
<!-- 导入依赖:jdbc、驱动、连接池、mybatis、mybatis-spring、spring-webmvc--> <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <version>8.0.23</version> </dependency> <dependency> <groupId>org.mybatis</groupId> <artifactId>mybatis</artifactId> <version>3.4.5</version> </dependency> <dependency> <groupId>org.mybatis</groupId> <artifactId>mybatis-spring</artifactId> <version>2.0.6</version> </dependency> <dependency> <groupId>com.mchange</groupId> <artifactId>c3p0</artifactId> <version>0.9.5.2</version> </dependency> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-webmvc</artifactId> <version>5.3.9</version> </dependency>
2、导入mybatis配置文件
3、spring配置文件:连接池、SSFB、接口包扫描
4、编写dao接口,mapper文件
5、测试:从容器中获取dao层实现类,调用方法查询数据库
//使用mybatis查询数据库 InputStream resourceAsStream = Resources.getResourceAsStream("config/mybatis-config.xml"); SqlSessionFactory build = new SqlSessionFactoryBuilder().build(resourceAsStream); UserMapper mapper = build.openSession().getMapper(UserMapper.class); User user = mapper.test(1);
springmvc
spring-mvc配置文件关键词
注解驱动:<mvc:annotation-driven/> 组件扫描器:context:component-scan 内部资源视图解析器bean:IntelnalResourceViewResolver 静态资源过滤器:<mvc:default-servlet-handler/>
web.xml配置文件关键词
DispatcherServlet:中央调度器,参数contextConfigLocation和/ CharacterEncodingFilter:过滤器,参数encoding和/* session-config:超时设置
1、依赖
<dependency> <groupId>javax.servlet.jsp</groupId> <artifactId>jsp-api</artifactId> <version>2.2</version> </dependency> <dependency> <groupId>javax.servlet</groupId> <artifactId>servlet-api</artifactId> <version>2.5</version> </dependency> <dependency> <groupId>javax.servlet</groupId> <artifactId>jstl</artifactId> <version>1.2</version> </dependency>
2、编写spring-mvc配置文件,包括:驱动注解,组件扫描器,内部资源视图解析器,静态资源解析器
3、配置web.xml文件,包括:DispatcherServelet中央调度器,编码过滤器,session超时
4、测试:controller包中创建类,创建test方法,添加@Controller注解,打印“hello world”,是否成功