ibatis分页

yikeshaweng

浏览: 3361 次
性别:
来自: 南京

最近访客更多访客>>

lzylin

wyzuomumu

woodding2008

博主相关

博客

微博

相册

留言

关于我

文章分类

全部博客 (5)

社区版块

存档分类

ibatis分页 oracle

package 包名;

import java.util.Date;

public class Employee
{
	private String id;
	private String loginname;
	private String name; 
	private String age;
	private Date birthday;
	private String dept_id;
	private String position;
	private String  gender;
	private String  married;
	private String salary;
	private String educational;
	private String country;
	private String city;
	private String remarks;
	private String school;
	private Date createtime;
	private String email;
	
	
	public Date getBirthday() {
		return birthday;
	}
	public void setBirthday(Date birthday) {
		this.birthday = birthday;
	}
	public String getCity() {
		return city;
	}
	public void setCity(String city) {
		this.city = city;
	}
	public String getCountry() {
		return country;
	}
	public void setCountry(String country) {
		this.country = country;
	}
	public Date getCreatetime() {
		return createtime;
	}
	public void setCreatetime(Date createtime) {
		this.createtime = createtime;
	}
	public String getDept_id() {
		return dept_id;
	}
	public void setDept_id(String dept_id) {
		this.dept_id = dept_id;
	}
	public String getEducational() {
		return educational;
	}
	public void setEducational(String educational) {
		this.educational = educational;
	}
	public String getEmail() {
		return email;
	}
	public void setEmail(String email) {
		this.email = email;
	}
	
	
	public String getId() {
		return id;
	}
	public void setId(String id) {
		this.id = id;
	}
	public String getLoginname() {
		return loginname;
	}
	public void setLoginname(String loginname) {
		this.loginname = loginname;
	}
	
	
	public String getAge() {
		return age;
	}
	public void setAge(String age) {
		this.age = age;
	}
	public String getGender() {
		return gender;
	}
	public void setGender(String gender) {
		this.gender = gender;
	}
	public String getMarried() {
		return married;
	}
	public void setMarried(String married) {
		this.married = married;
	}
	public String getName() {
		return name;
	}
	public void setName(String name) {
		this.name = name;
	}
	public String getPosition() {
		return position;
	}
	public void setPosition(String position) {
		this.position = position;
	}
	public String getRemarks() {
		return remarks;
	}
	public void setRemarks(String remarks) {
		this.remarks = remarks;
	}
	public String getSalary() {
		return salary;
	}
	public void setSalary(String salary) {
		this.salary = salary;
	}
	public String getSchool() {
		return school;
	}
	public void setSchool(String school) {
		this.school = school;
	}
}

package 包名;

import java.util.HashMap;
import java.util.List;
import java.util.Map;

public class PageModel<T>
{
	 //结果集  
    private T model;
      
    //查询记录数  
    private int totalRecords;  
      
    //每页多少条数据  
    private int pageSize=10;  
      
    //第几页  
    private int pageNo;  
    
    private int startIndex;
    private int endIndex;

	public int getEndIndex() {
		return endIndex;
	}

	public void setEndIndex(int endIndex) {
		this.endIndex = endIndex;
	}

	public int getStartIndex() {
		return startIndex;
	}

	public void setStartIndex(int startIndex) {
		this.startIndex = startIndex;
	}

	/** 
     * 总页数 
     * @return 
     */  
    public int getTotalPages() {  
        return (totalRecords + pageSize - 1) / pageSize;  
    }  
      
    /** 
     * 取得首页 
     * @return 
     */  
    public int getTopPageNo() {  
        return 1;  
    }  
      
    /** 
     * 上一页 
     * @return 
     */  
    public int getPreviousPageNo() {  
        if (pageNo <= 1) {  
            return 1;  
        }  
        return pageNo - 1;  
    }  
      
    /** 
     * 下一页 
     * @return 
     */  
    public int getNextPageNo() {  
        if (pageNo >= getBottomPageNo()) {  
            return getBottomPageNo();  
        }  
        return pageNo + 1;    
    }  
      
    /** 
     * 取得尾页 
     * @return 
     */  
    public int getBottomPageNo() {  
        return getTotalPages();  
    }  
      
 
  
    public int getTotalRecords() {  
        return totalRecords;  
    }  
  
    public void setTotalRecords(int totalRecords) {  
        this.totalRecords = totalRecords;  
    }  
  
    public int getPageSize() {  
        return pageSize;  
    }  
  
    public void setPageSize(int pageSize) {  
        this.pageSize = pageSize;  
    }  
  
    public int getPageNo() {  
        return pageNo;  
    }  
  
    public void setPageNo(int pageNo) {  
        this.pageNo = pageNo;  
    }

    public T getModel() {
		return model;
   }

   public void setModel(T model) 
   {
		this.model = model;
   }

	 
}

