一.com/book/map包下有两个配置文件:
1.MyBatisConfig.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="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/wzz"/>
<property name="username" value="root"/>
<property name="password" value="777777"/>
</dataSource>
</environment>
</environments>
<mappers>
<mapper resource="com/book/map/bookmap.xml"/>
</mappers>
</configuration>
2.bookmap.xml 用于写sql语句进行数据库具体操作
<?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="domain.blog.mappers.AutoorMapper">
<!-- parameterType为参数类型,resultType为返回值类型 -->
<select id="findById" parameterType="int" resultType="com.book.pojo.bookUser">
select * from bookuser where id=#{id}
</select>
</mapper>
二.一个简单java类bookUser
package com.book.pojo;
public class bookUser {
private int id;
private String userName;
private String password;
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getUserName() {
return userName;
}
public void setUserName(String userName) {
this.userName = userName;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
}
三.测试类
package com.book.test;
import java.io.IOException;
import java.io.Reader;
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.book.pojo.bookUser;
public class testBook {
public static void main(String[] args) {
String resource = "com/book/map/MyBatisConfig.xml";
Reader reader = null;
SqlSession session;
try {
reader = Resources.getResourceAsReader(resource);
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
SqlSessionFactory sqlMapper = new SqlSessionFactoryBuilder().build(reader);
session = sqlMapper.openSession();
bookUser temp = session.selectOne("findById",1);
System.out.print(temp.getUserName());
session.close();
}
}
原文:http://www.cnblogs.com/wzz1020/p/4846960.html