tushumanage.java

java+sql 图书管理系统

package MyLibraryok.books.untitled1;

import java.awt.*;
import java.io.*;
import java.util.*;

import javax.swing.*;

import java.sql.Statement;
import java.sql.ResultSet;
import java.sql.SQLException;
import MyLibraryok.MyMain.MainFrame2;
import MyLibraryok.Mydb.Mydb;

public class TushuManage extends JDialog { //implements Serializable
    String[] ss = {"图书编号", "条形码", "图书名称", "类别", "定价", "作者",
                  "出版社", "存放位置", "库存图书", "借出图书", "录入时间", "状态"};


    ArrayList list = new ArrayList();
    TableModelTest modle = new TableModelTest(list, ss);
    JTable jTable1 = new JTable(modle);


    JPanel jPanel1 = new JPanel();
    JPanel jPanel2 = new JPanel();
    JPanel jPanel3 = new JPanel();
    JPanel jPanel4 = new JPanel();
    JPanel jPanel5 = new JPanel();

    JButton jButton1 = new JButton();
    JButton jButton2 = new JButton();
    JButton jButton3 = new JButton();
    JButton jButton4 = new JButton();
    JButton jButton5 = new JButton();
    JButton jButton6 = new JButton();
    JButton jButton7 = new JButton();
    JButton jButton8 = new JButton();
    JButton jButton9 = new JButton();
    JButton jButton10 = new JButton();
    JButton jButton11 = new JButton();
    JLabel jLabel1 = new JLabel();
    JLabel jLabel2 = new JLabel();
    JLabel jLabel3 = new JLabel();
    JLabel jLabel4 = new JLabel();
    //JLabel jLabel5 = new JLabel();
    JLabel jLabel6 = new JLabel();
    JLabel jLabel7 = new JLabel();
    JLabel jLabel8 = new JLabel();

    JLabel jLabel13 = new JLabel();
    JLabel jLabel14 = new JLabel();
    JLabel jLabel15 = new JLabel();
    JLabel jLabel16 = new JLabel();
    JLabel jLabel17 = new JLabel();
    JLabel jLabel18 = new JLabel();
    JLabel jLabel19 = new JLabel();

    JTextField jTextBiaoHao = new JTextField();
    JTextField jTextTiaoXingMa = new JTextField();
    JTextField jTextShuMing = new JTextField();
    JTextField jTextZuoZhe = new JTextField();
    JTextField jTextDingJia = new JTextField();
    JTextField jTextCunFang = new JTextField();
    JTextField jTextLeiBie = new JTextField();
    JTextField jTextShuLiang = new JTextField();
    JTextField jTextChuBan = new JTextField();
    JTextField jTextChuBanShe = new JTextField();
    JTextField jTextKuCunTushu = new JTextField();
    JTextField jTextJieChunTushu = new JTextField();
    JTextField jTextRuKuShijian = new JTextField();
    JTextField jTextShuM = new JTextField();

//    Object alist;
//    Object tt;


//    private PopupMenu jScrollPane1;

    JScrollPane jScrollPane1 = new JScrollPane();
    JTextField jTextField1 = new JTextField();
    JLabel jLabel5 = new JLabel();
    JLabel jLabel9 = new JLabel();
    JLabel jLabel10 = new JLabel();
    public TushuManage(MainFrame2 ss) {
        super(ss,"",true);
        try {
            jbInit();
        } catch (Exception ex) {
            ex.printStackTrace();
        }
    }

