applicationContest.xml
<bean id="sqlMapClient" class="org.springframework.orm.ibatis.SqlMapClientFactoryBean">
<property name="configLocation">
<value>WEB-INF/sqlMapConfig.xml</value>
</property>
</bean>
WEB-INF/sqlMapConfig.xml里
<?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>
<settings cacheModelsEnabled="true" enhancementEnabled="true"
lazyLoadingEnabled="true" maxRequests="32" maxSessions="10"
maxTransactions="5" useStatementNamespaces="true" />
<sqlMap resource="com/ibatis/UserManage.xml" />
</sqlMapConfig>
com/ibatis/UserManage.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="com.VO.UserVO" alias="user" />
<!-- 新增用户对象 -->
<insert id="insertUsers" parameterClass="user">
insert into emp_t(id,username,age,sex,phone,qq,mail) values
('emp_'||emp_seq.nextval,#username#,#age#,#sex#,#phone#,#qq#,#mail#)
</insert>
<!-- 查询所有用户对象 -->
<select id="getAllUsers" resultClass="user">
select id,username,password,age,sex,time,phone,qq,mail,deptno from emp_t
</select>
<!-- 删除用户对象 -->
<delete id="deleteUsers">
delete from emp_t where id=#id[0]#
</delete>
</sqlMap>
package com.DAO;
import java.util.List;
import org.springframework.orm.ibatis.support.SqlMapClientDaoSupport;
import com.VO.PageVO;
import com.VO.UserVO;
public class UserDAO extends SqlMapClientDaoSupport {
public int delete(String[] id) {
int flag = getSqlMapClientTemplate().delete("deleteUsers", id);
return flag;
}
public UserVO getById(String id) {
return (UserVO) getSqlMapClientTemplate().queryForObject(
"getUsersById", id);
}
public UserVO getByName(String name) {
return (UserVO) getSqlMapClientTemplate().queryForObject(
"getUsersByName", name);
}
public List<UserVO> getAllList(UserVO uservo,PageVO pagevo) {
return getSqlMapClientTemplate().queryForList("getAllUsers", null);
}
public void save(UserVO uservo) {
getSqlMapClientTemplate().insert("insertUsers", uservo);
}
}
<bean id="sqlMapClient" class="org.springframework.orm.ibatis.SqlMapClientFactoryBean">
<property name="configLocation">
<value>WEB-INF/sqlMapConfig.xml</value>
</property>
</bean>
WEB-INF/sqlMapConfig.xml里
<?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>
<settings cacheModelsEnabled="true" enhancementEnabled="true"
lazyLoadingEnabled="true" maxRequests="32" maxSessions="10"
maxTransactions="5" useStatementNamespaces="true" />
<sqlMap resource="com/ibatis/UserManage.xml" />
</sqlMapConfig>
com/ibatis/UserManage.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="com.VO.UserVO" alias="user" />
<!-- 新增用户对象 -->
<insert id="insertUsers" parameterClass="user">
insert into emp_t(id,username,age,sex,phone,qq,mail) values
('emp_'||emp_seq.nextval,#username#,#age#,#sex#,#phone#,#qq#,#mail#)
</insert>
<!-- 查询所有用户对象 -->
<select id="getAllUsers" resultClass="user">
select id,username,password,age,sex,time,phone,qq,mail,deptno from emp_t
</select>
<!-- 删除用户对象 -->
<delete id="deleteUsers">
delete from emp_t where id=#id[0]#
</delete>
</sqlMap>
package com.DAO;
import java.util.List;
import org.springframework.orm.ibatis.support.SqlMapClientDaoSupport;
import com.VO.PageVO;
import com.VO.UserVO;
public class UserDAO extends SqlMapClientDaoSupport {
public int delete(String[] id) {
int flag = getSqlMapClientTemplate().delete("deleteUsers", id);
return flag;
}
public UserVO getById(String id) {
return (UserVO) getSqlMapClientTemplate().queryForObject(
"getUsersById", id);
}
public UserVO getByName(String name) {
return (UserVO) getSqlMapClientTemplate().queryForObject(
"getUsersByName", name);
}
public List<UserVO> getAllList(UserVO uservo,PageVO pagevo) {
return getSqlMapClientTemplate().queryForList("getAllUsers", null);
}
public void save(UserVO uservo) {
getSqlMapClientTemplate().insert("insertUsers", uservo);
}
}