首先简历数据库demo(本文选mysql) 数据库脚本: CREATE TABLE `ibatis` ( `id` varchar ( 20 ) NOT NULL , `name` varchar ( 20 ) default NULL , PRIMARY KEY (`id`)) ENGINE = InnoDB DEFAULT CHARSET = gb2312; insert into ibatis values (" 1 "," 1 "); insert into ibatis values (" 2 "," 2 "); DAO接口: package ch10.SpringAndIbatis; import java.util.List; public interface IDAO ... { public List getList(); public Ibatis getByName(String name); public Ibatis getById(String id); public void save(Ibatis ibatis); public void delete(String id); public void update(Ibatis ibatis);} Ibatis配置文件: <? xml version="1.0" encoding="UTF-8" ?> <! DOCTYPE sqlMapConfig PUBLIC "-//iBATIS.com//DTD SQL Map Config 2.0//EN" "http://www.ibatis.com/dtd/sql-map-config-2.dtd" > < sqlMapConfig > < sqlMap resource ="ch10/SpringAndIbatis/Ibatis.xml" /> </ sqlMapConfig > ibatis sql map文件ibatis.xml: <? 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 type ="ch10.SpringAndIbatis.Ibatis" alias ="user" /> < resultMap id ="ibatisTest" class ="user" > < result column ="id" property ="id" jdbcType ="VARCHAR" /> < result column ="name" property ="name" jdbcType ="VARCHAR" /> </ resultMap > <!-- 获得全查询列表 --> < select id ="getAllUsers" resultMap ="ibatisTest" > select * from Ibatis </ select > <!-- 根据用户名获得用户对象 --> < select id ="getUsersByName" resultMap ="ibatisTest" > select * from Ibatis where name=#value# </ select > <!-- 根据id获得用户对象 --> < select id ="getUsersById" resultMap ="ibatisTest"