废话不多说了，先给大家分享mybatis基本实例代码，具体代码如下所示：
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
|
<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 *模糊查询
|
1
2
3
4
5
6
7
8
|
<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>
|
好了，代码到此结束，希望对大家有所帮助。