frame_xufei.java

学生上机系统,请大家多多指教.以后会发

package student_computer;

import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
import java.sql.*;

/**
 * <p>Title: </p>
 * <p>Description: </p>
 * <p>Copyright: Copyright (c) 2006</p>
 * <p>Company: </p>
 * @author not attributable
 * @version 1.0
 */

public class Frame_xufei extends JFrame {
  JLabel jLabel1 = new JLabel();
  JLabel jLabel2 = new JLabel();
  JTextField jTextField1 = new JTextField();
  JLabel jLabel3 = new JLabel();
  JTextField jTextField2 = new JTextField();
  JButton jButton1 = new JButton();
  JButton jButton2 = new JButton();

  public Frame_xufei() {
    try {
      jbInit();
    }
    catch(Exception e) {
      e.printStackTrace();
    }
  }
  private void jbInit() throws Exception {
    jLabel1.setFont(new java.awt.Font("Dialog", 0, 32));
    jLabel1.setText("办理续费");
    jLabel1.setBounds(new Rectangle(103, 26, 201, 53));
    this.getContentPane().setLayout(null);
    jLabel2.setFont(new java.awt.Font("Dialog", 0, 16));
    jLabel2.setText("卡        号：");
    jLabel2.setBounds(new Rectangle(72, 110, 95, 28));
    jTextField1.setText("");
    jTextField1.setBounds(new Rectangle(169, 110, 102, 27));
    jLabel3.setFont(new java.awt.Font("Dialog", 0, 16));
    jLabel3.setText("续费金额：");
    jLabel3.setBounds(new Rectangle(72, 165, 87, 26));
    jTextField2.setText("");
    jTextField2.setBounds(new Rectangle(168, 164, 102, 27));
    jButton1.setBounds(new Rectangle(79, 222, 79, 30));
    jButton1.setFont(new java.awt.Font("Dialog", 0, 16));
    jButton1.setText("确定");
    jButton1.addActionListener(new Frame_xufei_jButton1_actionAdapter(this));
    jButton2.setBounds(new Rectangle(200, 222, 79, 30));
    jButton2.setFont(new java.awt.Font("Dialog", 0, 16));
    jButton2.setText("退出");
    jButton2.addActionListener(new Frame_xufei_jButton2_actionAdapter(this));
    this.setTitle("续费");
    this.getContentPane().add(jLabel1, null);
    this.getContentPane().add(jLabel2, null);
    this.getContentPane().add(jLabel3, null);
    this.getContentPane().add(jTextField1, null);
    this.getContentPane().add(jTextField2, null);
    this.getContentPane().add(jButton1, null);
    this.getContentPane().add(jButton2, null);
  }
////////////办理续费
  void jButton1_actionPerformed(ActionEvent e) {
    String card=jTextField1.getText().trim();
    String fee=jTextField2.getText().trim();
    if(card.equals("")||fee.equals(""))
    {
      JOptionPane.showMessageDialog(this,"卡号和金额不能为空","提示",JOptionPane.PLAIN_MESSAGE);
      return;
    }
    int fee1=Integer.parseInt(fee);
    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_money,card_state from card where card_number=?");
      stmt.setString(1,card);
      ResultSet rs=stmt.executeQuery();
      float feeyuan=-100;
      String state="";
      while(rs.next())
      {
        feeyuan=rs.getFloat(1);
        state=rs.getString(2).trim();
      }
      System.out.print(state);
      if(feeyuan==-100)
      {
        JOptionPane.showMessageDialog(this,"没有该卡记录，请查证！！！","提示",JOptionPane.PLAIN_MESSAGE);
        return;
      }
      if(state.equals("挂失"))
      {
        JOptionPane.showMessageDialog(this,"该卡已经挂失，无法充值！！！","提示",JOptionPane.PLAIN_MESSAGE);
        return;
      }
      float feefinal=feeyuan+fee1;
      PreparedStatement stmt1=con.prepareStatement("update card set card_money=? where card_number=?");

      stmt1.setFloat(1,feefinal);
      stmt1.setString(2,card);
      int a=stmt1.executeUpdate();
      if(a!=0)
      {
        JOptionPane.showMessageDialog(this,"续费成功！！！","提示",JOptionPane.PLAIN_MESSAGE);
        return;
      }
      //Statement stmt0=con.createStatement();
    }catch(Exception e7){e7.printStackTrace();}

  }

  void jButton2_actionPerformed(ActionEvent e) {
  this.setVisible(false);
  }
}

class Frame_xufei_jButton1_actionAdapter implements java.awt.event.ActionListener {
  Frame_xufei adaptee;

  Frame_xufei_jButton1_actionAdapter(Frame_xufei adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton1_actionPerformed(e);
  }
}

class Frame_xufei_jButton2_actionAdapter implements java.awt.event.ActionListener {
  Frame_xufei adaptee;

  Frame_xufei_jButton2_actionAdapter(Frame_xufei adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton2_actionPerformed(e);
  }
}