{            JOptionPane.showMessageDialog(this,"該卡已掛失，無法使用!!!","提示",JOptionPane.PLAIN_MESSAGE);            return;          }        }        PreparedStatement stmt1=con.prepareStatement("select computer_state,computer_status from computer where computer_number=? ");        stmt1.setString(1,computer);        ResultSet rs1=stmt1.executeQuery();        while(rs1.next())        {          String state=rs1.getString(1).trim();          //System.out.print(state);          String status=rs1.getString("computer_status").trim();          if(state.equals("使用")||status.equals("維修"))          {            JOptionPane.showMessageDialog(this,"對不起，機器不可用，請換臺機器!!!","提示",JOptionPane.PLAIN_MESSAGE);             return;          }        }        PreparedStatement stmt2=con.prepareStatement("select card_number from manage");        ResultSet rs2=stmt2.executeQuery();        int isSelect=0;        while(rs2.next())        {          String card1=rs2.getString(1).trim();          {            if(card.equals(card1))            {              isSelect=1;            }          }        }        if(isSelect==1)        {          JOptionPane.showMessageDialog(this,"對不起，該卡號已經登記過!!!","提示",JOptionPane.PLAIN_MESSAGE);          return;        }        //else        //{System.out.print("here");}        ////////////將機器制成使用狀態，登記上機時間        Date date=new Date();        String time=date.toLocaleString();        String time1=time.substring(11);        //System.out.print(time1);        PreparedStatement stmt3=con.prepareStatement("update computer set computer_state='使用' where computer_number=?");        stmt3.setString(1,computer);        PreparedStatement stmt4=con.prepareStatement("insert into manage(card_number,computer_number,manage_uptime) values(?,?,?)");        stmt4.setString(1,card);        stmt4.setString(2,computer);        stmt4.setString(3,time1);        int a=stmt3.executeUpdate();        int b=stmt4.executeUpdate();        if(a!=0&&b!=0)        {          JOptionPane.showMessageDialog(this,"上機登記成功!!!","提示",JOptionPane.PLAIN_MESSAGE);          //con.close();          return;        }        else        {          JOptionPane.showMessageDialog(this,"上機登記失敗!!!","提示",JOptionPane.PLAIN_MESSAGE);          return;        }      }catch(Exception e6)      {        //JOptionPane.showMessageDialog(this,"上機登記失敗！!!!","提示",JOptionPane.PLAIN_MESSAGE);         // return;         e6.printStackTrace();      }  }///////////////////下機登記  void jButton4_actionPerformed(ActionEvent e) {    String card=jTextField3.getText().trim();    String computer=jTextField4.getText();    if(card.equals("")||computer.equals(""))    {     JOptionPane.showMessageDialog(this,"卡號或者機號!!!","提示",JOptionPane.PLAIN_MESSAGE);      return;    }    try{     String driverName = "com.microsoft.jdbc.sqlserver.SQLServerDriver";      String dbURL = "jdbc:microsoft:sqlserver://210.30.104.11:1433; DatabaseName=student_computer";       String userName = "xueli";      String userPwd = "gejingguo";      Class.forName(driverName);      Connection con = DriverManager.getConnection(dbURL, userName, userPwd);      ///////////1檢查manage表中是否有該記錄      //PreparedStatement stmt=con.prepareStatement("select card_number,computer_number from manage");      Statement stmt0=con.createStatement();        ResultSet rs0=stmt0.executeQuery("select card_number,computer_number from manage");        int m=0;        while(rs0.next())        {          String card_num=rs0.getString("card_number").trim();          String computer_num=rs0.getString("computer_number").trim();          if(card.equals(card_num)&&computer.equals(computer_num))          {            m=1;          }        }        if(m!=1)        {          JOptionPane.showMessageDialog(this,"請確認該卡號和機號正確!!!","提示",JOptionPane.PLAIN_MESSAGE);         return;        }        ////////////////刪除manage中的記錄并計算余額插入card中        Date date=new Date();        String time=date.toLocaleString();        String time1=time.substring(11);        PreparedStatement stmt1=con.prepareStatement("select manage_uptime from manage where card_number=?");        stmt1.setString(1,card);        ResultSet rs1=stmt1.executeQuery();        String time2="";        while(rs1.next())        {          time2=rs1.getString(1).trim();        }        //System.out.println(time1);        //System.out.println(time2);        int  hour1=Integer.parseInt(time1.substring(0,2));        int m1=Integer.parseInt(time1.substring(3,5));        int hour2=Integer.parseInt(time2.substring(0,2));        int m2=Integer.parseInt(time2.substring(3,5));        float fee=(float)((hour1-hour2)*60+(m1-m2))/(float)60;        PreparedStatement stmt5=con.prepareStatement("select card_money from card where card_number=?");        stmt5.setString(1,card);        ResultSet rs5=stmt5.executeQuery();        float fee1=0;        while(rs5.next())        {          fee1=rs5.getFloat(1);        }        float fee2=fee1-fee;        //System.out.println(fee);        //System.out.println(fee1);        //System.out.println(fee2);        PreparedStatement stmt2=con.prepareStatement("update card set card_money=? where card_number=?");        stmt2.setFloat(1,fee2);        //System.out.print(fee);        stmt2.setString(2,card);        int b=stmt2.executeUpdate();        if(b==0)        {          JOptionPane.showMessageDialog(this,"修改余額失敗!!!","提示",JOptionPane.PLAIN_MESSAGE);         return;        }        PreparedStatement stmt=con.prepareStatement("delete from manage where card_number=?");       stmt.setString(1,card);       int a=stmt.executeUpdate();       if(a==0)       {         JOptionPane.showMessageDialog(this,"刪除記錄失敗!!!","提示",JOptionPane.PLAIN_MESSAGE);        return;       }        ////////////將機器的state置城空閑        PreparedStatement stmt3=con.prepareStatement("update computer set computer_state='空閑' where computer_number=?");        stmt3.setString(1,computer);        int c=stmt3.executeUpdate();        if(c==0)        {          JOptionPane.showMessageDialog(this,"修改機器狀態失敗!!!","提示",JOptionPane.PLAIN_MESSAGE);         return;        }        if(c!=0&&a!=0&&c!=0)        {          JOptionPane.showMessageDialog(this,"下機登記成功!!!","提示",JOptionPane.PLAIN_MESSAGE);         return;        }    }catch(Exception e7){e7.printStackTrace();}  }////////////  void jButton5_actionPerformed(ActionEvent e) {    jTextField3.setText("");    jTextField4.setText("");  }////////////將置空  void jButton3_actionPerformed(ActionEvent e) {    jTextField1.setText("");    jTextField2.setText("");  }}class Frame3_jButton1_actionAdapter implements java.awt.event.ActionListener {  Frame3 adaptee;  Frame3_jButton1_actionAdapter(Frame3 adaptee) {    this.adaptee = adaptee;  }  public void actionPerformed(ActionEvent e) {    adaptee.jButton1_actionPerformed(e);  }}class Frame3_jButton2_actionAdapter implements java.awt.event.ActionListener {  Frame3 adaptee;  Frame3_jButton2_actionAdapter(Frame3 adaptee) {    this.adaptee = adaptee;  }  public void actionPerformed(ActionEvent e) {    adaptee.jButton2_actionPerformed(e);  }}class Frame3_jButton4_actionAdapter implements java.awt.event.ActionListener {  Frame3 adaptee;  Frame3_jButton4_actionAdapter(Frame3 adaptee) {    this.adaptee = adaptee;  }  public void actionPerformed(ActionEvent e) {    adaptee.jButton4_actionPerformed(e);  }}class Frame3_jButton5_actionAdapter implements java.awt.event.ActionListener {  Frame3 adaptee;  Frame3_jButton5_actionAdapter(Frame3 adaptee) {    this.adaptee = adaptee;  }  public void actionPerformed(ActionEvent e) {    adaptee.jButton5_actionPerformed(e);  }}class Frame3_jButton3_actionAdapter implements java.awt.event.ActionListener {  Frame3 adaptee;  Frame3_jButton3_actionAdapter(Frame3 adaptee) {    this.adaptee = adaptee;  }  public void actionPerformed(ActionEvent e) {    adaptee.jButton3_actionPerformed(e);  }}