Mybatis+Spring3.0

 

先建立一个实体类：

package com.soft.entity;
/**
 * 
 * @Author: liuxinghui
 * @Date: Feb 2, 2012
 * @Version: 2.0
 * @Despcrition:
 */
public class User {
	  /** serialVersionUID */
    private static final long serialVersionUID = -421805527094084664L;
    
    private String user_id;// UserID
	private String hr_id;// HRID
	private String user_name;// 用户名
	private String domain;// 域
	private String pwd;// 加密后的Password
	private String user_dsp_name;// 用户显示名称
	private String email;// email地址
	private String tel;// 电话分机
	private String dept;// 部门
	private String job_title;// 职位
	private String sp_hr_id;// 直属上级的HRID
	private String join_date;// 加入公司的日期
	private String cost_center;// 成本中心
	private String location_code;// 分公司
	private String enable;// enable
	private String isout;// 外出
	private String agent_user_id;// 代理人
	private String language;// 语言
	private String mbtel;// 移动电话
	private String can_assign_out;// 可以指派
	private String is_leave;// 是否已经离开公司
	private String leave_date;// 离职日期
	private String user_cat_id;// 所在省份的ID
	private String hard_key_auth;//                           
	private String tel_ext;// 电话分机
	private String pwd1;// password
	private String location_code_2;// 省份
	private String fcd;// 记录新增日期
	private String fcu;// 初始化用户ID
	private String lcd;// 记录修改日期
	private String lcu;// 最后修改用户ID

	public String getUser_id() {
		return user_id;
	}

	public void setUser_id(String user_id) {
		this.user_id = user_id;
	}

	public String getHr_id() {
		return hr_id;
	}

	public void setHr_id(String hr_id) {
		this.hr_id = hr_id;
	}

	public String getUser_name() {
		return user_name;
	}

	public void setUser_name(String user_name) {
		this.user_name = user_name;
	}

	public String getDomain() {
		return domain;
	}

	public void setDomain(String domain) {
		this.domain = domain;
	}

	public String getPwd() {
		return pwd;
	}

	public void setPwd(String pwd) {
		this.pwd = pwd;
	}

	public String getUser_dsp_name() {
		return user_dsp_name;
	}

	public void setUser_dsp_name(String user_dsp_name) {
		this.user_dsp_name = user_dsp_name;
	}

	public String getEmail() {
		return email;
	}

	public void setEmail(String email) {
		this.email = email;
	}

	public String getTel() {
		return tel;
	}

	public void setTel(String tel) {
		this.tel = tel;
	}

	public String getDept() {
		return dept;
	}

	public void setDept(String dept) {
		this.dept = dept;
	}

	public String getJob_title() {
		return job_title;
	}

	public void setJob_title(String job_title) {
		this.job_title = job_title;
	}

	public String getSp_hr_id() {
		return sp_hr_id;
	}

	public void setSp_hr_id(String sp_hr_id) {
		this.sp_hr_id = sp_hr_id;
	}

	public String getJoin_date() {
		return join_date;
	}

	public void setJoin_date(String join_date) {
		this.join_date = join_date;
	}

	public String getCost_center() {
		return cost_center;
	}

	public void setCost_center(String cost_center) {
		this.cost_center = cost_center;
	}

	public String getLocation_code() {
		return location_code;
	}

	public void setLocation_code(String location_code) {
		this.location_code = location_code;
	}

	public String getEnable() {
		return enable;
	}

	public void setEnable(String enable) {
		this.enable = enable;
	}

	public String getIsout() {
		return isout;
	}

	public void setIsout(String isout) {
		this.isout = isout;
	}

	public String getAgent_user_id() {
		return agent_user_id;
	}

	public void setAgent_user_id(String agent_user_id) {
		this.agent_user_id = agent_user_id;
	}

	public String getLanguage() {
		return language;
	}

	public void setLanguage(String language) {
		this.language = language;
	}

	public String getMbtel() {
		return mbtel;
	}

	public void setMbtel(String mbtel) {
		this.mbtel = mbtel;
	}

	public String getCan_assign_out() {
		return can_assign_out;
	}

	public void setCan_assign_out(String can_assign_out) {
		this.can_assign_out = can_assign_out;
	}

	public String getIs_leave() {
		return is_leave;
	}

	public void setIs_leave(String is_leave) {
		this.is_leave = is_leave;
	}

	public String getLeave_date() {
		return leave_date;
	}

	public void setLeave_date(String leave_date) {
		this.leave_date = leave_date;
	}

	public String getUser_cat_id() {
		return user_cat_id;
	}

	public void setUser_cat_id(String user_cat_id) {
		this.user_cat_id = user_cat_id;
	}

	public String getHard_key_auth() {
		return hard_key_auth;
	}

	public void setHard_key_auth(String hard_key_auth) {
		this.hard_key_auth = hard_key_auth;
	}

	public String getTel_ext() {
		return tel_ext;
	}

	public void setTel_ext(String tel_ext) {
		this.tel_ext = tel_ext;
	}

