通过本文主要向大家介绍了mybatis配置文件详解,mybatis映射文件详解,mybatis注解详解,mybatis详解,mybatis配置详解等相关知识,希望对您有所帮助,也希望大家支持linkedu.com www.linkedu.com
废话不多说了,先给大家分享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>
</div>
下面看下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>
</div>
好了,代码到此结束,希望对大家有所帮助。
</div>
