一 MyBatis架構使用
1.1建立maven項目導入相關依賴
1 導入jar檔案,maven
2 處理配置檔案
3 開發業務代碼
先建立一個空項目,用于存放後面Mybatis相關項目子產品
項目名為mybatisAll即可
接下來設定maven為我們自己安裝的,不用idea自帶的(當然用自帶的也行)
在目前項目中建立子產品
選擇maven項目 next
輸入groupid和aitifactid 然後finish
檢查項目目前在磁盤上的存放路徑 然後next
檢查項目目錄結構是否有缺失
MyBatis官網說明文檔 https://mybatis.org/mybatis-3/zh/index.html
在pom.xml中導入MyBatis相關依賴jar檔案
<?xml version="1.0" encoding="UTF-8"?> <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd"> <modelVersion>4.0.0</modelVersion> <groupId>com.msb</groupId> <artifactId>mybatisTest01</artifactId> <version>1.0-SNAPSHOT</version> <packaging>jar</packaging> <dependencies> <!--mysqlConnector--> <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <version>8.0.16</version> </dependency> <!--mybatis 核心jar包--> <dependency> <groupId>org.mybatis</groupId> <artifactId>mybatis</artifactId> <version>3.5.3</version> </dependency> <!--junit--> <dependency> <groupId>junit</groupId> <artifactId>junit</artifactId> <version>4.13.1</version> <scope>test</scope> </dependency> <!--lombok --> <dependency> <groupId>org.projectlombok</groupId> <artifactId>lombok</artifactId> <version>1.18.12</version> <scope>provided</scope> </dependency> </dependencies> </project> |
安裝lombok插件後,重新開機idea
導入lombok依賴後,單獨設定啟用注解處理
1.2準備資料庫,包結構和實體類
實體類Dept
@Data
@AllArgsConstructor
@NoArgsConstructor
public class Dept implements Serializable {
private Integer deptno;
private String dname;
private String loc;
}
resources目錄下 建立 com/mapper目錄,然後添加DeptMapper.xml映射檔案
<?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="aaa">
<!--public List<Dept> findAll(){ }-->
<select id="findAll" resultType="com.msb.pojo.Dept" >
select * from dept
</select>
</mapper>
resources目錄下準備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> <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://127.0.0.1:3306/mydb?useSSL=false&useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai"/> <property name="username" value="root"/> <property name="password" value="root"/> </dataSource> </environment> </environments> <!--加載mapper映射檔案--> <mappers> <mapper resource="com/msb/mapper/DeptMapper.xml"/> </mappers> </configuration> |
1.3 準備Mapper映射檔案和核心配置檔案
1.4 運作測試
在test目錄下開發測試代碼并運作
public class Test1 {
private SqlSession sqlSession;
@Before
public void init(){
SqlSessionFactoryBuilder ssfb =new SqlSessionFactoryBuilder();
InputStream resourceAsStream = null;
try {
resourceAsStream = Resources.getResourceAsStream("sqlMapConfig.xml");
} catch (IOException e) {
e.printStackTrace();
}
SqlSessionFactory factory=ssfb.build(resourceAsStream) ;
sqlSession=factory.openSession();
}
@Test
public void testFindAll(){
// 調用SQL語句
List<Dept> list = sqlSession.selectList("findAll");
for (Dept dept : list) {
System.out.println(dept);
}
}
@After
public void release(){
// 關閉SQLSession
sqlSession.close();
}
}
感謝各位觀看閱讀,如果你也喜歡程式設計的話,歡迎關注,我将持續更新後續内容。