MyBatis

<?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="db.properties"></properties>
    <!-- 配置别名;推荐使用package包形式来配置别名;包的形式会扫描主包及子包中所有文件;以对象类名为别名,大小写不限,推荐使用小写 -->
    <typeAliases>
        <!-- <typeAlias type="com.sikiedu.beans.User" alias="user" /> -->
        <package name="com.sikiedu.beans" />
    </typeAliases>
    <!-- 配置mybatis运行环境 ; 在集成Spring是不用 -->
    <environments default="development">
        <environment id="development">
            <!-- 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>
        <!-- 单个配置 -->
        <!-- <mapper resource="com/sikiedu/mapper/UserMapper.xml" /> -->
        <!-- <mapper url="file:\D:JavaWorkSpaceJavaEE_SSM_Testssm_mybatissrccomsikiedumapperUserMapper.xml" /> -->
        <!-- <mapper class="com.sikiedu.mapper.UserMapper" /> -->
        <!-- 多配置-以包的形式;推荐使用 -->
        <package name="com.sikiedu.mapper" />
    </mappers>
</configuration>

 1 package com.sikiedu.beans;
 2 
 3 public class Role {
 4 
 5     private Integer id;
 6     private String name;
 7     private Integer level;
 8     private String roletype;
 9     private Integer userid;
10 
11     public Integer getId() {
12         return id;
13     }
14 
15     public void setId(Integer id) {
16         this.id = id;
17     }
18 
19     public String getName() {
20         return name;
21     }
22 
23     public void setName(String name) {
24         this.name = name;
25     }
26 
27     public Integer getLevel() {
28         return level;
29     }
30 
31     public void setLevel(Integer level) {
32         this.level = level;
33     }
34 
35     public String getRoletype() {
36         return roletype;
37     }
38 
39     public void setRoletype(String roletype) {
40         this.roletype = roletype;
41     }
42 
43     public Integer getUserid() {
44         return userid;
45     }
46 
47     public void setUserid(Integer userid) {
48         this.userid = userid;
49     }
50 
51     @Override
52     public String toString() {
53         return "Role [
54                 + userid + "]";
55     }
56 
57 }