简单的MyBatis使用DEMO。

最新推荐文章于 2024-06-15 21:55:18 发布
原创 最新推荐文章于 2024-06-15 21:55:18 发布 · 655 阅读 · 0 ·
CC 4.0 BY-SA版权
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。

本文提供了一个简单的MyBatis使用DEMO，涵盖了整体结构、Maven依赖、数据准备、配置文件详解及代码解析，帮助初学者快速上手MyBatis。

摘要生成于 C知道 ，由 DeepSeek-R1 满血版支持， 前往体验 >

简单的MyBatis使用DEMO。

1）整体结构


2）maven依赖


3）数据准备
4）配置文件


5）代码详解


package com.my.mybatis;
import java.util.List;
import java.util.Map;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
public class TestMyBatis {
static SqlSessionFactory sqlSessionFactory = null;
static {
sqlSessionFactory = MyBatisUtil.getSqlSessionFactory();
}
public static void main(String[] args) {
testAdd();
getUser();
getUserMap();
getUserMap1();
getUserCount();
}
public static void testAdd() {
SqlSession sqlSession = sqlSessionFactory.openSession();
try {
UserMapper userMapper = sqlSession.getMapper(UserMapper.class);
User user = new User("lisi", new Integer(25));
userMapper.insertUser(user);
sqlSession.commit();// 这里一定要提交，不然数据进不去数据库中
} finally {
sqlSession.close();
}
}
public static void getUser() {
SqlSession sqlSession = sqlSessionFactory.openSession();
try {
UserMapper userMapper = sqlSession.getMapper(UserMapper.class);
User user = userMapper.getUser("zhanjindong1");
System.out.println("name: " + user.getName() + "|age: "
+ user.getAge());
} finally {
sqlSession.close();
}
}
public static void getUserMap() {
SqlSession sqlSession = sqlSessionFactory.openSession();
try {
UserMapper userMapper = sqlSession.getMapper(UserMapper.class);
List<Map<String, Object>> userMap = userMapper.getUserMap("lisi");
System.out.println("userMap: " + userMap);
} finally {
sqlSession.close();
}
}
public static void getUserMap1() {
SqlSession sqlSession = sqlSessionFactory.openSession();
try {
UserMapper userMapper = sqlSession.getMapper(UserMapper.class);
List<Map<String, Object>> userMap = userMapper.getUserMap1("lisi");
System.out.println("userMap1: " + userMap);
} finally {
sqlSession.close();
}
}
public static void getUserCount() {
SqlSession sqlSession = sqlSessionFactory.openSession();
try {
UserMapper userMapper = sqlSession.getMapper(UserMapper.class);
int userCount = userMapper.getUserCount("zhangsan");
System.out.println("userCount: " + userCount);
} finally {
sqlSession.close();
}
}
}

运行结果:
Fri Apr 14 08:38:04 CST 2017 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
name: zhanjindong1|age: 18
userMap: [{name=lisi, id=5, age=25}, {name=lisi, id=6, age=25}, {name=lisi, id=7, age=25}, {name=lisi, id=8, age=25}, {name=lisi, id=9, age=25}, {name=lisi, id=10, age=25}, {name=lisi, id=11, age=25}, {name=lisi, id=12, age=25}, {name=lisi, id=13, age=25}, {name=lisi, id=14, age=25}, {name=lisi, id=15, age=25}, {name=lisi, age=25}, {name=lisi, age=25}]
userMap1: [com.my.mybatis.Account@756e4d, com.my.mybatis.Account@e2abd, com.my.mybatis.Account@eff760, com.my.mybatis.Account@2f32ff, com.my.mybatis.Account@13f2bb1, com.my.mybatis.Account@e9a829, com.my.mybatis.Account@18a00e3, com.my.mybatis.Account@8b7f67, com.my.mybatis.Account@c7a4e4, com.my.mybatis.Account@178f375, com.my.mybatis.Account@c87b21, com.my.mybatis.Account@1375618, com.my.mybatis.Account@10399e]
userCount: 2

