databasedesign.java

本源码是一个小型的数据库系统

                .addContainerGap(53, Short.MAX_VALUE))
        );
        pack();
    }// </editor-fold>//GEN-END:initComponents

    private void jButton10ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton10ActionPerformed
// TODO 将在此处添加您的处理代码：
        try
        {
            if(rs.isBeforeFirst()==true)
            {
                rs.next();
                rs.next();
            }
            else
                rs.next();
            this.showText(rs);
        }
        catch(Exception e){}
    }//GEN-LAST:event_jButton10ActionPerformed

    private void jButton9ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton9ActionPerformed
// TODO 将在此处添加您的处理代码：
        try
        {
            if(rs.isAfterLast()==true)
            {
                rs.previous();
                rs.previous();
            }
            else
                rs.previous();
            this.showText(rs);
        }
        catch(Exception e){System.out.println(e.getMessage());}
    }//GEN-LAST:event_jButton9ActionPerformed

    private void jButton8ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton8ActionPerformed
// TODO 将在此处添加您的处理代码：
        try
        {
            rs=stmt.executeQuery("select * from teacher");
            rs.last();
            this.showText(rs);
        }
        catch(Exception e){}
    }//GEN-LAST:event_jButton8ActionPerformed

    private void jButton7ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton7ActionPerformed
// TODO 将在此处添加您的处理代码：
        try
        {
            rs=stmt.executeQuery("select * from teacher");
            rs.first();
            this.showText(rs);
        }
        catch(Exception e){System.out.println(e.getMessage());}
    }//GEN-LAST:event_jButton7ActionPerformed

    private void jButton6ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton6ActionPerformed
// TODO 将在此处添加您的处理代码：
            float Number1=0;
            float Number2=0;
            float Number3=0;
            float all=0;
            try
            {
                rs=stmt.executeQuery("select * from teacher where xueli='博士'");
                while(rs.next())
                {
                    Number1++;
                }
                rs=stmt.executeQuery("select * from teacher where xueli='硕士'");
                while(rs.next())
                {
                    Number2++;
                }
                rs=stmt.executeQuery("select * from teacher where xueli='本科'");
                while(rs.next())
                {
                    Number3++;
                }
                all=Number1+Number2+Number3;
                jTextField8.setText("博士:"+(Number1/all)*100+"  硕士:"+(Number2/all)*100+"  本科:"+(Number3/all)*100);
            }
            catch(Exception e){}
    }//GEN-LAST:event_jButton6ActionPerformed

    private void jButton5ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton5ActionPerformed
// TODO 将在此处添加您的处理代码：
        try
        {
            int manNumber=0;
            int femalNumber=0;
            rs=stmt.executeQuery("select * from teacher where sex='男'");
            while(rs.next())
            {
                manNumber++;
            }
            rs=stmt.executeQuery("select * from teacher where sex='女'");
            while(rs.next())
            {
                femalNumber++;
            }
            jTextField8.setText("男:女 "+manNumber+":"+femalNumber);
        }
        catch(Exception e){}
    }//GEN-LAST:event_jButton5ActionPerformed

    private void jButton4ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton4ActionPerformed
// TODO 将在此处添加您的处理代码：
        try
        {
            rs=stmt.executeQuery("select avg(birthday) from teacher");
            rs.next();
            jTextField8.setText(rs.getString(1));
            
        }
        catch(Exception e){}
    }//GEN-LAST:event_jButton4ActionPerformed

    private void jButton3ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton3ActionPerformed
// TODO 将在此处添加您的处理代码：
        
        try
        {
            //rs=stmt.executeQuery();
            rs.next();
            //rs.updateString("");
           //rs.updatRow();
        }
        catch(Exception e)
        {
            System.out.println(e.getMessage());
        }
    }//GEN-LAST:event_jButton3ActionPerformed

    private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton2ActionPerformed
