ibatis_note_1

作为新手还是先照着做个小例子

一.导入ibatis包和mysql的jdbc包。

二.新建一个User类，包含id，name，sex。

三.写ibatis配置文件，SqlMapConfig.xml。

四.写sql映射的xml文件User.xml。

五.初始化配置文件并查询。

User.java

package com.forrest.ibatis.test.domain;import java.io.Serializable;public class User implements Serializable{private Integer id;private String name;private Integer sex;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 Integer getSex(){return sex;}public void setSex(Integer sex){this.sex = sex;}}

?

?SqlMapConfig.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/ibatis1"/>                      <property name="username" value="java"/>                   <property name="password" value="java"/>                   </dataSource>              </environment>          </environments>          <mappers>              <mapper resource="com/forrest/ibatis/test/User.xml"/>          </mappers>    </configuration>  

?User.xml

<?xml version="1.0" encoding="UTF-8" ?>  <!DOCTYPE mapper  PUBLIC "-//ibatis.apache.org//DTD Mapper 3.0//EN"  "http://ibatis.apache.org/dtd/ibatis-3-mapper.dtd">    <mapper namespace="UserMapper">      <select id="selectOne" parameterType="java.lang.Integer" resultType="com.forrest.ibatis.test.domain.User">          select * from t_user where id = #{id}    </select>  </mapper>

?main方法

public static void main(String[] args) throws IOException{String resource = "com/forrest/ibatis/test/SqlMapConfig.xml";Reader reader;reader = Resources.getResourceAsReader(resource);SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(reader);SqlSession sqlSession = sqlSessionFactory.openSession();User user = (User)sqlSession.selectOne("UserMapper.selectOne", "1");System.out.println(user.getId());System.out.println(user.getName());System.out.println(user.getSex());}

?

?