mybatis学习笔记

程序代码：

http://download.csdn.net/detail/zhengsihan/5879569

1、程序结构

2、代码和配置文件

test.java(测试类)

import java.io.InputStream;
import java.util.List;

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 org.minus.entity.Person;

public class Test {
	public static void main(String[] args) {
		String res = "mybatisConfig.xml";
		SqlSession sess = null;
		try {
			InputStream inputStream = Resources.getResourceAsStream(res);
			SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
			
			sess = sqlSessionFactory.openSession();
			List<Person> cent = sess.selectList("org.minus.entity.PersonMapper.selectAll");//Mapper的全限定名+select标签id
			for (Person person : cent) {
				System.out.println(person);
			}
		} catch (Exception e) {
			e.printStackTrace();
		}finally{
			sess.close();
		}
	}
}

Person.java（实体类）

package org.minus.entity;

public class Person {
	private int id;
	private String name;
	private int age;
	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 toString(){
		return "id为："+this.getId()+"\t名字为："+this.getName()+"\t年龄为："+this.getAge();
	}
}

PersonMapper.xml（实体类映射文件。注意resultMap的写法）

<?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="org.minus.entity.PersonMapper">
	<resultMap type="org.minus.entity.Person"  id="person">
		<id property="id" column="id" />
		<result property="name" column="name" />
		<result property="age" column="age" />
	</resultMap>
	
	<select id="selectAll"  resultMap="person">
		select * from person
	</select>
</mapper>

mybatisConfig.xml（mybatis配置文件）

<?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>
	<typeAliases>
		<typeAlias alias="person" type="org.minus.entity.Person"/>
	</typeAliases>
	
	<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/westfall"/>
				<property name="username" value="zsh"/>
				<property name="password" value="123456"/>
			</dataSource>
		</environment>
	</environments>
	
	<mappers>
		<mapper resource="org/minus/entity/PersonMapper.xml"/>
	</mappers>
</configuration>

参数查询：

<select id="selectById" parameterType="String" resultMap="person">
		select * from person where id=#{id}
	</select>

sess.selectList("org.minus.entity.PersonMapper.selectById","2");//第二个入参是参数