1、创建一个java工程,新建目录config,用于存放配置文件,有mybatis核心配置SqlMapConfig.xml,User.xml文件;新建目录test来存放测试类Mybatis_first;
2、在sqlmap包的User.xml中创建一个<mapper namespace="test">
<select id="findUserById" parameter="int" resultType="com.tfs.mybatis.User">
select * from user where id=#{id}
</select>
</mapper>
3、在SqlMapConfig包中配置数据源<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/mybatis"/>
<property name="username" value="root"/>
<property name="password" value="123456"/>
</dataSource>
</environment>
</environments>
在SqlMapConfig.xml中加载User.xml;<mappers><mapper resource="sqlmap/User.xml"></mapper></mappers>
在src包中新建一个包com.tfs.mybatis.po,存放User实体类。
4、Mybatis测试类
public class Mybatis_first{
private SqlSessionFactory sqlSessionFactory;
@Before
public void createSqlSessionFactory() throws Exception{
String resource="SqlMapConfig.xml";
InputStream inputStream=Resources.getResourceAsStream(resource);
sqlSessionFactory=new SqlSessionFactoryBuilder.build(inputStream);
}
@Test
public void testFindUserById() {
SqlSession sqlSession=null;
try{
sqlSession=sqlSessionFactory.openSession();
User user=sqlSession.selectOne("test.findUserById",10);
System.out.println(user);
}catch(Exception e){
e.printStackTrace();
}finally{
if(sqlSession!=null){
sqlSession.close();
}
}
}
}