IBelieve的专栏

----------------------此处的property顺序不能乱改要和存储过程里变量的顺序一致                   property="DATA" javaType="java.sql.ResultSet" resultMap="out_ResultMap"/>     {call sp_ypjg_cgdcx(?,?,?)}

startDate  endDate  传如为日期类型            Select * From (             Select * From (   SELECT rownum as rowIndex,       t.requestid,       t.requcode,          pkg_bshis_common

CREATE OR REPLACE PROCEDURE SP_REPORT_DBZ_HZCX( as_date_b   date,                                                as_date_e   date,                                                ai_dbzid    numeri

INSERT INTO HOSP_CWDMB  (BEDID,   OFFICEID,   CWH,   FJH,   BQ_OFFICEID,   DOCTID,   XBXZ,   HOSPID,   CWLB,   MEDIID,   ISZC,   FORGID,   FRCODE,   INDATE)VALUES  (222

Map map = new HashMap();   map.put("pathdylist", pathdylist);   map.put("FORGID", forgid);  getPathDyDAOImpl().deleteCpinf(map);         begin          delete cp_base_pgdy t where

Map map = new HashMap();   map.put("pathdylist", pathdylist);   map.put("FORGID", forgid);  List codes = getPathDyDAOImpl().queryPathdy(map);  sqlmap里这样写         select t.pathc