readersystempanel.java~38~

一个功能强大的图书管理系统,是个人版,适合学习swing的初学者阅读.

        buttonGroupSex.add(jRadioButton1);
        buttonGroupSex.add(jRadioButton2);
        jTpRightM.add(jTpRightBottomjPanel1,"借阅证办理业务     ");
        jTpRightM.add(jTpRightBottomjPanel2, "借阅证延期办理业务     ");
        jTpRightM.add(jTpRightBottomjPanel3,"借阅证注销业务      ");
        jTpRightBottomjPanel3.add(jPanelLeft1);
        jPanelLeft1.add(jLabel3);
        jPanelLeft1.add(jTextField23);
        jPanelLeft1.add(jLabel25);
        jPanelLeft1.add(jTextField25);
        jPanelLeft1.add(jTextField24);
        jPanelLeft1.add(jLabel26);
        jPanelLeft1.add(jLabel23);
        jPanelLeft1.add(jTextField3);
        jPanelLeft1.add(jTextField26);
        jPanelLeft1.add(jLabel24);
        jPanelLeft1.add(jButton3);
        jTpRightBottomjPanel3.add(jPanelRigth1);
        jTpRightM.add(jTpRightBottomjPanel4,"证件挂失和恢复业务   ");
        jTpRightBottomjPanel4.add(jPanel1);
        jPanel1.add(jLabel1);
        jPanel1.add(jLabel7);
        jPanel1.add(jTextField7);
        jPanel1.add(jLabel5);
        jPanel1.add(jTextField6);
        jPanel1.add(jButton1);
        jPanel1.add(jLabel4);
        jPanel1.add(jTextField5);
        jPanel1.add(jLabel2);
        jPanel1.add(jTextField2);
        jPanel1.add(jTextField1);
    }



    public void typeshow()
   {
       String sql = "select typeName,foregift from readerType";
       int size = 0;
       ResultSet re=null;
       re = dh.search(sql);
       try {
           while(re.next())
              size++;
          ztype=new String[size];
          yajinArry= new float[size];
           boolean temp =re.first();
           for(int i=0;temp;i++)
           {

               ztype[i]=re.getString(1).trim();
            //   jtxType1.addItem(ztype[i]);
               yajinArry[i]=re.getFloat(2);
               temp =re.next();
           }
          // jtxType1 = new JComboBox(ztype);
         //  jtxType1.updateUI();

       } catch (SQLException ex) {
           System.out.println(ex.toString());

       }
       dh.myClose(1);
   }


    public void this_ancestorResized(HierarchyEvent e) {
        jTpRightM.setSize((this.getWidth()) - 5,
                          (this.getHeight() - 30) * 3 / 5);
        jPanelBottom.setBounds(1, jTpRightM.getHeight() + jTpRightM.getY(),
                               (this.getWidth()) - 5,
                               (this.getHeight() - 30) * 2 / 5);
        jPanelSystemTop.setSize((this.getWidth()) - 5, 30);
    }

    //    jTpRightBottom.setSize((jPaneRightBottom.getWidth())-5,(jPaneRightBottom.getHeight()-5));
    public void jPaneRightBottom_componentResized(ComponentEvent e) {
        jTpRightM.setSize( -1, -1);
    }

    public void jSpSystemPanel_componentResized(ComponentEvent e) {

    }

    public void jPanelBottom_componentResized(ComponentEvent e) {
        jScrollPane1.setBounds(1, 2, jPanelBottom.getWidth() - 5,
                               jPanelBottom.getHeight() - 33);
        jPanel1btmm.setBounds(1, jPanelBottom.getHeight() - 31,
                              jPanelBottom.getWidth() - 5, 28);
    }

    public void jPanel1btmm_componentResized(ComponentEvent e) {
        btnQ.setBounds((jPanel1btmm.getWidth() / 3 - 100) / 2, 4, 110, 23);
        btnW.setBounds((jPanel1btmm.getWidth() / 3 - 100) / 2 +
                       jPanel1btmm.getWidth() / 3, 4, 110, 23);
        btnY.setBounds((jPanel1btmm.getWidth() / 3 - 100) / 2 +
                       jPanel1btmm.getWidth() * 2 / 3, 4, 110, 23);
    }

    public void jtxBanzhengshijian_actionPerformed(ActionEvent e) {
        jtxDangqianTime.setText(SystemFrame1.dateTime);
    }
    public void qingkong()
    {
        jtxDangqianTime.setText(" 点击获取当前时间");
        jtxAdd1.setText("");
        jtxTelphone1.setText("");
        jtxZhengjianNum1.setText("");
        jtxName1.setText("");
        jtxNum1.setText("");
        jtxYajin1.setText("选择读者类型点击获取押金值");
        jtxNum1.setText("在填写资料后点击获取");
    }
    public void jButton8_actionPerformed(ActionEvent e) {
        qingkong();
    }


    public void jtxBanzhengshijian_mouseClicked(MouseEvent e) {

        jtxDangqianTime.setText(SystemFrame1.dateTime.substring(0,4)+"年"+SystemFrame1.dateTime.substring(4,6)+"月"+SystemFrame1.dateTime.substring(6)+"日");
    }

    //设置显示的押金
    private void yajingShow()
    {
        int size=jtxType1.getItemCount();
        int i=0;
        while(i < size){
            if (jtxType1.getSelectedIndex() == i){
                jtxYajin1.setText("押金是 " + yajinArry[i] + " 元");
                yj=yajinArry[i];
                break;
            }
            i++;
        }
    }
    public void jtxYajin1_mouseClicked(MouseEvent e) {
       yajingShow();
    }

    public void btnQ_actionPerformed(ActionEvent e) {
        shuaxin(radearjTable, -1);
    }

    public void shuaxin(JTable jta, int x) {
        String sql = "";
        if (x == 0)
            sql = "select readerID,readerName,readerSex,readerAddress,readerTelephone,readerTypeName,state,可借书数量=(booksQuantity-borrowBooksNum),beginTime,certificateNum  from reader  where state=0";
        else if (x == 1)
            sql = "select readerID,readerName,readerSex,readerAddress,readerTelephone,readerTypeName,state ,可借书数量=(booksQuantity-borrowBooksNum),beginTime,certificateNum from reader where state=1";
        else
            sql = "select readerID,readerName,readerSex,readerAddress,readerTelephone,readerTypeName,state,可借书数量=(booksQuantity-borrowBooksNum),beginTime,certificateNum from reader";

        dh.search(sql);
        int size = 0;
        try {
            while (dh.rs.next())
                size++;
            date = new Object[size][title.length];
            boolean a = dh.rs.first();
            for (int i = 0; a; i++) {

                date[i][0] = dh.rs.getString(1).trim();
                date[i][1] = dh.rs.getString(2).trim();
                date[i][2] = dh.rs.getString(3).trim();
                date[i][3] = dh.rs.getString(4).trim();
                date[i][4] = dh.rs.getString(5).trim();
                date[i][5] = dh.rs.getString(6).trim();
                date[i][6] = "" + dh.rs.getBoolean(7);
                date[i][7] = "" + dh.rs.getInt(8);
                date[i][8] = dh.rs.getString(9).trim();
                date[i][9] = dh.rs.getString(10).trim();
                a = dh.rs.next();
            }
            DefaultTableModel model = new DefaultTableModel(date, title);
            jta.setModel(model);
            jta.updateUI();

        } catch (SQLException ex) {
            System.out.println(ex.toString());
        }
        dh.myClose(1);

    }

    public void btnW_actionPerformed(ActionEvent e) {
        shuaxin(radearjTable, 0);
    }

    public void btnY_actionPerformed(ActionEvent e) {
        shuaxin(radearjTable, 1);
    }
    //生成读者编号
    public void readerNumber()
    {
        String sNum = "";
        String num1 = "";
        int num = 0;
        String sql = "select top 1 readerID from readerInfo  order by id desc";

        dh.search(sql);
        try {
            if (dh.rs.next()) {
                sNum = dh.rs.getString(1);

                try {
                     num = Integer.parseInt(sNum.substring(2).trim())+1;

                } catch (RuntimeException ex) {
                   System.out.println(ex.toString());
                }
                 num1=""+num;
            }else
                num1 = "000001";
            while(num1.length()<6)
                num1="0"+num1;
        } catch (SQLException ex) {
            System.out.println(ex.toString());

        }
        dh.myClose(1);
        int i=0;
        char a='A';
        while(i<ztype.length){
            if (jtxType1.getSelectedIndex() == i)
            {
                a=(char)((int)a+i);
                xnum=a+"0"+num1;
                break;
            }
            i++;
        }
        jtxNum1.setText(xnum);

    }
    public void jtxNum1_mouseClicked(MouseEvent e) {
        readerNumber();
        yajingShow();

    }
    private void banzheng()
    {
        String bgtime = jtxDangqianTime.getText().trim();
        String add = jtxAdd1.getText().trim();
        String tel = jtxTelphone1.getText();
        String zhengjian = jtxZhengjian1.getSelectedItem().toString().trim();
        String name = jtxName1.getText().trim();
        String type = jtxType1.getSelectedItem().toString().trim();
        String zhengjianNum = jtxZhengjianNum1.getText().trim();

        String sex;
        if (jRadioButton2.isSelected())
            sex = jRadioButton2.getText().trim();
        else
            sex = jRadioButton1.getText().trim();
        if(name.equals(""))
            JOptionPane.showMessageDialog(null, "姓名不能为空！！！","用户名错误",JOptionPane.ERROR_MESSAGE);
        else
            if(zhengjianNum.equals(""))
                JOptionPane.showMessageDialog(null, "证件号码不能为空！！！","证件号码错误",JOptionPane.ERROR_MESSAGE);
            else{
                //提示输入押金
                JOptionPane.showInputDialog(null,
                                            "请支付办证的押金:  " + yj + "\n并输入其金额交费的金额",
                                            "" + yj);
                String sql = "insert into readerInfo (readerID,readerName,readerSex,readerTypeName,beginTime, beginHandlers,state,certificateName,certificateNum,readerAddress,readerTelephone) values(?,?,?,?,default,?,default,?,?,?,?)";
                PreparedStatement pstmt = null;
                try {

                    pstmt = dh.conn.prepareStatement(sql);
                    pstmt.setString(1, xnum);
                    pstmt.setString(2, name);
                    pstmt.setString(3, sex);
                    pstmt.setString(4, type);
                   // pstmt.setString(5, SystemFrame1.dateTime);
                    pstmt.setString(5, SystemFrame1.login);
                    pstmt.setString(6, zhengjian);
                    pstmt.setString(7, zhengjianNum);
                    pstmt.setString(8, add);
                    pstmt.setString(9, tel);
                    if (dh.add(pstmt)) {

                        JOptionPane.showMessageDialog(null, "添加成功");
                        qingkong();
                    } else
                        JOptionPane.showMessageDialog(null, "添加失败");

                } catch (SQLException ex) {
                    System.out.println(ex.toString());
                }
                dh.myClose(1);
            }

    }
    public void jButton2_actionPerformed(ActionEvent e) {
        banzheng();
    }

    public void jtxType1_itemStateChanged(ItemEvent e) {
        readerNumber();
        yajingShow();
    }

    public void jScrollPane1_componentResized(ComponentEvent e) {
        radearjTable.setSize(jScrollPane1.getWidth(),jScrollPane1.getHeight());
    }


    public void inputReaderNum(JTextField a,JTextArea b)
   {
       String bianhao="";
       try {
             bianhao= JOptionPane.showInputDialog(null,"请输入读者编号    例如 ","A0000001").trim();
       } catch (Exception ex) {
          // JOptionPane.showMessageDialog(null, "你没有输入读者信息");
       }

      if(!bianhao.equals("")){
          if ((int)bianhao.charAt(0)>='A' && (int)bianhao.charAt(0) <= 'Z' )
              {
              a.setText(""+bianhao);
              borrowBooksNum(a, b);
          }
      }
   }

   //点击查询读者的借书数量
  public void borrowBooksNum(JTextField a,JTextArea b)
  {

      String bianhao = "";
     if (!a.getText().trim().equals(""))
          bianhao = a.getText().trim();
      String snum = "";
      int num=0;
      String readerTypeNameTemp = "";

      if ((int)bianhao.charAt(0)>='A' && (int)bianhao.charAt(0) <= 'Z' ) {