iBatis select

一、修改 Employee.xml文件

为了从数据库表里查询出数据，我们使用<select>标签。

<?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="Employee">
	
	<insert id="insert" parameterClass="model.Employee">
		
		insert into Employee (name,gender,salary)
		values (#name#,#gender#,#salary#)
		
		<selectKey resultClass="int" keyProperty="id">
			select last_insert_id() as id
		</selectKey>
	</insert>
	
	<select id="select*" resultClass="model.Employee" parameterClass="int">
		select * from Employee where id = #id#
	</select>

</sqlMap>

二、java测试程序

public static void main(String[] args) throws IOException, SQLException{
		Reader reader = Resources.getResourceAsReader("SqlMapConfig.xml");
		SqlMapClient sqlMapClient = SqlMapClientBuilder.buildSqlMapClient(reader);
		
		
		//select--------------------------------------------------
		
		System.out.println("ready to select...");
		
		@SuppressWarnings("unchecked")
		List<Employee> employees = sqlMapClient.queryForList("Employee.select*",Employee.class);
		
		System.out.println("finish select...");
}