第一个mybatis程序(mybatis入门)

1.mybatis的JAR包下载地址：（官方网站）http://blog.mybatis.org/p/products.html

2.本人下载的是mybatis-3.2.5.jar，将此驱动包，和mysql驱动包一并拷入项目的lib目录下 

项目目录截图如下

附数据库脚本：

/*
Navicat MySQL Data Transfer

Source Server         : localhost_3306
Source Server Version : 50130
Source Host           : 127.0.0.1:3306
Source Database       : ibatis

Target Server Type    : MYSQL
Target Server Version : 50130
File Encoding         : 65001

Date: 2014-03-14 10:32:19
*/

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `ibatis`
-- ----------------------------
DROP TABLE IF EXISTS `ibatis`;
CREATE TABLE `ibatis` (
  `sid` int(10) NOT NULL AUTO_INCREMENT,
  `sname` varchar(10) NOT NULL,
  `stel` varchar(20) NOT NULL,
  PRIMARY KEY (`sid`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of ibatis
-- ----------------------------
INSERT INTO `ibatis` VALUES ('1', 'aqwe', '11002');

3.编写配置文档SqlMapConfig.xml，放置在src目录下

<?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="ibatis" type="pojo.ibatis" />  
    </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/ibatis" />
				<property name="username" value="root" />
				<property name="password" value="111" />
			</dataSource>
		</environment>
	</environments>
	<mappers>
		<mapper resource="pojo/ibatis.xml" />
	</mappers>
</configuration>

4.编写实体类ibatis.java，以及映射文件ibatis.xml

package pojo;

public class ibatis {
	private int sid;
	private String sname;
	private String stel;
	public int getSid() {
		return sid;
	}
	public void setSid(int sid) {
		this.sid = sid;
	}
	public String getSname() {
		return sname;
	}
	public void setSname(String sname) {
		this.sname = sname;
	}
	public String getStel() {
		return stel;
	}
	public void setStel(String stel) {
		this.stel = stel;
	}
	@Override
	public String toString() {
		return "ibatis [sid=" + sid + ", sname=" + sname + ", stel=" + stel
				+ "]";
	}
	
}

ibatis.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="ibatis"> 

<select id="selectibatis" parameterType="int" resultType="ibatis">
     select * from ibatis where sid = #{sid} 
</select>  
</mapper>  

5.编写测试类test.java

package 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 pojo.ibatis;

public class test {

	public static void main(String[] args) throws IOException {  
        Reader reader = Resources.getResourceAsReader("SqlMapConfig.xml" );  
        SqlSessionFactory ssf = new SqlSessionFactoryBuilder().build(reader);  
        SqlSession session = ssf.openSession();  
        try {  
            ibatis ib = (ibatis) session.selectOne("selectibatis",1);  
            System.out.println(ib);  
        } catch (Exception e) {  
            e.printStackTrace();  
        } finally {  
            session.close();  
        }  
    }  

}

6执行测试类，运行结果：ibatis [sid=1, sname=aqwe, stel=11002]  即成功查询到一条数据库记录

源程序下载：http://download.csdn.net/detail/b291437428/7038911