userinterface.java

资产管理系统的数据库设计 （一）开发背景 随着我国高等教育事业的迅猛发展

        org.jdesktop.layout.GroupLayout readerInfoPanelLayout = new org.jdesktop.layout.GroupLayout(readerInfoPanel);
        readerInfoPanel.setLayout(readerInfoPanelLayout);
        readerInfoPanelLayout.setHorizontalGroup(
            readerInfoPanelLayout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
            .add(readerInfoPanelLayout.createSequentialGroup()
                .add(readerInfoPanelLayout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
                    .add(readerInfoPanelLayout.createSequentialGroup()
                        .add(41, 41, 41)
                        .add(readerInfoPanelLayout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
                            .add(jLabel7)
                            .add(readerInfoPanelLayout.createSequentialGroup()
                                .add(52, 52, 52)
                                .add(readerInfoPanelLayout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
                                    .add(readerInfoPanelLayout.createSequentialGroup()
                                        .add(jLabel9)
                                        .add(20, 20, 20)
                                        .add(jTextField4, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, 85, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE))
                                    .add(readerInfoPanelLayout.createSequentialGroup()
                                        .add(readerInfoPanelLayout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
                                            .add(jLabel5)
                                            .add(jLabel8))
                                        .add(2, 2, 2)
                                        .add(readerInfoPanelLayout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
                                            .add(readerInfoPanelLayout.createSequentialGroup()
                                                .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
                                                .add(jTextField2, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, 103, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
                                                .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
                                                .add(jLabel6))
                                            .add(readerInfoPanelLayout.createSequentialGroup()
                                                .add(10, 10, 10)
                                                .add(jTextField3, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, 102, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE))))))))
                    .add(readerInfoPanelLayout.createSequentialGroup()
                        .add(20, 20, 20)
                        .add(jLabel1))
                    .add(readerInfoPanelLayout.createSequentialGroup()
                        .addContainerGap()
                        .add(jScrollPane2, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, 704, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)))
                .addContainerGap(22, Short.MAX_VALUE))
        );
        readerInfoPanelLayout.setVerticalGroup(
            readerInfoPanelLayout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
            .add(readerInfoPanelLayout.createSequentialGroup()
                .addContainerGap()
                .add(jLabel1)
                .add(7, 7, 7)
                .add(readerInfoPanelLayout.createParallelGroup(org.jdesktop.layout.GroupLayout.BASELINE)
                    .add(jLabel5)
                    .add(jLabel6)
                    .add(jTextField2, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE))
                .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
                .add(readerInfoPanelLayout.createParallelGroup(org.jdesktop.layout.GroupLayout.BASELINE)
                    .add(jLabel8)
                    .add(jTextField3, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE))
                .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
                .add(readerInfoPanelLayout.createParallelGroup(org.jdesktop.layout.GroupLayout.BASELINE)
                    .add(jLabel9)
                    .add(jTextField4, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE))
                .add(16, 16, 16)
                .add(jLabel7)
                .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                .add(jScrollPane2, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, 302, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
                .add(19, 19, 19))
        );
        jTabbedPane1.addTab("\u8bfb\u8005\u4fe1\u606f", readerInfoPanel);

        jMenu1.setText("\u7ba1\u85cf\u67e5\u8be2");
        jMenuBar1.add(jMenu1);

        jMenu2.setText("\u7528\u6237\u4fe1\u606f\u67e5\u8be2");
        jMenuBar1.add(jMenu2);

        helpMenu.setText("\u5e2e\u52a9");
        help.setText("\u663e\u793a\u5e2e\u52a9");
        help.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                helpActionPerformed(evt);
            }
        });

        helpMenu.add(help);

        about.setText("\u5173\u4e8e");
        about.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                aboutActionPerformed(evt);
            }
        });

        helpMenu.add(about);

        jMenuBar1.add(helpMenu);

        setJMenuBar(jMenuBar1);

        org.jdesktop.layout.GroupLayout layout = new org.jdesktop.layout.GroupLayout(getContentPane());
        getContentPane().setLayout(layout);
        layout.setHorizontalGroup(
            layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
            .add(layout.createSequentialGroup()
                .addContainerGap()
                .add(jTabbedPane1, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, 741, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
                .addContainerGap(19, Short.MAX_VALUE))
        );
        layout.setVerticalGroup(
            layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
            .add(layout.createSequentialGroup()
                .addContainerGap()
                .add(jTabbedPane1))
        );
        pack();
    }// </editor-fold>//GEN-END:initComponents

    private void jTabbedPane1MouseClicked(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_jTabbedPane1MouseClicked
// TODO 将在此处添加您的处理代码：
this.connect();
try{
    Connection con=DriverManager.getConnection(conURL);
    PreparedStatement ps=con.prepareStatement("select UserName,UserID,company from UserInfo where UserID=?");
    ps.setString(1,this.userid);
    ResultSet rs=ps.executeQuery();
    while(rs.next()){
        jTextField2.setText(rs.getString(1));
        jTextField3.setText(rs.getString(2));
        jTextField4.setText(rs.getString(3));   
    }
    ps.close();
    PreparedStatement pt=con.prepareStatement("select BookName,Author,PublishCompany,ISBN from BookInfo where ISBN=(select ISBN from LibBook where BookID=(select BookID from BorrowInfo where UserID=?))");
     pt.setString(1,this.userid);
    // pt.setString(2,this.userid);
    ResultSet rt=pt.executeQuery();
    int j=0;
    while(rt.next()){
        j++;
             for(int i=0;i<4;i++)
             {
                jTable3.setValueAt(rt.getString(i+1),j-1,i);          
    }
    }
    pt.close();
    con.close();
    
}catch(SQLException e){}
    }//GEN-LAST:event_jTabbedPane1MouseClicked
