摘要:
function ToDBC(obj) { var str = obj.value; var tmp = ""; for (var i = 0; i < str.length; i++) { if (str.charCodeAt(i) == 32) { //空格 32 tmp = tmp + Str 阅读全文
摘要:
1 play关联数据库时,驱动需要手动依赖 libraryDependencies ++= Seq( guice, jdbc, "com.h2database" % "h2" % "1.4.199", "com.google.code.gson" % "gson" % "2.3", "postgre 阅读全文
摘要:
BEGIN dbms_network_acl_admin.create_acl( acl => '随便起的名字.xml', description => '注释', principal => '数据库名字', --数据库用户名 ... 阅读全文
摘要:
create or replace procedure CMS_TO_ESB_INTEGRAL is --调用ESB积分错误是重发接口 http_req utl_http.req; http_resp utl_http.resp; request_env clob; l_replyline varchar2(2000); response_xml varchar2... 阅读全文
摘要:
select utl_raw.cast_to_varchar2(utl_encode.base64_encode(utl_raw.cast_to_raw('123456'))) from dual;select utl_raw.cast_to_varchar2(utl_encode.base64_d 阅读全文
摘要:
SELECT A.ORDER_ID,A.OP_DATE,row_number() OVER(PARTITION BY a.order_id ORDER BY A.op_date DESC) RN FROM TV_BU_BILL_RECORD A 阅读全文
摘要:
---批量删除重复数据 SQL -- delete from TT_VS_ORDER_HISTORY where HISTORY_ID in ( -- select HISTORY_ID from ( -- select count(1) num ,min(HISTORY_ID) HISTORY_ID, ORDER_ID, CHANGE_STATUS from TT... 阅读全文
摘要:
在软件eclipse下的Help->InstallNew Software->中,在Work with中点击Add。 添加 Name——"Kepler" repository; Location——http://download.eclipse.org/releases/kepler找到选项Web, 阅读全文
摘要:
var longitude = $("#dia-longitude").val(); var latitude = $("#dia-latitude").val(); var lon = /^-?((0|[1-9]\d?|1[1-7]\d)(\.\d{1,7})?|180(\.0{1,7})?)?$ 阅读全文
摘要:
//获取年月,最大日期 SimpleDateFormat format = new SimpleDateFormat("yyyy-MM-dd"); Calendar cal = Calendar.getInstance(); Date date = format.parse(a); cal.setT 阅读全文