mybatis

mybatis 

mapper

 

Xml代码 

1. <?xml version="1.0" encoding="UTF-8"?>  
2. <!DOCTYPE mapper  
3.   PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"  
4.   "http://mybatis.org/dtd/mybatis-3-mapper.dtd">  
5. <mapper namespace="com.dao.mapper.UserMapper">  
6.     <select id="findAll" resultType="User">  
7.         select * from user  
8.     </select>  
9.     <select id="findAllByUser" resultType="User">  
10.         select * from user  
11.         <where>  
12.             <if test="id!=null">  
13.                 and id=#{id}  
14.             </if>  
15.             <if test="name!=null">  
16.                 and name=#{name}  
17.             </if>  
18.             <if test="password!=null">  
19.                 and password=#{password}  
20.             </if>  
21.         </where>  
22.     </select>  
23.     <select id="findById" parameterType="int" resultType="User">  
24.         select * from user where id=#{parameter}  
25.     </select>  
26.       
27.     <select id="userLogin" parameterType="User" resultType="map">  
28.         select * from user where name=#{username} and password=#{userpwd}  
29.     </select>  
30.       
31.     <select id="insert" parameterType="User">  
32.         insert into user(name,password) value(#{name},#{password})  
33.     </select>  
34.     <select id="update" parameterType="User">  
35.         update user   
36.         <set>  
37.             <if test="name!=null">  
38.                 name=#{name},  
39.             </if>  
40.             <if test="password!=null">  
41.                 password=#{password}  
42.             </if>  
43.         </set>     
44.             where id=#{id}  
45.     </select>  
46.       
47.     <select id="deleteUser" parameterType="int">  
48.         delete * from user where id=#{parameter}  
49.     </select>  
50. </mapper>  

 

 

mybatis 

config

 

Xml代码 

1. <?xml version="1.0" encoding="UTF-8"?>  
2.   <!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "http://mybatis.org/dtd/mybatis-3-config.dtd">  
3.  <configuration>  
4.     <typeAliases>  
5.         <typeAlias type="com.entity"/>  
6.         <!-- <package name="com.entity"/> -->  
7.     </typeAliases>  
8.      <!-- <environments default="development">  
9.           <environment id="development">  
10.               <transactionManager type="JDBC" />  
11.               <dataSource type="POOLED">  
12.                   <property name="driver" value="com.mysql.jdbc.Driver" />  
13.                  <property name="url" value="jdbc:mysql://localhost:3306/test" />  
14.                  <property name="username" value="root" />  
15.                  <property name="password" value="karen" />  
16.              </dataSource>  
17.          </environment>  
18.      </environments>   
19.      <mappers>  
20.         <mapper resource="com/dao/mapper/UserMapper.xml"/>  
21.      </mappers>   -->  
22.  </configuration>