mybatis，初级入门

首先感谢：渐行渐远....那些错过的青春：http://www.cnblogs.com/liangxiaofeng/p/6371866.html

我的第一个mybatis项目，以前总是对mybatis有畏惧感，现在自己调试成功了一个，让mybatis从圣坛上降下来了。也让其他兄弟们尝尝鲜。

先来个项目目录图：

不讲mybatis原理，因为通过测试后，再去理解原理就很清楚了。最主要是，不能打断大家复制代码不是嘛，哈哈哈！

UserBean.java

package com.fei.mybatis.beans;

import java.io.Serializable;

public class UserBean implements Serializable {

	private static final long serialVersionUID = 1L;
	private Integer id;
	private String username;
	private String password;
	private Double account;
	
	public UserBean(){
		
	}
	
	public UserBean(String username,String password,Double account){
		super();
		this.username = username;
		this.password = password;
		this.account = account;
		
	}
	
	public UserBean(Integer id,String username,String password,Double account){
		super();
		this.id = id;
		this.username = username;
		this.password = password;
		this.account = account;
	}

	public Integer getId() {
		return id;
	}

	public void setId(Integer 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 Double getAccount() {
		return account;
	}

	public void setAccount(Double account) {
		this.account = account;
	}
	
	@Override
	public String toString() {
		
		return "UserBean ,id="+id+",username="+username+",password="+password+
				",account="+account;
	}
	
	
}

UserMapper.java

package com.fei.mybatis.mapper;

import java.util.List;

import com.fei.mybatis.beans.UserBean;

public interface UserMapper {
	
	//新增用户
	public int insertUser(UserBean user) throws Exception;
	
	//修改用户
	public int updateUser(UserBean user,int id) throws Exception;
	
	//删除用户
	public int deleteUser(int id) throws Exception;
	
	//根据id查询用户信息
	public UserBean selectUserById(int id) throws Exception;
	
	//查询所有用户的信息
	public List<UserBean> selectAllUser() throws Exception;
	
	
}

UserMapper.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org/DTD Mapper 3.0" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.fei.mybatis.mapper.UserMapper">
<!-- 自定义返回结果集 -->
   <resultMap id="userMap" type="UserBean">
        <id property="id" column="id" javaType="java.lang.Integer"></id>
        <result property="username" column="username" javaType="java.lang.String"></result>
        <result property="password" column="password" javaType="java.lang.String"></result>
        <result property="account" column="account" javaType="java.lang.Double"></result>
    </resultMap>
<!-- 在各种标签中的id属性必须和接口中的方法名相同 ， id属性值必须是唯一的，不能够重复使用。parameterType属性指明查询时使用的参数类型，resultType属性指明查询返回的结果集类型-->    
<!-- useGeneratedKeys：（ 仅 对 insert 有 用 ） 这 会 告 诉 MyBatis 使 用 JDBC 的getGeneratedKeys 
            方法来取出由数据（比如：像 MySQL 和 SQLServer 这样的数据库管理系统的自动递增字段）内部生成的主键。默认值： false。 -->    
<!--keyProperty： （仅对 insert有用）标记一个属性， MyBatis 会通过 getGeneratedKeys或者通过 insert 语句的 selectKey 子元素设置它的值。默认：不设置。 -->
<!--#{}中的内容，为占位符，当参数为某个JavaBean时，表示放置该Bean对象的属性值  -->