    private void jbInit() throws Exception {

//        Tu tu = new Tu("1.jpg.jpg");
//        tu.setLayout(null);
//        JFrame.setDefaultLookAndFeelDecorated(true);
        jPanel1.setBorder(BorderFactory.createTitledBorder("图书基本资料(可编辑)"));
        //      jPanel1.setOpaque(false);
//        jPanel1.setPreferredSize(new Dimension(600, 160));
        jPanel2.setBorder(BorderFactory.createTitledBorder("运行时状态(可编辑)"));
        //      jPanel2.setOpaque(false);
        jPanel1.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        jPanel3.setBackground(Color.white);
        jPanel3.setBorder(BorderFactory.createTitledBorder("图书列表"));
        jPanel4.setBackground(Color.white);
        //    jPanel3.setOpaque(false);
        jPanel4.setBorder(BorderFactory.createTitledBorder("系统设置"));
        //  jPanel4.setOpaque(false);
        jPanel5.setBorder(BorderFactory.createTitledBorder("图书查询"));
        //    jPanel5.setOpaque(false);

        jTextField1.setText("");
        jTextField1.setBounds(new Rectangle(67, 52, 91, 26));
        jLabel5.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        jLabel5.setText("状     态");
        jLabel5.setBounds(new Rectangle(13, 52, 58, 23));
        this.getContentPane().setBackground(Color.white);
        this.setFont(new java.awt.Font("黑体", Font.BOLD, 15));
        this.setTitle("图书基本信息");
        jButton6.setBackground(Color.lightGray);
        jButton8.setBackground(Color.lightGray);
        jButton9.setBackground(Color.lightGray);
        jButton10.setBackground(Color.lightGray);
        jButton11.setBackground(Color.lightGray);
        jLabel9.setBackground(UIManager.getColor("Button.highlight"));
        jLabel9.setFont(new java.awt.Font("华文彩云", Font.PLAIN, 35));
        jLabel9.setForeground(SystemColor.activeCaptionBorder);
//        jLabel9.setText("     我的图书，我选择");
//        jLabel9.setBounds(new Rectangle(150, 10, 500, 35));
//        jLabel10.setFont(new java.awt.Font("华文行楷", Font.PLAIN, 35));
//        jLabel10.setText("     我的图书，我选择！！！");
//        jLabel10.setBounds(new Rectangle(120, 10, 500, 40));
        jButton5.setBackground(Color.lightGray);
        jButton7.setBackground(Color.lightGray);
        jTable1.setGridColor(Color.lightGray);
        jScrollPane1.setForeground(Color.lightGray);
        jTextRuKuShijian.setDisabledTextColor(Color.white);
        jPanel3.add(jPanel4);
//        ImageIcon im = new ImageIcon("Image/4.jpg");
//        this.setIconImage(im.getImage());
//
        this.getContentPane().add(jPanel2);
        this.getContentPane().add(jButton1);
        this.getContentPane().add(jButton2);
        this.getContentPane().add(jButton4);
        this.getContentPane().add(jPanel3);
        //  this.getContentPane().add(jButton3);
        //this.getContentPane().add(this);


        this.getContentPane().setLayout(null);
        jPanel3.setFont(new java.awt.Font("幼圆", Font.PLAIN,
                                          30));
        jPanel3.setBounds(new Rectangle(18, 233, 615, 230));
        jPanel3.setLayout(null);
        jTable1.setAutoResizeMode(jTable1.AUTO_RESIZE_OFF);
        //jScrollPane1.setHorizontalScrollBarPolicy(jScrollPane1.HORIZONTAL_SCROLLBAR_ALWAYS);
        jScrollPane1.setVerticalScrollBarPolicy(JScrollPane.
                                                VERTICAL_SCROLLBAR_ALWAYS);

        // this.getContentPane().setBackground(SystemColor.scrollbar);
        this.setForeground(Color.white);
        jScrollPane1.setBounds(new Rectangle(8, 19, 380, 202));
        jScrollPane1.getViewport().setBackground(Color.white);

        jLabel1.setText("图书编号");
        jLabel1.setBounds(new Rectangle(14, 20, 54, 21));
        jPanel1.setLayout(null);
        jTextBiaoHao.setText("");
        jTextBiaoHao.setBounds(new Rectangle(65, 17, 94, 25));
        jLabel2.setText("条形码");
        jLabel2.setBounds(new Rectangle(161, 18, 56, 24));
        jTextTiaoXingMa.setText("");
        jTextTiaoXingMa.setBounds(new Rectangle(202, 17, 91, 26));
        jLabel3.setText("书  名");
        jLabel3.setBounds(new Rectangle(302, 20, 58, 23));
        jTextShuMing.setText("");
        jTextShuMing.setBounds(new Rectangle(347, 21, 92, 23));
        jLabel4.setText("作者");
        jLabel4.setBounds(new Rectangle(451, 23, 55, 20));
        jTextZuoZhe.setText("");
        jTextZuoZhe.setBounds(new Rectangle(498, 20, 99, 25));

        jLabel6.setText("定  价");
        jLabel6.setBounds(new Rectangle(161, 52, 38, 22));
        jTextDingJia.setText("");
        jTextDingJia.setBounds(new Rectangle(202, 52, 91, 25));
        jLabel7.setText("存放位置");
        jLabel7.setBounds(new Rectangle(292, 54, 57, 21));
        jTextCunFang.setText("");
        jTextCunFang.setBounds(new Rectangle(347, 53, 93, 25));
        jLabel8.setText("类别");
        jLabel8.setBounds(new Rectangle(451, 54, 47, 23));
        jTextLeiBie.setText("");
        jTextLeiBie.setBounds(new Rectangle(498, 51, 99, 24));

        jLabel13.setText("出版社");
        jLabel13.setBounds(new Rectangle(17, 85, 54, 20));
        jTextChuBanShe.setText("");
        jTextChuBanShe.setBounds(new Rectangle(61, 86, 229, 27));

        jLabel15.setText("库存图书");
        jLabel15.setBounds(new Rectangle(6, 22, 53, 26));
        jPanel2.setLayout(null);
        jTextKuCunTushu.setText("");
        jTextKuCunTushu.setBounds(new Rectangle(58, 22, 96, 27));
        jLabel16.setText("借出图书");
        jLabel16.setBounds(new Rectangle(155, 25, 55, 24));
        jTextJieChunTushu.setText("");
        jTextJieChunTushu.setBounds(new Rectangle(208, 23, 86, 26));
        jLabel17.setText("录入时间");
        jLabel17.setBounds(new Rectangle(296, 24, 52, 22));
        Mydb mydb = new Mydb();
        String s1 ="select getdate()";