DAO£º
package com.gxjs.DAO;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import util.DBException;
import util.DataBaseDAO;
import com.gxjs.model.CheckMonM;
public class CheckMonDAO {
public ArrayList getCheckMon(String beginDay,String endDay, DataBaseDAO dataBaseDAO) throws DBException{
ArrayList arrayList= new ArrayList();
CheckMonM checkMonM;
//½¨Á¢½á¹û¼¯
ResultSet rs=null;
String strSql="select a.raw_file_name,a.record_count record_count1,a.record_normal record_normal1,b.record_count record_count2,b.record_normal record_normal2,c.record_count record_normal3,c.deal_time from log_analyse_sum a, log_billing_sum b, log_sum c ";
strSql=strSql + " where c.deal_time between TO_CHAR(TO_DATE('"+beginDay+"', 'YYYY-MM-DD'), 'YYYYMMDD') AND";
strSql=strSql + " TO_CHAR(TO_DATE('"+endDay+"', 'YYYY-MM-DD'), 'YYYYMMDD') and rownum<100 ";
System.out.println(strSql);
//È¡µÃ½á¹û¼¯
rs=dataBaseDAO.executeQuery(strSql);
try {
while(rs.next()){
checkMonM=new CheckMonM();
checkMonM.setRawfileName(rs.getString("raw_file_name"));
checkMonM.setRecordCount1(rs.getLong("record_count1"));
checkMonM.setRecordNormal1(rs.getLong("record_normal1"));
Ò»¸öJSPÒ³Ãæ½ÓÊÕÆäËûÒ³ÃæÌá½»¹ýÀ´µÄFORM±íµ¥£¬µ«ÊÇÒªÇóÖ»½ÓÊÕµ±Ç°Õ¾µã¼°Æä×ÓÕ¾µãÌá½»¹ýÀ´µÄFORM±íµ¥£¬ÆäËûÕ¾µãÌá½»¹ýÀ´µÄ±íµ¥²»½ÓÊÕ£¬Õâ¸öÔõôÉèÖã¿
ÓùýÂËÆ÷
filter
½«µ±Ç°Õ¾µã¼°Æä×ÓÕ¾µã·ÅÒ»¸öĿ¼
È» ......
tableÔõô°ó¶¨Êý¾Ý¿â£¬²¢ÇÒÓÃJavaScriptʵÏÖ·Ò³¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£JavaScriptÄÜÏòJSPÒ³Ãæ´«µÝ²ÎÊýÂð
Äã˵µÄÎÊÌâÓеãÄǸö¡£¡££¬²»ºÃ»Ø´ð¡£¡£¡£¡£
jspÖÐtableÊÇÐèÒªhtml´úÂëÓëÒ³Ãæ¶Ë»ñÈ¡Êý¾Ý¿â²éѯºóµÄÐÅÏ¢½øÐÐ ......
insert into [ScholarshipManagement].[dbo].[department] ([department],[specialization] ,[grade]) output inserted.departmentID values(? ,? ,? )
ÇëÎÊ´ó¸çÃÇÕâ¸ösql Óï¾äÓ¦¸ÃÓÃJavaÀïµÄÄǸöÊý¾Ý¿â²Ù×÷·½·¨£¿ ......