本篇博客是基于maven工程的mybatis连接数据库的快速上手
1.连接数据库
下面的错误信息是由于jar包的问题,引用下文提供的pom.xml文件即可成功
检查对应数据库中的表
User实体类
package com.jian.pojo;
import lombok.Data;
/**
* @description:
* @author: ajian
*/
@Data
public class User {
private Integer StuID;
private Integer StuAge;
private String StuSex;
private String StuName;
private String StuClass;
}
如果不能进行注解开发,此处提供两种解决思路
UserDao接口类
package com.jian.dao;
import com.jian.pojo.User;
import java.util.List;
/**
* <功能描述><br>
*
* @className: UserDao
* @package: com.jian.dao
* @author: ajian
* @dete: 2020/10/10 9:19
*/
public interface UserDao {
List<User> findAll();
}
Usermapper.xml配置文件
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.jian.dao.UserDao">
<select id="findAll" resultType="com.jian.pojo.User">
select * from student
</select>
</mapper>
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.jdbc.Driver"/>
<property name="url" value="jdbc:mysql:///onlinedb"/>
<property name="username" value="root"/>
<property name="password" value="123456"/>
</dataSource>
</environment>
</environments>
<mappers>
<mapper resource="mapper/Usermapper.xml"/>
</mappers>
</configuration>
Test类
package com.jian.dao;
import com.jian.pojo.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;
import java.util.List;
/**
* @description:
* @author: ajian
*/
public class TestUserDao {
public static void main(String[] args) throws IOException {
//读取配置文件
Reader reader = Resources.getResourceAsReader("mabatis-config.xml");
//创建sqlSessionFactory工厂
SqlSessionFactory build = new SqlSessionFactoryBuilder().build(reader);
//通过sqlSessionFactory工厂,得到一个会话
SqlSession sqlSession = build.openSession();
//使用代理对象执行查询所有方法
UserDao mapper = sqlSession.getMapper(UserDao.class);
List<User> all = mapper.findAll();
for (User user : all) {
System.out.println(user);
}
//释放资源
sqlSession.close();
reader.close();
}
}
以上就是本篇文章的全部分享,配置文件笔者是设置了模板,可以自行度娘如何设置,或者留言