步骤
1,导入相关jar包
(1)junit
(2)mybatis
(3)mysql数据库
(4)spring相关
(5)aop织入
(6)mybatis-spring
<dependencies> <dependency> <groupId>junit</groupId> <artifactId>junit</artifactId> <version>4.12</version> </dependency> <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <version>5.1.47</version> </dependency> <dependency> <groupId>org.mybatis</groupId> <artifactId>mybatis</artifactId> <version>3.5.2</version> </dependency> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-webmvc</artifactId> <version>5.1.9.RELEASE</version> </dependency> <!--spring操作数据库,还需要spring-jdbc--> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-jdbc</artifactId> <version>5.1.9.RELEASE</version> </dependency> <dependency> <groupId>org.aspectj</groupId> <artifactId>aspectjweaver</artifactId> <version>1.8.13</version> </dependency> <dependency> <groupId>org.mybatis</groupId> <artifactId>mybatis-spring</artifactId> <version>2.0.2</version> </dependency> </dependencies>
2,编写配置文件
3测试
二mybatis
1编写实体类
2编写核心配置文件
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> <!-- <settings> <setting name="logImpl" value="STDOUT_LOGGING"/> </settings> --> <typeAliases> <package name="com..pojo"/> </typeAliases> <environments default="development"> <environment id="development"> <transactionManager type="JDBC"></transactionManager> <dataSource type="POOLED"> <property name="driver" value="com.mysql.jdbc.Driver"/> <property name="url" value="jdbc:mysql://localhost:3306/library_wzx?useSSL=true& useUnicode=true&characterEncoding=utf-8&serverTimezone=GMT%2B8"/> <property name="username" value="root"/> <property name="password" value="x5"/> </dataSource> </environment> </environments> <mappers> <mapper class="com.mapper.UserMapper"/> </mappers> </configuration>
3编写接口
4测试
静态资源过滤
<build> <resources> <resource> <directory>src/main/java</directory> <includes> <include>**/*.xml</include> </includes> <filtering>true</filtering> </resource> </resources> </build>
1mybatis-config.xml中的这部份被替换到
spring-dao.xml中的
<!--DataSource 使用spring的数据原替换mybatis的配置 c3p0 dbcp druid 我们使用spring提供的JDBC-->
没感觉有什么好的
2mybatis-config.xml中的这部份被替换到
spring-dao.xml中的
方式二
通过继承
SqlSessionDaoSupport实现
写一个类就要到bean中注入