学生学籍管理系统含java源代码

1、学生学籍管理详细设讣学号：姓名：班级：一、设计题目：学生学籍管理二：设计内容：设计GUI学生学籍管理界面，用户可以加入学生信息，并对基本信息进行修 改，添加，查询，删除。三：设计要求：进行简单的学生信息管理。四：总体设计（1）登陆界面的设计（2）主窗体的设计（3）添加学生信息窗体（4）查询学生信息窗体（5）修改学生信息窗体（6）删除学生信息窗体（7）事件响应的处理五：具体设计（1）程序结构的说明：A. 入 口 程序：student, java;B. 登陆界面程丿了；： mainframe, java;C. 主窗体程序：interfac. java;D. 添加信息窗口程序：tj. java;E.

2、 修改信息窗口程序：xg. java;F査询信息窗口程序:ex. java;G. 删除信息窗口程序:sc. java;H. 程序数据连接：DatabaseConn. java;(2)程序代码及分析说明A程序源代码(已提交)B. Student, java是程序的入口。使登录窗口位于窗口中间，并且不可改变窗口 大小。C. mainframe, java是程序的登陆窗体。输入用户名和密码(用户名和密码在数 据库的password表中)点击“进入系统S然后登陆界面消失；出现要操作的界 面(屏幕左上角)。D. tj. java是添加信息界面。添加基本信息后，点击添加信息”按钮,将信息 加入xinxi表

3、中。E. xg. java是修改信息界面。输入要修改的学号或姓名(两者数其一或全部输 入)，并输入所有信息，点击“修改信息”按钮(如果数据库中不存在此学号， 则弹出对话框“无此学生信息”)，若有则修改。F. sc. java是删除信息界面。输入要删除的学生的学号，点击“删除信息”按钮, 弹出确认删除对话框，即可删除该生信息。G. ex. java是查询信息界面。输入要查询的学生学号，点击“信息查询”按钮， 在相应的文本区里显示查询的信息。H:源代码/student, java：程序的入口。初始化界面，使主界面位于屏幕中间，且用户不 能改变大小/功能：完成程序的执行顺序import javax.

4、swing.UIManager;import javaawt*;import javasql*;/import screenpublic class studentboolean packFrame=false;/JFrame frame=new JFrame();public student()mainframe frame=new mainframe():if (packFrame)frame. pack();elseframe validate();DimensionscreenSize二Toolkit getDefaultToolkit() getScreenSize();Dimens

5、ion frameSize=frame getSize(); if(frameSize heightscreenSize height) frameSize height二screenSize height; if(frameSize widthscreenSize width) frameSize width二screenSize width; frame setLocation(screenSize width一frameSize width)/2, (screenSiz e.height-frameSize height)/2);frame. setVisible(true);publi

6、c static void main(StringZ args)tryUIManager setLookAndFeel (UIManager呂etSystemLookAndFeelClassName ( );catch(Exception e)e. printStackTrace ();new student ();数据库连接/package sql. database;import java.sql.*;public class DatabaseConnprivate static String user二“；private static String password二“；private

7、Connection conn=null;private Statement stmt二null;private ResuItSet rs二null;statictry Class. forName (，zsun. jdbc. odbc. JdbcOdbcDriver);/加载驱动 catch(ClassNotFoundException e) /创建数据库连接对象public Connection getConnectionOtryconn=DriverManager getConnection(zz jdbc :odbc: stu user, password); return conn;

8、catch(SQLException e)return null;public Statement createStat()tryconn=getConnect ion ();stmt=conn. createStatement();return stmt:catch (SQLException e) return null;public ResultSet getRs(String sql)try conn=getConnect ion();/ stmt=createStat();rs=stmt executeQuery(sql);return rs;catch(SQLException e

9、)return null;public void close()tryif (rs!=null)rs. close ();if(stmt!=null)stmt close ();if(conn!=null)conn. close ();catch(SQLException ex)ex. printStackTrace ();/mainframe javaimport javaawt*;import javaawt.event*;import javax swing *;import java.sql*;public class mainframe extends JFrame implemen

10、ts ActionListener static mainframe s;static JPanel pan=new JPanel ();static JLabel labell = new JLabel C用 户)；static JLabel label2 = new JLabel C密 码)；static JTextField textFieldl = new JTextFieldO ;static JPasswordField password = new JPasswordFieldO ;static JButton buttonl = new JButtonC进入系统)；static