//    class TbModel extends AbstractTableModel {
//        private static final long serialVersionUID = 1L;
//        private Vector data;
//        private Vector titles;
//        public void myTableModel() {
//            data=new Vector();
//            JDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
//            conURL= "jdbc:odbc:pejuwe";
//            try {
//                Class.forName(JDriver);
//            } catch (ClassNotFoundException e) {
//                System.out.println("forname:" + e.getMessage());
//            }
//            try{
//                Connection con=DriverManager.getConnection(conURL);
//                PreparedStatement ps=con.prepareStatement("select BookName,Author,PublishCompany,ISBN from BookInfo where ?=?");
//                String s=jComboBox1.getSelectedItem().toString();
//                String ss=jTextField1.getText().toString();
//                ps.setString(1,s);
//                ps.setString(2,ss);
//                ResultSet rs=ps.executeQuery();
//                while(rs.next()) {
//                    data.add(rs.getString(1));
//                    data.add(rs.getString(2));
//                    data.add(rs.getString(3));
//                    data.add(rs.getString(4));
//                }
//            } catch(SQLException e){}
//            titles=new Vector();
//        titles.add("书名");
//        titles.add("作者");
//        titles.add("出版社");
//        titles.add("ISBN");
//        }
//        
//        public int getRowCount(){
//            return data.size()/getColumnCount();
//        }
//        public int getColumnCount() {
//            return titles.size();
//        }
//        public Object getValueAt(int rowIndex,int columnIndex){
//            return data.get((rowIndex*getColumnCount())+columnIndex);
//        }
//    }
    private void jTextField1ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jTextField1ActionPerformed
// TODO 将在此处添加您的处理代码：
        this.connect();
        try{
            Connection con=DriverManager.getConnection(conURL);
            PreparedStatement ps=con.prepareStatement("select BookName,Author,PublishCompany,ISBN from BookInfo where BookName=?");
         String s=jComboBox1.getSelectedItem().toString();
         String ss=jTextField1.getText().toString();
        // String sss=s+"="+ss;
         ps.setString(1,ss);
        // ps.setString(2,ss);
         ResultSet rs=ps.executeQuery();
         int j=0;
         while(rs.next())
         {
             j++;
             for(int i=0;i<4;i++)
             {
                 jTable1.setValueAt(rs.getString(i+1),j-1,i);              
             }
         }
        }
        catch(SQLException e){}
    }//GEN-LAST:event_jTextField1ActionPerformed
    
    private void jTable1AncestorAdded(javax.swing.event.AncestorEvent evt) {//GEN-FIRST:event_jTable1AncestorAdded
// TODO 将在此处添加您的处理代码：
    }//GEN-LAST:event_jTable1AncestorAdded
    
    private void aboutActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_aboutActionPerformed
// TODO 显示关于：
        JOptionPane.showMessageDialog(this,"网二图书管理系统 v3.9d\n于兴红\n版权所有\n这是试用版，您还有29天试用期，请购买正版！！","关于",2);
    }//GEN-LAST:event_aboutActionPerformed
    
    private void helpActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_helpActionPerformed
// TODO 显示帮助：
        JOptionPane.showMessageDialog(this,"靠！这么简单还要看帮助？！？！","帮助",3);
    }//GEN-LAST:event_helpActionPerformed
    
    private void jComboBox1ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jComboBox1ActionPerformed
// TODO 将在此处添加您的处理代码：
    }//GEN-LAST:event_jComboBox1ActionPerformed
    
    /**
     * @param args the command line arguments
     */
//    public static void main(String args[]) {
//        java.awt.EventQueue.invokeLater(new Runnable() {
//            public void run() {
//                new UserInterface(UserID).setVisible(true);
//            }
//        });
//    }
    
    // 变量声明 - 不进行修改//GEN-BEGIN:variables
    private javax.swing.JMenuItem about;
    private javax.swing.JMenuItem help;
    private javax.swing.JMenu helpMenu;
    private javax.swing.JComboBox jComboBox1;
    private javax.swing.JComboBox jComboBox2;
    private javax.swing.JComboBox jComboBox3;
    private javax.swing.JLabel jLabel1;
    private javax.swing.JLabel jLabel2;
    private javax.swing.JLabel jLabel3;
    private javax.swing.JLabel jLabel4;
    private javax.swing.JLabel jLabel5;
    private javax.swing.JLabel jLabel6;
    private javax.swing.JLabel jLabel7;
    private javax.swing.JLabel jLabel8;
    private javax.swing.JLabel jLabel9;
    private javax.swing.JMenu jMenu1;
    private javax.swing.JMenu jMenu2;
    private javax.swing.JMenuBar jMenuBar1;
    private javax.swing.JScrollPane jScrollPane1;
    private javax.swing.JScrollPane jScrollPane2;
    private javax.swing.JTabbedPane jTabbedPane1;
    private javax.swing.JTable jTable1;
    private javax.swing.JTable jTable3;
    private javax.swing.JTextField jTextField1;
    private javax.swing.JTextField jTextField2;
    private javax.swing.JTextField jTextField3;
    private javax.swing.JTextField jTextField4;
    private javax.swing.JPanel queryPanel;
    private javax.swing.JPanel readerInfoPanel;
    // 变量声明结束//GEN-END:variables
}