hibernate 查询时 对日期的比较
来源:互联网 发布:大鱼端口查看器 编辑:程序博客网 时间:2024/05/16 05:15
http://www.roseindia.net/hibernate/hibernate-between-date.shtml
Hibernate's Built-in criterion: Between (using with Date)
In this section, you will learn to use "between" i.e.one of the built-in hibernate criterions. Restriction class provides built-in criterion via static factory methods. One important method of the Restriction class is between : which is used to apply a "between" constraint to the named property
In this tutorial, "Between" is used with the date object. It takes three parameters e.g. between("property_name",startDate,endDate)
Here is the code of the class using "between" with the Date class :
package roseindia.tutorial.hibernate;
Download this code:
Output:
log4j:WARN No appenders could be found for logger (org.hibernate.cfg.Environment).
log4j:WARN Please initialize the log4j system properly.
Hibernate: select this_.ID as ID0_0_, this_.insurance_name as insurance2_0_0_, this_.invested_amount as invested3_0_0_,
this_.investement_date as investem4_0_0_ from insurance this_ where this_.investement_date between ? and ? limit ?
Hibernate's Built-in criterion: Between (using with Date)
In this section, you will learn to use "between" i.e.one of the built-in hibernate criterions. Restriction class provides built-in criterion via static factory methods. One important method of the Restriction class is between : which is used to apply a "between" constraint to the named property
In this tutorial, "Between" is used with the date object. It takes three parameters e.g. between("property_name",startDate,endDate)
Here is the code of the class using "between" with the Date class :
package roseindia.tutorial.hibernate;
- import org.hibernate.*;
- import org.hibernate.criterion.*;
- import org.hibernate.cfg.*;
- import java.text.DateFormat;
- import java.text.SimpleDateFormat;
- import java.util.*;
- /**
- * @author Deepak Kumar
- *
- * http://www.roseindia.net
- Hibernate Criteria Query Example
- *
- */public class HibernateCriteriaQueryBetweenDate {
- public static void main(String[] args) {
- Session session = null;
- try {
- // This step will read
- hibernate.cfg.xml and prepare hibernate for
- // use
- SessionFactory sessionFactory
- = new Configuration().configure()
- .buildSessionFactory();
- session = sessionFactory.openSession();
- //Criteria Query Example
- Criteria crit =
- session.createCriteria(Insurance.class);
- DateFormat format =
- new SimpleDateFormat("yyyy-MM-dd hh:mm:ss");
- Date startDate =
- (Date)format.parse("2005-01-01 00:00:00");
- Date endDate =
- (Date)format.parse("2005-03-03 00:00:00");
- crit.add(Expression.between
- ("investementDate", new Date(startDate.getTime()),
- new Date(endDate.getTime()))); //
- Between date condition
- crit.setMaxResults(5); //
- Restricts the max rows to 5
- List insurances = crit.list();
- for(Iterator it =
- insurances.iterator();it.hasNext();){
- Insurance insurance =
- (Insurance) it.next();
- System.out.println("
- ID: " + insurance.getLngInsuranceId());
- System.out.println("
- Name: " + insurance.getInsuranceName());
- System.out.println("
- Amount: " + insurance.getInvestementAmount());
- System.out.println("
- Date: " + insurance.getInvestementDate());
- }
- session.close();
- } catch (Exception e) {
- System.out.println(e.getMessage());
- } finally {
- }
- }
- }
Download this code:
Output:
log4j:WARN No appenders could be found for logger (org.hibernate.cfg.Environment).
log4j:WARN Please initialize the log4j system properly.
Hibernate: select this_.ID as ID0_0_, this_.insurance_name as insurance2_0_0_, this_.invested_amount as invested3_0_0_,
this_.investement_date as investem4_0_0_ from insurance this_ where this_.investement_date between ? and ? limit ?
- hibernate 查询时 对日期的比较
- Hibernate HQL查询中对日期的查询操作总结
- Hibernate HQL查询中对日期的查询操作总结
- SOQL数据查询时对日期的相关处理操作。
- sql 对日期查询
- mongodb对日期范围查询
- 对日期进行模糊查询
- Oracle对日期模糊查询
- ASP,javascript中对日期时间的比较
- sql server中对日期字段值的比较
- 应用hibernate中的hql语句对日期的操作总结
- SQL中对日期进行模糊查询的方法
- 三种数据库对日期格式的区间查询
- hibernate 中日期的比较
- 对日期的一些操作
- Date对日期的处理
- MDX对日期的操作
- SSH对日期的处理
- Ubuntu 10.04 右上角网络管理图标消失的解决办法
- 【转】微软CRM 2013 New Features 系列汇总
- 从数据库(mysql)存取图片
- 字符串函数注意事项
- 分页存储过程(Sql Server) (表名、当前页索引、每页显示行数,则返回 数据集和总页数)
- hibernate 查询时 对日期的比较
- SPOOLING技术
- myeclipse快捷键大全
- 【FTP服务器之】客户端c语言代码
- 2013-10-28,文件编码初探(留给自己看)
- 二叉树中找出和为某一值的所有路径
- linux ubuntu中文输入法安装
- Riding the Fences
- quartz 的简单应用