fuzeyuding.java

这是自己做的图书馆信息管理系统

package infomanagement;

/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2003</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
import java.awt.BorderLayout;
import javax.swing.BorderFactory;
import javax.swing.JPanel;
import java.awt.Font;
import com.borland.jbcl.layout.XYLayout;
import java.awt.Color;
import com.borland.dx.dataset.Column;
import javax.swing.JDialog;
import javax.swing.JTextField;
import java.awt.Frame;
import com.borland.dx.sql.dataset.Database;
import com.borland.dx.sql.dataset.QueryDataSet;
import javax.swing.JLabel;
import com.borland.jbcl.layout.XYConstraints;
import javax.swing.JButton;
import java.awt.event.MouseEvent;
import java.awt.Dimension;
import java.awt.Point;
import javax.swing.JTextArea;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Calendar;
import javax.swing.JScrollPane;
import javax.swing.JTable;

/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2003</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class fuzeyuding extends JDialog {
  private JPanel jPanel1 = new JPanel();
  private XYLayout xYLayout1 = new XYLayout();
  private JLabel jLabel1 = new JLabel();
  private JLabel jLabel4 = new JLabel();
  private QueryDataSet queryDataSet1 = new QueryDataSet();
  private Database database1 = new Database();
  private QueryDataSet queryDataSet2 = new QueryDataSet();
  private Column column1 = new Column();
  JButton jButton1 = new JButton();
  JLabel jLabel2 = new JLabel();
  JTextField jTextField1 = new JTextField();
  JLabel jLabel3 = new JLabel();
  JTextField jTextField2 = new JTextField();
  JTextField jTextField3 = new JTextField();
  JLabel jLabel5 = new JLabel();
  JScrollPane jScrollPane1 = new JScrollPane();
  //JTable jTable1 ;
  String []po1={"学号","书号","预订日期"};
  String [][]po=new String[8][3];
  public fuzeyuding(Frame frame, String title, boolean modal) {
    super(frame, title, modal);
    try {
      jbInit();
      pack();
    }
    catch(Exception ex) {
      ex.printStackTrace();
    }
  }

  public fuzeyuding() {
    this(null, "", false);
  }
  private void jbInit() throws Exception {
    jPanel1.setLayout(xYLayout1);
    jLabel1.setFont(new java.awt.Font("Dialog", 0, 23));
    jLabel1.setForeground(Color.magenta);
    jLabel1.setBorder(BorderFactory.createEtchedBorder());
    jLabel1.setText("                        添加预定表");
    jLabel4.setBorder(BorderFactory.createEtchedBorder());

    jButton1.setText("添加");
    String oop="select 学号,书号,预订日期 from studentyd";
    try
    {
      dabaco hj = new dabaco();
      ResultSet huu = hj.stmt.executeQuery(oop);
      int u=0;
      while (huu.next())
      {
        for (int i = 0; i <= 2; i++)
        {
          po[u][i] = huu.getString(i + 1);

        }
        u++;

      }

    }


    catch(Exception ex)
    {

    }
    JTable jTable1=new JTable(po,po1);
    jButton1.addMouseListener(new java.awt.event.MouseAdapter()
    {
      //判断输入是否正确，是就进入，否就弹出一个对话框提示错误
      public void mouseClicked(MouseEvent e)
      {
             abClicked(e);

      }


    }

    );
    jLabel2.setFont(new java.awt.Font("宋体", Font.PLAIN, 20));
    jLabel2.setForeground(Color.red);
    jLabel2.setText("学号");
    jLabel3.setFont(new java.awt.Font("宋体", Font.PLAIN, 20));
    jLabel3.setForeground(Color.red);
    jLabel3.setText("书号");
    jLabel5.setFont(new java.awt.Font("宋体", Font.PLAIN, 16));
    jLabel5.setForeground(Color.green);
    jLabel5.setText("学生预订图书显示");
    this.getContentPane().add(jPanel1, BorderLayout.CENTER);
    jPanel1.add(jLabel1, new XYConstraints( -1, 1, 410, 53));
    jPanel1.add(jLabel2, new XYConstraints(29, 97, 44, 19));
    jPanel1.add(jLabel3, new XYConstraints(193, 92, -1, -1));
    jPanel1.add(jTextField2, new XYConstraints(248, 97, 83, 18));
    jPanel1.add(jTextField1, new XYConstraints(84, 95, 78, -1));
    jPanel1.add(jTextField3, new XYConstraints(100, 161, 176, 21));
    jPanel1.add(jButton1, new XYConstraints(157, 130, -1, -1));
    jPanel1.add(jLabel5, new XYConstraints(120, 197, -1, -1));
    jPanel1.add(jScrollPane1, new XYConstraints(30, 220, 339, 62));
    jPanel1.add(jTable1, new XYConstraints(34, 226, 330, 52));
    jPanel1.add(jLabel4, new XYConstraints(3, 88, 397, 202));
    jScrollPane1.getViewport().add(jTable1);
  }
  void abClicked(MouseEvent e)
  {

       String a=jTextField1.getText();
       String b=jTextField2.getText();
       /*
        Calendar currentCalendars= Calendar.getInstance();
        int years= currentCalendars.get(Calendar.YEAR);//年
        int months= currentCalendars.get(Calendar.MONTH)+1;//月
        int days= currentCalendars.get(Calendar.DAY_OF_MONTH);//日
        */
       try
      {
        dabaco bb = new dabaco();
        //Statement ps = bb.conn.createStatement();
        String gg;
        boolean mk = false;
        boolean nk=false;
        boolean pk=false;
        String query1 = "select 书号 from bookyd";
        //String query2 = "select 书号 from bookjc";
        String query3 = "select 书号 from book";
        String query4 = "select 学号 from student";
        ResultSet ff = bb.stmt.executeQuery(query1);
        while (ff.next())
        {
          gg = ff.getString(1);
          if (mk == true) {

          }
          else if (gg.equals(b)) {
            mk = true;

          }
          else {

          }

        }
        if (mk == true) {
          String st = new String("该书已被预订，不能预订");
          cheng dlg = new cheng(st);
          Dimension dlgSize = dlg.getPreferredSize();
          Dimension frmSize = getSize();
          Point loc = getLocation();
          dlg.setLocation( (frmSize.width - dlgSize.width) / 2 +
                          loc.x, (frmSize.height - dlgSize.height) / 2 + loc.y);
          dlg.setModal(true);
          dlg.pack();

          dlg.setVisible(true);

        }
        else
        {
          ResultSet kk = bb.stmt.executeQuery(query4);
          while (kk.next()) {
            String ll = kk.getString(1);
            if (nk == true) {

            }
            else if (ll.equals(a)) {
              nk = true;

            }
            else {

            }

            //ResultSet rs = bb.stmt.executeUpdate(query);
          }
          if (nk == true)
          {
            ResultSet oo = bb.stmt.executeQuery(query3);

            while (oo.next())
            {
            String mm = oo.getString(1);
            if (pk == true) {

            }
            else if (mm.equals(b)) {
              pk = true;

            }
            else
            {

            }
           }
          if(pk==true)
          {    //System.out.println("dddddddd");
               Calendar currentCalendars= Calendar.getInstance();
               int years= currentCalendars.get(Calendar.YEAR);//年
               int months= currentCalendars.get(Calendar.MONTH)+1;//月
               int days= currentCalendars.get(Calendar.DAY_OF_MONTH);//日
               String sppp=years+"-"+months+"-"+days;

               String ii="insert into bookyd values('"+a+"'"+","+"'"+b+"'"
                 +","+"'"+sppp+"'"+")";
               //String hhuh="insert into studentyd values("+"'1'"+","+"'103'"+","+"'33333'"
                 //  +")";

               String tt="insert into historya values("+"'"+a+"'"+","+"'"+b+"'"
                 +","+null+","+null+","+null+","+"'"+sppp+"'"+")";
               String go="delete from studentyd where 学号="+"'"+a+"'"+"and 书号="+"'"+b+"'";
               dabaco bc=new dabaco();
               //ResultSet huh=bb.stmt.executeQuery(ii);
               ResultSet gg3=bc.stmt.executeQuery(tt+ii+go);
          }
          else
          {
            jTextField3.setText("书库中没有该书");
          }


          }
        else
        {
          jTextField3.setText("学生库中没有该学生");



        }
      }}
      catch(SQLException ex)
      {

      }









  }
  void cancel(){
    dispose() ;
  }



}