NetBeans实现学生信息管理系统源码

Developed by Group Name: Water Star Reg.No:R3PSylvia Reg.No:R3PJune Reg.No:R3PNIITPROJECT IONStudentInformationManagementSystemStudent Management System SoftwareBatch Code: Start Date: 08/03/2013Name of the Coordinator:Shahnawaz Ahmad KhanName of the Developer: Ms.WaterEnglish Name: 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 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 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: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), 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_useinfo_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 = 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 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. 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 Keyboard 17Color 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/2013No 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 java.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; 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 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 Information 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 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 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(); 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_START; 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); 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.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(); 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:DataSource,); 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(name); 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.println(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); /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; JMenuItem 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; JTable 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=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); 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(); funmenubar.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;i20;i+) for(int j=0;j8;j+) tablesizeij=null; String column=sid,sname,sgender,sbirth,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 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(this); 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); menuoverview.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(this); 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(funjbok); 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(funmenubar); 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(); TableModel 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); con=DriverManager.getConnection(jdbc:odbc:DataSource); stmt=con.createStatement(); rs=stmt.executeQuery(select * from studentinfor); String rows=,; while(rs.next() for(int i=0;i8;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.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); 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); 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.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.parseInt(funjtf1.getText(); try con=DriverManager.getConnection(jdbc:odbc:DataSource); stmt=con.createStatement(); rs=stmt.executeQuery(select * from studentinfor where sid=+sid); String rows=,; 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 maj