Mybatis的基本应用(二)

wolong

　　src下的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>
<!-- 读取jdbc.properties 文件 -->
<properties resource="jdbc.properties" />
<!-- 取别名 -->
<typeAliases>
<typeAlias type="com.aowin.model.Demo" alias="Demo" />
</typeAliases>
<!-- 配置数据库连接信息 -->
<!-- 告诉mybatis用development环境-->
<environments default="development">
<!-- 开发环境 -->
<environment id="development">
<transactionManager type="JDBC" />
<dataSource type="POOLED">
<property name="driver" value="${jdbc.driver}" />
<property name="url" value="${jdbc.url}" />
<property name="username" value="${jdbc.username}" />
<property name="password" value="${jdbc.password}" />
</dataSource>
</environment>
</environments>
<!-- 加入映射文件 -->
<mappers>
<mapper resource="com/aowin/model/demo.xml"/>
</mappers>
</configuration>


　　model

package com.aowin.model;
public class Demo {
private int id;
private String content;
private String title;
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getContent() {
return content;
}
public void setContent(String content) {
this.content = content;
}
public String getTitle() {
return title;
}
public void setTitle(String title) {
this.title = title;
}
}

　　配置文件：demo.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">
<!-- 对model类进行映射
namespace:命名空间
-->
<mapper namespace="name_space">
<resultMap type="Demo" id="userResultMap">
<!-- 数据表和model类属性一一对应 -->
<result column="id" property="id" javaType="int" />
<result column="content" property="content" javaType="string" />
<result column="title" property="title" javaType="string" />
</resultMap>
<sql id="AllColumn">
id,content,title
</sql>
<!-- 声明sql片段 -->
<sql id="allColumnsWithoutId">
content,title
</sql>
<select id="selectAllDemos" resultMap="userResultMap">
select <include refid="AllColumn"/>  from demo
</select>
<!-- 参数ID 可以任意取名 -->
<select id="selectDemoById" resultMap="userResultMap" parameterType="int">
select <include refid="AllColumn"/> from demo where id = #{id}
</select>

<!-- 传递多个参数-->
<select id="selectDemoBytilteAndContent" resultMap="userResultMap" parameterType="Demo">
select <include refid="AllColumn"/> from demo
where content = #{content} and title = #{title}
</select>
<insert id="insertOneDemo" parameterType="Demo">
insert into  demo (<include refid="allColumnsWithoutId"/>)  values (#{content},#{title})
</insert>

<!-- 更新demo -->
<update id="updateDemo" parameterType="Demo">
update demo set content=#{content}
where id= #{id}
</update>
<!-- 删除一条demo记录 -->
<delete id="deleteDemoById" parameterType="int">
delete from demo where id = #{id}
</delete>
<select id="selectif" parameterType="Demo" resultMap="userResultMap">
select <include refid="allColumnsWithoutId"/> from demo
where '1' = '1'
<if test="content !=null">
and content = #{content}
</if>
<if test="title !=null">
and title = #{title}
</if>
</select>

<select id="selectchoose" parameterType="Demo" resultMap="userResultMap">
select * from demo
where '1'='1'
<choose>
<when test="content !=null">
and content = #{content}
</when>
<when test="title != null">
and title = #{title}
</when>
<otherwise />
</choose>
</select>
<select id="">
<foreach collection="list" item="ids"
open="(" separator="," close=")"
>
</foreach>
</select>
<!--foreach:遍历传进来的list 以开头 以 分割 以结束  -->
<select id="selectlist" resultMap="userResultMap">
select * from demo where id in
<foreach collection="list" item="demoIds" open="(" separator="," close=")">
#{demoIds}
</foreach>
</select>



</mapper>
　　Test类：

package com.aowin.dao;
import java.util.ArrayList;
import java.util.List;
import org.apache.ibatis.session.SqlSession;
import com.aowin.model.Demo;
import com.aowin.util.DBUtil;
/**
* MyBatis:把SQL单独写到配置文件中
*         简化JDBC操作
* @author jie.guo(mozzz.iyunv.com)
*/
public class DemoDAO {
public static void main(String[] args) {
//SqlSession session = DBUtil.getSqlSession();
//
//Demo demo = new Demo();
//demo.setContent("yy");
//demo.setTitle("yy");
//List<Demo> demos = session.selectList("name_space.selectif", demo);
//for(Demo d : demos){
//System.out.println(d.getContent());
//}
//
//session.commit();
//session.close();
//SqlSession sqlSession = DBUtil.getSqlSession();
//Demo d = new Demo();
//d.setContent("zzzzz");
//d.setTitle("zz");
//List<Demo> demos = sqlSession.selectList("name_space.selectchoose",d);
//for(Demo demo : demos){
//System.out.println(demo.getTitle());
//}

SqlSession session = DBUtil.getSqlSession();
List<Integer> demoIds = new ArrayList<Integer>();
demoIds.add(26);
demoIds.add(27);
demoIds.add(28);
List<Demo> demos = session.selectList("name_space.selectlist",demoIds);
for(Demo demo :demos){
System.out.println(demo.getContent());
}
}
}