mybatis新手快速入门以及一些错误汇总
作者:十维space 时间:2023-01-25 13:01:14
一、使用maven加载依赖
加载了连接数据库的依赖、mybatis的依赖以及lombok的依赖
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>4.11</version>
<scope>test</scope>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.47</version>
</dependency>
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.5.4</version>
</dependency>
<dependency>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
<version>1.18.12</version>
</dependency>
二、建库、建表
三、配置MyBatis的配置文件(conf.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.jdbc.Driver" />
<property name="url" value="jdbc:mysql://localhost:3306/数据库名字?/useUnicode=true&characterEncoding=utf8&useSSL=false" />
<property name="username" value="root" />
<property name="password" value="数据库密码" />
</dataSource>
</environment>
</environments>
</configuration>
四、定义表所对应的实体类
@Data
@NoArgsConstructor
@AllArgsConstructor
public class User {
private Integer uid;
private String uname;
private String password;
}
五、定义操作表的sql的映射文件xxxMapper.xml
见名知意,操作的user表,所以映射文件也命名为了userMapper.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">
<!--tuser是我自己定的名字-->
<mapper namespace="tuser">
<!--id自己设置,等会调用方法名使用,resultType查询结果类型-->
<select id="getUserById" resultType="com.hongda.space.entity.User">
<!--sql语句,#{}是参数格式,注意字段要与实体类属性一致-->
select * from t_user where uid=#{uid}
</select>
<!--parameterType参数类型-->
<insert id="insertUser" parameterType="com.hongda.space.entity.User">
insert into t_user(uname,password) values(#{uname},#{password});
</insert>
</mapper>
六、在Mybatis配置文件中添加映射文件
将编写好的userMapper.xml添加到mybatis.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.jdbc.Driver" />
<property name="url" value="jdbc:mysql://localhost:3306/数据库名字?/useUnicode=true&characterEncoding=utf8&useSSL=false" />
<property name="username" value="root" />
<property name="password" value="数据库密码" />
</dataSource>
</environment>
</environments>
<mappers>
<mapper resource="mapper/userMapper.xml"/>
</mappers>
</configuration>
七、编写增删改查代码测试
import com.hongda.space.entity.User;
import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
import java.io.IOException;
import java.io.Reader;
/**
* @ClassName Test01
* @Description TODO
* @Author whd
* @Date 2021/3/19 14:45
*/
public class Test01 {
public static void main(String[] args) throws IOException {
//1.读取配置文件
Reader reader = Resources.getResourceAsReader("conf.xml");
//2.获取sqlSessionFactory
SqlSessionFactory sessionFactory = new SqlSessionFactoryBuilder().build(reader);
//3.获取sqlsession对象 执行sql
SqlSession session = sessionFactory.openSession();
//4.执行sql
User user = session.selectOne("tuser.getUserById", 1);
System.out.println(user);
int i = session.insert("tuser.insertUser",new User(null, "小刘", "4545"));
System.out.println(i+"------------");
session.commit();
}
}
结果:
一些错误
编写中可能碰到的错误
1.Mapped Statements collection does not contain…
2.The server time zone value'XXXXXXXXX' is…
在Mybatis配置文件中的jdbc连接地址后面拼接serverTimezone=Asia/Shanghai
总结
来源:https://blog.csdn.net/WHD1998/article/details/115011468
标签:mybatis,快速,入门
0
投稿
猜你喜欢
C# WPF实现的语音播放自定义控件
2022-11-23 19:45:49
SpringCloud实战小贴士之Zuul的路径匹配
2021-05-26 13:26:36
java简单实现用语音读txt文档方法总结
2022-11-10 22:02:54
SpringBoot整合WebSocket的客户端和服务端的实现代码
2023-03-30 04:19:07
Android多线程学习实例详解
2022-02-17 19:00:56
Spring JDK动态 代理实现过程详解
2023-11-16 19:42:15
Android仿微信雷达辐射搜索好友(逻辑清晰实现简单)
2022-07-25 05:28:19
Java运行时数据区域(内存划分)的深入讲解
2023-03-16 02:36:50
Java NIO实现聊天功能
2022-06-12 08:31:31
Android实现多段颜色进度条效果
2023-09-30 22:07:51
vs2019永久配置opencv开发环境的方法步骤
2023-11-02 19:38:58
Java 电话号码的组合示例详解
2023-07-30 22:27:53
如何用IDEA调试BUG的几种方法
2022-08-04 17:12:46
Android自定义控件实现带数值和动画的圆形进度条
2021-09-09 22:02:46
VS2013创建Windows服务与调试服务的图文方法
2022-01-15 02:23:14
Android封装MVP实现登录注册功能
2021-06-14 20:45:08
C#7.0中新特性汇总
2023-06-24 18:29:13
Android嵌套RecyclerView左右滑动替代自定义view
2023-03-27 14:51:17
android中实现指针滑动的动态效果方法
2023-10-07 15:54:44
SpringData JPA中@OneToMany和@ManyToOne的用法详解
2021-10-01 00:49:10