Ibatis 基础知识学习

<?xml version="1.0" encoding="UTF-8" ?>

<!DOCTYPE sqlMap      
    PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN"      
    "http://ibatis.apache.org/dtd/sql-map-2.dtd">

<sqlMap namespace="Account">

	<!-- no mapping -->
	<select id="queryUser" resultClass="com.xixi.ibatis.User"
		parameterClass="string">
		SELECT * FROM tb_user WHERE name = #name#
	</select>

	<!--  内联映射 MAP类 -->
	<select id="queryUser01" resultClass="hashmap"
		parameterClass="int">
		SELECT name, password FROM tb_user WHERE id = #id#
	</select>

	<!-- 内联映射 实体类 -->
	<select id="queryUser02" parameterClass="string"
		resultClass="com.xixi.ibatis.User">
		SELECT Id id, name name, password password FROM tb_user WHERE
		name like '%$name$%'
	</select>

	<!-- 显示映射 实体类 -->
	<resultMap class="com.xixi.ibatis.User" id="UserResult">
		<result property="id" column="Id"/>
		<result property="name" column="name"/>
		<result property="password" column="password"/>
	</resultMap>

	<select id="queryUser03" resultMap="UserResult" parameterClass="int">
		SELECT * FROM tb_user WHERE id = #id#
	</select>

	<!-- 显示映射 Map -->
	<resultMap class="hashmap" id="mapResult">
		<result property="id" column="Id"/>
		<result property="name" column="name"/>
		<result property="password" column="password"/>
	</resultMap>

	<select id="queryMap02" parameterClass="int" resultMap="mapResult">
		SELECT * FROM tb_user WHERE id = #id#
	</select>

	<!-- XML -->
	<select id="queryXML" parameterClass="int" resultClass="xml">
		SELECT * FROM tb_user WHERE id = #id#
	</select>

	<!-- 自动映射 -->
	<insert id="insertUser01" parameterClass="com.xixi.ibatis.User">
		INSERT INTO tb_user 
		(
			name, password
		)VALUES(
			 #name:VARCHAR#,
		 #password:VARCHAR#
		)
	</insert>

	<!-- 内联映射 -->
	<insert id="insertUser02" parameterClass="com.xixi.ibatis.User">
		INSERT INTO tb_user
		(
			name, password
		)VALUES(
		 #name:VARCHAR#,
		 #password:VARCHAR#
		)
	</insert>

	<!-- 外联映射 -->
	<parameterMap class="com.xixi.ibatis.User" id="usermap">
		<parameter property="name" jdbcType="VARCHAR"/>
		<parameter property="password" jdbcType="VARCHAR"/>
	</parameterMap>

	<insert id="insertUser03" parameterMap="usermap">
		INSERT INTO tb_user(
			name, password
		)VALUES(
			?,?
		)
	</insert>

	<insert id="insertUser04" parameterClass="com.xixi.ibatis.User">
		INSERT INTO tb_user(
			id, name, password
		)VALUES(
			#id#,
			#name#,
			#password#
		)

		<!-- 这是Mysql的用法  -->
		<selectKey keyProperty="id" resultClass="int">
			SELECT LAST_INSERT_ID() 
		</selectKey>
	</insert>

<!-- 调用存储过程 -->
	<parameterMap class="java.util.Map" id="pro">
		<parameter property="name" jdbcType="VARCHAR" javaType="string" mode="IN"/>
	</parameterMap>
	<procedure id="p1" parameterMap="pro">
		{call first(?)}
	</procedure>

</sqlMap>

public void testSelect(){
		Reader reader = null ;
		try {
			reader = Resources.getResourceAsReader("SqlMapConfig.xml");
			SqlMapClient sqlmap = SqlMapClientBuilder.buildSqlMapClient(reader);

			List<User> list = sqlmap.queryForList("queryUser", "xixi");

			System.out.println(list.get(0).getName());
		} catch (IOException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
public void testSelect02(){
		Reader reader = null ;
		try {
			reader = Resources.getResourceAsReader("SqlMapConfig.xml");
			SqlMapClient sqlmap = SqlMapClientBuilder.buildSqlMapClient(reader);
			List<User> list = sqlmap.queryForList("queryUser02", "x");

			for (User user : list) {
				System.out.println(user.getName());
			}
		} catch (IOException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}

	public void testSelect03(){
		Reader reader = null ;
		try {
			reader = Resources.getResourceAsReader("SqlMapConfig.xml");
			SqlMapClient sqlmap = SqlMapClientBuilder.buildSqlMapClient(reader);

			User user = (User)sqlmap.queryForObject("queryUser03", 1);

			System.out.println(user.getName()+"----"+user.getPassword());
		} catch (IOException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}

	public void testSelect04(){
		Reader reader = null ;
		try {
			reader = Resources.getResourceAsReader("SqlMapConfig.xml");
			SqlMapClient sqlmap = SqlMapClientBuilder.buildSqlMapClient(reader);

			Map user = (Map)sqlmap.queryForObject("queryMap02", 2);

			System.out.println(user.get("id")+"-------"+user.get("name"));
		} catch (IOException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}

	public void testSelect05(){
		Reader reader = null ;
		try {
			reader = Resources.getResourceAsReader("SqlMapConfig.xml");
			SqlMapClient sqlmap = SqlMapClientBuilder.buildSqlMapClient(reader);

			Object user = sqlmap.queryForObject("queryXML", 2);

			System.out.println(user);
		} catch (IOException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}

	public void testInsert(){
		Reader reader = null;
		try {
			reader = Resources.getResourceAsReader("SqlMapConfig.xml");
			SqlMapClient sqlmap = SqlMapClientBuilder.buildSqlMapClient(reader);

			User user = new User();
			user.setName(" 张三2丰");
			user.setPassword("4569852");

			sqlmap.insert("insertUser01", user);

		} catch (IOException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}

	public void testInsert02(){
		Reader reader = null;
		try {
			reader = Resources.getResourceAsReader("SqlMapConfig.xml");
			SqlMapClient sqlmap = SqlMapClientBuilder.buildSqlMapClient(reader);

			User user = new User();
			user.setName(" 张四丰");
			user.setPassword("4569852");

			sqlmap.insert("insertUser02", user);

		} catch (IOException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}

	public void testInsert03(){
		Reader reader = null;
		try {
			reader = Resources.getResourceAsReader("SqlMapConfig.xml");
			SqlMapClient sqlmap = SqlMapClientBuilder.buildSqlMapClient(reader);

			User user = new User();
			user.setName(" 张无丰555");
			user.setPassword("4569852");

			Integer id = (Integer) sqlmap.insert("insertUser03", user);
			System.out.println(id+"-----------");

		} catch (IOException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}

	public void testInsert04(){
		Reader reader = null;
		try {
			reader = Resources.getResourceAsReader("SqlMapConfig.xml");
			SqlMapClient sqlmap = SqlMapClientBuilder.buildSqlMapClient(reader);

			User user = new User();
			user.setName(" 张无丰666");
			user.setPassword("4569852");

			Integer id = (Integer) sqlmap.insert("insertUser04", user);
			System.out.println(id+"-----------");

		} catch (IOException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
//调用存储过程
	public void testInsert05(){
		Reader reader = null;
		try {
			reader = Resources.getResourceAsReader("SqlMapConfig.xml");
			SqlMapClient sqlmap = SqlMapClientBuilder.buildSqlMapClient(reader);

			Map<String, String> m = new HashMap<String, String>();
			m.put("name", "xxxxxxxxxxxx");

			sqlmap.update("p1", m);
			System.out.println("-----------");

		} catch (IOException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}