frame3.java~29~

来自「学生上机系统,请大家多多指教.以后会发」· JAVA~29~ 代码 · 共 476 行 · 第 1/2 页

        }
        //stmt.setString(1,card);
        /////////////查看该卡与俄和是否挂失
        PreparedStatement stmt=con.prepareStatement("select card_money,card_state from card where card_number=?");
        stmt.setString(1,card);
        ResultSet rs=stmt.executeQuery();
        while(rs.next())
        {
          int mon=rs.getInt(1);
          String state=rs.getString(2).trim();
          if(mon<1)
          {
            JOptionPane.showMessageDialog(this,"对不起，余额不足一小时，请充值!!!","提示",JOptionPane.PLAIN_MESSAGE);
             return;
          }
          if(state.equals("挂失"))
          {

            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();
        }
        if(time2.equals(""))
        {
          JOptionPane.showMessageDialog(this,"here!!!","提示",JOptionPane.PLAIN_MESSAGE);
         return;
        }
        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)((hour2-hour1)*60+(m2-m1))/(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);
        }
        if(fee1==0)
        {
          System.out.print("钱提取失败");
        }
        float fee2=fee1-fee;
        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;
        }




    }catch(Exception e7){e7.printStackTrace();}


  }
}

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);
  }
}