MyBatis 基础笔记

来源：互联网发布：空气污染物浓度数据编辑：程序博客网时间：2024/06/05 05:35

需要的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 MYUSERWHERE 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();}}}

响应流程：

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

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

嗯，收工~