Mybatis 使用注解的基本配置

最新推荐文章于 2023-09-27 22:50:29 发布

叕叕666

最新推荐文章于 2023-09-27 22:50:29 发布

阅读量147

点赞数

分类专栏： Java Mybatis 文章标签： mybatis java

本文链接：https://blog.csdn.net/m0_50163856/article/details/116090303

版权

Java 同时被 2 个专栏收录

159 篇文章 0 订阅

订阅专栏

Mybatis

8 篇文章 0 订阅

订阅专栏

本文档展示了如何在Java项目中配置MyBatis连接MySQL数据库，包括引入依赖、配置数据库连接信息、创建MyBatis配置文件、定义Mapper接口及其实现。示例代码详细解释了查询所有记录和按条件获取单条记录的方法。

摘要由CSDN通过智能技术生成

导入依赖

<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.5.6</version>
</dependency>

在resources目录下创建mysql.properties，写入：

driver=com.mysql.cj.jdbc.Driver
url=jdbc:mysql://127.0.0.1:3306/javatest?serverTimezone=UTC&useSSL=false&allowPublicKeyRetrieval=true
name=root
password=root1234

在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="mysql.properties"></properties>
    <environments default="development">
        <environment id="development">
            <transactionManager type="JDBC"/>
            <dataSource type="POOLED">
                <property name="driver" value="${driver}"/>
                <property name="url" value="${url}"/>
                <property name="username" value="${name}"/>
                <property name="password" value="${password}"/>
            </dataSource>
        </environment>
    </environments>
    <mappers>
        <mapper class="com.mine.dao.MyuserDao"></mapper>
    </mappers>
</configuration>

创建 com.mine.dao.MyuserDao 接口写入：

public interface MyuserDao {

    @Select("select * from myuser ${order}")
    List<Map<String,Object>> getAll(String order);

    @Select("select * from myuser where id = #{id}")
    Map<String,Object> getOne(Integer id);

}

调用

public class MyMain {
    public static void main(String[] args) {

        SqlSessionFactoryBuilder builder = new SqlSessionFactoryBuilder();
        InputStream inputStream =
                Thread.currentThread().getContextClassLoader().getResourceAsStream("mybatis-config.xml");
        SqlSessionFactory factory = builder.build(inputStream);
        SqlSession sqlSession = factory.openSession(true);//开启事务
        MyuserDao myUserMapper = sqlSession.getMapper(MyuserDao.class);
        Map<String, Object> one = myUserMapper.getOne(2);
        System.out.println(one);
        System.out.println("-----------------------");
        List<Map<String, Object>> all = myUserMapper.getAll("order by 1 desc");
        System.out.println(all);

    }
}