frame_card_add.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_card_add extends JFrame {
  JLabel jLabel1 = new JLabel();
  JPanel jPanel1 = new JPanel();
  JLabel jLabel3 = new JLabel();
  JTextField jstudent_num = new JTextField();
  JLabel jLabel4 = new JLabel();
  JTextField jstuent_name = new JTextField();
  JLabel jLabel5 = new JLabel();
  JComboBox jComboBox1 = new JComboBox();
  JLabel jLabel6 = new JLabel();
  JTextField jstudent_class = new JTextField();
  JLabel jLabel7 = new JLabel();
  JTextField jstudent_tel = new JTextField();
  JButton jButton1 = new JButton();
  JButton jButton2 = new JButton();
  JLabel jLabel8 = new JLabel();
  JTextField jmonney = new JTextField();
  JLabel jLabel9 = new JLabel();
  JTextField jcard = new JTextField();
  JButton jButton3 = new JButton();
  JLabel jLabel2 = new JLabel();
  JTextField jdate = new JTextField();

  public Frame_card_add() {
    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(181, 20, 157, 57));
    this.getContentPane().setLayout(null);
    jPanel1.setBorder(BorderFactory.createEtchedBorder());
    jPanel1.setBounds(new Rectangle(40, 77, 447, 271));
    jPanel1.setLayout(null);
    jLabel3.setFont(new java.awt.Font("Dialog", 0, 16));
    jLabel3.setText("学号：");
    jLabel3.setBounds(new Rectangle(19, 24, 77, 28));
    jstudent_num.setText("");
    jstudent_num.setBounds(new Rectangle(99, 25, 110, 27));
    jLabel4.setFont(new java.awt.Font("Dialog", 0, 16));
    jLabel4.setText("姓名：");
    jLabel4.setBounds(new Rectangle(229, 22, 54, 33));
    jstuent_name.setText("");
    jstuent_name.setBounds(new Rectangle(307, 25, 111, 26));
    jLabel5.setFont(new java.awt.Font("Dialog", 0, 16));
    jLabel5.setText("性别：");
    jLabel5.setBounds(new Rectangle(19, 74, 58, 31));
    jComboBox1.setBounds(new Rectangle(99, 77, 97, 24));
    jLabel6.setFont(new java.awt.Font("Dialog", 0, 16));
    jLabel6.setText("班级：");
    jLabel6.setBounds(new Rectangle(229, 72, 78, 34));
    jstudent_class.setText("");
    jstudent_class.setBounds(new Rectangle(307, 75, 112, 28));
    jLabel7.setFont(new java.awt.Font("Dialog", 0, 16));
    jLabel7.setText("联系方式：");
    jLabel7.setBounds(new Rectangle(19, 131, 80, 28));
    jstudent_tel.setText("");
    jstudent_tel.setBounds(new Rectangle(99, 133, 111, 25));
    jButton1.setBounds(new Rectangle(112, 363, 106, 35));
    jButton1.setFont(new java.awt.Font("Dialog", 0, 16));
    jButton1.setText("确定");
    jButton1.addActionListener(new Frame_card_add_jButton1_actionAdapter(this));
    jButton2.setBounds(new Rectangle(325, 365, 106, 35));
    jButton2.setFont(new java.awt.Font("Dialog", 0, 16));
    jButton2.setText("取消");
    jButton2.addActionListener(new Frame_card_add_jButton2_actionAdapter(this));
    jLabel8.setFont(new java.awt.Font("Dialog", 0, 16));
    jLabel8.setText("金额：");
    jLabel8.setBounds(new Rectangle(229, 128, 66, 34));
    jmonney.setText("");
    jmonney.setBounds(new Rectangle(307, 131, 111, 29));
    jLabel9.setFont(new java.awt.Font("Dialog", 0, 16));
    jLabel9.setText("分配卡号：");
    jLabel9.setBounds(new Rectangle(19, 181, 89, 29));
    jcard.setForeground(Color.black);
    jcard.setText("");
    jcard.setBounds(new Rectangle(99, 183, 109, 25));
    jButton3.setBounds(new Rectangle(236, 183, 85, 25));
    jButton3.setFont(new java.awt.Font("Dialog", 0, 12));
    jButton3.setText("自动生成");
    jButton3.addActionListener(new Frame_card_add_jButton3_actionAdapter(this));
    jLabel2.setFont(new java.awt.Font("Dialog", 0, 16));
    jLabel2.setText("注册日期: ");
    jLabel2.setBounds(new Rectangle(20, 229, 92, 28));
    jdate.setText("2006-10-07");
    jdate.setBounds(new Rectangle(100, 229, 110, 27));
    jPanel1.add(jstudent_num, null);
    jPanel1.add(jLabel3, null);
    jPanel1.add(jLabel4, null);
    jPanel1.add(jstuent_name, null);
    jPanel1.add(jComboBox1, null);
    jPanel1.add(jLabel5, null);
    jPanel1.add(jLabel6, null);
    jPanel1.add(jstudent_class, null);
    jPanel1.add(jstudent_tel, null);
    jPanel1.add(jLabel7, null);
    jPanel1.add(jLabel8, null);
    jPanel1.add(jmonney, null);
    jPanel1.add(jcard, null);
    jPanel1.add(jLabel9, null);
    jPanel1.add(jButton3, null);
    jPanel1.add(jLabel2, null);
    jPanel1.add(jdate, null);
    this.getContentPane().add(jButton1, null);
    this.getContentPane().add(jButton2, null);
    this.getContentPane().add(jLabel1, null);
    this.getContentPane().add(jPanel1, null);
    this.setSize(540,450);
    this.setLocation(220,180);
    jComboBox1.addItem("男");
    jComboBox1.addItem("女");
    this.setTitle("卡号注册");
  }
