基于Spring+Ibatis的安全线程实现
作者: 佚名, 出处:CSDN, 责任编辑: 张帅,
2008-07-04 13:22
过去做过一些基于spring、hibernate整合应用的实例,本人感觉spring与hibernate最好的结合就是泛型Dao的实现,代码量节省了一半,而且业务逻辑一目了然。
Spring_other.xml存放用户自定义bean
| SqlMap_config.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 lazyLoadingEnabled="true" useStatementNamespaces="true" enhancementEnabled="true" errorTracingEnabled="true" /> /////////////定义ibatis相关操作参数,例如延迟加载,命名空间是否生效,是否打开缓存,调试阶段出错信息反馈等等 <sqlMap resource="com/user/user.xml" /> //////////////包含用户的相关操作xml文件 </sqlMapConfig> User.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 namespace="User"> <typeAlias alias="user" type="com.user.User" /><!-- obj --> <!-- get user --> <select id="getUser" parameterClass="java.lang.String" resultClass="user"> <![CDATA[ select id, name, sex from t_user where name like #name# ]]> </select> <!-- update user --> <update id="updateUser" parameterClass="user"> <![CDATA[ update t_user set name=#name#, sex=#sex# where id = #id# ]]> </update> <insert id="insertUser" parameterClass="user"> <![CDATA[ insert into t_user( id, name, sex) values( #id#, #name#, #sex# ) ]]> </insert> <delete id="deleteUser" parameterClass="java.lang.String"> <![CDATA[ delete from t_user where id = #value# ]]> </delete> <select id="selectUser" resultClass="user"> <![CDATA[ select * from t_user order by id desc ]]> </select> </sqlMap> |
该配置文件属性就不多了。用户可在网上搜一堆够看了。
针对spring_other.xml 里面的用户自定义bean如下
UserDao.java 接口
| package com.user.dao; import java.util.List; import com.user.User; public interface UserDao { public User getUser(String name); public void updateUser(User user); public List selectUser(); public void insertUser(User user); } |
UserDaoImpl.java 实现类
| package com.user.dao; import java.util.List; import org.springframework.orm.ibatis.support.SqlMapClientDaoSupport; import com.user.User; public class UserDaoImpl extends SqlMapClientDaoSupport implements UserDao { //private static Logger log = Logger.getLogger(UserDaoImpl.class); public User getUser(String name) { return (User) this.getSqlMapClientTemplate().queryForObject("User.getUser","name"); } public void updateUser(User user) { this.getSqlMapClientTemplate().update("User.updateUser", user); } public List selectUser() { return this.getSqlMapClientTemplate().queryForList("User.selectUser",""); } public void insertUser(User user) { this.getSqlMapClientTemplate().insert("User.insertUser", user); } } |
- 本文关键词:
- Web开发

