如果看不懂请看官方文档仅供参考
https://mybatis.org/mybatis-3/zh/index.html(官方文档)
下面有源码
能看到这里相信大家的Java已经学习了挺长时间了,肯定不会以为HelloWorld是简单的你好,世界或者是在刚入门的时候最简单的HelloWorld。
带大家重温一下经典
public class HelloWorld{
public static void main(String args[]){
System.out.println("HelloWorld");
}
}
这个的输出肯定就是“HelloWorld”
回归正题
1.创建数据库,表,并添加一条数据
create database test1;
use test1;
create table t_user(
`id` primary key auto_increment,
`last_name` varchar(20),
`gender`varchar(10),
email varchar(50)
)
2.创建一个java工程mybatis
2.1创建对应的javaBean
package mybatis.bean;
public class User {
private Integer id;
private String lastName;
private String gender;
private String email;
public Integer getId() {
return id;
}
public void setId(Integer id) {
this.id = id;
}
public String getLastName() {
return lastName;
}
public void setLastName(String lastName) {
this.lastName = lastName;
}
public String getGender() {
return gender;
}
public void setGender(String gender) {
this.gender = gender;
}
public String getEmail() {
return email;
}
public void setEmail(String email) {
this.email = email;
}
@Override
public String toString() {
return "user [id=" + id + ", lastName=" + lastName + ", gender=" + gender + ", email=" + email + "]";
}
}
2.2创建lib文件并导包
一共三个包
log4j.jar -->将查询过程打印到控制台
mybatis-3.4.1.jar --> mybatis框架包
mysql-connector-java-5.1.37-bin.jar -->数据库驱动
2.3在根目录下创建conf文件夹,用来放置xml文件
log4j.xml -->将查询过程打印到控制台
mybatis-config.xml ==>XML 配置文件中包含了对 MyBatis 系统的核心设置,包括获取数据库连接实例的数据源(DataSource)以及决定事务作用域和控制方式的事务管理器(TransactionManager)。
<?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/test1"/>
<property name="username" value="root"/>
<property name="password" value="123456"/>
</dataSource>
</environment>
</environments>
<mappers>
<mapper resource="MybatisMapper.xml"/>
</mappers>
</configuration>
里面需要改的
自己数据库的url,username,password
resource:第三个文件的全名称
MybatisMapper.xml==>探究已映射的 SQL 语句
<?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="mybatis.UserMapper">
<!-- namespace:名称空间
id:唯一标识
resultType:返回值类型
#{id}:从传出来的参数中取出id值
-->
<select id="selectUser" resultType="mybatis.bean.User">
select id,last_name lastName,gender,email from t_user where id = #{id}
</select>
</mapper>
namespace:名称空间
id:唯一标识
resultType:返回值类型
#{id}:从传出来的参数中取出id值
3.测试
import java.io.IOException;
import java.io.InputStream;
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 mybatis.bean.User;
public class mybatisTest {
public static void main(String[] args) throws IOException {
String resource = "mybatis-config.xml";
InputStream inputStream = Resources.getResourceAsStream(resource);
SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
//获取SQLSession实例,能直接执行已经映射的sql语句
SqlSession openSession = sqlSessionFactory.openSession();
//sql语句的唯一标识符:statement Unique identifier matching the statement to use.
//执行sql语句要用的参数:statement Unique identifier matching the statement to use.
try {
User user = openSession.selectOne("selectUser", 1);
System.out.println(user);
}finally {
openSession.close();
}
}
}
4.运行结果
源码+jar包(百度网盘)
链接:https://pan.baidu.com/s/1A3AT4gbjBEiaFp2_VglPIg
提取码:1234
酒枯推荐
本周推荐学习: SSM (Spring + SpringMVC+Mybatis)