附上全套源码:

1)package com.my.mybatis;
public class Account {
private int id;
private String name;
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}

}
2)package com.my.mybatis;
public class User {
    private String name;
    private Integer age;
    public String getName() {
        return name;
    }
    public void setName(String name) {
        this.name = name;
    }
    public Integer getAge() {
        return age;
    }
    public void setAge(Integer age) {
        this.age = age;
    }
    public User(String name, Integer age) {
        super();
        this.name = name;
        this.age = age;
    }


    public User() {
        super();
    }
}


package com.my.mybatis;


import java.util.List;
import java.util.Map;


3)public interface UserMapper {
    public void insertUser(User user);
    public User getUser(String name);
public int getUserCount(String string);
public List<Map<String, Object>>  getUserCount1(String string);
public List<Map<String, Object>> getUserMap(String string);
public List<Map<String, Object>> getUserMap1(String string);
public List<Account> getUserMap2(String string);
public List<Map<String, Object>> getUserCount2(String string);
public List<Map<String, Object>> getUser1(String string);
}
4)package com.my.mybatis;
import java.io.IOException;
import java.io.Reader;
import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
public class MyBatisUtil {
    private final static SqlSessionFactory sqlSessionFactory;
    static {
        String resource = "mybatis-config.xml";
        Reader reader = null;
        try {
            reader = Resources.getResourceAsReader(resource);
        } catch (IOException e) {
            System.out.println(e.getMessage());
        }
        sqlSessionFactory = new SqlSessionFactoryBuilder().build(reader);
    }
    public static SqlSessionFactory getSqlSessionFactory() {
        return sqlSessionFactory;
    }
}
5)package com.my.mybatis;
import java.util.List;
import java.util.Map;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
public class TestMyBatis {
static SqlSessionFactory sqlSessionFactory = null;
static {
sqlSessionFactory = MyBatisUtil.getSqlSessionFactory();
}
public static void main(String[] args) {
testAdd();
getUser();
getUserMap();
getUserMap1();
getUserCount();
}
public static void testAdd() {
SqlSession sqlSession = sqlSessionFactory.openSession();
try {
UserMapper userMapper = sqlSession.getMapper(UserMapper.class);
User user = new User("lisi", new Integer(25));
userMapper.insertUser(user);
sqlSession.commit();// 这里一定要提交，不然数据进不去数据库中
} finally {
sqlSession.close();
}
}
public static void getUser() {
SqlSession sqlSession = sqlSessionFactory.openSession();
try {
UserMapper userMapper = sqlSession.getMapper(UserMapper.class);
User user = userMapper.getUser("zhanjindong1");
List<Map<String, Object>> userMap = userMapper
.getUser1("zhanjindong1");
System.out.println("name: " + user.getName() + "|age: "
+ user.getAge());


System.out.println("getUser  :userMap: " + userMap);
} finally {
sqlSession.close();
}
}
public static void getUserMap() {
SqlSession sqlSession = sqlSessionFactory.openSession();
try {
UserMapper userMapper = sqlSession.getMapper(UserMapper.class);
List<Map<String, Object>> userMap = userMapper.getUserMap("lisi");
System.out.println("getUserMap :userMap: " + userMap);
} finally {
sqlSession.close();
}
}
public static void getUserMap1() {
SqlSession sqlSession = sqlSessionFactory.openSession();
try {
UserMapper userMapper = sqlSession.getMapper(UserMapper.class);
List<Map<String, Object>> userMap1 = userMapper.getUserMap1("lisi");
List<Account> userMap2 = userMapper.getUserMap2("lisi");
System.out.println("userMap1: " + userMap1);
System.out.println("userMap2: " + userMap2);
} finally {
sqlSession.close();
}
}
public static void getUserCount() {
SqlSession sqlSession = sqlSessionFactory.openSession();
try {
UserMapper userMapper = sqlSession.getMapper(UserMapper.class);
int userCount = userMapper.getUserCount("zhangsan");
List<Map<String, Object>> userCount1 = userMapper
.getUserCount1("zhangsan");
List<Map<String, Object>> userCount2 = userMapper
.getUserCount2("zhangsan");
System.out.println("userCount: " + userCount);
System.out.println("userCount1: " + userCount1);
System.out.println("userCount2: " + userCount2);
} finally {
sqlSession.close();
}
}
}
6)<?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="com.my.mybatis.UserMapper">
<resultMap id="userMaps" type="com.my.mybatis.Account">
<id column="id" property="id" javaType="Integer" />
<result column="name" property="name" javaType="String" />
</resultMap>
<!-- 这里namespace必须是UserMapper接口的路径” -->
<insert id="insertUser" parameterType="User">
insert into user(name,age) values(#{name},#{age})
<!-- 这里sql结尾不能加分号，否则报“ORA-00911”的错误 -->
</insert>
<!-- 这里的id必须和UserMapper接口中的接口方法名相同 -->
<select id="getUser" resultType="User" parameterType="String">
select *
from user where name=#{name}
</select>
<select id="getUser1" resultType="java.util.Map" parameterType="String">
select *
from user where name=#{name}
</select>
<select id="getUserCount" resultType="Int" parameterType="java.lang.String">
select
count(*) from user where name=#{name}
</select>
<select id="getUserCount1" resultType="Int" parameterType="java.lang.String">
select
count(*) from user where name=#{name}
</select>
<select id="getUserCount2" parameterType="java.lang.String"
resultType="java.util.Map">
select
count(*) from
user where name=#{name}
</select>
<select id="getUserMap" resultType="java.util.Map"
parameterType="java.lang.String">
select * from user where name=#{name}
</select>
<select id="getUserMap1" resultMap="userMaps" parameterType="java.lang.String">
select id,name from user where name=#{name}
</select>
<select id="getUserMap2" resultMap="userMaps" parameterType="java.lang.String">
select id,name from user where name=#{name}
</select>
</mapper>
7)<?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>   
        <!-- changes from the defaults for testing -->   
        <setting name="cacheEnabled" value="false" />   
        <setting name="useGeneratedKeys" value="true" />   
        <setting name="defaultExecutorType" value="REUSE" />   
    </settings>   
    <typeAliases>   
       <typeAlias alias="User" type="com.my.mybatis.User"/>   
    </typeAliases>   
    <environments default="development">   
       <environment id="development">   
           <transactionManager type="jdbc"/>   
           <dataSource type="POOLED">   
              <property name="driver" value="com.mysql.jdbc.Driver"/>   
              <property name="url" value="jdbc:mysql://localhost:3306/mybatis"/>   
              <property name="username" value="root"/>   
              <property name="password" value="123456"/>   
           </dataSource>   
       </environment>   
    </environments>   
    <mappers>   
        <mapper resource="mappers/UserMapper.xml" />   
    </mappers>   
