MyBatis第一天

MyBatis第一天

1. 导入jar包
   
   2.编写实体类

package com.demo.pojo;
/**
 * 实体类
 * @author Administrator
 *
 */
public class Flower {
	private int id;
	private String name;
	private double price;
	private String production;
	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 double getPrice() {
		return price;
	}
	public void setPrice(double price) {
		this.price = price;
	}
	public String getProduction() {
		return production;
	}
	public void setProduction(String production) {
		this.production = production;
	}
	@Override
	public String toString() {
		return "Flower [id=" + id + ", name=" + name + ", price=" + price + ", production=" + production + "]";
	}
	
}

3.配置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="default">
		<environment id="default">
			<!--使用JDBC事务-->
			<transactionManager type="JDBC"/>
			<!--使用数据库连接池-->
			<dataSource type="POOLED">
				<property name="driver" value="com.mysql.jdbc.Driver"/>
				<property name="url" value="jdbc:mysql://localhost:3306/ssm"/>
				<property name="username" value="root"/>
				<property name="password" value="system"/>
			</dataSource>
		</environment>
	</environments>
	<mappers>
		<mapper resource="com/demo/pojo/FlowerMapper.xml"/>
	</mappers>
</configuration>

4.配置FlowerMapper.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="a.b">
	实体类名字区分大小写
	<select id="selAll" resultType="com.demo.pojo.Flower">
		select * from flower
	</select>
</mapper>

5.编写测试类

	@Test
	public void selAll() throws IOException{
		InputStream is = Resources.getResourceAsStream("mybatis.xml");
		SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(is);
		SqlSession session = factory.openSession();
		List<Flower> list = session.selectList("a.b.selAll");
		for (Flower flower : list) {
			System.out.println(flower.toString());
		}
		session.close();
	}