Mybatis的基本应用(二)

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.iteye.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());
		}
	}

}