</configuration>
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/maven-v4_0_0.xsd">
<modelVersion>4.0.0</modelVersion>
<groupId>com.my.mybatis</groupId>
<artifactId>mybatis</artifactId>
<packaging>war</packaging>
<version>0.0.1-SNAPSHOT</version>
<name>mybatis Maven Webapp</name>
<url>http://maven.apache.org</url>
<dependencies>
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>3.8.1</version>
<scope>test</scope>
</dependency>
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.2.3</version>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.38</version>
</dependency>
</dependencies>
<build>
<finalName>mybatis</finalName>
</build>
</project>

运行结果:

Fri Apr 14 08:54:51 CST 2017 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
name: zhanjindong1|age: 18
getUser  :userMap: [{name=zhanjindong1, id=1, age=18}]
getUserMap :userMap: [{name=lisi, id=5, age=25}, {name=lisi, id=6, age=25}, {name=lisi, id=7, age=25}, {name=lisi, id=8, age=25}, {name=lisi, id=9, age=25}, {name=lisi, id=10, age=25}, {name=lisi, id=11, age=25}, {name=lisi, id=12, age=25}, {name=lisi, id=13, age=25}, {name=lisi, id=14, age=25}, {name=lisi, id=15, age=25}, {name=lisi, age=25}, {name=lisi, age=25}, {name=lisi, age=25}, {name=lisi, age=25}, {name=lisi, age=25}, {name=lisi, age=25}, {name=lisi, age=25}, {name=lisi, age=25}, {name=lisi, age=25}]
userMap1: [com.my.mybatis.Account@8b7f67, com.my.mybatis.Account@c7a4e4, com.my.mybatis.Account@178f375, com.my.mybatis.Account@c87b21, com.my.mybatis.Account@1375618, com.my.mybatis.Account@10399e, com.my.mybatis.Account@d992b2, com.my.mybatis.Account@15be6bb, com.my.mybatis.Account@39f31e, com.my.mybatis.Account@1fcfece, com.my.mybatis.Account@1ceabc1, com.my.mybatis.Account@15eef3d, com.my.mybatis.Account@f4468b, com.my.mybatis.Account@c4c815, com.my.mybatis.Account@82f6ef, com.my.mybatis.Account@fc185, com.my.mybatis.Account@3b1d11, com.my.mybatis.Account@f5e5e3, com.my.mybatis.Account@16d4b5c, com.my.mybatis.Account@100a15d]
userMap2: [com.my.mybatis.Account@1efea79, com.my.mybatis.Account@34c75a, com.my.mybatis.Account@16a51ab, com.my.mybatis.Account@1081592, com.my.mybatis.Account@19a81e8, com.my.mybatis.Account@1629756, com.my.mybatis.Account@ee68d8, com.my.mybatis.Account@15b5592, com.my.mybatis.Account@651fd0, com.my.mybatis.Account@120ebad, com.my.mybatis.Account@19f379, com.my.mybatis.Account@1c7cbad, com.my.mybatis.Account@12cc05a, com.my.mybatis.Account@1933fd1, com.my.mybatis.Account@8a9f61, com.my.mybatis.Account@153acfe, com.my.mybatis.Account@16905e, com.my.mybatis.Account@2d45ba, com.my.mybatis.Account@5ca609, com.my.mybatis.Account@e2cbe0]
userCount: 2
userCount1: [2]
userCount2: [{count(*)=2}]
MyBatis的简单使用demo
03-10
MyBatis的简单使用demo，请配合博客https://mp.youkuaiyun.com/mdeditor/88378844#。
springBoot+mybatis简单demo完整详细版
04-26
在本项目"springBoot+mybatis简单demo完整详细版"中，我们将深入探讨如何使用Spring Boot与MyBatis框架构建一个简单的应用。Spring Boot以其快速启动、自动化配置和开箱即用的特点，大大简化了Java应用程序的开发...
Mybatis的Demo使用(详细创建项目的步骤，注解形式和非注解形式实现)
车车的博客
11-18 1627
先来了解一下三层架构： 界面层（视图层）：接收用户的请求，调用service，显示请求的处理结果的。对应的包叫做Controller。 业务逻辑层，处理业务逻辑，使用算法处理数据，吧数据返回给界面层，对应的包是service。 持久层（数据库访问层）：访问数据库，或者读取文件，访问网络。对应的包是dao。 想象一下一个网页里面的学生信息，他是怎样来从数据库中获取出来，显示到网页中来的？ 本篇主要介绍对持久层（数据库访问层）的一种框架：Mybatis 。即了解怎样从数据库中拿取数据。 ..
mybatis的简单使用和demo
yuhaifei_123的博客
09-13 476
mybatis的简单使用和demodemo 这个是简单demo的 码云地址 https://git.oschina.net/yuhaifei/Mybatis_demo.git 1.导入jar包2.配置mybatis一下必要的文件 <?xml version="1.0" encoding="UTF-8" ?> <!DOCTYPE configuration PUBLIC "-//myb
MyBatis入门demo
kejiaming的专栏
05-20 6148
最近要学习使用MyBatis，参照网上的资料和官方的教程，根据自己的理解，记录一下。 MyBatisJar包下载地址：http://download.youkuaiyun.com/detail/jolingogo/5220163 官方教程：http://mybatis.github.com/mybatis-3/zh/index.htm 一.什么是MyBatis        MyBat
Mybatis Demo
Jintao_Ma的博客
10-16 914
Mybatis Demo 在分析Spring AOP的事务时，需要进行事务的配置，所以需要先对进行持久层的配置原理进行分析，这篇文章来分析下mybatis是如何使用的，通过一个简单的Demo并且分析它的原理： 1.示例如下 User.java package com.company.user.entity; public class User { private Integer
mybatis简单使用demo
04-22
mybatis简单使用mybatis简单使用demomybatis简单使用demomybatis简单使用demomybatis简单使用demomybatis简单使用demomybatis简单使用demomybatis简单使用demomybatis简单使用demomybatis简单使用demomybatis简单...
mybatis demo
01-25
MyBatis可以使用简单的XML或注解进行配置和原始映射，将接口和Java的POJOs(Plain Old Java Objects，普通的Java对象)映射成数据库中的记录。它的核心组件包括SqlSessionFactoryBuilder、SqlSessionFactory、...
springboot+mybatis 整合Demo下载
02-02
SpringBoot和MyBatis是两个在Java开发领域广泛使用的开源框架。SpringBoot简化了Spring应用的初始搭建以及开发过程，而MyBatis则是一个优秀的持久层框架，它支持定制化SQL、存储过程以及高级映射。现在我们来深入...
springboot-mybatis-demo
12-07
MyBatis-Spring是它们的整合模块，负责处理事务管理和Bean的注入，使得在Spring环境下使用MyBatis变得简单。 【MySQL】MySQL提供了强大的SQL支持，适合各种规模的项目。在Spring Boot中，通过JDBC或者JPA来与MySQL...
mybatis maven demo
08-06
mybatis maven demo 测试示例 mybatis maven demo 测试示例
Mybatisdemo
03-21
Mybatis开发小例子以及详细配置文件解析，快速入门和使用mybatis
MyBatisDemo
11-25
MyBatisDemo，简单的增、删、改、查
MybatisDemo
10-19
Mybatis实现数据的增删改查（CRUD）。Mybatis关联查询（嵌套查询）。
MyBatis使用Demo
最新发布
蒋大钊的博客
06-15 1070
MyBatis 基本用法的一个学习记录，方便后面查阅
mybatis使用demo
u012772803的博客
02-19 235
pom中导入依赖 <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <version>8.0.20</version> </dependency> <dependency> <groupId>c
MyBatis简单使用的demo
KK的博客
04-30 446
MyBatis简单使用的demo MyBatis 是一个java持久层框架，类似hibernate，但是比hibernate轻，功能没hibernate多，关于谁好谁坏，一直有人再争论，应该是各有各的好处，大家可以自行百度其优缺点。 本章内容 MyBatis 配置 MyBatis Java dome MyBatis 配置 -下载M
MyBatis小demo
往事
07-18 902
一套MyBatis+oracle+servlet+jQuery+tomcat实现的增、删、改、查、分页、动态条件查询，希望能够给初学者带来便利，提高新手的能力。 一、项目结构 二、配置文件 1、 MyBatis-config.xml "http://mybatis.org/dtd/mybatis-3-config.dtd">
简易MyBatis基础Demo教程
在本篇知识梳理中，我们将深入探讨与标题《一个灰常简单的MyBatisDemo》和描述《一个很简单的mybatisdemo.仅仅使用mybatis的基本jar包》相关的关键知识点。 ### MyBatis 核心概念 **1. SQL 映射文件** SQL 映射...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值