配置方法和步骤

1. 打开MyEclipse或者Eclipse，新建一个JavaProject项目mybatis

2. 准备所需jar包（mybatis-3.2.2.jar，oscarJDBC.jar），右键点击项目依次选择New--Folder，此时弹出对话 框，Folder name填写lib。复制jar包粘贴到lib文件夹，展开lib文件夹，选中2个jar包，右键点击jar包，依次选择Build Path--Add to Path。

3. 在mybatis项目下创建cn.st.mybatis.domain、cn.st.mybatis.mapper、cn.st.mybatis.test

4. 在cn.st.mybatis.domain包下创建实体类User，用于映射数据库中数据，代码如下：

//create table users(userId INT primary key,userName varchar(50),userPassword varchar(50),userBal INT default 0);
//insert into test values(1,'test','123',0);
package cn.st.mybatis.domain;

public class User {
        private Integer userId;
        private String userName;
        private String userPassword;
        private Integer userBal;
  public int getUserId() {
        return userId;
    }

    public void setUserId(int userId) {
        this.userId = userId;
    }

    public String getUserName() {
        return userName;
    }

    public void setUserName(String userName) {
        this.userName = userName;
    }

    public String getUserPassword() {
        return userPassword;
    }

    public void setUserPassword(String userPassword) {
        this.userPassword = userPassword;
    }

    public float getUserBal() {
        return userBal;
    }

    public void wetUserBal(int userBal) {
        this.userBal = userBal;
    }

    @Override
    public String toString() {
        return "User [userId=" + userId + ", userName=" + userName + ", userPassword="
    + userPassword+ ",userBal=" + userBal + "]";
    }
}

5. 在cn.st.mybatis.mapper包下定义数据访问接口UserMapper，通过该接口的方法来操作数据，与神通数据库进行交互。代码如下：

package cn.st.mybatis.mapper;

                import cn.st.mybatis.domain.User;

                public interface UserMapper {
                        public User selectUser(int userId);

                        public void insertUser(User user);

                        public void updateUser(User user);

                        public void deleteUser(int userId);

                }

6. 在与UserMapper.java相同路径下创建配置文件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="cn.st.mybatis.mapper.UserMapper">

    <resultMap type="User" id="User">
        <result property="userId" column="userId" />
        <result property="userPassword" column="userPassword" />
        <result property="userBal" column="userBal" />
    </resultMap>

    <select id="selectUser" parameterType="int"
        resultType="User">
        select * from sysdba.users where userId = #{userId}
    </select>

    <insert id="insertUser" parameterType="cn.st.mybatis.domain.User">
        insert into users(userName,userPassword,userBal)
        values (#{userName},#{userpassword},#{userBal})
    </insert>

     <update id="updateUser" parameterType="cn.st.mybatis.domain.User">
        update users set userName=#{userName},userPassword=#{userPassword},
        userBal=#{userBal} where userId=#{userId}
    </update>

     <delete id="deleteUser" parameterType="int">
        delete from users where UserId=#{userId}
    </delete>

</mapper>

7. Src目录下创建 mybatis配置文件Configuration.xml，配置与数据库链接的相关参数，并注册mapper，和给类起别名。代码如下：

<?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>
          <typeAliases>
              <typeAlias type="cn.st.mybatis.domain.User" alias="User"/>
         </typeAliases>
        <environments default="development">
            <environment id="development">
               <transactionManager type="JDBC" />
               <dataSource type="POOLED">
                   <property name="driver" value="com.oscar.Driver"/>
                   <property name="url" value="jdbc:oscar://192.168.1.13/osrdb"/>
                   <property name="username" value="SYSDBA"/>
                   <property name="password" value="szoscar55"/>
                </dataSource>
           </environment>
        </environments>
         <mappers>
              <mapper resource="cn/st/mybatis/mapper/UserMapper.xml"/>
         </mappers>
  </configuration>