java学生成绩管理系统

西安文理学院

计算机科学系课程设计报告设计名称： 软件课程设计设计题目： 学生成绩管理系统学生学号：业班级： 软件工程二班学生姓名： 陈健学生成绩：指导教师（职称）：杨全（）课题工作时间:2011.4.11至2011.4.21/303详细设计及实现用户登陆模块代码实现packagecom.kk;importjava.awt.*;importjava.awt.event.*;importjavax.swing.*;publicclassLoginextendsJFrame{privatestaticfinallongserialVersionUID=4949257312955311099L;TextFieldf1;TextFieldf2;JButtonb1;JButtonb2;JButtonb3;Stringpower;//表示权限Login(){Containercp=getContentPane();cp.setLayout(newGridLayout(4,1));Labell1=newLabel(" 用户名");Labell2=newLabel(" 密码");Panelp1=newPanel();Panelp2=newPanel();Panelp3=newPanel();f1=newTextField(10);f2=newTextField(10);f2.setEchoChar('*');TOC\o"1-5"\h\zb1=newJButton(" 登录 ");b2=newJButton(" 重置 ");b3=newJButton(" 退出 ");p1.add(l1);p1.add(f1);p2.add(l2);p2.add(f2);p3.add(b1);p3.add(b2);p3.add(b3);cp.add(p1);cp.add(p2);cp.add(p3);b1.addActionListener(newEnter());b2.addActionListener(newReWrite());b3.addActionListener(newClose());}publicstaticvoidmain(String[]args){Loginlog=newLogin();log.setTitle("系统登录");log.setBounds(200,200,300,300);log.setBackground(Color.blue);log.setVisible(true);}classEnterimplementsActionListener{publicvoidactionPerformed(ActionEvente){if((f1.getText()).equals("1410")&&(f2.getText()).equals("chenjian")){JOptionPane.showMessageDialog(null,"登录成功！用户权限是管理员");power="管理员";XueShengframe1=newXueSheng();frame1.setVisible(true);}elseif((f1.getText()).equals("abc")&&(f2.getText()).equals("123456")){JOptionPane.showMessageDialog(null," 登录成功!登录成功！用户权限是游客 ");power="游客";Findf2=newFind();f2.setVisible(true);}elseJOptionPane.showMessageDialog(null,"登录失败，请重新登录！");}}classReWriteimplementsActionListener{publicvoidactionPerformed(ActionEvente){f1.setText("");f2.setText("");f1.requestFocus();}}classCloseimplementsActionListener{publicvoidactionPerformed(ActionEvente){JButtonbt=(JButton)e.getSource();if(bt==b3)System.exit(0);}}}管理员界面I-lln.'xi查询增加朋除I-lln.'xi查询增加朋除欢迎进入学生信息管理界而代码实现：packagecom.kk;importjava.awt.*;importjava.awt.event.*;importjavax.swing.*;importjavax.swing.JFrame;publicclassXueShengextendsJFrameimplementsActionListener{JButtoncx,zj,tc,sc;XueSheng(){setBounds(100,100,600,600);JPanelpanel2=newJPanel();setContentPane(panel2);panel2.setLayout(null);JLabellabel1=newJLabel("欢迎进入学生信息管理界面 ");label1.setFont(newFont("BOLD",Font.BOLD,28));panel2.add(label1);label1.setBounds(50,20,400,100);cx=newJButton("查询");panel2.add(cx);cx.setBounds(50,200,80,50);zj=newJButton("增加");panel2.add(zj);zj.setBounds(150,200,80,50);sc=newJButton("删除");panel2.add(sc);sc.setBounds(250,200,80,50);tc=newJButton("退出");panel2.add(tc);tc.setBounds(350,200,80,50);cx.addActionListener(this);zj.addActionListener(this);sc.addActionListener(this);tc.addActionListener(this);setVisible(true);publicvoidactionPerformed(ActionEvente){if(e.getSource()==cx){Findf=newFind();}if(e.getSource()==zj){AddFIf=newAddFI();}if(e.getSource()==sc){Deletd=newDelet();}if(e.getSource()==tc){shutDown();}privatevoidshutDown(){this.dispose();}用户界面代码实现：packagecom.kk;importjava.awt.*;importjava.awt.event.*;importjava.sql.Connection;importjava.sql.DriverManager;importjava.sql.PreparedStatement;importjava.sql.ResultSet;importjava.sql.SQLException;importjavax.swing.*;publicclassFindextendsJFrameimplementsActionListener{JTextFieldt1;StringSTNO,r1,r2,r3,r4,r5,r6;JButtonb1,b2;XueShengxue;Find(){super("查询学生信息");Containerc1=this.getContentPane();setBackground(newColor(215,215,215));c1.setLayout(newGridLayout(3,2));JPanelpp=newJPanel();JLabellabel0=newJLabel("请输入你的学号 ");label0.setForeground(Color.blue);pp.add(label0);JPanelp1=newJPanel();t1=newJTextField(10);p1.add(newLabel(""));p1.add(t1);c1.add(p1);JPanelp2=newJPanel();b1=newJButton(" 查询");b2=newJButton(" 退出");b1.addActionListener(this);b2.addActionListener(this);p2.add(b1);p2.add(b2);c1.add(p2);this.setVisible(true);this.setBounds(200,200,400,300);}publicvoidactionPerformed(ActionEvente){try{if(e.getSource()==b1){try{STNO=t1.getText();Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver").newInstance();Stringurl="jdbc:sqlserver://localhost:1433;DatabaseName=ss";StringuserName="sa";//默认用户名StringuserPwd="sa";Connectioncn=DriverManager.getConnection(url,userName,userPwd);Stringstr="selectStudent.SNAME,Student.SAGE,Student.SSEX,Student.STNO,Course.Cname,SC.GradefromStudent,Course,SCwhereStudent.STNO=SC.STNOandSC.Cno=Course.CnoandStudent.STNO='"+STNO+"'";PreparedStatementps=cn.prepareStatement(str);ResultSetrs=ps.executeQuery();System.out.println("STNO="+STNO);if(rs.next()){r1=rs.getString("STNO");r2=rs.getString("SNAME");r3=rs.getString("SAGE");r4=rs.getString("SSEX");r5=rs.getString("Cname");r6=rs.getString("Grade");}else{JOptionPane.showMessageDialog(null,"你输入的学号有误");cn.close();}catch(SQLExceptiong){System.out.println("Error"+g.getErrorCode());System.out.println("Merrage="+g.getMessage());}catch(Exceptionf){f.printStackTrace();}Filef=newFile();this.dispose();}if(e.getSource()==b2){t1.setText("");t1.repaint();}}catch(NumberFormatExceptionex){JOptionPane.showMessageDialog(null,"数据转换错误 ");classJFrameimplementsActionListener{JTextFieldtt1,t2,t3,t4,t5,t6;JButtonb3;File(){super("查询学生信息");Containerc2=this.getContentPane();setBackground(newColor(215,215,215));c2.setLayout(newGridLayout(3,1));tt1=newJTextField(r1);t2=newJTextField(r2);t3=newJTextField(r3);t4=newJTextField(r4);t5=newJTextField(r5);t6=newJTextField(r6);tt1.setEditable(false);t2.setEditable(false);t3.setEditable(false);t4.setEditable(false);t5.setEditable(false);t6.setEditable(false);JPanelpp1=newJPanel();JLabellabel2=newJLabel("学号为"+STNO+"学生的信息 ");pp1.add(label2);label2.setFont(newFont("BOLD",Font.BOLD,28));c2.add(pp1);JPanelpp2=newJPanel(newGridLayout(6,2));pp2.add(newJLabel("学号",SwingConstants.CENTER));tt1.setText(STNO);pp2.add(tt1);pp2.add(newJLabel("姓名",SwingConstants.CENTER));pp2.add(t2);pp2.add(newJLabel("年龄",SwingConstants.CENTER));pp2.add(t3);pp2.add(newJLabel("性别",SwingConstants.CENTER));pp2.add(t4);pp2.add(newJLabel("课程",SwingConstants.CENTER));pp2.add(t5);pp2.add(newJLabel("成绩",SwingConstants.CENTER));pp2.add(t6);c2.add(pp2);JPanelpp3=newJPanel();b3=newJButton("返回)b3.addActionListener(this);pp3.add(b3);c2.add(pp3);this.setBounds(200,200,600,400);setVisible(true);}publicvoidactionPerformed(ActionEventf){if(f.getSource()==b3){this.dispose();}}}}添加模块

添加模块代码实现：packagecom.kk;importjava.awt.*;importjava.awt.event.*;importjavax.swing.*;importjava.sql.*;publicclassAddFIextendsJFrameimplementsActionListener{JTextFieldSTNOText,SNAMEText,SAGEText,SSEXText,SDEPTText;JButtonb1,b2,b3;StringSTNO,SNAME,SAGE,SSEX,SDEPT;publicAddFI(){Containerc=this.getContentPane();c.setLayout(newGridLayout(3,1));JPanelcenter=newJPanel(newGridLayout(5,2));JPanellow=newJPanel(newFlowLayout());儿abellabell=new儿abel(" 添加孥生信息”，SwingConstants.CENTER);label1.setFont(newFont("TRUE",Font.TRUETYPE_FONT,20));c.add(label1);STNOText=newJTextField(30);SNAMEText=newJTextField(30);SSEXText=newJTextField(30);SAGEText=newJTextField(30);center.add(newJLabel("center.add(STNOText);center.add(newJLabel("center.add(SNAMEText);center.add(newJLabel("center.add(SSEXText);center.add(newJLabel("center.add(SAGEText);center.add(newJLabel("SDEPTTextcenter.add(newJLabel("center.add(STNOText);center.add(newJLabel("center.add(SNAMEText);center.add(newJLabel("center.add(SSEXText);center.add(newJLabel("center.add(SAGEText);center.add(newJLabel("学号",SwingConstants.CENTER));姓名",SwingConstants.CENTER));性别",SwingConstants.CENTER));年龄",SwingConstants.CENTER));系别",SwingConstants.CENTER));

center.add(SDEPTText);c.add(center);b1=newJButton("添加");b2=newJButton("清除");b3=newJButton("退出");low.add(b1);low.add(b2);low.add(b3);c.add(low);// 按fil添加jiantingb1.addActionListener(this);b2.addActionListener(this);b3.addActionListener(this);this.setBounds(200,200,600,400);this.setVisible(true);this.setTitle(" 添加孥生信息)}publicvoidactionPerformed(ActionEvente){if(e.getSource()==b1){addFI();}if(e.getSource()==b2){clearForm();}if(e.getSource()==b3){shutdown();}}privatevoidaddFI(){STNO=STNOText.getText();SNAME=SNAMEText.getText();SSEX=SSEXText.getText();SAGE=SAGEText.getText();SDEPT=SDEPTText.getText();SAGE.length()==if(STNO.length()==0||SNAME.length()SAGE.length()==||SDEPT.length()==0||SSEX.length()==0)JOptionPane.showMessageDialog(this,"请添加完全信息 ");else{try{Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver").newInstance();Stringurl="jdbc:sqlserver://localhost:1433;DatabaseName=ss";StringuserName="sa";//默认用户名StringuserPwd="sa";Connectioncn=DriverManager.getConnection(url,userName,userPwd);Stringstr="INSERTINTOStudentVALUES(?,?,?,?,?)";PreparedStatementps=cn.prepareStatement(str);ps.setString(1,STNO);ps.setString(2,SNAME);ps.setString(3,SSEX);ps.setString(4,SAGE);ps.setString(5,SDEPT);ps.executeUpdate();cn.close();JOptionPane.showMessageDialog(this,"添加成功");clearForm();}catch(SQLExceptione){System.out.println("ECode"+e.getErrorCode());System.out.println("EM="+e.getMessage());}catch(Exceptione){e.printStackTrace();privatevoidclearForm(){STNOText.setText("");SNAMEText.setText("");SAGEText.setText("");SSEXText.setText("");SDEPTText.setText("");}privatevoidshutdown。{this.dispose();}}删除模块代码实现：packagecom.kk;importjava.awt.*;importjava.awt.event.*;importjava.sql.Connection;importjava.sql.DriverManager;importjava.sql.PreparedStatement;importjava.sql.SQLException;importjavax.swing.*;publicclassDeletextendsJFrameimplementsActionListener{JButtonyes;JButtoncancle;JTextFieldtext1;StringSTNO;Delet(){Containerc=this.getContentPane();c.setLayout(newGridLayout(3,1));c.setFont(newFont("true",Font.TRUETYPE_FONT,13));JPanelp1=newJPanel();JPanelp2=newJPanel();JLabellabel1=newJLabel("删除学生信息",SwingConstants.CENTER);label1.setFont(newFont("true",Font.TRUETYPE_FONT,13));label1.setForeground(Color.blue);c.add(label1);JLabellabel2=newJLabel("请输入学号 ");text1=newJTextField(10);p1.add(label2);p1.add(text1);c.add(p1);yes=newJButton("确定");cancle=newJButton("退出");p2.add(yes);p2.add(cancle);c.add(p2);yes.addActionListener(this);cancle.addActionListener(this);this.setTitle("删除学生信息 ");this.setBounds(200,200,400,300);this.setVisible(true);}publicvoidactionPerformed(ActionEvente){if(e.getSource()==yes){del();}if(e.getSource()==cancle){shutDown();}privatevoiddel(){STNO=text1.getText();try{Class.forName("com.microsoft.sqlserver.jdbc.SQL