springMVC +mybites 中SqlSessionDaoSupport 的使用

  使用spring注解的方式，使用 mybites 中的 SqlSessionDaoSupport 

 只是测试的例子，表中只有2个字段

1 。继承SqlSessionDaoSupport 的顶级dao 层代码

 

package com.inf.base;import java.sql.Connection;import java.util.List;import java.util.Map;import javax.servlet.http.HttpServletRequest;import org.apache.ibatis.session.SqlSessionFactory;import org.mybatis.spring.SqlSessionTemplate;import org.mybatis.spring.support.SqlSessionDaoSupport;import org.springframework.beans.factory.annotation.Autowired;import com.inf.system.utiles.PropertyUtils;import com.inf.system.utiles.page.PageBean;/** * 顶层接口 * @author zongxin */public  class BaseDao extends SqlSessionDaoSupport{/* // 使用 SqlSessionTemplate @Autowired private SqlSessionTemplate sqlSessionTemplate; @Autowired public void setSqlSessionTemplate(SqlSessionTemplate sqlSessionTemplate)     {super.setSqlSessionTemplate(sqlSessionTemplate);     }*///使用sqlSessionFactory@Autowired private  SqlSessionFactory sqlSessionFactory;@Autowired public void setSqlSessionFactory(SqlSessionFactory sqlSessionFactory)  {      super.setSqlSessionFactory(sqlSessionFactory);  }/** * 执行insert操作 * @param statement * @return */public int insert(String statement) {return getSqlSession().insert(statement);}/** * 执行insert操作 * @param statement * @param parameter * @return */public int insert(String statement, Object parameter) {return getSqlSession().insert(statement, parameter);}public int update(String statement) {return getSqlSession().update(statement);}public int update(String statement, Object parameter) {return getSqlSession().update(statement, parameter);}public int delete(String statement) {return getSqlSession().delete(statement);}public int delete(String statement, Object parameter) {return getSqlSession().delete(statement, parameter);}/** * 获取一个list集合 * @param statement * @return */public List<?> selectList(String statement) {return getSqlSession().selectList(statement);}/** * 根据参数 获取一个list集合 * @param statement * @param parameter * @return */public List<?> selectList(String statement, Object parameter) {return getSqlSession().selectList(statement, parameter);}public Map<?, ?> selectMap(String statement, String mapKey) {return getSqlSession().selectMap(statement, mapKey);}public Map<?, ?> selectMap(String statement, Object parameter, String mapKey) {return getSqlSession().selectMap(statement, parameter, mapKey);}/** * 获取Object对象 * @param statement * @return */public Object selectOne(String statement) {return getSqlSession().selectOne(statement);}/** * 获取connection, 以便执行较为复杂的用法 * @return */public Connection getConnection() {return getSqlSession().getConnection();}}

2.实体类 代码：

      

package com.inf.sys.user.model;public class TestGener {  private Long generId;private String  generValue;public Long getGenerId() {return generId;}public void setGenerId(Long generId) {this.generId = generId;}public String getGenerValue() {return generValue;}public void setGenerValue(String generValue) {this.generValue = generValue;}  }

3，dao层接口代码：

  

package com.inf.sys.user.repository;public interface TestDao {public Long getTestIds(String generName);}

4，dao的实现类代码

package com.inf.sys.user.repository.impl;import org.springframework.stereotype.Repository;import com.inf.base.BaseDao;import com.inf.sys.user.repository.TestDao;@Repositorypublic class TestDaoImpl extends BaseDao implements TestDao{public Long getTestIds(String generName){Object object= this.selectOne("com.inf.sys.user.mapper.TestMapper.getTestIds",generName);Long reault=Long.valueOf(String.valueOf(object));return reault;}}

注意： 

com.inf.sys.user.mapper.TestMapper 为对应的mapper接口文件， <pre name="code" class="java">getTestIds 为对应的参数

5，mapper 接口代码：

package com.inf.sys.user.mapper;public interface TestMapper {Long  getTestIds(String generName);}

6.mapper 对应的xml映射文件

<?xml version="1.0" encoding="UTF-8" ?><!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" ><mapper namespace="com.inf.sys.user.mapper.TestMapper"><select id="getTestIds" parameterType="String" resultType="String">SELECT GENER_IDFROM tb_sys_id_generatorWHERE GENER_VALUE=#{generName}</select></mapper>

7. 测试使用的action代码：

package com.inf.sys.user.action;import java.io.PrintWriter;import java.util.HashMap;import java.util.Map;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.stereotype.Controller;import org.springframework.web.bind.annotation.RequestMapping;import org.springframework.web.bind.annotation.RequestParam;import com.inf.sys.user.repository.TestDao;import com.inf.system.utiles.JsonBean;//test@Controller@RequestMapping("test/")public class TestCollection {@Autowiredprivate TestDao testDao;@RequestMapping("testGetgen.do")public void testGetgen(@RequestParam(required=true) String generName,HttpServletRequest request, HttpServletResponse response) throws Exception{response.setCharacterEncoding("UTF-8");response.setContentType("text/html;charset=UTF-8");Map<String, Object> result=new HashMap<String, Object>();Long resulte=testDao.getTestIds(generName);result.put("success",true);result.put("msg",resulte);System.out.println( "this is result======"+result);PrintWriter out = response.getWriter();out.print(JsonBean.toJson(result));}}

8.spring xml文件配置注意代码

<context:property-placeholderignore-unresolvable="true" location="classpath*:/datasource.properties" /><context:property-placeholderignore-unresolvable="true" location="classpath*:/config.properties" /><context:property-placeholderignore-unresolvable="true" location="classpath*:/applicationContext.properties" /><context:component-scan base-package="com.inf.sys"><context:exclude-filter type="annotation"expression="org.springframework.stereotype.Controller" /><context:exclude-filter type="annotation"expression="org.springframework.web.bind.annotation.ControllerAdvice" /></context:component-scan><bean id="abstractDataSource" abstract="true"class="org.apache.commons.dbcp.BasicDataSource"><property name="driverClassName" value="${datasource.driverClass}" /><property name="validationQuery" value="${datasource.validationQuery}" /><property name="maxIdle" value="${datasource.maxIdle}" /><property name="minIdle" value="${datasource.minIdle}" /><property name="maxActive" value="${datasource.maxActive}" /><property name="initialSize" value="${datasource.initialSize}" /></bean><!-- 默认数据源-mybatis使用 --><bean id="dataSource" parent="abstractDataSource"><property name="url" value="${datasource.url.0}" /><property name="username" value="${datasource.username}" /><property name="password" value="${datasource.password}" /></bean><!--事务管理器配置 --><bean id="transactionManager"class="org.springframework.jdbc.datasource.DataSourceTransactionManager"><property name="dataSource" ref="dataSource" /></bean><!-- 定义SqlSessionFactoryBean --><bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean"><property name="dataSource" ref="dataSource" /><property name="configLocation" value="classpath:mybatis-config.xml" /><property name="mapperLocations" value="classpath:com/inf/sys/*/mapper/*.xml" /><property name="typeAliasesPackage" value="com.inf.sys.*.model" /></bean><!-- <bean id="sqlSessionTemplate" class="org.mybatis.spring.SqlSessionTemplate"> <constructor-arg index="0" ref="sqlSessionFactory" /> </bean> --><!-- 扫描Mapper文件，并实施自动注入 --><bean class="org.mybatis.spring.mapper.MapperScannerConfigurer"><property name="sqlSessionFactoryBeanName" value="sqlSessionFactory" /><property name="basePackage" value="com.inf.sys.*.mapper;" /></bean>

注意：

在dao的实现类上增加注解  @Repository 

      在 顶层dao类 baseDa 中 

      @Autowired
public void setSqlSessionFactory(SqlSessionFactory sqlSessionFactory)
 {
     super.setSqlSessionFactory(sqlSessionFactory);
 }

 注入sqlSessionFactory  或者是 sqlSessionTemplate

 通常使用mybites 直接使用mapper的方式 ，不使用dao层接口和dao的实现类，

applicationContext.xml 中的配置   ：

<!-- 扫描Mapper文件，并实施自动注入 --><bean class="org.mybatis.spring.mapper.MapperScannerConfigurer"><property name="sqlSessionFactoryBeanName" value="sqlSessionFactory" /><property name="basePackage" value="com.inf.sys.*.mapper;" /></bean>

 

<!-- 扫描Mapper文件，并实施自动注入 --><bean class="org.mybatis.spring.mapper.MapperScannerConfigurer"><property name="sqlSessionFactoryBeanName" value="sqlSessionFactory" /><property name="basePackage" value="com.inf.sys.*.mapper;" /></bean>