/////////////////添加学生和卡信息
  void jButton1_actionPerformed(ActionEvent e) {
     String student_num=jstudent_num.getText().trim();
     String student_name=jstuent_name.getText().trim();
     String student_sex=(String) jComboBox1.getSelectedItem();
     String student_class=jstudent_class.getText().trim();
     String student_tel=jstudent_tel.getText().trim();
     String monney=jmonney.getText().trim();
     String card_num=jcard.getText().trim();
     String date=jdate.getText().trim();
     if(student_num.equals("")||student_name.equals("")||student_sex.equals("")||student_class.equals("")||monney.equals("")||card_num.equals("")||date.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);

        //System.out.println(apartid+dom_id+date);
        PreparedStatement stmt=con.prepareStatement("insert into student values(?,?,?,?,?)");
        //ResultSet rs=stmt.executeQuery();
        stmt.setString(1,student_num);
        stmt.setString(2,student_name);
        stmt.setString(3,student_sex);
        stmt.setString(4,student_class);
        stmt.setString(5,student_tel);
        PreparedStatement stmt1=con.prepareStatement("insert into card values(?,?,?,?,?)");
        //ResultSet rs=stmt.executeQuery();
        stmt1.setString(1,card_num);
        stmt1.setString(2,student_num);
        float m=Float.parseFloat(monney);
        stmt1.setFloat(3,m);
        stmt1.setString(4,date);
        stmt1.setString(5,"正常");

        int a=stmt.executeUpdate();
        int b=stmt1.executeUpdate();
        if(a!=0&&b!=0)
        {
          JOptionPane.showMessageDialog(this,"注册成功!!!","提示",JOptionPane.PLAIN_MESSAGE);
      return;
        }





       // stmt.setInt(1,apartid);
     }catch(Exception e1){  JOptionPane.showMessageDialog(this,"注册失败,请确保该学号没有注册过!!!","提示",JOptionPane.PLAIN_MESSAGE);
      return;}

  }
///////////////自动分配卡号
  void jButton3_actionPerformed(ActionEvent e) {
    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);

         //System.out.println(apartid+dom_id+date);
         Statement stmt=con.createStatement();
         ResultSet rs=stmt.executeQuery("select max(Card_number) from card");
         String cardid="0";
         int id=0;
         while(rs.next())
         {
          // cardid=rs.getString("Card_number").trim();
          cardid=rs.getString(1).trim();
          //System.out.print(cardid);
          id=Integer.parseInt(cardid)+1;
         }
         jcard.setText(new Integer(id).toString());
    }catch(Exception e2){e2.printStackTrace();}
  }
/////////////退出
  void jButton2_actionPerformed(ActionEvent e) {
    this.show(false);
  }
}

class Frame_card_add_jButton1_actionAdapter implements java.awt.event.ActionListener {
  Frame_card_add adaptee;

  Frame_card_add_jButton1_actionAdapter(Frame_card_add adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton1_actionPerformed(e);
  }
}

class Frame_card_add_jButton3_actionAdapter implements java.awt.event.ActionListener {
  Frame_card_add adaptee;

  Frame_card_add_jButton3_actionAdapter(Frame_card_add adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton3_actionPerformed(e);
  }
}

class Frame_card_add_jButton2_actionAdapter implements java.awt.event.ActionListener {
  Frame_card_add adaptee;

  Frame_card_add_jButton2_actionAdapter(Frame_card_add adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton2_actionPerformed(e);
  }
}