郭清明
- 浏览: 17612 次
- 性别:
- 来自: 深圳
-
最新评论
文章列表
/*将xx.tld文件引入JSP，在页面上写
*<page:pageTag name="userForm" property="page" method="getUserInfo" zone="sResult,editZone"/>
*/
public class PageTag extends TagSupport {//继承自TagSupport
private String name;
private String property;
private String scope;
pr ...
lag()/lead():获取当前记录指定距离的记录信息
lag():往前推
lead():往后推
--时间更加精确，确保唯一性--
select supplier_id from (
select v1.supplier_id,
lag(v1.LAST_UPDATE_DATE) over(order by v1.LAST_UPDATE_DATE desc,v1.SUPPLIER_ID) maxdate
from BAS_SUPPLIER_V v1
where v1.ENTITY_ID = '1330')
where maxdate is null;
...
--condition--
create table t1(id int);
create table t2(id int);
create table t3(id int);
create or replace package aa_test is
-- Author : tom
-- Created : 2010-5-10 17:04:24
-- Purpose :
type tom_re is record(
id t1.id%type);
type tom_insert_tab is table of tom_re index by binary_ ...
-- Public type declarations
TYPE tp_insert_line_rec IS RECORD(
icas_selected_lines_t_id icas_selected_lines_t.icas_selected_lines_t_id%TYPE,
transactionflow_id icas_selected_lines_t.transactionflow_id%TYPE,
transaction_id icas_selected_lines_t.transaction_id%TYPE,
ap ...
注：此SQL原作者 袁老大
CREATE OR REPLACE PACKAGE split_pck IS
type char_table is table of varchar2(4000);
function split_string(pi_str in varchar2, pi_separator in varchar2) return char_table;
procedure test_split_string(pi_string in varchar, pi_separator in varchar2);
end split_pck;
CREATE OR REPLACE ...
一、 前提条件
1、在使用定时调度平台必须依赖2个jar包doccrytpe.jar，Schedule.jar（最好放在web项目中的lib下）
二、具体操作
doccrytpe.jar：用来加密解密的组件。
Schedule.jar:平台所提供的包，个应用系统中所需被调度的servlet必须要继承里面的
ScheduleServlet，并且需要覆盖其中的2个抽象方法。
方法一boolean doOtherMethod(HttpServletRequest request, HttpServletResponse response)
此方法为servlet具体所执行的逻辑业务代码。执行完成后，成 ...
PROCEDURE GET_PAYMENT_INVOICE(P_VENDOR_ID NUMBER, --普通输入参数
P_PAYMENT_METHOD VARCHAR2,
......
P_ORDERCOLUMN VARCHAR2,--排序的行
P_ORDERTYPE VARCHAR2,--升序OR降序
...
- 2009-11-25 09:39
- 浏览 572
- 评论(0)
/*------------------------------------------------------------------\
| AUTHOR : yapi
| CREATED : 2009-11-23
| PURPOSE : 2A1_SQL:报关价格
\------------------------------------------------------------------*/
PROCEDURE query_pips_2a1( p_datefrom varchar2,
p_dat ...
- 2009-11-23 10:13
- 浏览 866
- 评论(0)
<div id="des4c1a"
<%
int a=0;
String dis4c1a=(String)request.getAttribute("typeSelect");
if(dis4c1a.equals("4c1a")){ %>
style="display:"
<%}else{ %>style="display:none"
<%} %>>
...
</div>
<div id="des4c1b" ...
- 2009-11-23 09:04
- 浏览 661
- 评论(0)
import java.util.regex.Pattern;
/**
* 检日期
* @param value
* @param datePattern
* @return
*/
public static boolean validateDate(String value) {
Pattern p = Pattern.compile("^((\\d{2}(([02468][048])|([13579][26]))[\\/\\/\\s]?((((0?" +
"[13578])|(1[02]))[\\/\\/ ...
- 2009-11-17 10:23
- 浏览 778
- 评论(0)
CREATE OR REPLACE PACKAGE BODY icas_insert_line_pkg IS
-- Function and procedure implementations
FUNCTION f_get_currency(iv_company_code IN VARCHAR2) RETURN VARCHAR2 IS
v_func_currency VARCHAR2(15) := '-1'; --中间币种--
BEGIN
--先查出中间币种--
SELECT t.functional_currency_code
INTO v_ ...
- 2009-11-05 10:42
- 浏览 743
- 评论(0)
order by seqno nulls last--空滞后--
//分页自定义标签
import javax.servlet.http.HttpServletRequest;
import javax.servlet.jsp.JspException;
import javax.servlet.jsp.JspTagException;
import javax.servlet.jsp.JspWriter;
import javax.servlet.jsp.tagext.TagSupport;
import org.apache.struts.util.RequestUtils;
imp ...
- 2009-10-12 22:37
- 浏览 654
- 评论(0)
SELECT id
,currencyCode
,(CASE WHEN total<=3 THEN amount ELSE (3 - last_total)/conversion_rate END) AS target_amount
,(CASE WHEN total<=3 THEN target_amount ELSE 3 - last_total END) AS target_amount
FROM (
SELECT t.*
,t.amount*r.conversion_rate as target_amount
...
- 2009-09-10 23:42
- 浏览 959
- 评论(0)
select main.* ,nvl((select nvl(conversion_rate,1)
from icas_base_daily_rates_temp
where from_currency=main.org_currency and upper(to_currency)='USD'
and conversion_date=to_date('2009-9-10', 'YYYY-MM-DD')),1) rate
from
(select id,total,amount,
(case when total<=3 then amount ...
- 2009-09-10 19:11
- 浏览 1386
- 评论(0)
VAR v_target NUMBER;
EXEC :v_target := 10;
SELECT id,amount,(CASE WHEN total<=:v_target THEN amount ELSE :v_target - last_total END) AS selected_amount
FROM (
SELECT t.*
,SUM(amount) OVER(ORDER BY amount,id) as total
,SUM(amount) OVER(ORDER BY amount,id) - amount as last_total
FR ...
- 2009-09-09 23:11
- 浏览 812
- 评论(0)