MyBatis基础实例

MyBatisAPI:http://www.mybatis.org/mybatis-3/zh/getting-started.html

项目结构：

1.导入mybatis-3.3.1.jar包

2.配置config.xml文件，负责数据源的配置、实体类别名、注册接口等，如下：

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE configuration SYSTEM "http://mybatis.org/dtd/mybatis-3-config.dtd" >
<configuration>
	<!-- 配置实体类User，起别名users -->
	<typeAliases>
		<typeAlias type="com.casv.model.User" alias="users" />
		<!-- 扫描实体类包，后续可以直接使用类名
		<package name="com.casv.model.User"/>
		-->
	</typeAliases>
	<!-- 配置数据源 -->
	<environments default="development">
		<environment id="development">
			<transactionManager type="JDBC"></transactionManager>
			<dataSource type="POOLED">
				<property name="driver" value="com.mysql.jdbc.Driver" />
				<property name="url" value="jdbc:mysql://localhost:3306/userdatabase" />
				<property name="username" value="root" />
				<property name="password" value="123456" />
			</dataSource>
		</environment>
	</environments>
	<mappers>
		<!-- 注册userMapper.xml -->
		<mapper resource="com/casv/dao/userMapper.xml"></mapper>
		<!-- 注册userServer接口 -->
		<mapper class="com.casv.impl.userServer"/>
	</mappers>
</configuration>

3.创建实体类Use.java

package com.casv.model;

public class User {
	
	private int uid;
	private String name;
	private String pwd;

	public int getUid() {
		return uid;
	}

	public void setUid(int uid) {
		this.uid = uid;
	}

	public String getName() {
		return name;
	}

	public void setName(String name) {
		this.name = name;
	}

	public String getPwd() {
		return pwd;
	}

	public void setPwd(String pwd) {
		this.pwd = pwd;
	}

}

4.创建userMapper.xml，进行dao操作

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper SYSTEM "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >
<!-- namespace:命名空间，对应dao接口 -->
<mapper namespace="com.casv.dao.userMapper">
	<!-- 配置resultMap属性，进行表字段与实体类属性映射 -->
	<resultMap id="BaseResultMap" type="users">
		<result column="u_id" property="uid"></result>
		<result column="u_name" property="name"></result>
		<result column="u_pwd" property="pwd"></result>
	</resultMap>
	<!--
	  parameterType:指定参数类型，可以是基本数据类型，也可以是对象; 
          resultType:指定返回结果类型，可以是基本数据类型，也可以是java容器及javabean;
	-->
	<select id="alluser" resultMap="BaseResultMap" resultType="users">
	    select * from t_user
	</select>
	<select id="getuserbyid" resultMap="BaseResultMap" parameterType="int" resultType="users">
	    select * from t_user where u_id=#{uid}
	</select>
	<insert id="adduser" parameterType="users">
	    insert into t_user(u_name,u_pwd) values(#{name},#{pwd})
	</insert>
	<delete id="deluser" parameterType="int">
	    delete from t_user where u_id=#{uid}
	</delete>
	<update id="uppuser" parameterType="users">
	     update t_user set u_name=#{name},u_pwd=#{pwd} where u_id=#{uid}
	</update>
</mapper>

5.创建MyBatisUtil.java工具类

package com.casv.util;

import java.io.IOException;
import java.io.InputStream;

import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;

public class MyBatisUtil {

	public static SqlSessionFactory getSessionFactory(){
		String resource="config.xml";
		SqlSessionFactory sessionfactory=null;
		try {
			InputStream inputStream = Resources.getResourceAsStream(resource);
			//InputStream inputStream=TestMybatis.class.getClassLoader().getResourceAsStream(resource);
			sessionfactory=new SqlSessionFactoryBuilder().build(inputStream);
			
		} catch (IOException e) {
			e.printStackTrace();
		}
		return sessionfactory;
	}
}

6.编写测试类TestMybatis.java

package com.casv.test;

import java.util.List;

import junit.framework.TestCase;

import org.apache.ibatis.session.SqlSession;

import com.casv.impl.userServer;
import com.casv.model.User;
import com.casv.util.MyBatisUtil;

public class TestMybaits extends TestCase {

	User user = new User();
	
	private SqlSession session;

	//全查询
	public void testAlluser() {
		session = MyBatisUtil.getSessionFactory().openSession();
		List<User> list = session.selectList("com.casv.dao.userMapper.alluser");
		session.close();
		for (User user : list) {
			System.out.println(user.getUid() + " " + user.getName());
		}
	}

	//根据id查询
	public void testgetuserbyID() {
        session=MyBatisUtil.getSessionFactory().openSession();
        user=session.selectOne("com.casv.dao.userMapper.getuserbyid", 1);
        System.out.println(user.getName());
	}

	//添加
	public void testAdduser() {
		user.setName("张三");
		user.setPwd("123456");
		session=MyBatisUtil.getSessionFactory().openSession();
		int count=session.insert("com.casv.dao.userMapper.adduser", user);
		if(count!=0){
			session.commit();
			session.close();
			System.out.println("添加成功");
		}else{
			System.out.println("添加失败");
		}
		
	}

	//删除
	public void testDelUser() {
        user.setUid(10);
        session=MyBatisUtil.getSessionFactory().openSession();
        int count=session.delete("com.casv.dao.userMapper.deluser",user);
        if(count!=0){
			session.commit();
			session.close();
			System.out.println("删除成功");
		}else{
			System.out.println("删除失败");
		}
	}

	//修改
	public void testUpdate() {
        user.setUid(10);
        user.setName("周润发");
        user.setPwd("123456");
        session=MyBatisUtil.getSessionFactory().openSession();
        int count=session.update("com.casv.dao.userMapper.uppuser", user);
        if(count!=0){
			session.commit();
			session.close();
			System.out.println("修改成功");
		}else{
			System.out.println("修改失败");
		}
	}


}