Spring+Ibatis集成开发实例.docVIP

首先简历数据库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 /dtd/sql-map-config-2.dtd sqlMapConfig sqlMap resource=ch10/SpringAndIbatis/Ibatis.xml / /sqlMapConfigibatis sql map文件ibatis.xml： ?xml version=1.0 encoding=UTF-8 ? !DOCTYPE sqlMap PUBLIC -////DTD SQL Map 2.0//EN /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 select * from Ibatis where id=#value# /select !-- 新增用户对象 -- insert id=insertUsers parameterClass=user insert into ibatis (id,name) values (#id#,#name#) /insert !-- 删除用户对象 -- delete id=deleteUsers delete from ibatis where id=#value# /delete !-- 更新用户对象 -- delete id=updateUsers parameterClass=user update ibatis set name=#name# where id=#id# /delete /sqlMap spring配置文件 ?xml version=1.0 encoding=UTF-8? beans xmlns=/schema/beans xmlns:xsi=/2001/XMLSchema-instance xsi:schemaLocation=/schema/beans /schema/beans/