	public String getPwd1() {
		return pwd1;
	}

	public void setPwd1(String pwd1) {
		this.pwd1 = pwd1;
	}

	public String getLocation_code_2() {
		return location_code_2;
	}

	public void setLocation_code_2(String location_code_2) {
		this.location_code_2 = location_code_2;
	}

	public String getFcd() {
		return fcd;
	}

	public void setFcd(String fcd) {
		this.fcd = fcd;
	}

	public String getFcu() {
		return fcu;
	}

	public void setFcu(String fcu) {
		this.fcu = fcu;
	}

	public String getLcd() {
		return lcd;
	}

	public void setLcd(String lcd) {
		this.lcd = lcd;
	}

	public String getLcu() {
		return lcu;
	}

	public void setLcu(String lcu) {
		this.lcu = lcu;
	}
}
添加一个UsersMapper：
package com.soft.persistence;
import java.util.List;
public interface UsersMapper{
	
	public List list();
}
添加一个UsersMapper.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.soft.persistence.UsersMapper">

	<select id="list" resultType="com.soft.entity.User">
		select user_id,
		       hr_id,
		       user_name,
		       domain,
		       pwd,
		       user_dsp_name,
		       email,
		       tel,
		       dept,
		       job_title,
		       sp_hr_id,
		       to_char(join_date,'yyyy/MM/dd') join_date,
		       cost_center,
		       location_code,
		       enable,
		       isout,
		       agent_user_id,
		       language,
		       mbtel,
		       can_assign_out,
		       is_leave,
		       decode(is_leave,0,'', to_char(leave_date,'yyyy/MM/dd')) leave_date,
		       user_cat_id,
		       hard_key_auth,
		       tel_ext,
		       pwd1,
		       location_code_2,
		       fcd,
		       fcu,
		       lcd,
		       lcu
		  from tu_oaf_users
	</select>
</mapper>
 
测试


package com.soft.test;

import java.util.List;

import org.springframework.context.ApplicationContext;
import org.springframework.context.support.FileSystemXmlApplicationContext;

import com.soft.entity.User;
import com.soft.persistence.UsersMapper;

/**
 * 
 * @Author: liuxinghui
 * @Date: Feb 2, 2012
 * @Version: 2.0
 * @Despcrition:
 */
public class UserMapperTest {
@SuppressWarnings("unchecked")
public static void main(String[] args) {
	  ApplicationContext aContext = new FileSystemXmlApplicationContext("WebRoot/WEB-INF/applicationContext.xml"); 
	  UsersMapper userMapper = aContext.getBean(UsersMapper.class); 
	   List<User> user =userMapper.list(); 
	   for(int i=0;i<user.size();i++){
		   System.out.println(user.get(i).getUser_name());
		   
	   }
	    

}
}
配置文件：

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
     xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
     xmlns:aop="http://www.springframework.org/schema/aop"
     xmlns:tx="http://www.springframework.org/schema/tx"
     xmlns:jdbc="http://www.springframework.org/schema/jdbc"
     xmlns:context="http://www.springframework.org/schema/context"
     xsi:schemaLocation="
     http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-3.0.xsd
     http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.0.xsd
     http://www.springframework.org/schema/jdbc http://www.springframework.org/schema/jdbc/spring-jdbc-3.0.xsd
     http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-3.0.xsd
     http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-3.0.xsd">
	<!-- 加载spring.properties资源文件 -->
	<bean id="propertyConfigurer"
		class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
		<property name="location" value="classpath:spring.properties" />
	</bean>
	<!-- 创建数据源 -->
		<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
		<property name="driverClassName" value="${jdbc.driverClassName}"/>
		<property name="url" value="${jdbc.url}"/>
		<property name="username" value="${jdbc.username}"/>
		<property name="password" value="${jdbc.password}"/>
		<property name="defaultAutoCommit" value="false"></property>
		</bean> 	
    <!-- define the SqlSessionFactory -->
    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
        <property name="dataSource" ref="dataSource" />
        <property name="typeAliasesPackage" value="com.soft.entity" />
    </bean>
    
    <!-- transaction manager, use JtaTransactionManager for global tx -->
    <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
        <property name="dataSource" ref="dataSource" />
    </bean>

    <!-- enable component scanning (beware that this does not enable mapper scanning!) --> 
    <!-- 在 XML 配置文件中启动 Spring 的自动扫描功能我们就不再需要在 XML 中显式使用 <bean/> 进行 Bean 的配置。Spring 在容器初始化时将自动扫描 base-package 指定的包及其子包下的所有 class 文件，所有标注了 @Repository 的类都将被注册为 Spring Bean -->   
    <context:component-scan base-package="org.mybatis.jpetstore.service" />

    <!-- enable autowire -->
    <context:annotation-config />

    <!-- enable transaction demarcation with annotations -->
    <tx:annotation-driven />

    <!-- scan for mappers and let them be autowired -->
    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
        <property name="basePackage" value="com.soft.persistence" />
    </bean>

	
</beans>