10 2016 档案
在controller写sql在mapper拼接
摘要：这是在controller里面： String search = ""; if("null".equals(start_time)||"".equals(start_time)) search += " "; else{ search += " and to_char(A.create_time,
阅读全文
sql中关于case when的一个例子
摘要：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
阅读全文
查询一周最近一周的数据，date String 随意转换，更有疯狂的排序
摘要：--查看一周随访的详情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
阅读全文
存储过程中update,然后用sql%判断update是否成功的存储过程
摘要：--更新用户状态 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
阅读全文
存储过程中拼接sql的示例
摘要：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
阅读全文
一条带分页的sql
摘要：SELECT * FROM (SELECT USERID, TYPE, TYPE_DESC, SEX, USERNAME, HEADPORTRAIT, HOSPITAL, HLEVEL, DEPT, JOBTITLE, PRICE, TIME, INTRODUCE, ISFRIEND, ROWNUM
阅读全文
一个读取propeties配置文件的工具类，线程安全的
摘要：public class ConfigUtil { private static Map<String,Properties> map = new HashMap<String,Properties>(); /** * 根据Properties文件名称获取Properties对象 * @param
阅读全文
一个用httpPost,get访问外网接口,参数json,返回json的示例
摘要：package com.royal.util; import java.io.BufferedReader;import java.io.DataInputStream;import java.io.DataOutputStream;import java.io.File;import java.i
阅读全文
几个强大的oracle自带函数，可根据日期算年纪，根据数值匹配字段
摘要：select A.USER_NAME, decode(A.SEX, 1, '男', 2, '女'）AS SEX, A.HEAD_PORTRAIT, TRUNC(months_between(sysdate, A.BIRTHDAY) / 12) || '岁' AS BIRTHDAY, Z.DISEAS
阅读全文
sql对日期的处理，一个存储过程示例
摘要：IF v_docType = 3 THEN update T_PATIENT_INFO set USER_NAME =userName ,SEX = v_sex,BIRTHDAY = to_date(brithday,'YYYYMMDD'), ID_NUMBER = idNumber,PROVINC
阅读全文
一条sql,有分页，表合并查询，多表连接，用于oracle数据库
摘要：SELECT * FROM ( SELECT TT.*,ROWNUM RN FROM ( SELECT A.CASE_ID AS TREATID, A.TYPE AS TYPE, B.CONTENT AS CONTENT, B.ADD_USER_ID AS ADDUSERID, B.Add_User
阅读全文
