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標籤idfor (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");//第二個入參是參數