Mybatis简单配置

全局配置文件

<?xml version="1.0" encoding="UTF-8"?>

<!-- 引入数据源的配置文件 resource指定文件的位置-->
<properties resource="mybatis/db.properties"></properties>

<!-- 设置别名 type类的全路径 alias别名-->
<typeAliases>
    <typeAlias type="com.ssm.singletest.mbt.common.entity.Users" alias="Users"/>
</typeAliases>

<!--配置开发环境 default用来设置默认的开发环境 可以包含很多的environment-->
<environments default="test">
    <!-- 测试环境 -->
    <environment id="test">
        <!-- mybatis的事务交给jdbc来管理 -->
        <transactionManager type="jdbc"></transactionManager>
        <!-- 配置数据源（连接池），池化的 -->
        <dataSource type="pooled">
            <property name="driver" value="${driverClass}"/>
            <property name="url" value="${jdbcUrl}"/>
            <property name="username" value="${user}"/>
            <property name="password" value="${password}"/>
        </dataSource>
    </environment>
    <!-- 开发环境-->
    <environment id="dev">
        <transactionManager type="jdbc"></transactionManager>
        <dataSource type="pooled">
            <property name="driver" value="${driverClass}"/>
            <property name="url" value="${jdbcUrl}"/>
            <property name="username" value="${user}"/>
            <property name="password" value="${password}"/>
        </dataSource>
    </environment>
</environments>

<!-- 引入映射文件 -->
<mappers>
    <!-- 引入UserMapper.xml	resource指定文件的位置，右键。copy qua...name -->
    <mapper resource="mybatis/mapper/UserMapper.xml"/>
</mappers>

映射文件配置

<?xml version="1.0" encoding="UTF-8"?>

<select id="getUserById" resultType="com.xiefeng.ssm.singletest.mbt.common.entity.Users">
    select id, username, passwd, create_time as createTime from users where id = #{id}
</select>
<select id="findAll" resultType="com.xiefeng.ssm.singletest.mbt.common.entity.Users">
    select id, username, passwd, create_time as createTime from users
</select>

<insert id="insertOne">
    insert into users (username, passwd, create_time) values (#{username}, #{passwd}, now())
</insert>

<update id="updateOne">
    update users set username = #{username} where id = #{id}
</update>

<delete id="deleteOne">
    delete from users where id = #{id}
</delete>

Java代码

public class FirstTest {

private SqlSessionFactory ssf;

@Before
public void init() {
    try {
        InputStream in = Resources.getResourceAsStream("mybatis/sqlMapConfig.xml"); // 类路径下
        ssf = new SqlSessionFactoryBuilder().build(in);
    } catch (IOException e) {
        e.printStackTrace();
    }
}

@Test
public void test(){
    SqlSession session = ssf.openSession();
    System.out.println(session);
    Users users = session.selectOne("com.ssm.singletest.mbt.common.mapper.UserMapper.getUserById", 1);
    System.out.println(users);
    session.close();
}

@Test
public void testSelectAll(){
    SqlSession session = ssf.openSession();
    List<Users> users = session.selectList("userfirst.findAll");
    for (Users user : users) {
        System.out.println(user);
    }
    session.close();
}

@Test
public void testInsert(){
    SqlSession session = ssf.openSession();
    Users users = new Users();
    users.setUsername("xiey6");
    users.setPasswd("xiexie");
    session.insert("com.ssm.singletest.mbt.common.mapper.UserMapper.insertOne", users);
    session.commit();
    session.close();
}

@Test
public void testUpdate(){
    SqlSession session = ssf.openSession();
    Users users = new Users();
    users.setUsername("mother");
    users.setId(6L);
    session.update("com.ssm.singletest.mbt.common.mapper.UserMapper.updateOne", users);
    session.commit();
    session.close();
}

@Test
public void testDelete(){
    SqlSession session = ssf.openSession();
    Long id = 8L;
    session.delete("com.ssm.singletest.mbt.common.mapper.UserMapper.deleteOne", id);
    session.commit();
    session.close();
}

}

数据库配置文件

driverClass=com.mysql.jdbc.Driver
jdbcUrl=jdbc:mysql://192.168.29.130:3306/ssm
user=root
password=root