摘要：
jpa,组合查询，模糊匹配 阅读全文
摘要：
public class DateUtil { private DateUtil(){ } public static final String hhmmFormat="HH:mm"; public static final String MMddFormat="MM-dd"; public sta 阅读全文
摘要：
这是在controller里面： String search = ""; if("null".equals(start_time)||"".equals(start_time)) search += " "; else{ search += " and to_char(A.create_time, 阅读全文
摘要：
SELECT rownum R, a.expert_id as USERID, a.expert_id as TYPE, b.type_desc as TYPE_DESC, a.sex as SEX, a.user_name as USERNAME, a.head_portrait as HEADP 阅读全文
摘要：
--查看一周随访的详情70007PROCEDURE GET_PATIENT_WEEKFU ( userId in NUMERIC, time in date, V_LIST OUT MYCURSOR )IS BEGIN OPEN V_LIST FOR SELECT ANSWERTEXT, OPTIO 阅读全文
摘要：
v_userId:=seq_user_id.nextval; --返回user_id --插入用户注册信息表 INSERT INTO t_user_register_info (USER_ID,ACCOUNT,PASSWORD,USER_TYPE_ID,CREATE_TIME) values(v_u 阅读全文
摘要：
--更新用户状态 PROCEDURE P_UPDATE_USER_STATUS ( v_SrcID IN NUMERIC, v_DstID IN NUMERIC, v_DstType IN NUMERIC, v_Offline IN NUMERIC ) IS BEGIN IF v_DstType=1 阅读全文
摘要：
create or replace package body CRF_CMS_DOCTOR_PKG is --根据医院查询医生PROCEDURE P_HOSPITALBYDOCTOR_LIST ( v_HOSPITAL_ID IN NUMERIC, v_DEPT_ID IN NUMERIC, v_J 阅读全文
摘要：
SELECT * FROM (SELECT USERID, TYPE, TYPE_DESC, SEX, USERNAME, HEADPORTRAIT, HOSPITAL, HLEVEL, DEPT, JOBTITLE, PRICE, TIME, INTRODUCE, ISFRIEND, ROWNUM 阅读全文