ibaits基本代码范例

1、1：注入ibatis的jar 2：对应的配置=#startDate# and rptdtentry=#startDate# and r.rptdtentry=#startDate# and tr.rptdtentryinsert intotempreport(seccode,rpttitle,rptDtpublish,pdf_url,rptinst,rptcode)values(#seccode#,#rpttitle#,#rptDtpublish#,#pdf_url#,#rptinst#,#rptcode#)3=#startDate# and downDate=#dateAfter5PM# a

2、nd downDate select id as id,url as url,downDate as downDate,downSuccess as downSuccess,downPath as downPath,ybYear as ybYear,ybMonth as ybMonth,ybDay as ybDay,ybJG as ybJG,ybTitle as ybTitle,seccode as seccode,rptcode as rptcodefrom historyorder by id descselect id as id from history where url=#url#

3、select * from history where downSuccess=0insert intohistory(url,downSuccess,downPath,ybYear,ybMonth,ybDay,ybJG,ybTitle,seccode,rptcode)values(#url#,#downSuccess#,#downPath#,#ybYear#,#ybMonth#,#ybDay#,#ybJG#,#ybTitle#,#seccode#,#rptcode#)update historyset downSuccess=1where id=#id#4public class Histo

4、ryService private HistoryService() public static List getAllHistories() List histories = new ArrayList();SqlMapClient sqlMap = CommApp.getSqlMap();if(sqlMap != null) try histories = sqlMap.queryForList(getAllHistories);catch(Exception ex) ex.printStackTrace();return histories;5public static Stat get

5、OneDayStat(String date) Stat stat = null;if(date != null & !date.equals() stat = new Stat();stat.setCur_date(date);QueryParams params = new QueryParams();SqlMapClient sqlMap = CommApp.getSqlMap();try params.setStartDate(date + 00:00:00);params.setEndDate(date + 23:59:59);Integer cur_getAmount = (Int

6、eger)sqlMap.queryForObject(getCurGetAmount, params);stat.setCur_getAmount(cur_getAValue();Integer cur_inputAmount = (Integer)sqlMap.queryForObject(getCurInputAmount, params);stat.setCur_inputAmount(cur_inputAValue();Integer inputAmount = (Integer)sqlMap.queryForObject(getInputAmoun

7、t, params);stat.setInputAmount(inputAValue();Integer avgInputTD = (Integer)sqlMap.queryForObject(getAvgInputTD, params);if(avgInputTD = null)stat.setAvgInputTD(0);elsestat.setAvgInputTD(avgInputTD.intValue();params.setDateAfter5PM(date + 17:00:00);Integer cur_getAmountAfter5PM = (Integer)sqlMap.queryForObject(getCurGetAmountAfter5PM, params);stat.setCur_ge