Mybatis入門實例

一 工程目錄結構

二  數據表定義

mysql> describe kyly_user;
+--------------+--------------+------+-----+---------+----------------+
| Field        | Type         | Null | Key | Default | Extra          |
+--------------+--------------+------+-----+---------+----------------+
| id           | bigint(20)   | NO   | PRI | NULL    | auto_increment |
| username     | varchar(30)  | YES  |     | NULL    |                |
| password     | varchar(50)  | YES  |     | NULL    |                |
| roleid       | bigint(20)   | YES  | MUL | NULL    |                |
| sex          | varchar(4)   | YES  |     | NULL    |                |
| telphone     | varchar(12)  | YES  |     | NULL    |                |
| emailaddress | varchar(250) | YES  |     | NULL    |                |
| firstname    | varchar(20)  | YES  |     | NULL    |                |
| familyname   | varchar(20)  | YES  |     | NULL    |                |
| registtime   | datetime     | YES  |     | NULL    |                |
+--------------+--------------+------+-----+---------+----------------+

三 Mybatis配置文件

<?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/qdkyly"/>
				<property name="username" value="root"/>
				<property name="password" value="*****"/>
			</dataSource>
		</environment>
	</environments>
	<mappers>
		<mapper resource="com/symantec/ps/purejdbc/mapper/SqlMap.xml"/>
	</mappers>
</configuration>

四 用戶表Mapper文件

<?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.symantec.ps.purejdbc.mapper">
	<select id="selectUser" parameterType="int" resultType="com.symantec.ps.purejdbc.bean.UserBean">
		select * from kyly_user where id = #{id}
	</select>
</mapper>

五 userbean類定義

package com.symantec.ps.purejdbc.bean;

import java.util.Date;

public class UserBean{
	public UserBean(){
		
	}
	private int id;
	private String username;
	private String password;
	private int roleId;
	private String sex;
	private String emailaddress;
	private String telephone;
	private String firstname;
	private String familyname;
	private Date registtime;
	
	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;
	}
	public int getRoleId() {
		return roleId;
	}
	public void setRoleId(int roleId) {
		this.roleId = roleId;
	}
	public String getSex() {
		return sex;
	}
	public void setSex(String sex) {
		this.sex = sex;
	}
	public String getEmailaddress() {
		return emailaddress;
	}
	public void setEmailaddress(String emailaddress) {
		this.emailaddress = emailaddress;
	}
	public String getTelephone() {
		return telephone;
	}
	public void setTelephone(String telephone) {
		this.telephone = telephone;
	}
	public String getFirstname() {
		return firstname;
	}
	public void setFirstname(String firstname) {
		this.firstname = firstname;
	}
	public String getFamilyname() {
		return familyname;
	}
	public void setFamilyname(String familyname) {
		this.familyname = familyname;
	}
	public Date getRegisttime() {
		return registtime;
	}
	public void setRegisttime(Date registtime) {
		this.registtime = registtime;
	}
	
}

六 查詢測試

package com.symantec.ps;

import java.io.FileInputStream;
import java.io.InputStream;

import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;

import com.symantec.ps.purejdbc.bean.UserBean;

public class Client {
	public static void main(String[] args) {
		String configPath = "etc/mybatis-config.xml";
		InputStream inputStream; 
		SqlSession session = null;
		try {
			inputStream = new FileInputStream(configPath);//Resources.getResourceAsStream(configPath);
			SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
			session = sqlSessionFactory.openSession();
		} catch (Exception e) {
			System.out.println(e.getMessage());
		}
		
		UserBean user = session.selectOne("selectUser",1);
		System.out.println(user.getEmailaddress());
		session.close();
		
	}

}