程序代码:
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");//第二个入参是参数