2016年01月_yangzhao6628

08月 07月 03月 02月 01月

原创 oracle模糊查询用法

SELECT *FROM Certificates cWHERE 1 = 1AND instr('130',c.IDCARD)>0ORDER BY c.certificatenum DESC

2016-01-27 19:41:34 438

原创 ORACLE case when查询语句用法

SELECT CE."ID",CE.OLDVALUE,CE."VALUE",CE.CERTIFICATEID,CASE CE.STATUSWHEN 1 THEN '勘误'WHEN 2 THEN '修改'WHEN 3 THEN '变更'END AS STATUS,CE.CREATETIME,US."NAME" FROM CERTIFICATE

2016-01-26 16:01:19 477

原创 oracle创建函数例子

create or replace function GETEXAMINEENAMEBYID(PARAM_ID NUMBER)return VARCHAR2isEXANNAME VARCHAR2(50);beginSELECT NAME into EXANNAME FROM EXAMINEE WHERE ID=PARAM_ID;return EXANNAME;end;

2016-01-26 14:44:55 519

原创 java字符串按照逗号分开

if (serviceCatepic.getPicIds() != null && !"".equals(serviceCatepic.getPicIds())) { StringTokenizer st = new StringTokenizer(serviceCatepic.getPicIds(),","); while(st.ha

2016-01-19 18:12:35 2294

原创 easyui初始化combobox

//状态初始化function statuscomboboxInit(){ statuscombobox = $('#status').combobox({ url : ctx + '/sysController/find.do', queryParams : { key: '003' },

2016-01-19 11:11:31 1086

原创 jsp判断是否存在List

移除

2016-01-19 10:42:23 351

原创 jquery清空form表单

$('#FormID').form('clear');

2016-01-19 09:51:34 754

原创 easyui异步

/** 号场列表 */var venueSiteDatagrid;/** 编辑状态 */var editRow = undefined;/** 场馆Id */var venueId;/** 名称 */var venueName;$(function() { venueId = $('#venueId').val(); venueName =

2016-01-12 19:45:49 446