Java课程设计 学生基本信息管理个人博客

学生基本信息管理系统个人博客

团队课程设计链接

http://www.cnblogs.com/ll321/p/7067598.html

个人负责模块

负责部分界面设计，处理代码；
处理部分数据库数据。

自己的代码提交记录截图

自己负责模块或任务详细说明

数据库数据删除(在删除界面把数据库数据删除)

package database;

import java.sql.SQLException;

public class DELETE {
	public static String[][] delete(String name){
		String str ="delete from students where name="+"'"+name+"'"+";";
		String[][] strs = new String[100][8];
		try{
			DBUtil.exec(str);

		}catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return strs;

	}
	
}

图形界面设计和处理

1.搜索界面设计（把数据库的数据输送到图形界面）

public SearchJFrame() {
        initComponents();
    }
private void Button1ActionPerformed(java.awt.event.ActionEvent evt) {
String name = TextField1.getText().trim();
     if(name.length()==0){
     JOptionPane.showMessageDialog(null,"输入不能为空！");
                                }
        else{
        String[][] strs = SEARCH.serach(name);
        for (int i = 0; i < 10; i++) {
        	for (int j = 0; j < 8; j++) {
        		System.out.print(strs[i][j] + " ");
        	}
        	System.out.println();
        }
        ImformationJFrame ImformationJFrame = new ImformationJFrame(strs);
        ImformationJFrame.setVisible(true);
        this.setVisible(false);
        }
    }
       private void Button2ActionPerformed(java.awt.event.ActionEvent evt) {
       MainJFrame MainJFrame = new MainJFrame();
       MainJFrame.setVisible(true);
       this.setVisible(false);
    }
    public static void main(String args[]) {
        /* Set the Nimbus look and feel */
        //<editor-fold defaultstate="collapsed" desc=" Look and feel setting code (optional) ">
        /* If Nimbus (introduced in Java SE 6) is not available, stay with the default look and feel.
         * For details see http://download.oracle.com/javase/tutorial/uiswing/lookandfeel/plaf.html
         */
        try {
            for (javax.swing.UIManager.LookAndFeelInfo info : javax.swing.UIManager.getInstalledLookAndFeels()) {
                if ("Nimbus".equals(info.getName())) {
                    javax.swing.UIManager.setLookAndFeel(info.getClassName());
                    break;
                }
            }
        } catch (ClassNotFoundException ex) {
            java.util.logging.Logger.getLogger(SearchJFrame.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
        } catch (InstantiationException ex) {
            java.util.logging.Logger.getLogger(SearchJFrame.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
        } catch (IllegalAccessException ex) {
            java.util.logging.Logger.getLogger(SearchJFrame.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
        } catch (javax.swing.UnsupportedLookAndFeelException ex) {
            java.util.logging.Logger.getLogger(SearchJFrame.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
        }
}

2.添加界面设计（把输入的数据输送到数据库）

public class AddJFrame extends javax.swing.JFrame {
    public AddJFrame() {
        initComponents();
    }
    private void initComponents() {
        setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
        AddButton.setText("添加");
        AddButton.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                try {
					AddButtonActionPerformed(evt);
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
            }
        });
        Button2.setText("返回");
        Button2.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                Button2ActionPerformed(evt);
            }
        });
        pack();
    }
    private void AddButtonActionPerformed(java.awt.event.ActionEvent evt) throws SQLException {
       String number = TextField1.getText().trim();
       String name = TextField2.getText().trim();
       String gender = TextField3.getText().trim();
       String birthdate = TextField4.getText().trim();
       String politics = TextField5.getText().trim();
       String address = TextField6.getText().trim();
       String telephone = TextField7.getText().trim();
       String dormitory = TextField8.getText().trim();
       if(number.length()==0||name.length()==0||gender.length()==0||birthdate.length()==0||politics.length()==0||address.length()==0||telephone.length()==0||dormitory.length()==0){
           JOptionPane.showMessageDialog(null, "有数据为空！！");
       }
       else{
    	   ADD.add(number, name, gender, birthdate, politics, address, telephone, dormitory);
    	    JOptionPane.showMessageDialog(null, "添加成功！");

    }
    }
	private void Button2ActionPerformed(java.awt.event.ActionEvent evt) {
        MainJFrame MainJFrame = new MainJFrame();
        MainJFrame.setVisible(true);
        this.setVisible(false);
    }
    public static void main(String args[]) {
        try {
            for (javax.swing.UIManager.LookAndFeelInfo info : javax.swing.UIManager.getInstalledLookAndFeels()) {
                if ("Nimbus".equals(info.getName())) {
                    javax.swing.UIManager.setLookAndFeel(info.getClassName());
                    break;
                }
            }
        } catch (ClassNotFoundException ex) {
            java.util.logging.Logger.getLogger(AddJFrame.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
        } catch (InstantiationException ex) {
            java.util.logging.Logger.getLogger(AddJFrame.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
        } catch (IllegalAccessException ex) {
            java.util.logging.Logger.getLogger(AddJFrame.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
        } catch (javax.swing.UnsupportedLookAndFeelException ex) {
            java.util.logging.Logger.getLogger(AddJFrame.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
        }
        java.awt.EventQueue.invokeLater(new Runnable() {
            public void run() {
                new AddJFrame().setVisible(true);
            }
        });
    }

}

3.删除界面设计（将数据库的数据删除）

private void Button2ActionPerformed(java.awt.event.ActionEvent evt) {
        MainJFrame MainJFrame = new MainJFrame();
        MainJFrame.setVisible(true);
        this.setVisible(false);
    }

    private void Button1ActionPerformed(java.awt.event.ActionEvent evt) {
         String number = TextField1.getText().trim();
       String name = TextField2.getText().trim();
        if(name.length()==0&&number.length()==0){
           JOptionPane.showMessageDialog(null,"输入不能为空！" );
        }
        else{
        	database.DELETE.delete(name);

        }
    }
    public static void main(String args[]) {
        try {
            for (javax.swing.UIManager.LookAndFeelInfo info : javax.swing.UIManager.getInstalledLookAndFeels()) {
                if ("Nimbus".equals(info.getName())) {
                    javax.swing.UIManager.setLookAndFeel(info.getClassName());
                    break;
                }
            }
        } catch (ClassNotFoundException ex) {
            java.util.logging.Logger.getLogger(DeleteJFrame.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
        } catch (InstantiationException ex) {
            java.util.logging.Logger.getLogger(DeleteJFrame.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
        } catch (IllegalAccessException ex) {
            java.util.logging.Logger.getLogger(DeleteJFrame.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
        } catch (javax.swing.UnsupportedLookAndFeelException ex) {
            java.util.logging.Logger.getLogger(DeleteJFrame.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
        }
        java.awt.EventQueue.invokeLater(new Runnable() {
            public void run() {
                new DeleteJFrame().setVisible(true);
            }
        });
}

4.修改界面设计（修改数据库的数据内容）

    private void Button1ActionPerformed(java.awt.event.ActionEvent evt) {

      String number = TextField1.getText().trim();
      String name = TextField2.getText().trim();
        String gender = TextField3.getText().trim();
         String birthdate = TextField4.getText().trim();
          String politics = TextField5.getText().trim();
           String address = TextField6.getText().trim();
            String telephone = TextField7.getText().trim();
             String dormitory = TextField8.getText().trim();
              CHANGE.change(number,name,gender, birthdate, politics, address, telephone, dormitory);
    }

    private void Button2ActionPerformed(java.awt.event.ActionEvent evt) {
        MainJFrame MainJFrame = new MainJFrame();
        MainJFrame.setVisible(true);
        this.setVisible(false);
    }

    public static void main(String args[]) {
        try {
            for (javax.swing.UIManager.LookAndFeelInfo info : javax.swing.UIManager.getInstalledLookAndFeels()) {
                if ("Nimbus".equals(info.getName())) {
                    javax.swing.UIManager.setLookAndFeel(info.getClassName());
                    break;
                }
            }
        } catch (ClassNotFoundException ex) {
            java.util.logging.Logger.getLogger(ChangeJFrame.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
        } catch (InstantiationException ex) {
            java.util.logging.Logger.getLogger(ChangeJFrame.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
        } catch (IllegalAccessException ex) {
            java.util.logging.Logger.getLogger(ChangeJFrame.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
        } catch (javax.swing.UnsupportedLookAndFeelException ex) {
            java.util.logging.Logger.getLogger(ChangeJFrame.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
        }
        java.awt.EventQueue.invokeLater(new Runnable() {
            public void run() {
                new ChangeJFrame().setVisible(true);
            }
        });
}

课程设计感想

通过这次的课程设计，我认识到了自己的不足之处，对于一部分知识掌握的还不是很好，还有很多的欠缺之处，需要自己不断的改进。而且在这次课设的过程中，大大地提升了对net beans 和数据库的使用熟练度，有了很大收获。