11、 JRadioButton radioBu11on 1=new JRadioButton(管理员, true) ;/ “管理员”初始状态被选中static JRadioButton radioButton2=new JRadioButton(z/学生”)；static JRadioButton radioButton3=new JRadioButton(z/教师”)；ButtonGroup buttonGroup=new ButtonGroup();public mainframe()JLabel label=new JLabel (new Imageicon(z/图片 44.jpg);lab

12、el. setSize(400, 400);pan. add (label);pan. setLayout(null);pan. setSize (400, 400);this. setTitle (”学籍管理系统)；this. setSize (400, 400);this setLayout(null);labell. setBounds (100, 25, 49, 20);textFieldl. setBounds(155, 24, 120, 20);label2. setBounds (100, 62, 49, 20);password setBounds(155, 61, 120,

13、20);buttonl. setBounds (150, 200, 101, 22);radioButtonl. setBounds(105, 120, 80, 20);radioButton2. setBounds(180, 120, 60, 20); radioButton3. setBounds(240, 120, 60, 20); buttonl addActionListener(this);buttonGroup add(radioButtonl);buttonGroup add(radioButton2);buttonGroup add(radioButton3);this ad

14、d(radioButtonl);this add(radioButton2);this add(radioButton3);this, add(labell);this. add(label2);this add(textFieldl);this add(password);this add(buttonl);this add(pan);this setDefaultCloseOperation(JFrame EXIT_ON_CLOSE); this setVisible(true);public static void main(String args)new mainframe ();pu

15、blic void actionPerformed(ActionEvent e)辻(radioButtonl. isSelectedO)/管理员if(textField1. getText() equals(syc)&password getText() equals(123) interfac b=new interfac():this dispose ();/JOptionPane. showMessageDialog(null,登陆成功)；elseif(“ equals(textField1. getText ()I Iequals (password getText () ) 空）；J

16、OptionPane. showMessageDialog(null,用户名或密码不能为else有误）；JOptionPane. showMessageDialog(null,用户名或密码输入辻(radioButton2. isSelected()/学生 tryClass forName (z/sun. jdbc odbc JdbcOdbcDriver，z);catch (ClassNotFoundException ce)JOptionPane showMessageDialog(s, ce. getMessage();tryConnectioncon=DriverManager getCo

17、nnection(，z jdbc: odbc: stu，z,”)；Statement stmt = con. createStatement();ResultSet rs = stmtexecuteQuery(select * from password where 用 户 名二 +textFieldl. getText ()+ and 密码二z，+password. getText ()+);if(textField1. getText() equals(): password getText() equals()JOptionPane. showMessageDialog(this,用 户

18、名 或密码 不可为空！ ”)；else if (rsnext () new interfac () :elseJOptionPane. showMessageDialog(this,您的输入有误);/stmt close ();catch (SQLException se)JOptionPane showMessageDialog(s, se. getMessage(); /interface javaimport javaawtimport javaawt.event*;import javax swing *;public class interfac extends JFrame imp

19、lements ActionListener static JMenuBar jMenuBar = new JMenuBar() ;/菜单条static JMenu jMenuFile = new JMenu(文件”)；/菜单项static JMenu jMenuExit = new JMenu(退岀)；static JMenuItem jMenuIteml = new JMenuItem(添加信息)；/菜单子项static JMenuItem jMenuItem2 = new JMenuItem(修改信息)；static JMenuItem jMenuItem3 = new JMenuIte

20、m(，z信息查询)；static JMenuItem jMenuIteml = new JMenuItem(，z删除信息);static JLabel label3 = new JLabel C请选择操作项”); static JLabel label4 = new JLabel C学籍管理系统”);static JButton static JButtonbutton2 = new JButton (添加信息)button3 = new JButton (修改信息)JButton （信息查询） JButton C删除信息。static JButton button4 = new static

21、 JButton buttond = newpublic interfac()this. setTitlef学籍管理系统)；this setLayout(null);this. setSize (400, 400);label3. setBounds(15& 92, 9& 33);label3 setFont(new Font(Dialog, Font PLAIN, 15); label4. setFont(new Font (Dialog, Font. BOLD, 20); label4. setBounds (157, 37, 280, 40);button2. setBounds (74

22、, 136, 97, 33);button3. setBounds (226, 136, 97, 33); button4. setBounds (74, 185, 97, 33);buttono. setBounds (226, 185, 97, 33);this add(button2);this add(button3);this add(button4);this add(buttond);this. add(label3);this. add(label4);setJMenuBar (jMenuBar);jMenuFile. add(jMenuIteml) !/n文件菜单项中加入子菜

23、单 jMenuFile. add(jMenuItem2);jMenuFile. add(jMenuItem3);jMenuFile. add(jMenuItem4);jMenuBar. add(jMenuFile) ;/将菜单项加入菜单条jMenuBar add(jMenuExit);button2. addActionListener (this) ;/本窗 口 向按钮事件源注册 button3 addActionListener (this);button4 addActionListener(this);buttond addActionListener(this);jMenuIteml

24、. addActionListener (this) ;/本窗口菜单子项注册 jMenuItem2 addActionListener (this);jMenuItem3 addActionListener(this);jMenuItem4 addActionListener(this);jMenuExit addActionListener(this);this setDefaultCloseOperation(JFrame EXIT_ON_CLOSE);this setVisible(true);public static void main(StringZ args)interfac a

25、=new interfac ():public void actionPerformed(ActionEvent e) 按钮事件的处理if(e. getSource()=jMenuExit)System. exit (0);else if(e. getSource()=jMenuIteml e. getSource()=button2) tryt j a=new t j ();catch(Exception ee) else if(e. getSource()=jMenuItem2 e. getSource()=button3) tryxg a=new xg ();catch(Exceptio

26、n ed) elseif(e. getSource()=jMenuItem3 e getSource()=button4)tryex a=new cx() ; catch(Exception ec) elseif (e. getSource () =jMenuIteml I e. getSource () =button5)trysc a=new sc ();catch(Exception es)/tj. java添加界面import javax swing *;import javaawt*;import javaawt.event*;import java.sql*;public clas

27、s tj extends JFrame implements ActionListenerstatic tj s:static JLabel label 1 = new JLabel (学号：”)；static JTextField textFieldl = new JTextField();static JLabel label2 = new JLabel (姓名：”)；static JTextField textField2 = new JTextField();static JLabel label3 = new JLabel (性别：”)；static JTextField textF

28、ield7=new JTextField();static JLabel label4 = new JLabel (出生日期：”)；static JTextField textField3 二 new JTextField;static JLabel labelo = new JLabel (政治面貌：”)；static JTextField textField8=new JTextField();static JLabel label6 = new JLabel (籍贯”)；static JTextField textField4 = new JTextField;static JLabel

29、 label7 = new JLabel C系别：”)；static JTextField textField9 = new JTextFieldD ; static JLabel label8 = new JLabel (专业:”)； static JTextField textFieldd = new JTextField(); static JButton buttonl = new JButton(，z增加”)；public t j ()this. setTitle(z，增加学生信息);this setLayout (null);this. setSize (400, 400);lab

30、el 1 setBounds (30, 11,51,33);textField1. setBounds(86,16,74,22);label2 setBounds(162, 11,51,33)9textField2 setBounds(192,16,44,22);label3. setBounds (241, 11,70,33)9textField7. setBounds(275,15,50,25);label4 setBounds (31, 53,55,33);textField3 setBounds(86,5&74,22);label5 setBounds(241, 53,70,33)Vt

31、extField8 setBounds(296,57,72,25);label6 setBounds(163, 53,26,33)ftextField-! setBounds (191,5&44,22);label?. setBounds (30, 94,50,33);textField9. setBounds(86, 94, 74, 22); label8. setBounds (163, 94, 51, 33); textFieldd. setBounds(190, 99, 17& 22); buttonl. setBounds (25, 241, 80, 33); buttonl add

32、ActionListener(this);this add(labell); this. add(label2); this. add(label3); this. add(label4); this, add(labelo); this. add(label6); this, add(label?); this. add(label8); this add(textFieldl); this. add(textField2); this. add(textField3); this add(textField4); this add(textField5); this add(textFie

33、ld7);this add(textField8);this add(textField9);this add(buttonl);this. setDefaultCloseOperation(JFrame. DISPOSE_ON_CLOSE);this setVisible(true);public static void main(StringLZ args) throws Exceptiont j a=new t j ();a. setDefaultCloseOperation(JFrame EXIT_ON_CLOSE);public void actionPerformed (Actio

34、nEvent e)/事件处理程序if (e. getSource () = buttonl)tryClass fordme(sun. jdbc odbc JdbcOdbcDriver/z);catch (ClassNotFoundException ce)JOptionPane. showMessageDialog(s, ce. getMessage();tryConnectioncon=DriverManager getConnection(，z jdbc: odbc: stu，z, “)；Statement stmt = con. createStatement();ResultSet r

35、s=stmt execut eQuery (select * from xinxi where 学号 二z，+textField 1 getText()+)；if (rs next ()JOptionPane. showMessageDialog(null,此学号已经被注册)；elsestmt, execute （，zinsert into xinxi （学号，姓名，性别，出生日期,政治面貌, 籍贯，系别，专业)values (皿+textFieldl. getText ()+z/，,，z+textField2. getText () +,，+textField7. getText ()+，+

36、textField3 getText()+, +textField8 getText () +, +textField4. getText ()+, +textField9. getText ()+, +textField3. getText ()+);JOptionPane. showMessageDialog(null,添加信息成功)；catch (SQLException se)JOptionPane showMessageDialog(s, se. getMessage();/xg. java修改界面import javax swing *;import javaawt*;import

37、 javaawt.event*;import java.sql*;public class xg extends JFrame implements ActionListener static xg s:static JLabel label 1 = new JLabel (学号：”)；static JTextField textFieldl = new JTextField();static JLabel label2 = new JLabel (姓名：”)；static JTextField textField2 = new JTextField(); static JLabel labe

38、l3 = new JLabel (性别：”)；static JTextField textField7=new JTextField();static JLabel label4 = new JLabel (出生日期：”)； static JTextField textField3 二 new JTextField;static JLabel labelo = new JLabel (政治面貌：”)； static JTextField textField8=new JTextField();static JLabel label6 = new JLabel (籍贯”)；static JTex

39、tField textField4 = new JTextField;static JLabel label7 = new JLabel C系别：”)；static JTextField textField9 = new JTextFieldD ;static JLabel label8 = new JLabel (专业:”)；static JTextField textFieldd = new JTextField();static JButton button2=new JButton(修改)；public xg()this. setTitleC修改学生信息);this setLayout

40、 (null);this. setSize (400, 400);label 1. setBounds (30, 11,51,33);textField1. setBounds(86,16,74,22);label2 setBounds(162, 11,51,33)9textField2 setBounds(192,16,44,22);label3. setBounds (241, 11,70,33)9textField7. setBounds(275,15,50,25);label4 setBounds (31, 53,55,33);textField3 setBounds(86,58,74

41、,22);label5 setBounds(241, 53,70,33)9textField8 setBounds(296,57,72,25);label6 setBounds(163, 53,26,33)VtextField-! setBounds (191,5&44,22);label7. setBounds (30, 94,50,33);textField9. setBounds(86, 94, 74, 22); label8. setBounds (163, 94, 51, 33); textFieldd. setBounds(190, 99, 17& 22); button2. se

42、tBounds (115, 241, 80, 33); button2 addActionListener (this); this, add(labell); this. add(label2); this. add(label3); this. add(label4); this, add(labelo); this. add(label6); this, add(label?); this. add(label8); this add(textFieldl); this. add(textField2); this. add(textField3); this add(textField

43、4); this add(textField5); this. add(textField7); this. add(textField8); this add(textField9);this add(button2);this. setDefaultCloseOperation(JFrame. DISPOSE_ON_CLOSE);this setVisible(true);public static void main(Stringargs) throws Exceptionxg a=new xg ();a. setDefaultCloseOperation(JFrame EXIT_ON_

44、CLOSE);public void actionPerformed(ActionEvent e)/事件处理程序if (e. getSource () =button2)tryClass forame(sun. jdbc odbc JdbcOdbcDriver);catch (ClassNotFoundException ce)JOptionPane. showMessageDialog(s, ce. getMessageO);tryConnection con = DriverManager getConnection(jdbc：odbc：stu, ”)；Statement stmt = c

45、on. createStatement();ResultSet rs=stm t execut eQuery (select * from xinxi where 学号 =,，z+textField 1 getText()+,);if (textField 1. getText () trim() equals()JOptionPane. showMessageDialog(this,学号不可为空！ ”)；else if (rsnext ()StringupdateSql二updatexinxi set 学 号二+textFieldl. getText () +,姓名二皿+textField2

46、. getText ()+, 性 别二z，+textField7. getText ()+，z,出生日期=+ textField3. getText ()+/z，,政 治面貌二z，+textField8. getText ()+”,籍贯二+ textField4. getText ()+, 系 别=，+textField9. getText ()+,专业二+textField5. getText()+trystmt executeQuery(updateSql); catch(SQLException se) JOptionPane showMessageDialog(null,修改成功)；c

47、atch(SQLException se)JOptionPane showMessageDialog(s, se. getMessage();/sc. java删除界面import javax swing *;import javaawt*;import javaawt.event*;import java.sql.*;public class sc extends JFrame implements ActionListenerstatic sc s;static JLabel labell = new JLabel C学号：)；static JTextField textFieldl =

48、new JTextFieldD ;static JLabel label2 = new JLabel C姓名：”)； static JTextField textField2 = new JTextField(); static JLabel label3 = new JLabel (性别：”)； static JTextField textField7=new JTextField;static JLabel label4 = new JLabel(出生日期:”); static JTextField textField3 = new JTextField;static JLabel lab

49、el5 = new JLabel C政治面貌:”);static JTextField textField8=new JTextField;static JLabel label6 = new JLabel (籍贯”)；static JTextField textField4 = new JTextField();static JLabel label7 = new JLabel C系别：)；static JTextField textField9 = new JTextField(); static JLabel label8 二 new JLabel (专业:“)； static JTex

50、tField textFieldd = new JTextField;static JButton button4=new JButtonC删除)；public sc() throws Exceptionthis. setTitleC删除学生信息)；this. setLayout(null);this. setSize (400, 400);label 1. setBounds (30, 11,01,33);textField1. setBounds(86,16,74,22);label2 setBounds(162, 11, I,33)ftextField2 setBounds(192,16

51、,44,22);label3. setBounds (241, 11,70,33)9textField7. setBounds(275,15,50,25);label4. setBounds (31, 53,55,33);textField3. setBounds(86,8,74,22);label5 setBounds(241, 53,70,33)9textField8 setBounds(296,57,72,25);label6 setBounds(163, 53,26,33)textField4 setBounds(191,5&44,22);label7. setBounds (30,

52、94,50,33);textField9 setBounds(86, 94,74,22)9label8. setBounds(163, 94, I,33)VtextFieldo setBounds(190,99,178,22)button4. setBounds(295, 241, 80, 33); button4. addActionListener(this); this, add(labell);this. add(label2);this. add(label3);this. add(label4);this, add(labelo);this. add(label6);this, a

53、dd(label?);this add(label8);this add(textFieldl);this. add(textField2);this. add(textField3);this add(textField4);this add(textField5);this. add(textField7);this. add(textField8);this add(textField9);this add(button4);this. setDefaultCloseOperation(JFrame. DISPOSE_ON_CLOSE); this setVisible(true);public static void main(Stringargs) throws Exceptionsc a= new sc ();a. setDefaultCloseOperation(JFrame EXIT_