<?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="Employee">
  <resultMap id="Employee.EmployeeResult" class="com.huasoft.common.domain.Employee" >
    <result column="ID" property="id" jdbcType="VARCHAR" />
    <result column="LOGINNAME" property="loginname" jdbcType="VARCHAR" />
    <result column="NAME" property="name" jdbcType="VARCHAR" />
    <result column="AGE" property="age" jdbcType="VARCHAR" />
    <result column="BIRTHDAY" property="birthday" jdbcType="TIMESTAMP" />
    <result column="DEPT_ID" property="dept_id" jdbcType="VARCHAR" />
    <result column="POSITION" property="position" jdbcType="VARCHAR" />
    <result column="GENDER" property="gender" jdbcType="VARCHAR" />
    <result column="MARRIED" property="married" jdbcType="VARCHAR" />
    <result column="SALARY" property="salary" jdbcType="VARCHAR" />
    <result column="EDUCATIONAL" property="educational" jdbcType="VARCHAR" />
    <result column="COUNTRY" property="country" jdbcType="VARCHAR" />
    <result column="CITY" property="city" jdbcType="VARCHAR" />
    <result column="REMARKS" property="remarks" jdbcType="VARCHAR" />
    <result column="SCHOOL" property="school" jdbcType="VARCHAR" />
    <result column="CREATETIME" property="createtime" jdbcType="TIMESTAMP" />
    <result column="EMAIL" property="email" jdbcType="VARCHAR" />
  </resultMap>
	
  	<select id="Employee.selectListByCondition"
		parameterClass="java.util.HashMap"  
		resultMap="Employee.EmployeeResult">
		select * from (select ROWNUM ROW_NUM,t.* from (
		select id, loginname, age, birthday, dept_id, position, gender, 
		married, salary, educational, country, city, remarks, school, createtime, e                mail,name from t_employee where +"条件根据自己项目实际需求") t) WHERE ROW_NUM BETWEEN #page.startIndex# AND #page.endIndex#
	</select>
</sqlMap>

package 包名;

import java.io.Serializable;
import java.util.List;



public interface BaseDao<T> {
	

	/**
	 * sql查询列表
	 * 
	 * @param statementId
	 *            sql语句名称后缀
	 * @param parameters
	 *            sql参数
	 * @return 查询结果
	 */
	List<T> queryForList(T model,String statementId, int startIndex,int endIndex);

}

package 包名;

import java.io.Serializable;
import java.util.HashMap;

import java.util.List;
import java.util.Map;
import java.util.HashMap;

import org.springframework.orm.ibatis.support.SqlMapClientDaoSupport;




public class BaseDaoImpl<T> extends SqlMapClientDaoSupport  implements BaseDao<T>{
	public <T> T queryForList(T model, String statementId,int startIndex,int endIndex)         {
	    PageModel<T> page=new PageModel<T>();
            page.setModel(model);
            page.setStartIndex(startIndex);
            page.setStartIndex(endIndex);
            Map map=new HashMap();
            map.put("page",page);
            List<T> list=getSqlMapClientTemplate().queryForList("statementId",map);
            return list;
	}	
}

package 包名
import java.util.List
public class Test{
    public static void main(String args[]){
         BaseDao<Employee> base=new BaseDaoImpl<>();
         Employee employee=new Employee ();
         //从数据库中取出前10条记录
         List list=base.queryForList(employee,"statementId",1,10);
         //遍历list集合
    }



}

<!--spring配置文件-->
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" "http://www.springframework.org/dtd/spring-beans.dtd">

<beans>
      <!--jndi数据源-->
	<bean id="dataSource" 
	    class="org.springframework.jndi.JndiObjectFactoryBean">
		<property name="jndiName" 
			value="java:comp/env/jdbc/dljxkp"/>
		<property name="lookupOnStartup" 
			value="false"/>
		<property name="cache" 
			value="true"/>
		<property name="proxyInterface" 
			value="javax.sql.DataSource"/>
	</bean>
        
	 <!--  
	<bean id="dataSource"
		class="org.apache.commons.dbcp.BasicDataSource"
		destroy-method="close">
		<property name="driverClassName"
			value="oracle.jdbc.driver.OracleDriver" />
		<property name="url" value="jdbc:oracle:thin:@数据库IP地址:1521:SID" />
		<property name="username" value="数据库用户名" />
		<property name="password" value="数据库密码" />
	</bean>
	-->
	<bean id="sqlMapClient" class="org.springframework.orm.ibatis.SqlMapClientFactoryBean">
    	<property name="configLocation">
            <value>classpath:sqlmap配置文件</value>
        </property>      
        <property name="dataSource"><ref bean="dataSource"/></property>       
    </bean>	
     
	<bean id="baseDao" class="包名+类名Impl">
		<property name="sqlMapClient" ref="sqlMapClient"/>
	</bean>	
			 
</beans>

<!--web.xml配置文件-->
<?xml version="1.0" encoding="UTF-8"?>
<web-app version="2.4" xmlns="http://java.sun.com/xml/ns/j2ee"
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee 
	http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd">

	<!-- 用于初始化Spring容器的Listener -->
	<context-param>
		<param-name>contextConfigLocation</param-name>
		<param-value>
		    classpath:/spring配置文件
		</param-value>
	</context-param>
	<listener>
	    <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
	</listener>

	<welcome-file-list>
		<welcome-file>/index.jsp</welcome-file>
	</welcome-file-list>
	<resource-ref>
		<res-ref-name>jdbc/名称</res-ref-name>
		<res-type>java.sql.DataSource</res-type>
		<res-auth>Container</res-auth>
		<res-sharing-scope>Shareable</res-sharing-scope>
	</resource-ref>
</web-app>

<!--sqlMap配置文件-->
<?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>
 
  <sqlMap resource="ibatis映射文件"/> 
</sqlMapConfig>
http://shopsale.sinaapp.com

分享到：