NetBeans實現(xiàn)學生信息管理系統(tǒng)源碼

《NetBeans實現(xiàn)學生信息管理系統(tǒng)源碼》由會員分享，可在線閱讀，更多相關(guān)《NetBeans實現(xiàn)學生信息管理系統(tǒng)源碼（43頁珍藏版）》請在裝配圖網(wǎng)上搜索。

1、Developed by Group Name: Water Star Reg.No:R3P3000005 Sylvia Reg.No:R3P3000045 June Reg.No:R3P3000050 NIIT PROJECT ION StudentInformationManagementSystem Student Management System Software Batch Co

2、de: Start Date: 08/03/2013 Name of the Coordinator:Shahnawaz Ahmad Khan Name of the Developer: Ms.Water English Name: Water Name (Chinese & Ponyin): 水（water) End Date:14/03/2013 Date of Submission：18/03/2013 NIIT CERTIFICATE This is to certify that this report, ti

3、tled "_Student Information Management System___", embodies the original work done by Peter In partial fulfillment of his course requirement at NIIT. Coordinator: Shahnawaz Ahmad Khan Associate Coordinator: Acknowledgement I would like t

4、o thank our Faculty Mr. Shahnawaz and Chinese associate Faculty Ms. Li Fanfan for all their guidance and support during the entire phase of this project development without which the project would not have been completed. System Analysis System Summary: It is convenient for the users to man

5、age student information.for example :add, delete,update and overview student information. Business Rules: 1,create database ,tables and constraints. 2,interface design 3,implement the source code 4,debug and test Data Query: create database SIMS use SIMS create table useinfo (uid

6、int primary key identity(101,1), uname nchar(20) not null, upassword nchar(10) default '00000', urealname nchar(20), umobil nchar(15) ) create table studentinfor (sid int primary key identity(10001,1), sname nchar(20) not null, sgender char(4), sbirthday nchar(15), smobil

7、nchar(15), semil nchar(20), sacademy nchar(20), smajor nchar(20), ) alter table useinfo add constraint uniq unique(uname) alter table studentinfor add constraint un unique(sname) alter table studentinfor alter column smobil char(11) alter table useinfo drop constraint DF__useinfo__upa

8、sswo__108B795B //How to Use Update、Insert、Select、delete in Code 1)stat=con.prepareStatement("update studentinfor set sgender=?,sbirthday=?,smobil=?,semil=?,sacademy=?,smajor=? where sid=?"); 2)stat=con.prepareStatement("insert into useinfo values(?,?,?,?)"); 3) ResultSet rs

9、= stmt.executeQuery("SELECT * FROM useinfo"); 4) stat=con.prepareStatement("delete from studentinfor where sid=?"); Interface Design for Student_Information Manager__ As the development of the computer, more and more management depend on the computer. For this reason,we

10、group Water design a student information management for the student information management system.It is convenient for the manager to overview ,add, update,delete student information.  Configuration Hardware: Intel (R) Pentium(R) Dual E2180 2.1G Hz 1.20G Hz 3.0

11、0GB RAM 250GB 7200 RPM Hard Disk 10/100NIC Optical Mouse Keyboard 17"Color Monitor Operating System: Microsoft Windows 07 Software: Netbeans IDE 7.2.1、Microsoft SQL Server 2008 Individual Project Schedule SrNo

12、Activity Description Planned date of Completion Actual Date Remarks 1 Create Database 09/03/2013 09/03/2013 No Problem 2 Interface Design 09/03/2013 09/03/2013 No Problem 3 Interface Implementation 11/03/2013 11/03/2013 No problem 4 Function Implementation 13/03/2013 11/03

13、/2013 No problem 5 Debugging 13/03/2013 13/03/2013 Many Problems had been solved 6 7 8 9 10 11  Source Code //login GUI and the main function //StudentMain.java package studentinformationmanagementsystem; import java.awt.*; im

