yw.java~5~

JAVA实验图形 =各种 的 JAVA简单代码 出初学者必备！！！！！！！！！

package yw321;
import java.io.*;
import java.sql.*;
import java.awt.*;
import javax.swing.*;
import java.awt.event.*;
import java.sql.*;
import java.util.*;
import javax.swing.table.*;
import java.awt.Frame;


public class yw extends JFrame
   {
    static String bookname;
    static int number;
    static int bj;
    static int abj;
    static String cbs;
    static String cbsadd;
    static int cbsphone;
    static int bno;
    Button bb = new Button("确定");
    Button bb4 = new Button("确定"); Button bb5 = new Button("确定");
    TextField b2 = new TextField(); TextField b3 = new TextField();TextField b4 = new TextField();
    TextField b5 = new TextField();TextField b6 = new TextField(); TextField b7 = new TextField();
   TextField b8 = new TextField();TextField b9 = new TextField();TextField b10 = new TextField();
TextField b11 = new TextField();TextField b12 = new TextField();TextField b13 = new TextField();
TextField b14 = new TextField();TextField b15 = new TextField();TextField b16 = new TextField();
Button bb3 = new Button("购销教材");String num1;public static int sn;
    public static String sna;
    AbstractTableModel tm;
    JTable table;
    JScrollPane scollpane;
    String titles[];
    Vector records;
    public void shencha() {String sql = "select bnum,bname,bjiage,cbs from allbook where bno=" +
                     b4.getText() + "";JDBCJTable f = new JDBCJTable();
        f.init();
        try {
            f.start2(sql);
        } catch (Exception e) {
            e.printStackTrace();
        }
        System.out.println("数量：:" + number);
        int n1 = number - Integer.parseInt(b5.getText());
        if (n1 < 0) {
            Label b1 = new Label("对不起，你申请的书已经没有库存，请等候！差" + -n1 + "本");
            sql = "insert into nobook(sno,sname,bno,bnum) VALUES(" + b2.getText() +
                  ",'" + b3.getText() + "'," + b4.getText() + "," + -n1 + ")";
            try {
                f.start(sql);
            } catch (Exception e) {
                e.printStackTrace();
            }
            sql = "update allbook set bnum= 0 where bno=" + b4.getText() +
                  "";
            try {
                f.start(sql);
            } catch (Exception e) {
                e.printStackTrace();
            }

            f.add(b1);
        } else {
            Label b = new Label("审查通过！请收好您的领书单!(领书时用到)          学号:" +
                                b2.getText() + "     姓名:" + b3.getText() +
                                "     申请书号:" + b4.getText() + "      申请数量:" +
                                b5.getText());
            fapiao();
            f.add(b, "North");
            chaxun5();
            sql = "update allbook set bnum=" + n1 + " where bno=" + b4.getText() +
                  "";
            try {
                f.start(sql);
            } catch (Exception e) {
                e.printStackTrace();
            }
        }
        f.setSize(600, 80);
        f.setTitle("领书单");
        f.setVisible(true);
    }
    public void delete() {JDBCJTable f = new JDBCJTable();
        f.setSize(200, 200);
        f.setTitle("购销教材操作系统");
        f.setVisible(true);
        b16.setSize(100, 30);
        b16.setEditable(true);
        b16.setLocation(0, 0);
        b16.setText("书号");
        f.add(b16);
        bb5.setSize(80, 30);
              bb5.setLocation(50, 50);
              bb5.setVisible(true);
              f.add(bb5);
              bb5.addActionListener(new ActionListener() {
                  public void actionPerformed(ActionEvent e) {
                        delete2();
                  }
        });


     }public void delete2(){JDBCJTable f = new JDBCJTable();
             String sql = "delete  allbook where bno="+b16.getText()+"";
              try {
                  f.start(sql);
              } catch (Exception e) {
                  e.printStackTrace();
              }   f.setSize(200, 20);
          f.setTitle("删除成功！");
          f.setVisible(true);

     }
    public void jie() {
        String sql = "INSERT INTO  sellbook(sno,sname,bno,bnum) VALUES(" +
                     b2.getText() + ",'" + b3.getText() + "'," + b4.getText() +
                     "," + b5.getText() + ")";
        JDBCJTable f = new JDBCJTable();
        try {
            f.start(sql);
        } catch (Exception e) {
            e.printStackTrace();
        }
        shencha();
    }

    public void fapiao() {
        JDBCJTable f = new JDBCJTable();
        abj = Integer.parseInt(b5.getText()) * bj;
        String sql =
                "INSERT INTO  fapiao(sno,sname,bno,bname,bnum,bjiage,allbjiage) VALUES(" +
                b2.getText() + ",'" + b3.getText() + "'," + b4.getText() + ",'" +
                bookname + "'," + b5.getText() + "," + bj + "," + abj + ")";
        try {
            f.start(sql);
        } catch (Exception e) {
            e.printStackTrace();
        }

    }

    public void goushubiao() {
        chaxun6();
    }

    public void chaxun8() {
        String sql = "select * from sellbook";
        JDBCJTable f = new JDBCJTable();
        f.init();
        try {
            f.start(sql);
        } catch (Exception e) {
            e.printStackTrace();
        }

        f.setSize(600, 150);
        f.setTitle("学生申请教材记录表");
        f.setVisible(true);

    }

    public void insert() {
        JDBCJTable f = new JDBCJTable();
        f.setSize(500, 500);
        f.setTitle("购销教材操作系统");
        f.setVisible(true);
        b9.setSize(100, 30);
        b9.setEditable(true);
        b9.setLocation(0, 0);
        b9.setText("书号");
        f.add(b9);
        b10.setSize(100, 30);
        b10.setLocation(150, 0);
        b10.setEditable(true);
        b10.setVisible(true);
        b10.setText("书名");
        f.add(b10);
        b11.setSize(100, 30);
        b11.setLocation(300, 0);
        b11.setEditable(true);
        b11.setVisible(true);
        b11.setText("书数量");
        f.add(b11);
        b12.setSize(100, 30);
        b12.setLocation(0, 100);
        b12.setEditable(true);
        b12.setVisible(true);
        b12.setText("书单价");
        f.add(b12);
        b13.setSize(100, 30);
        b13.setLocation(150, 100);
        b13.setEditable(true);
        b13.setVisible(true);
        b13.setText("出版社");
        f.add(b13);
        b14.setSize(100, 30);
        b14.setLocation(300, 100);
        b14.setEditable(true);
        b14.setVisible(true);
        b14.setText("出版社地址");
        f.add(b14);
        b15.setSize(100, 30);
        b15.setLocation(0, 200);
        b15.setEditable(true);
        b15.setVisible(true);
        b15.setText("出版社电话");
        f.add(b15);
        bb4.setSize(100, 30);
        bb4.setLocation(300, 300);
        bb4.setVisible(true);
        f.add(bb4);
        bb4.addActionListener(new ActionListener() {
            public void actionPerformed(ActionEvent e) {
                insert2();
            }
        });
    }

    public void insert2() {
        JDBCJTable f = new JDBCJTable();
        f.init();
        String sql =
                "INSERT INTO  allbook(bno,bname,bnum,bjiage,cbs,cbsadd,cbsphone) VALUES(" +
                b9.getText() + ",'" + b10.getText() + "'," + b11.getText() +
                "," + b12.getText() + ",'" + b13.getText() + "','" +
                b14.getText() + "'," + b15.getText() + ")";
        try {
            f.start(sql);
        } catch (Exception e) {
        }
        f.setSize(200, 20);
        f.setTitle("添加成功！");
        f.setVisible(true);
    }

    public void chaxun7() {
        JDBCJTable f = new JDBCJTable();
        f.setSize(550, 100);
        f.setTitle("购销教材操作系统");
        f.setVisible(true);
        b7.setSize(100, 30);
        b8.setSize(100, 30);
        b8.setEditable(true);
        b8.setLocation(200, 0);
        b8.setText("数量");
        b8.setVisible(true);
        f.add(b8);
        bb3.setSize(100, 30);
        bb3.setLocation(350, 0);
        bb3.setVisible(true);
        f.add(bb3);

        b7.setEditable(true);
        b7.setLocation(0, 0);
        b7.setText("书号");
        b7.setVisible(true);
        f.add(b7);
        bb3.addActionListener(new ActionListener() {
            public void actionPerformed(ActionEvent e) {
                caigou();
            }
        });

    }

    public void caigou() {
        String sql = "update allbook set bnum=" + b8.getText() + "where bno=" +
                     b7.getText();
        JDBCJTable f = new JDBCJTable();
        try {
            f.start(sql);
        } catch (Exception e) {
            e.printStackTrace();
        }
        sql = "delete from nobook where bnum=" + b8.getText() + " and bno=" +
              b7.getText();
        try {
            f.start(sql);
        } catch (Exception e) {
            e.printStackTrace();
        }

        chaxun6();
    }

    public void chaxun6() {
        String sql = "select bno,bnum from nobook";
        JDBCJTable f = new JDBCJTable();
        f.init();
        try {
            f.start(sql);
        } catch (Exception e) {
            e.printStackTrace();
        }
        f.setSize(550, 300);
        f.setTitle("秘书生成的购书单");
        f.setVisible(true);
    }

    public void chaxun5() {
        String sql = "select * from fapiao where sno=" + b2.getText() + "";
        JDBCJTable f = new JDBCJTable();
        f.init();