Mybatis配置

最新推荐文章于 2025-12-05 17:02:52 发布

原创最新推荐文章于 2025-12-05 17:02:52 发布 · 81 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#mybatis #java #intellij-idea

配置pom.xml

添加并且刷新配置装载

<dependency>
  <groupId>org.mybatis</groupId>
  <artifactId>mybatis</artifactId>
  <version>3.2.2</version>
</dependency>

resoures新建File 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>
    <properties resource="database.properties"></properties>
    
    <typeAliases>
        <package name="nj.zb.kb22.pojo"/>
    </typeAliases>
    <environments default="development">
        <environment id="development">
            <transactionManager type="JDBC"></transactionManager>
            <dataSource type="POOLED">
                <property name="driver" value="${driver}"/>
                <property name="url" value="${url}"/>
                <property name="username" value="${user}"/>
                <property name="password" value="${password}"/>
            </dataSource>
        </environment>
    </environments>
    <mappers>
        <mapper resource="nj/zb/kb22/dao/DogDao.xml"></mapper>
        <mapper resource="nj/zb/kb22/dao/MasterDao.xml"></mapper>
    </mappers>
</configuration>

resources添加nj/zb/kb22

新建DogDao.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="nj.zb.kb22.dao.IDogDao">
<select id="getDogList" resultType="Dog">
    select id,name,love,health,strain,datetime from dog
</select>
    <insert id="save">
        insert into dog(id,name,love,health,strain,datetime)
        values (null,#{name},#{love},#{health},#{strain},now())
    </insert>

    <update id="update">
        update dog set name=#{name},love=#{love},health=#{health},strain=#{strain},datetime=now() where id=#{id}
    </update>
</mapper>

新建MasterDao.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="nj.zb.kb22.dao.IMasterDao">
    <select id="getAllMaster" resultType="Master">
        select id,mastername,brithday,dogid,datetime from master
    </select>
    <insert id="save">
        insert into master(id,mastername,brithday,dogid,datetime)
        values (null,#{mastername},now(),#{dogid},now())
    </insert>
</mapper>