项目的目录结构:
一、添加mybatis.jar以及mysql的驱动包
二、创建数据的表
三、编写与表对应的实体类
四、编写连接数据库的配置文件configuration.xml
五、编写PersonMapper接口
六、编写PersonMapper的实现,personMapper.xml文件
七、编写测试文件
一:直接把mybatis和mysql的jar包添加进去
二:创建数据表的语句。(数据库名称为evan)
create table t_person(
id int not null primary key auto_increment,
name varchar(20),
age varchar(20)
);
三、与数据库表对应的实体类Person
package com.evan.entity;
public class Person {
private Integer id;
private String name;
private String age;
public Integer getId() {
return id;
}
public void setId(Integer id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getAge() {
return age;
}
public void setAge(String age) {
this.age = age;
}
}
四、编写configuration.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>
<typeAliases>
<!--给实体类起一个别名 user -->
<typeAlias type="com.evan.entity.Person" alias="Person" />
</typeAliases>
<!--数据源配置 这块用 mysql数据库 -->
<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/evan" />
<property name="username" value="root" />
<property name="password" value="123456" />
</dataSource>
</environment>
</environments>
<mappers>
<!--userMapper.xml装载进来 同等于把“dao”的实现装载进来 -->
<mapper resource="mybatis/personMapper.xml" />
</mappers>
</configuration>
五、编写PersonMapper接口
public interface PersonMapper {
public Person findById(Integer id );
}
六、编写PersonMapper的实现,personMapper.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.evan.dao.PersonMapper">
<!-- findById必须和接口中的方法名一样 返回一个User 就是刚才的别名 如果不弄别名要连类路径一起写 麻烦 -->
<select id="findById" parameterType="HashMap" resultType="Person">
select
* from t_person where id=#{id}
</select>
</mapper>
七、编写测试文件MybatisTest
package com.evan.test;
import java.io.IOException;
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 com.evan.dao.PersonMapper;
import com.evan.entity.Person;
public class MybatisTest {
/**
* 获得MyBatis SqlSessionFactory
* SqlSessionFactory负责创建SqlSession,一旦创建成功,就可以用SqlSession实例来执行映射语句
* ,commit,rollback,close等方法。
*
* @return
*/
private static SqlSessionFactory getSessionFactory() {
SqlSessionFactory sessionFactory = null;
String resource = "configuration.xml";
try {
sessionFactory = new SqlSessionFactoryBuilder().build(Resources
.getResourceAsReader(resource));
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return sessionFactory;
}
public static void main(String[] args) {
SqlSession sqlSession = getSessionFactory().openSession();
PersonMapper personMapper = sqlSession.getMapper(PersonMapper.class);
Person person = personMapper.findById(1);
System.out.println(person.getName());
}
}
点击运行,就能把id为1的数据查出来了。如果觉得麻烦我已经把源码上传到资源里面。免积分的
下载地址为:http://download.csdn.net/detail/zl544434558/6384241