iBatis初步认识与使用

package com.wxc.bean;

public class BookInfo {
	private int id;
	private String bookISBN;
	private String bookName;
	private String author;
	private float price;
	private int typeId;
	private String publish;
	public int getId() {
		return id;
	}
	public void setId(int id) {
		this.id = id;
	}
	public String getBookISBN() {
		return bookISBN;
	}
	public void setBookISBN(String bookISBN) {
		this.bookISBN = bookISBN;
	}
	public String getBookName() {
		return bookName;
	}
	public void setBookName(String bookName) {
		this.bookName = bookName;
	}
	public String getAuthor() {
		return author;
	}
	public void setAuthor(String author) {
		this.author = author;
	}
	public float getPrice() {
		return price;
	}
	public void setPrice(float price) {
		this.price = price;
	}
	public int getTypeId() {
		return typeId;
	}
	public void setTypeId(int typeId) {
		this.typeId = typeId;
	}
	public String getPublish() {
		return publish;
	}
	public void setPublish(String publish) {
		this.publish = publish;
	}
	@Override
	public String toString() {
		return "BookInfo:"+this.bookName+","+this.author+","+this.price+","+this.publish;
	}
}

<?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>  
    <!-- 通过typeAlias使得我们在下面使用BookInfo实体类的时候不需要写包名 -->  
    <typeAlias alias="BookInfo" type="com.wxc.bean.BookInfo" />
    
    <!-- 只需要在这里写sql语句参数什么的可以外部传进来 -->  
    <!-- id表示select里的sql语句，resultClass表示返回结果的类型 -->  
    <select id="listBookInfo" resultClass="BookInfo">  
        select * from bookinfo  
    </select>  
  
    <!-- parameterClass表示参数的内容 -->  
    <!-- #表示这是一个外部调用的需要传进的参数，可以理解为占位符 -->  
    <select id="listBookInfoByAuthor" parameterClass="String" resultClass="BookInfo">  
       select * from bookinfo where author = #name#
    </select>  
  	
  	<!-- 修改 -->
  	<update id="update" parameterClass="BookInfo">
  	update bookinfo set 
  	bookISBN=#bookISBN#,
  	bookName=#bookName#,
  	author=#author#,
  	price=#price#,
  	typeId=#typeId#,
  	publish=#publish# 
  	where id=#id#
  	</update>
  	
  	<!-- 删除 -->
  	<delete id="delete" parameterClass="int">
  	delete from bookinfo where id = #id#
  	</delete>
  	
  	<!-- 多条件查询 -->
  	<select id="listByAuthorAndPublis" parameterMap="HashMap">
  	select * from bookinfo where author=#author# and publish=#publish#
  	</select>
</sqlMap>  

jdbc.driverClassName=com.mysql.jdbc.Driver  
jdbc.url=jdbc\:mysql\://localhost\:3306/book?autoReconnect\=true&useUnicode\=true&characterEncoding\=utf8  
jdbc.username=root  
jdbc.password=root

<?xml version="1.0" encoding="UTF-8" ?>  
<!DOCTYPE sqlMapConfig        
    PUBLIC "-//ibatis.apache.org//DTD SQL Map Config 2.0//EN"        
    "http://ibatis.apache.org/dtd/sql-map-config-2.dtd">
<sqlMapConfig>
<!-- 引入JDBC的配置文件 -->
	<properties resource="jdbc.properties" />
	<transactionManager type="JDBC">
		<dataSource type="SIMPLE">
			<property name="JDBC.Driver" value="${jdbc.driverClassName}" />
			<property name="JDBC.ConnectionURL" value="${jdbc.url}" />
			<property name="JDBC.Username" value="${jdbc.username}" />
			<property name="JDBC.Password" value="${jdbc.password}" />
		</dataSource>
	</transactionManager>
	<!-- 引入各个类的实体映射文件 -->
	<sqlMap resource="com/wxc/bean/BookInfo.xml" />
</sqlMapConfig>  

package com.wxc.dao;

import java.util.List;

import com.wxc.bean.BookInfo;

public interface BookInfoDao {
	/**
	 * 获取所有图书信息
	 */
	public List<BookInfo> listBookInfo();
	
	/**
	 * 根据作者获取图书信息
	 */
	public List<BookInfo> bookInfoByAuthor(String name);
	
	/**
	 * 修改图书信息
	 */
	public void update(BookInfo bookinfo);
	
	/**
	 * 删除图书信息
	 */
	public void delete(int id);
	
	/**
	 * 注意这里的参数不是一个而是两个
	 * 根据作者与出版社获取图书信息
	 */
	public List<BookInfo> listByAuthorAndPublish(String author,String publish);
}	

package com.wxc.impl;

import java.io.Reader;
import java.sql.SQLException;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

import com.ibatis.common.resources.Resources;
import com.ibatis.sqlmap.client.SqlMapClient;
import com.ibatis.sqlmap.client.SqlMapClientBuilder;
import com.wxc.bean.BookInfo;
import com.wxc.dao.BookInfoDao;

public class BookInfoDaoImpl implements BookInfoDao {
	private static SqlMapClient sqlMapClient = null;
	
	//读取配置文件
	static{
		try {
			Reader reader = Resources.getResourceAsReader("SqlMapConfig.xml");
			sqlMapClient = SqlMapClientBuilder.buildSqlMapClient(reader);
			reader.close();
		} catch (Exception e) {
			e.printStackTrace();
		}
	}
	@SuppressWarnings("unchecked")
	@Override
	public List<BookInfo> listBookInfo() {
		List<BookInfo> list = null;
		try {
			//注意第一个参数，是对应xml文件里的查询id
			list = this.sqlMapClient.queryForList("listBookInfo", null);
		} catch (Exception e) {
			e.printStackTrace();
		}
		return list;
	}

	@SuppressWarnings("unchecked")
	@Override
	public List<BookInfo> bookInfoByAuthor(String name) {
		List<BookInfo> list = null;
		try {
			list = this.sqlMapClient.queryForList("listBookInfoByAuthor", name);
		} catch (Exception e) {
			e.printStackTrace();
		}
		return list;
	}

	@SuppressWarnings("static-access")
	@Override
	public void update(BookInfo bookinfo) {
	try {
		this.sqlMapClient.update("update", bookinfo);
	} catch (SQLException e) {
		e.printStackTrace();
	}
	}

	@SuppressWarnings("static-access")
	@Override
	public void delete(int id) {
		try {
			this.sqlMapClient.delete("delete", id);
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}

	@Override
	public List<BookInfo> listByAuthorAndPublish(String author, String publish) {
		Map mp = new HashMap();
		mp.put("anthor", author);
		mp.put("publish", publish);
		List<BookInfo> list = null;
		try {
			list = this.sqlMapClient.queryForList("listByAuthorAndPublis", mp);
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return list;
	}

}