mybaits框架的实现之查询所有数据

第一步：创建数据库：ceshi

第二步：创建user表并添加数据：

第三步：使用myeclipse创建一个web项目：mybatis-getList

第四步：导入需要的jar包：jar包放到lib下面,并添加到项目中，并builderPath

第五步：创建包

第六步：在com.salmon.bean下面创建类UserBean

package com.salmon.bean;

public class UserBean {
  private int id;
  private String name;
  private int age;
  private String sex;
  private String address;
public int getId() {
	return id;
}
public void setId(int id) {
	this.id = id;
}
public String getName() {
	return name;
}
public void setName(String name) {
	this.name = name;
}
public int getAge() {
	return age;
}
public void setAge(int age) {
	this.age = age;
}
public String getSex() {
	return sex;
}
public void setSex(String sex) {
	this.sex = sex;
}
public String getAddress() {
	return address;
}
public void setAddress(String address) {
	this.address = address;
}
@Override
public String toString() {
	return "User [id=" + id + ", name=" + name + ", age=" + age + ", sex="
			+ sex + ", address=" + address + "]";
}
public UserBean(int id, String name, int age, String sex, String address) {
	super();
	this.id = id;
	this.name = name;
	this.age = age;
	this.sex = sex;
	this.address = address;
}
public UserBean() {
	
}

  
  
  
}

 第七步：在resources下创建jdbc.properties文件：

url = jdbc:mysql://localhost:3306/ceshi?useUnicode=true&characterEncoding=utf-8
username = root
password = admin
driver=com.mysql.jdbc.Driver

第八步：在resources下创建mybatisConfig.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>
	<!-- 配置数据库连接信息 引入资源文件 -->
	<properties resource="jdbc.properties"></properties>
	
	<!-- development 开发模式 work 工作模式 -->
	<environments default="development">
		<environment id="development">
			<transactionManager type="JDBC" />
			<dataSource type="POOLED">
				<property name="driver" value="${driver}" />
				<property name="url" value="${url}" />
				<property name="username" value="${username}" />
				<property name="password" value="${password}" />

			</dataSource>
		</environment>
	</environments>
	<mappers>
		<mapper resource="com/salmon/mapper/userMapper.xml" />
	</mappers>
</configuration>

第九步：在com.salmon.mapper下创建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">
<mapper namespace="com.salmon.dao.UserDao">
      
   <!-- 查询所有数据-->
   <select id="getList" resultType="com.salmon.bean.UserBean">
      select id,name,age,sex,address from user
   </select>
  
</mapper>

第十步：在com.salmon.util下创建SqlSessionUtil类

package com.salmon.util;

import java.io.IOException;
import java.io.Reader;

import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;

public class SqlSessionUtil {
	private static SqlSessionFactory factory;
	
	static{
		try {
			Reader	reader = Resources.getResourceAsReader("mybatisConfig.xml");
			// 第二部 获得sqlsession工厂
			factory = new SqlSessionFactoryBuilder()
					.build(reader);
		} catch (IOException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
	
	public static SqlSessionFactory  getSessionFactory(){
		return factory;
	}
    
	public static SqlSession getSession(){
		return getSessionFactory().openSession();//默认不自动提交
		//return getSessionFactory().openSession(true);自动提交
	}
}

第十一步：在com.salmon下创建UserDao接口

package com.salmon.dao;

import java.util.List;
import com.salmon.bean.UserBean;

public interface UserDao {	
	
	//查询所有数据
	public List<UserBean> getList();

}

第十二步：在com.salmon.test下创建测试类Test

package com.salmon.test;

import java.util.List;

import org.apache.ibatis.session.SqlSession;

import com.salmon.bean.UserBean;
import com.salmon.util.SqlSessionUtil;

public class Test{
public static void main(String[] args) {
	SqlSession session = SqlSessionUtil.getSession();
	List<UserBean> userlist = session.selectList("getList");
	for (UserBean user : userlist) {
        System.out.println(user);
	}
	session.close();
}
}

运行结果：

下载地址：​​​​​​https://download.csdn.net/download/qq_55641896/85075133?spm=1001.2014.3001.5501