// TODO 将在此处添加您的处理代码：
        try
        {
            
            if(rs.isBeforeFirst()==true)
            {
                rs.next();
                rs.deleteRow();
            }
            else if(rs.isAfterLast()==true)
            {
                rs.previous();
                rs.deleteRow();
            }
            else
                rs.deleteRow();
            jTextField1.setText("");
            jTextField2.setText("");
            jTextField3.setText("");
            jTextField4.setText("");
            jTextField5.setText("");
            jTextField6.setText("");
            jTextField7.setText("");
        }
        catch(SQLException e){}
    }//GEN-LAST:event_jButton2ActionPerformed

    private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton1ActionPerformed
// TODO 将在此处添加您的处理代码：
        String number=javax.swing.JOptionPane.showInputDialog("请输入工号：");
        String name=javax.swing.JOptionPane.showInputDialog("请输入姓名：");
        String sex=javax.swing.JOptionPane.showInputDialog("请输入性别：");
        String birthday=javax.swing.JOptionPane.showInputDialog("请输入出生年月：");
        String ident=javax.swing.JOptionPane.showInputDialog("请输入职称：");
        String xueli=javax.swing.JOptionPane.showInputDialog("请输入最后学历：");
        String adapt=javax.swing.JOptionPane.showInputDialog("请输入院系：");
        try
        {
            rs=stmt.executeQuery("select * from teacher");
            rs.moveToInsertRow();
            rs.updateString("number",number);
            rs.updateString("name",name); 
            rs.updateString("sex",sex);
            rs.updateString("birthday",birthday);
            rs.updateString("ident",ident);
            rs.updateString("xueli",xueli);
            rs.updateString("adapt",adapt);
            rs.insertRow();
        }
        catch(SQLException e){}
    }//GEN-LAST:event_jButton1ActionPerformed
    
    /**
     * @param args the command line arguments
     */
    public void showText(ResultSet rs)
    {
        try
        {
            jTextField1.setText(rs.getString("number"));
            jTextField2.setText(rs.getString("name"));
            jTextField3.setText(rs.getString("sex"));
            jTextField4.setText(rs.getString("birthday"));
            jTextField5.setText(rs.getString("ident"));
            jTextField6.setText(rs.getString("xueli"));
            jTextField7.setText(rs.getString("adapt"));
        }
        catch(SQLException e){}
        
    }
    public void closeDataBase()throws SQLException
    {
        try
        {
            stmt.close();
            con.close();
        }
        catch(Exception e){}
    }
    
    public static void main(String args[]) {
                final DataBaseDesign frame=new DataBaseDesign();
                frame.setLocation(300,200);
                frame.setVisible(true);
                frame.addWindowListener(new WindowAdapter()
                {
                    public void windowClosing(WindowEvent e)
                    {
                        try
                        {
                            frame.closeDataBase();
                        }
                        catch(SQLException evt)
                            {System.out.println(evt.getMessage());}
                        System.exit(0);
                    }
                });
                
    }
    
    // 变量声明 - 不进行修改//GEN-BEGIN:variables
    private javax.swing.JButton jButton1;
    private javax.swing.JButton jButton10;
    private javax.swing.JButton jButton2;
    private javax.swing.JButton jButton3;
    private javax.swing.JButton jButton4;
    private javax.swing.JButton jButton5;
    private javax.swing.JButton jButton6;
    private javax.swing.JButton jButton7;
    private javax.swing.JButton jButton8;
    private javax.swing.JButton jButton9;
    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.JTextField jTextField1;
    private javax.swing.JTextField jTextField2;
    private javax.swing.JTextField jTextField3;
    private javax.swing.JTextField jTextField4;
    private javax.swing.JTextField jTextField5;
    private javax.swing.JTextField jTextField6;
    private javax.swing.JTextField jTextField7;
    private javax.swing.JTextField jTextField8;
    // 变量声明结束//GEN-END:variables
    
}