runtask.java

酒店管理系统·可用于一般旅社的营业操作。方便你的酒店管理

/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

package com.redingsoft.timeutil;

import com.redingsoft.openroom.SingleopenFrame;
import com.redingsoft.sql.SetSQL;
import java.util.TimerTask;
import java.util.Vector;
import javax.swing.JOptionPane;

/**
 *
 * @author Administrator
 */
public class runtask extends TimerTask{
   
    @Override
    public void run() {
       // throw new UnsupportedOperationException("Not supported yet.");
    
      String r_id=gettimer.r_id;
     int i=WarnMsg("提示",""+r_id+"号房间入住时间以到，该通知结帐了！点击确定立即结账，取消不结账。");
      if(i==JOptionPane.YES_OPTION){
         String checktime=Util.getNowDTime(); //获得当前结算时间
         String indate=SingleopenFrame.intime;
         String delinlive="delete from inlive where r_no='"+r_id+"'"; //更新inlve表
         String update="update roominfo set state='"+"可供"+"'"+"where id='"+r_id+"'"; //更新roomifo表
        int flag=SetSQL.executeUpdate(delinlive);
         if(flag!=0){
           SetSQL.executeUpdate(update);  
         WarnMsg("提示","【"+r_id+"】号房间结账成功");
         }
      }
    }
/*******************************************************
     * 函数名称:WarnMsgPane(String title ,String msg ,component null)
     * 参数：tile 提示标题 msg 提示消息 显示他的父组件
     * 功能：为错误的输入和连接错误做出提示
     ************************************************************/
 public static int WarnMsg(String title,String msg){
 int i= JOptionPane.showConfirmDialog(null, msg, title, JOptionPane.YES_NO_OPTION);
 return i;
 }
}