    <insert id="insertUser" useGeneratedKeys="true" keyProperty="id">
        insert into t_user (username,password,account) values (#{username},#{password},#{account})
    </insert>
    
    <update id="updateUser" >
      update t_user set username=#{username},password=#{password},account=#{account} where id=#{id}
    </update>
    
    <delete id="deleteUser" parameterType="int">
     delete from t_user where id=#{id}  
    </delete>
    
    <select id="selectUserById" parameterType="int" resultMap="userMap">
     select * from t_user where id=#{id}
    </select>
    
    <select id="selectAllUser" resultMap="userMap">
     select * from t_user
    </select>
    
    
</mapper>

UserService.java

package com.fei.mybatis.service;

import java.util.List;

import org.apache.ibatis.session.SqlSession;

import com.fei.mybatis.beans.UserBean;
import com.fei.mybatis.mapper.UserMapper;
import com.fei.mybatis.tools.DBTools;

public class UserService {
	static DBTools tool = new DBTools();
	
	public static void main(String[] args) {
		insertUser();
//		deleteUser();
//		selectUserById();
//		selectAllUser();
	}
	
	/**
	 * 新增用户
	 */
	private static void insertUser(){
		
		SqlSession session = tool.getSession();
		UserMapper mapper = session.getMapper(UserMapper.class);
		UserBean user = new UserBean("tom","110",2222.0); 
		try {
			mapper.insertUser(user);
			System.out.println(user.toString());
			session.commit();
		} catch (Exception e) {

			e.printStackTrace();
			session.rollback();
		}
	}
	
	/**
	 *  删除用户
	 */
	private static void deleteUser(){
		SqlSession session = tool.getSession();
		UserMapper mapper = session.getMapper(UserMapper.class);
		try {
			mapper.deleteUser(1);
			session.commit();
		} catch (Exception e) {
			e.printStackTrace();
			session.rollback();
		}
	}
	
	/**
	 * 根据id查询用户
	 */
	private static void selectUserById(){
		SqlSession session = tool.getSession();
		UserMapper mapper = session.getMapper(UserMapper.class);
		try {
			UserBean user = mapper.selectUserById(2);
			System.out.println(user.toString());
			session.commit();
		} catch (Exception e) {
			// TODO: handle exception
			e.printStackTrace();
			session.rollback();
		}
	}
	
	/**
	 * 查询所有的用户
	 */
	private static void selectAllUser(){
		SqlSession session = tool.getSession();
		UserMapper mapper = session.getMapper(UserMapper.class);
		try {
			List<UserBean> user = mapper.selectAllUser();
			System.out.println(user.toString());
			session.commit();
		} catch (Exception e) {
			e.printStackTrace();
			session.rollback();
		}
	}
	

}

DBTools.java

package com.fei.mybatis.tools;

import java.io.Reader;
import java.sql.Connection;

import javax.annotation.Resource;

import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.Configuration;
import org.apache.ibatis.session.ExecutorType;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
import org.apache.ibatis.session.TransactionIsolationLevel;

public class DBTools {
	
	public static SqlSessionFactory sessionFactory = new SqlSessionFactory() {
		
		@Override
		public SqlSession openSession(ExecutorType arg0, Connection arg1) {
			// TODO Auto-generated method stub
			return null;
		}
		
		@Override
		public SqlSession openSession(ExecutorType arg0, TransactionIsolationLevel arg1) {
			// TODO Auto-generated method stub
			return null;
		}
		
		@Override
		public SqlSession openSession(ExecutorType arg0, boolean arg1) {
			// TODO Auto-generated method stub
			return null;
		}
		
		@Override
		public SqlSession openSession(ExecutorType arg0) {
			// TODO Auto-generated method stub
			return null;
		}
		
		@Override
		public SqlSession openSession(TransactionIsolationLevel arg0) {
			// TODO Auto-generated method stub
			return null;
		}
		
		@Override
		public SqlSession openSession(Connection arg0) {
			// TODO Auto-generated method stub
			return null;
		}
		
		@Override
		public SqlSession openSession(boolean arg0) {
			// TODO Auto-generated method stub
			return null;
		}
		
		@Override
		public SqlSession openSession() {
			// TODO Auto-generated method stub
			return null;
		}
		
		@Override
		public Configuration getConfiguration() {
			// TODO Auto-generated method stub
			return null;
		}
	};
	
	static{
		try {
			//使用Mybatis提供的Resource类加载mybatis的配置文件
			Reader reader = Resources.getResourceAsReader("mybatis.cfg.xml");
			//构建sqlSession的工厂
			sessionFactory = new SqlSessionFactoryBuilder().build(reader);
		} catch (Exception e) {
			
		}
	}
	
	//创建能执行映射文件中的sqlSession
	public static SqlSession getSession(){
		return sessionFactory.openSession();
	}
	
}

log4j.properties

是空的

mybatis.cfg.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>

  <!-- 引入外部配置文件 -->
  <properties resource="mysql.properties"></properties>
  
  
   <!-- 为JAVA Bean起类别名 -->
   <typeAliases >
        <!-- 别名方式1，一个一个的配置 type中放置的是类的全路径，alias中放置的是类别名
        <typeAliase type="com.fei.mybatis.beans.UserBean" alias="UserBean"/> -->
        <!-- 别名方式2，自动扫描，将JAVA类的类名作为类的类别名 -->
        <package name="com.fei.mybatis.beans"/>
   </typeAliases>
   
   
   <!-- 配置mybatis运行环境 -->
     <environments default="cybatis">
        <environment id="cybatis">
            <!-- type="JDBC" 代表使用JDBC的提交和回滚来管理事务 -->
            <transactionManager type="JDBC" />
            
            <!-- mybatis提供了3种数据源类型，分别是：POOLED,UNPOOLED,JNDI -->
            <!-- POOLED 表示支持JDBC数据源连接池 -->
            <!-- UNPOOLED 表示不支持数据源连接池 -->
            <!-- JNDI 表示支持外部数据源连接池 -->
            <dataSource type="POOLED">
                <property name="driver" value="${jdbc.driver}" />
                <property name="url" value="${jdbc.url}" />
                <property name="username" value="${jdbc.username}" />
                <property name="password" value="${jdbc.password}" />
            </dataSource>
        </environment>
    </environments> 
    
    
    <mappers>
        <!-- 告知映射文件方式1，一个一个的配置
        <mapper resource="com/cy/mybatis/mapper/UserMapper.xml"/>-->
        <!-- 告知映射文件方式2，自动扫描包内的Mapper接口与配置文件 -->
        <package name="com/fei/mybatis/mapper"/>
    </mappers>
</configuration>

mysql.properties

jdbc.driver=com.microsoft.sqlserver.jdbc.SQLServerDriver
jdbc.url=jdbc:sqlserver://localhost:1433;DatabaseName=mybatis
jdbc.username=sa
jdbc.password=写自己的密码

这样就完工了，运行UserService.java,run  as ，run application，就可以看到结果：

！！！！！！！！！！！！！！！！！！！！！！！！完工了！！！！！！！！！！！！！！！！！！！！！！！！！！！！！！！！！！！