`
conquer0
  • 浏览: 76580 次
  • 性别: Icon_minigender_1
  • 来自: 广州
文章分类
社区版块
存档分类
最新评论

js禁用右键

阅读更多
<body oncontextmenu="return false;">

//获取客户端IP,格式:"217.199.184.144";
String userIp=request.getRemoteAddr();

ORACLE按照拼音,部首,笔画排序   http://uiiang.iteye.com/blog/312324,比如:
    select distinct product as item_id, t.item_name
      from sup_kc_doc_unite_info
      left join sup_dict_item t on product = t.item_id
                               and t.nls_lang = #nlsLang#
     where product_family = #itemId#
       and web_site_lang = #nlsLang#
       and product is not null
     order by nlssort(t.item_name, 'NLS_SORT=SCHINESE_PINYIN_M') asc

oracle触发器写法:
create or replace trigger t_sup_kc_doc_basic_info_del
before delete
on SUP_KC_DOC_BASIC_INFO
for each row
begin

     IF DELETING THEN
        --关联删除--
         delete from sup_kc_doc_unite_info t
         where t.web_doc_id = :OLD.web_doc_id;

     END IF;

end t_sup_kc_doc_basic_info_del;
分享到:
评论

相关推荐

Global site tag (gtag.js) - Google Analytics