14、port javax.swing.*; import java.awt.event.*; import java.sql.*; import javax.swing.UIManager; public class StudentMain extends JFrame implements ActionListener { JLabel Ltitle,Lname,Lpassword; JButton Blogin,Bexit,Lregister; JTextField TFname; JPasswordField TFpassword;

15、 GridBagLayout gbl; GridBagConstraints gbc; GridLayout gl; Font f1,f2,f3; JPanel p1,p2; Connection con; PreparedStatement stat; Statement stmt; ResultSet rs; public String name; public StudentMain(boolean flag) { //boolean f=f

16、super("StudentInformationManagementSystem"); this.setDefaultCloseOperation(WindowConstants.EXIT_ON_CLOSE); f1=new Font("宋體",1,25); f2=new Font("宋體",1,20); f3=new Font("宋體",1,18); Ltitle=new JLabel("Student Info

17、rmation Management System",JLabel.CENTER); Ltitle.setVerticalAlignment(JLabel.CENTER); Ltitle.setForeground(Color.red); Lname=new JLabel("UserName",JLabel.CENTER); Lpassword=new JLabel("UserPassword",JLabel.CENTER); Lregister=new

18、JButton("Register"); Ltitle.setFont(f1); Lname.setFont(f2); Lpassword.setFont(f2); Lregister.setFont(f2); TFname=new JTextField(15); //TFname.setBounds(0,0,150,40); TFname.setFont(f2); TFpassword=new JPasswor

19、dField(15); TFpassword.setFont(f2); TFpassword.setEchoChar('*'); Blogin=new JButton("Login"); Blogin.setFont(f2); Bexit=new JButton("Exit"); Bexit.setFont(f2); p1=new JPanel(); p2=new JPanel

20、(); gbl=new GridBagLayout(); gbc=new GridBagConstraints(); gl=new GridLayout(3,1); p1.setLayout(gbl); gbc.fill=GridBagConstraints.NONE; gbc.insets=new Insets(0,0,11,10); gbc.anchor=GridBagConstraints.CENTER; gbc.gridwidth=1;

21、 gbl.setConstraints(Lname, gbc); p1.add(Lname); gbc.gridwidth = GridBagConstraints.REMAINDER; gbc.anchor=GridBagConstraints.LINE_START; gbl.setConstraints(TFname, gbc); p1.add(TFname); gbc.gridwidth=1; gbc.anchor=GridBagCo

22、nstraints.CENTER; gbl.setConstraints(Lpassword, gbc); p1.add(Lpassword); gbc.gridwidth = GridBagConstraints.REMAINDER; gbc.anchor=GridBagConstraints.CENTER; gbl.setConstraints(TFpassword, gbc); p1.add(TFpassword); p2.setLayout(new Flow

23、Layout(FlowLayout.CENTER,20,0)); p2.add(Blogin); p2.add(Bexit); p2.add(Lregister); this.setLayout(gl); this.add(Ltitle); this.add(p1); this.add(p2); Blogin.addActionListener(this); Bexit.addActionListener(this

24、); Lregister.addActionListener(this); Dimension screenSize = Toolkit.getDefaultToolkit().getScreenSize(); setBounds((screenSize.width-365)/2, (screenSize.height-449)/2, 550, 350); this.setVisible(flag); } public void actionPerformed(Action

25、Event ae) { if(ae.getActionCommand()=="Exit") System.exit(0); if(ae.getActionCommand()=="Login") { name=TFname.getText(); String password=TFpassword.getText(); if(name.equals("")||passwo

26、rd.equals("")) JOptionPane.showMessageDialog(null,"UserName,UserPassword is not null"); else{ try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); con=DriverManager.getConnection(

27、"jdbc:odbc:DataSource","",""); Statement stmt=con.createStatement(); ResultSet rs = stmt.executeQuery("SELECT * FROM useinfo"); boolean isfind=false; while(rs.next()) {

28、 if(name.equals(rs.getString(2))) { isfind=true; if(password.equals( rs.getString(3))) { this.dispose(); new Function(name);

29、 TFname.setText(""); TFpassword.setText(""); } else { JOptionPane.showMessageDialog(null,"Password is worng！");

30、 } break; } } if( isfind==false) { JOptionPane.showMessageDialog(null,"Not Exsit the User,Please Register！"); } con.cl

31、ose(); }catch(Exception e) { System.out.println("Error "+e.getMessage()); } } } if(ae.getActionCommand()=="Register") { new AddUser(); } }

32、 public static void main(String[] args) { // TODO code application logic here try { UIManager.setLookAndFeel(new com.sun.java.swing.plaf.windows.WindowsLookAndFeel()); } catch(Exception e) { } new StudentMai

33、n(true); } } //Function GUI //Function.java package studentinformationmanagementsystem; import javax.swing.*; import java.awt.*; import java.awt.event.*; import java.sql.*; import javax.swing.table.*; import java.util.*; public class Function extends JFrame implements Actio

