1.導包(配置pom.xml) 一定要用這個網站：https://mvnrepository.com/ 點擊查看代碼 <dependency> <groupId>org.mybatis</groupId> <artifactId>mybatis</artifactId> <version>3.5.4 ...
1.導包(配置pom.xml)
一定要用這個網站：https://mvnrepository.com/
點擊查看代碼
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.5.4</version>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.47</version>
</dependency>
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>4.9</version>
</dependency>
<dependency>
<groupId>org.slf4j</groupId>
<artifactId>slf4j-log4j12</artifactId>
<version>1.7.9</version>
</dependency>
</dependencies>
2.創建mybatis核心配置文件（mybatis-config.xml）
去官網中文文檔入門裡面複製也ok
點擊查看代碼
<?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">
</properties>
<typeAliases>
<package name="com.mhys.bean" />
</typeAliases>
<environments default="development">
<environment id="development">
<transactionManager type="JDBC"/>
<dataSource type="POOLED">
<property name="driver" value="${driverClassName}"/>
<property name="url" value="${url}"/>
<property name="username" value="${username}"/>
<property name="password" value="${password}"/>
</dataSource>
</environment>
</environments>
<mappers>
<package name="com.mhys.mapper"/>
</mappers>
</configuration>
3.創建實體類（註意欄位要和表裡欄位對應）
這是我的資料庫欄位
4.創建jdbc和logo4j配置文檔
5.創建mapper介面（介面命名和映射文件一致）
6.創建測試類
點擊查看代碼
@Test
public void testSelect() {
try {
InputStream is=Resources.getResourceAsStream("mybatis-config.xml");
SqlSessionFactory sf=new SqlSessionFactoryBuilder().build(is);
SqlSession session=sf.openSession();//創建一次對話(類似於mysql的對話=connection)
AdminMapper am=session.getMapper(AdminMapper.class);
List<Admin> list=am.findAdmin();
System.out.println(list.toString());
session.commit();
session.close();
is.close();
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
@Test
public void testDelete() {
try {
InputStream is=Resources.getResourceAsStream("mybatis-config.xml");
SqlSessionFactory sf=new SqlSessionFactoryBuilder().build(is);
SqlSession session=sf.openSession();//創建一次對話(類似於mysql的對話=connection)
AdminMapper am=session.getMapper(AdminMapper.class);
int num=am.deleteAdmin("4");
System.out.println(num);
session.commit();
session.close();
is.close();
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
@Test
public void testAdd() {
try {
InputStream is=Resources.getResourceAsStream("mybatis-config.xml");
SqlSessionFactory sf=new SqlSessionFactoryBuilder().build(is);
SqlSession session=sf.openSession();//創建一次對話(類似於mysql的對話=connection)
AdminMapper am=session.getMapper(AdminMapper.class);
int num=am.addAdmin(new Admin(null, "增加", "李四", "超級管理員", 0));
System.out.println(num);
session.commit();
session.close();
is.close();
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
@Test
public void testupdate() {
try {
InputStream is=Resources.getResourceAsStream("mybatis-config.xml");
SqlSessionFactory sf=new SqlSessionFactoryBuilder().build(is);
SqlSession session=sf.openSession();//創建一次對話(類似於mysql的對話=connection)
AdminMapper am=session.getMapper(AdminMapper.class);
int num= am.updateAdmin(new Admin(14, "呆瓜", "呆瓜", "老六", 0));
System.out.println(num);
session.commit();
session.close();
is.close();
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
7.調用前資料庫
8.調用
9.控制台
10.調用後資料庫
後續將會更新使用xml映射使用
