当前位置: 首页 > news >正文

ORM Bee,如何使用Oracle的TO_DATE函数?

ORM Bee,如何使用Oracle的TO_DATE函数?

在Bee V2.4.0,可以这样使用:

        LocaldatetimeTable selectBean=new LocaldatetimeTable();Condition condition=BF.getCondition();condition.op("localdatetime", Op.ge, new TO_DATE("2024-07-08", "YYYY-MM-DD"));List<LocaldatetimeTable> list=suidRich.select(selectBean,condition);Printer.printList(list);

日志:
 

[INFO] [Bee] -------- Bee    2.4.0 -------- 
[INFO] [Bee] -------- Honey  2.4.0 -------- 
[INFO] [Bee] -------- BeeExt 2.4.0 -------- 
[DEBUG] [Bee] ========= Bee    buildId  2.4.0.7
[DEBUG] [Bee] ========= Honey  buildId  2.4.0.7
[DEBUG] [Bee] ========= BeeExt buildId  2.4.0.7
[INFO] [Bee] ========= get the dbName via url is: Oracle
[INFO] [Bee] select SQL: select id,name,datetime,timestamp,localdatetime,ext,json from localdatetime_table where localdatetime>=TO_DATE(?, 'YYYY-MM-DD')   [values]: 2024-07-08(String)
[INFO] [Bee] select SQL:  ( ExecutableSql )
select id,name,datetime,timestamp,localdatetime,ext,json from localdatetime_table where localdatetime>=TO_DATE('2024-07-08', 'YYYY-MM-DD') ;
[DEBUG] Use OriginalConn!
[INFO] [Bee]  | <--  select rows: 2
[INFO] LocaldatetimeTable[id=12,name=null,datetime=null,timestamp=null,localdatetime=2024-07-08T23:55:35.534,ext=null,json=null]
[INFO] LocaldatetimeTable[id=13,name=null,datetime=null,timestamp=null,localdatetime=2024-07-08T23:56:01.521,ext=null,json=null]

condition.op("localdatetime", Op.ge, new TO_DATE("2024-07-08", "YYYY-MM-DD"));

对应SQL:

//where localdatetime>=TO_DATE('2024-07-08', 'YYYY-MM-DD') ;


select * from ORDERS where total between 20 and 94
与
select * from ORDERS where total>=20 and total<=94
是等价的.

以下是Java的例子.

public class LocalDateTimeExam3 {public static void main(String[] args) throws Exception {LocaldatetimeTable bean = new LocaldatetimeTable();bean.setId(10);
//		bean.setLocaldatetime(LocalDateTime.now());bean.setTimestamp(new Timestamp(System.currentTimeMillis()));SuidRich suidRich = BF.getSuidRich();
//		int a=suidRich.insert(bean);
//		Logger.info("insert num:"+a);LocaldatetimeTable selectBean = new LocaldatetimeTable();Condition condition = BF.getCondition();condition.op("localdatetime", Op.ge, new TO_DATE("2024-07-08", "YYYY-MM-DD"));List<LocaldatetimeTable> list = suidRich.select(selectBean, condition);Printer.printList(list);String dateString = "2024-07-08T23:55:35.534";SimpleDateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd'T'HH:mm:ss.SSS");Date parsedDate = dateFormat.parse(dateString);Timestamp timestamp = new Timestamp(parsedDate.getTime());
//	        System.out.println("Timestamp in Java format: " + timestamp);condition = BF.getCondition();condition.op("localdatetime", Op.ge, timestamp);condition.op("localdatetime", Op.le, timestamp); //改为另一个timestamp的值即可list = suidRich.select(selectBean, condition);Printer.printList(list);}

使用到:

