MyBatis 基础笔记

需要的lib文件：

源代码：

         1.     新建Oracle数据表

CREATE TABLE MYUSER    
(    
    id       VARCHAR2(10) PRIMARY KEY,    
    pwd      VARCHAR2(10) NOT NULL,    
    NAME     VARCHAR2(15) NOT NULL,    
    birthday VARCHAR2(8) NOT NULL,    
    salary   NUMBER(10,2)    
);

         2.     在com.entity包下新建UserEntity.class

package com.entity;  
  
import java.io.Serializable;  
  
public class UserEntity implements Serializable{  
    private static final long serialVersionUID = -458045724375300041L;  
      
    private String userID;  
    private String userPWD;  
    private String userName;  
    private String userBirthday;  
    private String userSalary;  
      
      
    public String getUserID() {  
        return userID;  
    }  
    public void setUserID(String userID) {  
        this.userID = userID;  
    }  
    public String getUserPWD() {  
        return userPWD;  
    }  
    public void setUserPWD(String userPWD) {  
        this.userPWD = userPWD;  
    }  
    public String getUserName() {  
        return userName;  
    }  
    public void setUserName(String userName) {  
        this.userName = userName;  
    }  
    public String getUserBirthday() {  
        return userBirthday;  
    }  
    public void setUserBirthday(String userBirthday) {  
        this.userBirthday = userBirthday;  
    }  
    public String getUserSalary() {  
        return userSalary;  
    }  
    public void setUserSalary(String userSalary) {  
        this.userSalary = userSalary;  
    }  
}

         3.     在src下新建mybatis-config.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="oracle.jdbc.driver.OracleDriver" />
				<property name="url" value="jdbc:oracle:thin:@192.168.80.128:1521:ocp" />
				<property name="username" value="shenyang" />
				<property name="password" value="shenyang" />
			</dataSource>
		</environment>
	</environments>
	<mappers>
		<mapper resource="UserMapper.xml" />
	</mappers>
</configuration>

         4.     在src下新建UserMapper.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="suibian1">
	
	<resultMap type="com.entity.UserEntity" id="userResultMap">  
        <id property="userID" column="id"/>  
        <result property="userPWD" column="pwd"/>  
        <result property="userName" column="name"/>  
        <result property="userBirthday" column="birthday"/>
        <result property="userSalary" column="salary"/>
    </resultMap>
     
	<select id="getUser" parameterType="String" resultType="com.entity.UserEntity" resultMap="userResultMap">  
        <![CDATA[ 
            SELECT * FROM MYUSER
			WHERE ID =  #{userID}
        ]]>   
    </select>
    
    <insert id="insertUser" parameterType="com.entity.UserEntity">
            INSERT INTO MYUSER(ID,PWD,NAME,BIRTHDAY,SALARY)
             VALUES(
             	#{userID},
             	#{userPWD},
             	#{userName},
             	#{userBirthday},
             	#{userSalary}
             )
    </insert>

</mapper>

建立测试类：

package com.main;

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 com.entity.UserEntity;

public class Test {

	public static void main(String[] args) {

		SqlSessionFactory sqlSessionFactory = null;

		String resource = "mybatis-config.xml";
		Reader reader = null;
		try {
			reader = Resources.getResourceAsReader(resource);
		} catch (IOException e1) {
			e1.printStackTrace();
		}
		sqlSessionFactory = new SqlSessionFactoryBuilder().build(reader);
		SqlSession sqlSession = sqlSessionFactory.openSession();
		try {
			UserEntity user = (UserEntity) sqlSession.selectOne("suibian1.getUser", "1");
			System.out.println(user.getUserName());
			sqlSession.commit();// 这里一定要提交，不然数据进不去数据库中
		} catch (Exception e) {
			sqlSession.rollback();
			e.printStackTrace();
		} finally {
			sqlSession.close();
		}
	}
}

响应流程：

1. Test.class 第 22 行 加载mybatis-config.xml文件。
2. mybatis-config.xml文件 第 17 行加载UserMapper.xml文件。
3. Test.class 第 29 行的“suibian1.getUser”通过UserMapper.xml文件找到了，UserMapper.xml文件 第 14 行。
4. 执行该SQL语句。
   

源代码请到： 点击打开链接   下载

嗯，收工~