《NetBeans實現(xiàn)學(xué)生信息管理系統(tǒng)源碼》由會員分享，可在線閱讀，更多相關(guān)《NetBeans實現(xiàn)學(xué)生信息管理系統(tǒng)源碼（43頁珍藏版）》請在裝配圖網(wǎng)上搜索。
1、Developed by Group Name: Water Star Reg.No:R3P3000005Sylvia Reg.No:R3P3000045June Reg.No:R3P3000050NIITPROJECT IONStudentInformationManagementSystemStudent Management System SoftwareBatch Code: Start Date: 08/03/2013Name of the Coordinator:Shahnawaz Ahmad KhanName of the Developer: Ms.WaterEnglish N
2、ame: WaterName (Chinese & Ponyin): 水（water)End Date:14/03/2013Date of Submission：18/03/2013NIITCERTIFICATEThis is to certify that this report, titled "_Student Information Management System_", embodies the original work done by Peter In partial fulfillment of his course requirement at
3、NIIT.Coordinator: Shahnawaz Ahmad KhanAssociate Coordinator: AcknowledgementI would like to 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
4、 completed.System AnalysisSystem Summary: It is convenient for the users to manage 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 testData Query
5、:create database SIMSuse SIMScreate table useinfo(uid 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
6、), sbirthday nchar(15), smobil nchar(15), semil nchar(20), sacademy nchar(20), smajor nchar(20),)alter table useinfoadd constraint uniq unique(uname)alter table studentinforadd constraint un unique(sname)alter table studentinforalter column smobil char(11)alter table useinfodrop constraint DF_useinf
7、o_upasswo_108B795B /How to Use Update、Insert、Select、delete in Code1)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 = stm
8、t.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 group Water design
9、 a student information management for the student information management system.It is convenient for the manager to overview ,add, update,delete student information. ConfigurationHardware: Intel (R) Pentium(R) Dual E2180 2.1G Hz 1.20G Hz 3.00GB RAM 250GB 7200 RPM Hard Disk 10/100NIC Optical Mouse Ke
10、yboard 17"Color Monitor Operating System: Microsoft Windows 07Software: Netbeans IDE 7.2.1、Microsoft SQL Server 2008Individual Project ScheduleSrNoActivity DescriptionPlanned date of CompletionActual DateRemarks1Create Database09/03/201309/03/2013No Problem2Interface Design09/03/201309/03/2013N
11、o Problem3Interface Implementation11/03/201311/03/2013No problem4Function Implementation13/03/201311/03/2013No problem5Debugging13/03/201313/03/2013Many Problems had been solved67891011Source Code/login GUI and the main function /StudentMain.java package studentinformationmanagementsystem;import jav
12、a.awt.*;import 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; GridBagLayout gbl; GridBa
13、gConstraints 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 super("StudentInformationManagementSystem"); this.setDefaultCloseOperation(WindowConstants.E
14、XIT_ON_CLOSE); f1=new Font("宋體",1,25); f2=new Font("宋體",1,20); f3=new Font("宋體",1,18); Ltitle=new JLabel("Student Information Management System",JLabel.CENTER); Ltitle.setVerticalAlignment(JLabel.CENTER); Ltitle.setForeground(Color.red); Lname=new JLabel("
15、;UserName",JLabel.CENTER); Lpassword=new JLabel("UserPassword",JLabel.CENTER); Lregister=new 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)
16、; TFpassword=new JPasswordField(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(); gbl=new GridBagLayout(); gbc=new GridBagConstraints()
17、; 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; gbl.setConstraints(Lname, gbc); p1.add(Lname); gbc.gridwidth = GridBagConstraints.REMAINDER; gbc.anchor=GridBagConstraints.LINE_STAR
18、T; gbl.setConstraints(TFname, gbc); p1.add(TFname); gbc.gridwidth=1; gbc.anchor=GridBagConstraints.CENTER; gbl.setConstraints(Lpassword, gbc); p1.add(Lpassword); gbc.gridwidth = GridBagConstraints.REMAINDER; gbc.anchor=GridBagConstraints.CENTER; gbl.setConstraints(TFpassword, gbc); p1.add(TFpassword
19、); p2.setLayout(new FlowLayout(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); Lregister.addActionListener(this); Dimension screenSize = Toolkit
20、.getDefaultToolkit().getScreenSize(); setBounds(screenSize.width-365)/2, (screenSize.height-449)/2, 550, 350); this.setVisible(flag); public void actionPerformed(ActionEvent ae) if(ae.getActionCommand()="Exit") System.exit(0); if(ae.getActionCommand()="Login") name=TFname.getText
21、(); String password=TFpassword.getText(); if(name.equals("")|password.equals("") JOptionPane.showMessageDialog(null,"UserName,UserPassword is not null"); else try Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); con=DriverManager.getConnection("jdbc:odbc:Da
22、taSource","",""); Statement stmt=con.createStatement(); ResultSet rs = stmt.executeQuery("SELECT * FROM useinfo"); boolean isfind=false; while(rs.next() if(name.equals(rs.getString(2) isfind=true; if(password.equals( rs.getString(3) this.dispose(); new Function(nam
23、e); TFname.setText(""); TFpassword.setText(""); else JOptionPane.showMessageDialog(null,"Password is worng！"); break; if( isfind=false) JOptionPane.showMessageDialog(null,"Not Exsit the User,Please Register！"); con.close(); catch(Exception e) System.out.printl
24、n("Error "+e.getMessage(); if(ae.getActionCommand()="Register") new AddUser(); 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 StudentMain(true);
25、/Function GUI/Function.javapackage 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 ActionListener JMenu funmenu1,funmenu2,funmenu3; JMenuI
26、tem menuitempwd,menulogout,menuexit,menuoverview; JPanel funpl1,funpl2,funpl3,funpl4,funpl5,funpl6; JLabel funlb1,funlb2; JButton funjbadd,funjbdelete,funjbupdate,funjboverview,funjbok,funjbcancel; JMenuBar funmenubar; JComboBox funjcb1; JTextField funjtf1,funjtf2; Font funf1; JScrollPane jsp; JTabl
27、e funjtb; JScrollPane funjsp; Connection con; Statement stmt; PreparedStatement stat; ResultSet rs; ResultSetMetaData rsmd; public String ss; Function(String str) super("StudentManagementSystem"); this.setDefaultCloseOperation(WindowConstants.EXIT_ON_CLOSE); ss=str; setLayout(null); funjsp
28、=new JScrollPane(); funf1=new Font("Arial",Font.BOLD|Font.ITALIC,20); funjcb1=new 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
29、); funpl3=new JPanel(); funpl3.setLayout(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=new JMenuBar(); f
30、unmenubar.setBounds(0,0,490,30); funlb1=new JLabel("Welcome To The System! ",JLabel.CENTER); funlb1.setFont(funf1); Object tablesize=new Object208; for(int i=0;i<20;i+) for(int j=0;j<8;j+) tablesizeij=null; String column="sid","sname","sgender","sbi
31、rth","smobil","semil","sacademy","smajor" funjtb=new JTable(tablesize,column); funjtb.setShowGrid(true); funjtf1=new JTextField(25); funjtf1.addActionListener(this); funjbadd=new JButton("Add"); funjbadd.addActionListener(this); funjbdelete=new
32、JButton("Delete"); funjbdelete.addActionListener(this); funjboverview=new JButton("Overview"); funjboverview.addActionListener(this); funjbupdate=new JButton("Update"); funjbupdate.addActionListener(this); funjbok=new JButton("OK"); funjbok.addActionListener(t
33、his); funjbcancel=new JButton("Cancel"); funjbcancel.addActionListener(this); funmenu1=new JMenu("user management"); funmenu2=new JMenu(" overview"); funmenu3=new JMenu(" help"); menuoverview=new JMenuItem("check my infomation",JMenuItem.CENTER); men
34、uoverview.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); menulogout.addActionListener(thi
35、s); funmenu1.add(menulogout); menuexit=new JMenuItem("Exit",JMenuItem.CENTER); menuexit.addActionListener(this); funmenu1.add(menuexit); funmenubar.add(funmenu1); funmenubar.add(funmenu2); funmenubar.add(funmenu3); funpl2.add(funlb1); funpl3.add(funjcb1); funpl3.add(funjtf1); funpl3.add(fu
36、njbok); funpl3.add(funjbcancel); funpl4.add(funjboverview); funpl4.add(funjbadd); funpl4.add(funjbdelete); funpl4.add(funjbupdate); 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(fu
37、nmenubar); add(funpl5); add(funpl6); this.setVisible(true); 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(); TableMod
38、el mdl=funjtb.getModel(); if(ae.getSource().equals(menuitempwd) try UpdatePassword up=new UpdatePassword(); up.TFuname.setText(ss); catch(Exception e) System.out.println("Error: "+e); else if(ae.getSource().equals(funjboverview) try Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
39、con=DriverManager.getConnection("jdbc:odbc:DataSource"); stmt=con.createStatement(); rs=stmt.executeQuery("select * from studentinfor"); String rows="","","","","","","","" while(rs.next() for(int i=0
40、;i<8;i+) rowsi=rs.getString(i+1); mdl.setValueAt(rowsi, rs.getRow()-1, i); con.close(); funjtb.repaint(); catch(Exception e) System.out.println("Error:"+e); else if(ae.getSource().equals(menuoverview) try con=DriverManager.getConnection("jdbc:odbc:DataSource"); stmt=con.create
41、Statement(); 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); String realname=rs.getString(3); String mobil=rs.getString(4); UserInformation ui=new
42、 UserInformation(true); ui.TFuid.setText(id); ui.TFuname.setText(name); ui.TFurealname.setText(realname); ui.TFumobil.setText(mobil); con.close(); catch(Exception e) System.out.println("Error: "+e); else if(ae.getSource().equals(menulogout) this.dispose(); new StudentMain(true); else if(ae
43、.getSource().equals(menuexit) System.exit(1); else if(ae.getSource() = funjbok) if(funjtf1.getText().equals("") JOptionPane.showMessageDialog(null, "Please Input The StudentID or StudentName"); else if (funjcb1.getSelectedItem().equals("select by ID") int sid=Integer.pa
44、rseInt(funjtf1.getText(); try con=DriverManager.getConnection("jdbc:odbc:DataSource"); stmt=con.createStatement(); rs=stmt.executeQuery("select * from studentinfor where sid="+sid); String rows="","","","","","","&q
45、uot;,"" if(rs.next() 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); String email=rs.getString(6); String academy=rs.getString(7); String major=rs.getString(8); Stud
46、entInformation si=new StudentInformation(); si.TFid.setText(ID); si.TFname.setText(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); else JOptionPane.showMessageDialog(null, &
47、quot;Check The ID Again!"); con.close(); catch(Exception e) System.out.println("Error:"+e); else if (funjcb1.getSelectedItem().equals("select by name") try con=DriverManager.getConnection("jdbc:odbc:DataSource"); stmt=con.createStatement(); rs=stmt.executeQuery(&qu
48、ot;select * from studentinfor where sname='"+funjtf1.getText()+"'"); String rows="","","","","","","","" rsmd=rs.getMetaData(); if(rs.next() int id=rs.getInt(1); String ID=Integer.toString(id); Str
49、ing name=rs.getString(2); String gender=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); StudentInformation si=new StudentInformation(); si.TFid.setText(ID); si.TFname.setText(name
50、); si.TFsex.setText(gender); si.TFbirthday.setText(birth); si.TFmobil.setText(mobil); si.TFemail.setText(email); si.TFacademy.setText(academy); si.TFmajor.setText(major); else JOptionPane.showMessageDialog(null, "Check The Name Again!"); con.close(); funjtb.repaint(); funjtb.updateUI(); catch(Exception e) System
NetBeans實現(xiàn)學(xué)生信息管理系統(tǒng)源碼
