JavaMaven项目中使用Mybatis框架 - Powered by Discuz! Archiver

数据人与超自然意识 发表于 2023-7-11 14:35:11

Maven项目中使用Mybatis框架

一 .准备一个空的Maven项目。 </mappers>https://img2023.cnblogs.com/blog/2812602/202307/2812602-20230711113123899-1226205485.png
二. 配置pom文件，引入相关依赖。 </mappers> </configuration> </configuration> <dependency> </configuration> <groupId>org.mybatis</groupId> </configuration> <artifactId>mybatis</artifactId> </configuration> <version>3.5.6</version> </configuration> </dependency> </configuration> </configuration> <dependency> </configuration> <groupId>mysql</groupId> </configuration> <artifactId>mysql-connector-java</artifactId> </configuration> <version>8.0.33</version> </configuration> </dependency> </configuration> </configuration> <dependency> </configuration> <groupId>junit</groupId> </configuration> <artifactId>junit</artifactId> </configuration> <version>4.13.1</version> </configuration> <scope>test</scope> </configuration> </dependency> </configuration> </configuration> </configuration> <dependency> </configuration> <groupId>org.projectlombok</groupId> </configuration> <artifactId>lombok</artifactId> </configuration> <version>1.18.18</version> </configuration> </dependency> </configuration> </dependencies>三. mybatis配置文件编写。 </mappers><?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration </configuration> PUBLIC "-//mybatis.org//DTD Config 3.0//EN" </configuration> "https://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration> </configuration> <settings> </configuration> </configuration> </settings> </configuration> <environments default="development"> </configuration> <environment id="development"> </configuration> <transactionManager type="JDBC"/> </configuration> <dataSource type="POOLED"> </configuration> <property name="driver" value="com.mysql.cj.jdbc.Driver"/> </configuration> <property name="url" value="jdbc:mysql://localhost:3306/数据库名字"/> </configuration> <property name="username" value="用户名"/> </configuration> <property name="password" value="密码"/> </configuration> </dataSource> </mappers> </environment> </configuration> </environments> </mappers> <mappers> </mappers> </configuration>四.这里按照实体类-Mapper-Mapper.xml的顺序写，并非固定的。 </mappers>1.写一个实体类 </mappers>1 @Data
2 public class Owner {
3 private Integer id;//业主id
4 private StringOwnerName;//业主姓名
5 private StringOwnerSex;//业主性别
6 private StringOwnerTel;//业主电话
7 }2.编写OwnerMapper接口 </mappers>1 public interface OwnerMapper {
2 //写一个作为例子
3 //添加一个业主
4 void addAOwner(Owner Owner);
5 }3.编写OwnerMapper.xml文件 </mappers><?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
 PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
 "https://mybatis.org/dtd/mybatis-3-mapper.dtd">

<mapper namespace="com.wsl.wuye.mapper.OwnerMapper">

<insert id="addAOwner">
 insert into owner(owner_name,owner_sex,owner_tel)
 values (#{ownerName},#{ownerSex},#{ownerTel})
</insert>

</mapper>五.将xml文件添加进mybatis的配置文件 </mappers> <settings>

 <setting name="mapUnderscoreToCamelCase" value="true"/>

<setting name="logImpl" value="STDOUT_LOGGING"/>
</settings>

<mappers>

 <mapper resource="mappers/OwnerMapper.xml"/>
</mappers>六.编写测试类，测试一下上面的方法 </mappers> 1 public class OwnerMapperTest { 2 private SqlSession sqlSession; 3 private OwnerMapper mapper; 45 @Before //表示在测试方法执行前执行 6 public void init() { 7 //1.获取配置文件mybatis-config.xml的流对象 8 InputStream stream; 9 try { </configuration> //注意别导错包了，是apache下那个10 stream = Resources.getResourceAsStream("mybatis-config.xml");11 } catch (IOException e) {12 throw new RuntimeException(e);13 }14 15 //2. 获取一个SqlSessionFactory对象16 SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(stream);17 18 //3.通过工厂类SqlSessionFactory生成SqlSession对象19 sqlSession = sqlSessionFactory.openSession();20 21 //4.获取OwnerMapper的代理22 mapper = sqlSession.getMapper(OwnerMapper.class);23 }24@After //测试方法后执行25 public void commit() {26 //6.提交事务27 sqlSession.commit();28 }29 @Test30 public void testAddAOwner() {31 //5.测试添加一个业主对象的方法32 Owner m = new Owner();33 m.setId(50);34 m.setOwnerName("齐虎");35 m.setOwnerSex("男");36 m.setOwnerTel("15665457345");37 mapper.addAOwner(m);38 }39 }总结：这里已经算是成功完成了一个插入操作，想进行其他的操作只需在mapper接口里添加方法，再在对应的xml文件里写sql语句就行了。注意的是有的时候你不止一个实体类，这时候你编写新的mapper接口和新的xml文件后一定不要忘记在mybatis的配置文件还要配置一下（上面第五点）。下面看下项目的一般结构。 </mappers>https://img2023.cnblogs.com/blog/2812602/202307/2812602-20230711135109286-1106474669.png
 </mappers>免责声明：如果侵犯了您的权益，请联系站长，我们会及时删除侵权内容，谢谢合作！

页: [1]

ToB企服应用市场:ToB评测及商务社交产业平台's Archiver

Maven项目中使用Mybatis框架