mybatis使用实例

1.jdbc.properties

jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/housework
jdbc.username=root
jdbc.password=

2.编写mybatis核心配置文件 SqlMapConfig.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>

</configuration>

<?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="jdbc.properties"></properties>

    <typeAliases>
        <typeAlias type="第二类.domain.User" alias="user"></typeAlias>
        <typeAlias type="第二类.domain.Administrator" alias="administrator"></typeAlias>
    </typeAliases>

    <environments default="development">
        <environment id="development">
            <transactionManager type="JDBC"></transactionManager>
            <dataSource type="POOLED">
                <property name="driver" value="${jdbc.driver}"></property>
                <property name="url" value="${jdbc.url}"></property>
                <property name="username" value="${jdbc.username}"></property>
                <property name="password" value="${jdbc.password}"></property>
            </dataSource>
        </environment>
    </environments>

    <mappers>
        <mapper resource="mapper/UserMapper.xml"></mapper>
        <mapper resource="mapper/AdministratorMapper.xml"></mapper>
    </mappers>
</configuration>

3.映射文件 UserMapper.xml 和mapper包中接口的方法对应

<?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="">

</mapper>

<?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="第二类.mapper.UserMapper">
    <select id="findAll" resultType="user">
        select * from user
    </select>

    <select id="findUser" resultType="user" parameterType="user">
         select * from user
        <where>
            <if test="id!=null">
                and id=#{id}
            </if>
            <if test="NAME!=''">
                and NAME=#{NAME}
            </if>
            <if test="profession!=''">
                and profession=#{profession}
            </if>
        </where>
    </select>

    <insert id="findAdd" parameterType="user">
        insert into user set id=#{id},NAME=#{NAME},profession=#{profession}
    </insert>

    <delete id="SelectUser" parameterType="user">
        delete from user where id=#{id}
    </delete>
</mapper>

4.mapper包接口中的方法

public interface UserMapper {
    public List<User> findAll();

    public List<User> findUser(User user);

    public void findAdministrator(Administrator administrator);

    public void findAdd(User user);

    public void SelectUser(User user);
}

5.使用：

private InputStream resourceAsStream = Resources.getResourceAsStream("SqlMapConfig.xml");
private SqlSessionFactory sqlSessionFactory=new SqlSessionFactoryBuilder().build(resourceAsStream);
private SqlSession sqlSession = sqlSessionFactory.openSession();
private UserMapper mapper = sqlSession.getMapper(UserMapper.class);
//查询全部信息
List<User> list=mapper.findAll();
//添加一条信息
mapper.findAdd(user);