mybatis基本实例详解
程序员文章站
2024-03-02 18:10:16
废话不多说了，先给大家分享mybatis基本实例代码，具体代码如下所示：
废话不多说了，先给大家分享mybatis基本实例代码，具体代码如下所示：
<configuration>
<properties resource="db.properties">
<property name="" value=""/>
</properties>
<!-- 起别名 -->
<typealiases>
<package name="com.my.mybatis.beans"/> <!-- 别名为:类名 -->
<package name="com.my.mybatis.xml"/>
<!--
<typealias type="com.my.mybatis.xml.user" alias="_user"/>
-->
</typealiases>
<environments default="development">
<environment id="development">
<transactionmanager type="jdbc" />
<datasource type="pooled">
<property name="driver" value="com.mysql.jdbc.driver" />
<property name="url" value="jdbc:mysql://localhost:3306/mybatis" />
<property name="username" value="root" />
<property name="password" value="tiger" />
</datasource>
</environment>
</environments>
<mappers>
<mapper resource="com/my/mybatis/usermapper.xml"></mapper>
<mapper resource="com/my/mybatis/xml/testuserxml.xml"/>
<mapper class="com.my.mybatis.xml.usermapper"/>
<mapper resource="com/my/mybatis/one2one/one2one.xml"/>
<mapper resource="com/my/mybatis/one2many/one2many.xml"/>
<mapper resource="com/my/mybatis/jstllike/jstl.xml"/>
<mapper resource="com/my/mybatis/procedure/store.xml"/>
</mappers>
</configuration>
下面看下mybatis *模糊查询
<select id="getlike" parametertype="conditionuser" resulttype="user">
select * from d_user where
<if test="name != null">
<!-- 如下格式 -->
name like '%' #{name} '%' and
</if>
age between #{minage} and #{maxage}
</select>
好了，代码到此结束，希望对大家有所帮助。