1,在maven中引入Mybatis
<!-- https://mvnrepository.com/artifact/org.mybatis/mybatis -->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.5.6</version>
</dependency>
2,在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>
<environments default="development">
<environment id="development">
<transactionManager type="JDBC"/>
<dataSource type="POOLED">
<property name="driver" value="com.mysql.cj.jdbc.Driver"/>
<!--连接数据库地址 -->
<property name="url" value="jdbc:mysql://localhost:3306/mybatisuseSSL=true&useUnicode=true&characterEncoding=UTF-8&serverTimeZone=GMT%2B8" />
<!--连接数据库名字 -->
<property name="username" value="root"/>
<!--连接数据库密码 -->
<property name="password" value=""/>
</dataSource>
</environment>
</environments>
<mappers>
<mapper resource="User.mapper.xml"/><!--地址和第三步的位置同步-->
</mappers>
</configuration>
3,在resources中创建User.mapper.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">
<!--namespace绑定mapper接口 -->
<mapper namespace="cn.mybatis.Uesrmapper">
<!-- id=Uesrmapper中的方法名字 -->
<!-- resultType对应实体类的位置 -->
<select id="getUserlist" resultType="cn.mybatis.User">
select * from mybatis.admin;
</select>
<select id="getUserByid" resultType="cn.mybatis.User" parameterType="int">
select * from mybatis.admin where id=#{id}
</select>
<insert id="addUser" parameterType="cn.mybatis.User">
insert into mybatis.admin(id,user)value(#{id},#{user})
</insert>
</mapper>
3,编写一个实体类User,对应数据库信息。
4,编写一个接口类:Uesrmapper.java:
public interface Uesrmapper {
//查询全部用户
List<User> getUserlist();
//根据id查询
List<User> getUserByid(int id);
//添加用户
int addUser(User user);
}
5,编写一个Mybatis.java类:
public class Mybatis {
private SqlSessionFactory sqlSessionFactory;
public Mybatis(){
InputStream is = null;
try {
//使用mybatis获取sqlSessionFactory
String resource = "mybatis-config.xml";
is = Resources.getResourceAsStream(resource);
sqlSessionFactory = new SqlSessionFactoryBuilder().build(is);
} catch (IOException e) {
e.printStackTrace();
}
}
public SqlSession getSqlSession() {
SqlSession sqlSession = sqlSessionFactory.openSession();
return sqlSession;
}
}
6,调用:
SqlSession sqlSession = Mybatis.getSqlSession();
//执行sql
Uesrmapper us = sqlSession.getMapper(Uesrmapper.class);
List<User> ls = us.getUserByid(id);
sqlSession.close();