ibatis+spring+struts spring 外部注入 SqlMapClientTemplate

最新推荐文章于 2024-09-11 15:58:47 发布

mocaoshang

最新推荐文章于 2024-09-11 15:58:47 发布

阅读量1k

点赞数

分类专栏： ssh 框架整合文章标签： spring struts ibatis bean class user

本文链接：https://blog.csdn.net/mocaoshang/article/details/6601220

版权

ssh 框架整合专栏收录该内容

2 篇文章 0 订阅

订阅专栏

applicationContext.xml配置文件:

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.0.xsd">

// 数据库的配置信息

// loginService set 注入 loginDAO
   <bean id="loginService" class="com.lxitedu.bullet.service.impl.LoginServiceImpl">
       <property name="loginDAO" ref="loginDAOA"/>
   </bean>

// loginDAOImpl set 注入 sqlMapClientTemplate
   <bean id="loginDAOA" class="com.lxitedu.bullet.model.impl.LoginDAOImpl">
       <property name="sqlMapClientTemplate" ref="sqlMapClientTemplate"/>
   </bean>

//sqlMapClientTemplate set 注入 sqlMapClient
   <bean id="sqlMapClientTemplate" class="org.springframework.orm.ibatis.SqlMapClientTemplate">
       <property name="sqlMapClient">
           <ref bean="sqlMapClient"/>
       </property>
</bean>

// sqlMapClient 初始化 sql-map-config.xml文件
   <bean id="sqlMapClient" class="org.springframework.orm.ibatis.SqlMapClientFactoryBean">
       <property name="configLocation" value="WEB-INF/sql-map-config.xml" />
       <property name="dataSource" ref="dataSource" />
   </bean>
</beans>

sql-map-config.xml配置文件：

// 主要就是一些sql 语句

<sqlMap namespace="Account">
   <resultMap class="com.lxitedu.bullet.model.bean.User" id="result">
       <result property="userID" column="userID" columnIndex="1" />
       <result property="userName" column="userName" columnIndex="2" />
       <result property="userPassword" column="userPassword"
           columnIndex="3" />
       <result property="userSex" column="userSex" columnIndex="4" />
       <result property="userAge" column="userAge" columnIndex="5" />
       <result property="userEmail" column="userEmail" columnIndex="6" />
       <result property="userPhone" column="userPhone" columnIndex="7" />
       <result property="userCreateTime" column="userCreateTime"
           columnIndex="8" />
       <result property="userStatus" column="userStatus" columnIndex="9" />
       <result property="userLoginTime" column="userLoginTime"
           columnIndex="10" />
       <result property="team" column="userTeam" columnIndex="11" />
   </resultMap>

   <select id="getLoginInfo" resultMap="result">
       SELECT
       userID,userName,userPassword,userSex,userAge,userEmail,userPhone,userCreateTime,userStatus,userLoginTime,userTeam
       FROM user WHERE userName = #userName# AND userPassword =
       #userPassword#
   </select>
</sqlMap>

/*-------------------------------------java 代码--------------------------------------*/

// ioc 中拿实例然后掉service 层

public void setServlet(ActionServlet actionServlet){
       super.setServlet(actionServlet);
       if(actionServlet != null){
           ServletContext servletContext = actionServlet.getServletContext();
           WebApplicationContext wac = WebApplicationContextUtils.getRequiredWebApplicationContext(servletContext);
           object = wac.getBean(className);
       }
}

// model 层（持久层）拿值

public SqlMapClientTemplate sqlMapClientTemplate;
   public SqlMapClientTemplate getSqlMapClientTemplate() {
       return sqlMapClientTemplate;
   }

   public void setSqlMapClientTemplate(SqlMapClientTemplate sqlMapClientTemplate) {
       this.sqlMapClientTemplate = sqlMapClientTemplate;
   }

   public User getValue(User user) {
       List<User> userList = getSqlMapClientTemplate().queryForList("getLoginInfo", user);