34、nListener { JMenu funmenu1,funmenu2,funmenu3; JMenuItem menuitempwd,menulogout,menuexit,menuoverview; JPanel funpl1,funpl2,funpl3,funpl4,funpl5,funpl6; JLabel funlb1,funlb2; JButton funjbadd,funjbdelete,funjbupdate,funjboverview,funjbok,funjbcancel; JMenuBar funmenuba

35、r; JComboBox funjcb1; JTextField funjtf1,funjtf2; Font funf1; JScrollPane jsp; JTable funjtb; JScrollPane funjsp; Connection con; Statement stmt; PreparedStatement stat; ResultSet rs; ResultSetMetaData rsmd; public String ss; Functi

36、on(String str) { super("StudentManagementSystem"); this.setDefaultCloseOperation(WindowConstants.EXIT_ON_CLOSE); ss=str; setLayout(null); funjsp=new JScrollPane(); funf1=new Font("Arial",Font.BOLD|Font.ITALIC,20); funjcb1=new

37、JComboBox(); funjcb1.addItem("select by ID"); funjcb1.addItem("select by name"); funjcb1.addActionListener(this); funpl2=new JPanel(); funpl2.setLayout(new FlowLayout(FlowLayout.CENTER,0,3)); funpl3=new JPanel(); funpl3.setL

38、ayout(new FlowLayout(FlowLayout.LEFT,20,3)); funpl4=new JPanel(); funpl4.setLayout(new FlowLayout(FlowLayout.CENTER,20,3)); funpl5=new JPanel(); funpl5.setLayout(new GridLayout(4,1)); funpl6=new JPanel(); funpl6.setLayout(new FlowLayout()); funmenubar

39、=new JMenuBar(); funmenubar.setBounds(0,0,490,30); funlb1=new JLabel("Welcome To The System! ",JLabel.CENTER); funlb1.setFont(funf1); Object tablesize[][]=new Object[20][8]; for(int i=0;i<20;i++) { for(int j=0;j<8;j++) {

40、 tablesize[i][j]=null; } } String column[]={"sid","sname","sgender","sbirth","smobil","semil","sacademy","smajor"}; funjtb=new JTable(tablesize,column); funjtb.setShowGrid(t

41、rue); funjtf1=new JTextField(25); funjtf1.addActionListener(this); funjbadd=new JButton("Add"); funjbadd.addActionListener(this); funjbdelete=new JButton("Delete"); funjbdelete.addActionListener(this); funjboverview=new JButton(&qu

42、ot;Overview"); funjboverview.addActionListener(this); funjbupdate=new JButton("Update"); funjbupdate.addActionListener(this); funjbok=new JButton("OK"); funjbok.addActionListener(this); funjbcancel=new JButton("Cancel");

43、 funjbcancel.addActionListener(this); funmenu1=new JMenu("user management"); funmenu2=new JMenu(" overview"); funmenu3=new JMenu(" help"); menuoverview=new JMenuItem("check my infomation",JMenuItem.CENTER); menuoverview

44、.addActionListener(this); menuitempwd=new JMenuItem("password management",JMenuItem.CENTER); menuitempwd.addActionListener(this); funmenu1.add(menuoverview); funmenu1.add(menuitempwd); menulogout=new JMenuItem("Log Out",JMenuItem.CENTER);

45、 menulogout.addActionListener(this); funmenu1.add(menulogout); menuexit=new JMenuItem("Exit",JMenuItem.CENTER); menuexit.addActionListener(this); funmenu1.add(menuexit); funmenubar.add(funmenu1); funmenubar.add(funmenu2); funmenubar.add(fu

46、nmenu3); funpl2.add(funlb1); funpl3.add(funjcb1); funpl3.add(funjtf1); funpl3.add(funjbok); funpl3.add(funjbcancel); funpl4.add(funjboverview); funpl4.add(funjbadd); funpl4.add(funjbdelete); funpl4.add(funjbupdate);

47、 funpl5.add(funpl2); funpl5.add(funpl3); funpl5.add(funpl4); funpl5.setBounds(0,50,475,120); funpl6.add(new JScrollPane(funjtb)); funpl6.setBounds(10,165,455,500); add(funmenubar); add(funpl5); add(funpl6); this.setVisible(true);

48、 Dimension screenSize = Toolkit.getDefaultToolkit().getScreenSize(); setBounds((screenSize.width-450)/2, (screenSize.height-550)/2,490,580); } public void actionPerformed(ActionEvent ae) { //update password String s=ae.getActionCommand(); TableModel mdl=f

49、unjtb.getModel(); if(ae.getSource().equals(menuitempwd)) { try{ UpdatePassword up=new UpdatePassword(); up.TFuname.setText(ss); }catch(Exception e) { System.out.println("Error: "+e);

50、} } else if(ae.getSource().equals(funjboverview)) { try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); con=DriverManager.getConnection("jdbc:odbc:DataSource"); stmt=con

51、.createStatement(); rs=stmt.executeQuery("select * from studentinfor"); String rows[]={"","","","","","","",""}; while(rs.next()) {

52、 for(int i=0;i<8;i++) { rows[i]=rs.getString(i+1); mdl.setValueAt(rows[i], rs.getRow()-1, i); } } con.close(); funjtb.repaint(); }

53、 catch(Exception e) { System.out.println("Error:"+e); } } else if(ae.getSource().equals(menuoverview)) { try { con=DriverManager.getConnection("jdbc:odbc:DataSource");

54、 stmt=con.createStatement(); rs=stmt.executeQuery("select uid,uname,urealname,umobil from useinfo where uname='"+ss+"'"); rs.next(); String id=Integer.toString(rs.getInt(1)); String name=rs.getString(2);

55、 String realname=rs.getString(3); String mobil=rs.getString(4); UserInformation ui=new UserInformation(true); ui.TFuid.setText(id); ui.TFuname.setText(name); ui.TFurealname.setText(realname);

56、ui.TFumobil.setText(mobil); con.close(); }catch(Exception e) { System.out.println("Error: "+e); } } else if(ae.getSource().equals(menulogout)) { this.dispose();

57、 new StudentMain(true); } else if(ae.getSource().equals(menuexit)) { System.exit(1); } else if(ae.getSource() == funjbok) { if(funjtf1.getText().equals("")) { JOptionPane.showMessageD

58、ialog(null, "Please Input The StudentID or StudentName"); } else if (funjcb1.getSelectedItem().equals("select by ID")) { int sid=Integer.parseInt(funjtf1.getText()); try { con=Dr

59、iverManager.getConnection("jdbc:odbc:DataSource"); stmt=con.createStatement(); rs=stmt.executeQuery("select * from studentinfor where sid="+sid); String rows[]={"","","","","

60、","","",""}; if(rs.next()) { int id=rs.getInt(1); String ID=Integer.toString(id); String name=rs.getString(2); String gender=

61、rs.getString(3); String birth=rs.getString(4); String mobil=rs.getString(5); String email=rs.getString(6); String academy=rs.getString(7); String major=rs.getString(8);

62、 StudentInformation si=new StudentInformation(); si.TFid.setText(ID); si.TFname.setText(name); si.TFsex.setText(gender); si.TFbirthday.setText(birth); si.TFm

63、obil.setText(mobil); si.TFemail.setText(email); si.TFacademy.setText(academy); si.TFmajor.setText(major); } else { JOptionPane.showMessag

64、eDialog(null, "Check The ID Again!"); } con.close(); } catch(Exception e) { System.out.println("Error:"+e); } } else if (funj

65、cb1.getSelectedItem().equals("select by name")) { try { con=DriverManager.getConnection("jdbc:odbc:DataSource"); stmt=con.createStatement(); rs=stmt.executeQuery("select * from studentinf

66、or where sname='"+funjtf1.getText()+"'"); String rows[]={"","","","","","","",""}; rsmd=rs.getMetaData(); if(rs.next()) {

67、 int id=rs.getInt(1); String ID=Integer.toString(id); String name=rs.getString(2); String gender=rs.getString(3); String birth=rs.getString(4); String mobil=rs.getString(5);

68、 String email=rs.getString(6); String academy=rs.getString(7); String major=rs.getString(8); StudentInformation si=new StudentInformation(); si.TFid.setText(ID); si.TFname.setText(

69、name); si.TFsex.setText(gender); si.TFbirthday.setText(birth); si.TFmobil.setText(mobil); si.TFemail.setText(email); si.TFacademy.setText(academy); si.TFmajor.setText(major);

70、 } else { JOptionPane.showMessageDialog(null, "Check The Name Again!"); } con.close(); funjtb.repaint(); funjtb.updateUI(); } catch(Exception e) { System