首先简历数据库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 ");
`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);
}
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 >
<! 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"
<! 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"