	/*** Add a expression condition.* <br>This method cannot be used for SQL update set part.* <br>When Op type is Op.in/Op.notIn,Object type can be List,Set,Number,Number[],String.* @param field Field name* @param op operator* @param value Value of the field.* @return Condition*/public Condition op(String field, Op op, Object value);

日志:
 

[INFO] [Bee] -------- Bee    2.4.0 -------- 
[INFO] [Bee] -------- Honey  2.4.0 -------- 
[INFO] [Bee] -------- BeeExt 2.4.0 -------- 
[DEBUG] [Bee] ========= Bee    buildId  2.4.0.7
[DEBUG] [Bee] ========= Honey  buildId  2.4.0.7
[DEBUG] [Bee] ========= BeeExt buildId  2.4.0.7
[INFO] [Bee] ========= get the dbName via url is: Oracle
[INFO] [Bee] select SQL: select id,name,datetime,timestamp,localdatetime,ext,json from localdatetime_table where localdatetime>=TO_DATE(?, 'YYYY-MM-DD')   [values]: 2024-07-08(String)
[INFO] [Bee] select SQL:  ( ExecutableSql )
select id,name,datetime,timestamp,localdatetime,ext,json from localdatetime_table where localdatetime>=TO_DATE('2024-07-08', 'YYYY-MM-DD') ;
[DEBUG] Use OriginalConn!
[INFO] [Bee]  | <--  select rows: 2
[INFO] LocaldatetimeTable[id=12,name=null,datetime=null,timestamp=null,localdatetime=2024-07-08T23:55:35.534,ext=null,json=null]
[INFO] LocaldatetimeTable[id=13,name=null,datetime=null,timestamp=null,localdatetime=2024-07-08T23:56:01.521,ext=null,json=null]
[INFO] [Bee] select SQL: select id,name,datetime,timestamp,localdatetime,ext,json from localdatetime_table where localdatetime>=? and localdatetime<=?   [values]: 2024-07-08 23:55:35.534(java.sql.Timestamp),2024-07-08 23:55:35.534(java.sql.Timestamp)
[INFO] [Bee] select SQL:  ( ExecutableSql )
select id,name,datetime,timestamp,localdatetime,ext,json from localdatetime_table where localdatetime>=2024-07-08 23:55:35.534 and localdatetime<=2024-07-08 23:55:35.534 ;
[INFO] [Bee]  | <--  select rows: 1
[INFO] LocaldatetimeTable[id=12,name=null,datetime=null,timestamp=null,localdatetime=2024-07-08T23:55:35.534,ext=null,json=null]

http://www.lryc.cn/news/398469.html

相关文章:

  • HTML CSS 基础复习笔记 - 框架、装饰、弹性盒子
  • C++:创建线程
  • python如何查看类的函数
  • P6. 对局列表和排行榜功能
  • uniapp easycom组件冲突
  • 总结24个Python接单赚钱平台与详细教程,兼职月入5000+
  • macOS 的电源适配器设置
  • 视觉SLAM与定位之一前端特征点及匹配
  • 开源项目的认识理解
  • 37.哀家要长脑子了!--层序遍历
  • 【从零开始AI绘画6】StableDiffusionWebUI拓展的安装方法以及推荐的几个拓展
  • HTML5表单的自动验证、取消验证、自定义错误信息
  • SpringMVC系列九: 数据格式化与验证及国际化
  • 判断链表中是否有环(力扣141.环形链表)
  • Kubernetes基于helm部署jenkins
  • 【Linux】vim详解
  • Android11 mtk 第二次设置壁纸,锁屏壁纸不变的问题
  • Java学习路线
  • java 实现人脸检测
  • VSCode神仙插件——Codeium (AI编程助手)
  • css文本划线效果(text-decoration相关属性详解)
  • 《Windows API每日一练》8.5 listbox控件
  • 使用Node.js 框架( Express.js)来创建一个简单的 API 端点
  • 企业服务行业CRM解决方案
  • 服务器怎么进PE系统?
  • Linux内核编译与调试menuos-linux-3.18.6-在ubuntu20.04环境
  • java-mysql 三层架构
  • 打工人如何应对AI对工作岗位的风险
  • C++:从C语言过渡到C++
  • 在安卓中使用FFmpeg录制摄像头的视频并保存到本地MP4文件