seikyulogic.java

用strutshibernate做的项目

			 */
			int nowyear = Integer.parseInt(nowdatetime.substring(0,4));
			int nowmonth = Integer.parseInt(nowdatetime.substring(5,7));
			int nowday = Integer.parseInt(nowdatetime.substring(8,10));
			int nowhh = Integer.parseInt(nowdatetime.substring(11,13));
			int nowmm = Integer.parseInt(nowdatetime.substring(14,16));
			int nowss = Integer.parseInt(nowdatetime.substring(17,19));
			
			/*
			 * 查询数据库中记录的修改时间
			 */
			String sqlstr = "SELECT UPDATE_DATE FROM SEIKYU "
							+ "WHERE TAISYO_FLG = 1 "
							+ "AND KETTEI_FLG = 0 "
							+ "AND DEL_FLG = 0"
							+" ORDER BY ID DESC,"
							+ "NEN DESC,"
							+ "HAGAKI_ID ASC,"
							+ "TOUKYU_ID ASC,"
							+ "BANGOU ASC";
			List Datelist = Seikyu.getUpdate_Date(sqlstr);
			Iterator it = Datelist.iterator();
			
			/*
			 * 逐条判断日期是否正确
			 */
			while(it.hasNext()){
				/*
				 * 获取数据库中记录的修改时间
				 * 并分割为年、月、日进行判断
				 */
				String update = (String)it.next();
				int upyear = Integer.parseInt(update.substring(0,4));
				int upmonth = Integer.parseInt(update.substring(5,7));
				int upday = Integer.parseInt(update.substring(8,10));
				int uphh = Integer.parseInt(update.substring(11,13));
				int upmm = Integer.parseInt(update.substring(14,16));
				int upss = Integer.parseInt(update.substring(17,19));
				if(nowyear < upyear){
					flag = true;
				}
				else if(nowyear == upyear){
					if(nowmonth < upmonth){
						flag = true;
					}
					else if(nowmonth == upmonth){
						if(nowday < upday){
							flag = true;
						}
						else if(nowday == upday){
							if(nowhh < uphh){
								flag = true;
							}
							else if(nowmm == upmm){
								if(nowss < upss){
									flag = true;
								}
							}
						}
					}
				}
			}
			return flag;
		}
		
		
		/**
		 * 该函数用于更新Seikyu表
		 * 将操作结果返回
		 * @return String
		 * @author� 杨丽娟 2006-04-17
		 */
		public String updateTable(){
			String message = null;
			String sqlstr = "UPDATE SEIKYU SET KETTEI_FLG = 1 "
							+ "WHERE TAISYO_FLG = 1 "
							+ "AND KETTEI_FLG = 0 "
							+ "AND DEL_FLG = 0";
			BatchDBConnectionUtil con = new BatchDBConnectionUtil();
			message = con.executeUpdate(sqlstr);
			con.close();
			return message;
		}
		
		
		/**
		 * 该函数用于获得组信息List
		 * @param NEN 年
		 * @param HAGAKI 葉書区分
		 * @param KUMI_KUBUN 组番号
		 * @return List
		 * @author �杨丽娟 2006-04-14
		 */
		public List getKUMI(String NEN, String HAGAKI_ID, String KUMI_KUBUN){
			List KumiList = new ArrayList();
			int nen = Integer.parseInt(NEN);
			int hagaki = Integer.parseInt(HAGAKI_ID);
			int kumi_kubun = Integer.parseInt(KUMI_KUBUN);
			String sqlstr = "SELECT * FROM KUMI "
							+ "WHERE NEN = " + nen
							+ " AND HAGAKI_ID = " + hagaki
							+ " AND KUMI_KUBUN = " + kumi_kubun;
			KumiList = Kumi.getKumiData(sqlstr);
			return KumiList;
		}
		
		/**
		 * 该函数用于获得Kensyou表的信息List
		 * @param NEN
		 * @param HAGAKI_ID
		 * @param TOUKYU_ID
		 * @return List
		 * @author 杨丽娟 2006-04-14
		 */
		public List getKensyou(String NEN, String HAGAKI_ID, String TOUKYU_ID){
			List KensyouList = new ArrayList();
			int nen = Integer.parseInt(NEN);
			int hagaki = Integer.parseInt(HAGAKI_ID);
			int toukyu = Integer.parseInt(TOUKYU_ID);
			String sqlstr = "SELECT * FROM KENSYOU "
							+ "WHERE NEN = " + nen
							+ " AND HAGAKI_ID = " + hagaki
							+ " AND TOUKYU_ID = " + toukyu;
			KensyouList = Kensyou.getKensyouData(sqlstr);
			return KensyouList;
		}
		
		/**
		 * 该函数用于获得KENSYOU表信息List
		 * @param NEN
		 * @param HAGAKI_ID
		 * @param TOUKYU_ID
		 * @return List
		 * @author� 杨丽娟 2006-04-14
		 */
		public List getTousen(String NEN, String HAGAKI_ID, String TOUKYU_ID){
			List TousenList = new ArrayList();
			int nen = Integer.parseInt(NEN);
			int hagaki = Integer.parseInt(HAGAKI_ID);
			int toukyu = Integer.parseInt(TOUKYU_ID);
			String sqlstr = "SELECT * FROM KENSYOU "
							+ "WHERE NEN = " + nen
							+ " AND HAGAKI_ID = " + hagaki
							+ " AND TOUKYU_ID = " + toukyu;
			TousenList = Tousen.getTousenDate(sqlstr);
			return TousenList;
		}
		
		/**
		 * 该函数用于获得赏品名略称
		 * @param NEN
		 * @param HAGAKI_ID
		 * @param TOUKYU_ID
		 * @param SYOUHIN_ID
		 * @return Strig
		 * @author� 杨丽娟 2006-04-14
		 */
		public String getSyouhin_ryaku(String NEN, String HAGAKI_ID, String TOUKYU_ID, String SYOUHIN_ID){
			String Syouhin_ryaku = null;
			int nen = Integer.parseInt(NEN);
			int hagaki = Integer.parseInt(HAGAKI_ID);
			int toukyu = Integer.parseInt(TOUKYU_ID);
			int syouhin = Integer.parseInt(SYOUHIN_ID);
			Syouhin_ryaku = Syouhin.selectSyouhin_ryaku(nen,hagaki,toukyu,syouhin);
			return Syouhin_ryaku;
		}
		
		/**
		 * 该函数用于获得葉書区分名称
		 * @param HAGAKI_ID
		 * @return String
		 * @author� 杨丽娟 2006-04-20
		 */
		public String getHagaki_mei(String HAGAKI_ID){
			String hagaki_mei = null;
			int hagaki_id = Integer.parseInt(HAGAKI_ID);
			hagaki_mei = Hagakicd.selectHagaki_mei(hagaki_id);
			return hagaki_mei;
		}
		
		/**
		 * 该函数用于获得等级名称
		 * @param TOUKYU_ID
		 * @return String
		 * @author� 杨丽娟 2006-04-20
		 */
		public String getToukyu_mei(String TOUKYU_ID){
			String toukyu_mei = null;
			int toukyu_id = Integer.parseInt(TOUKYU_ID);
			toukyu_mei = Toukyucd.selectToukyu_mei(toukyu_id);
			return toukyu_mei;
		}
		
		/**
		 * 该函数用于向Seikyo表插入数据
		 * 返回操作信息
		 * @param seikyuInputActionForm
		 * @param KUMI
		 * @param KEN_ID
		 * @param KYOKU_ID
		 * @param SEIKYU_DATE
		 * @return String
		 * @author �杨丽娟 2006-04-14
		 */
		public static String insertSeikyo(SeikyuInputActionForm form, String ken_id, String kyoku_id) {
			
			int NEN = Integer.parseInt(DataTypeCheck.HeliToXili(form.getNian()));
			int HAGAKI_ID = Integer.parseInt(form.getYeshuqufen());
			int ID = Seikyu.getMaxID()+1;
			int TOUKYU_ID = Integer.parseInt(form.getDengji());
			String BANGOU = form.getKujifanhao();
			int KUMI_KUBUN = 5;
			int KEN_ID = 0;
			String KUMI = form.getZu();
			if(ken_id == null || ken_id.trim().equals("")){
				return "errors";
			}
			else{
				KEN_ID = Integer.parseInt(ken_id);
			}
			String KYOKU_ID = null;
			if(kyoku_id == null || kyoku_id.trim().equals("")){
				return "errors";
			}
			else{
				KYOKU_ID = kyoku_id;
			}
			int SYOUHIN_ID = Integer.parseInt(form.getShangpinkodo());
			String SEIKYU_DATE = form.getDengludate();
			int REPORT_FLG = 0;
			int TAISYO_FLG = 1;
			int KETTEI_FLG = 0;
			int SIJI_FLG = 0;
			int HASSOU_FLG = 0;
			int H_JITAKU = 1;
			String psff = form.getPeisongfangfa();
			if(psff.trim().equals("���Ǒ���")){
				H_JITAKU = 0;
			}
			int H_ZIPCD_MAE = Integer.parseInt(form.getQianyoubianfanhao());
			int H_ZIPCD_ATO = Integer.parseInt(form.getHouyoubianfanhao());
			String H_ATENA = form.getShiming();
			String H_JUSYO = form.getZhusuo();
			String H_TEL = form.getDianhuafanhao();
			int DEL_FLG = 0;
			String INSERT_DATE = form.getDengludate();
			SimpleDateFormat date = new SimpleDateFormat("yyyy-MM-dd hh:mm:ss");
			String UPDATE_DATE = date.format(new java.util.Date());
			 
			String H_SITEI_DATE = form.getPeidazhidingdate();
			if(H_SITEI_DATE == null || H_SITEI_DATE.trim().equals("")){
				SimpleDateFormat ff = new SimpleDateFormat("yyyy-MM-dd");			
				H_SITEI_DATE = ff.format(new java.util.Date());
			}
			String sqlstr = "INSERT INTO SEIKYU(NEN,HAGAKI_ID,ID,TOUKYU_ID,BANGOU,KUMI_KUBUN,KUMI,KEN_ID,"
							+"KYOKU_ID,SYOUHIN_ID,SEIKYU_DATE,REPORT_FLG,TAISYO_FLG,KETTEI_FLG,SIJI_FLG,"
							+"HASSOU_FLG,H_JITAKU,H_ZIPCD_MAE,H_ZIPCD_ATO,H_ATENA,H_JUSYO,H_TEL,DEL_FLG,"
							+"INSERT_DATE,UPDATE_DATE,H_SITEI_DATE)"
							+ " VALUES("
							+ NEN
							+ ","
							+ HAGAKI_ID
							+ ","
							+ ID
							+ ","
							+ TOUKYU_ID
							+ ","
							+ "'" + BANGOU + "'"
							+ ","
							+ KUMI_KUBUN
							+ ","
							+ "'" + KUMI + "'"
							+ ","
							+ KEN_ID
							+ ","
							+ "'" + KYOKU_ID + "'"
							+ ","
							+ SYOUHIN_ID
							+ ","
							+ "'" + SEIKYU_DATE + "'"
							+ ","
							+ REPORT_FLG
							+ ","
							+ TAISYO_FLG
							+ ","
							+ KETTEI_FLG
							+ ","
							+ SIJI_FLG
							+ ","
							+ HASSOU_FLG
							+ ","
							+ H_JITAKU
							+ ","
							+ H_ZIPCD_MAE
							+ ","
							+ H_ZIPCD_ATO
							+ ","
							+ "'" + H_ATENA + "'"
							+ ","
							+ "'" + H_JUSYO + "'"
							+ ","
							+ "'" + H_TEL + "'"
							+ ","
							+ DEL_FLG
							+ ","
							+ "'" + INSERT_DATE + "'"
							+ ","
							+ "'" + UPDATE_DATE + "'"
							+ ","
							+ "'" + H_SITEI_DATE + "'" + ")";

			System.out.println("TTTTTT>>" + sqlstr);
			String Insertflag = new BatchDBConnectionUtil()
					.executeUpdate(sqlstr);		
			return Insertflag;
		}
		
		
		/**
		 * 该函数用于查询要删除的信息
		 * @param mainkey 信息主键
		 * @return List
		 * @author� 杨丽娟 2006-04-19
		 */
		public List getDeleteDateList(String mainkey){
			List DeleteDateList = new ArrayList();
			int nen = Integer.parseInt(mainkey.substring(0,4));
			int hagaki_id = Integer.parseInt(mainkey.substring(4,5));
			int id = Integer.parseInt(mainkey.substring(5));
			SeikyuLogic logic = new SeikyuLogic();
			String sqlstr = "SELECT * FROM SEIKYU "
							+ "WHERE NEN = " + nen
							+ " AND HAGAKI_ID = " + hagaki_id
							+ " AND ID = " + id;
			DeleteDateList = Seikyu.getBeanList(sqlstr);
			return DeleteDateList;	
		}
		
		/**
		 * 该函数用于删除数据
		 * 返回操作信息
		 * @return String
		 * @author 杨丽娟 2006-04-19
		 */
		public String deleteSeikyuData(String mainkey){
			int nen = Integer.parseInt(mainkey.substring(0,4));
			int hagaki_id = Integer.parseInt(mainkey.substring(4,5));
			int id = Integer.parseInt(mainkey.substring(5));
			String sqlstr = "UPDATE SEIKYU "
							+ "SET DEL_FLG = 1 "
							+ "WHERE NEN = " + nen
							+ " AND HAGAKI_ID = " + hagaki_id
							+ " AND ID = " + id;
			String Deleteflag = new BatchDBConnectionUtil()
										.executeUpdate(sqlstr);
			return Deleteflag;
		}

}