2023年-Java大作业学生成绩管理.docx

《2023年-Java大作业学生成绩管理.docx》由会员分享，可在线阅读，更多相关《2023年-Java大作业学生成绩管理.docx（30页珍藏版）》请在淘文阁 - 分享文档赚钱的网站上搜索。

1、本科学生综合性实验报告课程名称：Java开发技术项目名称：学生成绩管理系统学生姓名 学号指导教师开课学期 20n至2012学年第一学期完成时间 2011 年1月 3 日课程信息管理课 程 信 息 添 加课 程 信 息 修 改课 程 信 息 查 询课 程 信 息 删 除图3.5-课程信息管理模块成 绩 信 息 删 除成 绩 信 息 查 询成 绩 信 息 修 改成 绩 统 计成绩信息管理成绩信息添加图36成绩信息管理模块3.2学生成绩管理系统的功能模块简介:(1)基本信息管理(以学生为例)if (obj=tianj ia) /添力口(Sno=tf_xuehao.getText () .trim()

2、;Sname=tf_xingming.getText().trim();sex=tf_xingbie . getText() .trim();age1=1nteger.parseint(tf_nianling.getText().trim();tel_no=tf_dianhua.getText().trim();classno=tf_banhao.getText().trim();addr=tf_dizhi.getText () .trim();if(Sno length ()=0| |Sname.length()=0| |sex.length ()=0| |agel=0| | Sno len

3、gth() =0| |tel_no.length()=0| |addr.length()=0| |classno.length 0 =0)(JOptionPane . showMessageOia1og(this, ”请添力口完整信息！“，”提示 信息J , JOptionPane. QUESTION_MESSAGE);elsetryps=con.prepareStatement(ninsert into student values,?,?,?,?,?,?)”)；Sno);Sname); sex); classno); addr);ps , setstring (1, ps , setstr

4、ing (2, ps , setstring (3, ps , setstring (4, ps , setstring (5,ps.setlnt (6, agel);ps.setstring (7, tel_no);JOptionPane . s匕owMessage。工a_Jog (this, ”确定添力口吗？ “，”提 示信息“，JOptionPane. QUESTION_MESSAGE);tf_xuehao.setText();tf_xingming.setText( );tf_xingbie.setText(“);tf_nianling.setText();tf_dianhua.set

5、Text ( n);tf_dizhi . setText(n);tf_banhao.setText ( );rs=ps . executeQuery ();)catch(SQLException sql) (JOptionPane . sbowMessageDialog (t his添力口成功！，”提示信 息”,JOptionPane . QUESTION_MESSAGE);)if (obj=xiugai) /修改(String no=shuru.getText () .trim();Sno=tf_xuehao.getText().trim();Sname=tf_xingming.getTex

6、t().trim();sex=tf_xingbie . getText() .trim();age1=Integer.parseint(tf_nianling.getText().trim();tel_no=tf_dianhua.getText() .trim();addr=tf_dizhi.getText().trim();classno=tf_banhao.getText().trim();try(ps=con.prepareStatement(Hupdate student setSno=?,Sname=?,sex=?,classno=?,addr=?,age=?,tel_no=? wh

7、ere Sno=?H);ps . setstring(1, Sno);ps.setstring(2, Sname);ps.setString(3,sex);pssetstring (4,classno);ps.setstring (5,addr);ps . setlnt (6fagel);ps.setstring(7,tel_no);ps.setString(8,no);JOptionPane . s力owMessageOialog(this, ”确定修改吗？”提示信息”,JOptionPane . QUESTION_MESSAGE);tf_xuehao.setText(H;tf_xingmi

8、ng.setText(n);tf_xingbie . setText();tf_banhao.setText(H);tf_dizhi . setText();tf_nianling.setText(n);tf_dianhua.setText(n);JOptionPane . s匕owMessageDialog (this, ”修改成功! n，”提示信息”，JOptionPane . INFORMATION_MESSAGE);rs=ps . executeQuery(); rs , next ();)catch(SQLException sql) (JOptionPane.showMessage

9、Dialog(Component)null,sql.getMessage(), ”提 示信息“，JOptionPane . QUESTION_MESSAGE);)if (obj=shanchu) /删除(try(String no=shuru.getText().trim();ps=con.prepareStatement(delete from student where Sno=?n);ps . setstring(1,no);JOptionPane . showMessageOialog(this, ”确定册U除吗？”提示信 息”,JOptionPane.QUESTION_MESSAGE

10、);tf_xuehao.setText();tf_nianling.setText(n n);tf_xingming.setText(n);tf_dianhua.setText( );tf_dizhi . setText();tf_xingbie . setText();tf_banhao.setText();rs=ps . executeQuery();JOptionPane . showMessageOialog(this, ”册“除成功! ”，”提示信息 , JOptionPane . INFORMATION_MESSAGE);catch(SQLException sqlex) (sql

11、ex . getMessage(); )if (obj=qingkong) /清空 (shuru . setText (n);tf_xuehao.setText ( n);tf_nianling.setText( );tf_xingming.setText( );tf_dianhua.setText( );tf_dizhi . setText();tf_xingbie.setText( “);tf banhao.setText ();)主要功能：添加、删除、修改、查询学生基本信息。实现目的：对于每个新的学年都有大量的学生入录，对学生信息的添加是必不可少的。同时，在管 理员的日常工作过程中，难免

12、不出现错误。所以对其信息修改功能也是必不可少的，删除则 是在学生开除学籍时可以使用。同时课程、教师、成绩信息和学生信息操作是相同的。(2)成绩统计：/统计各科平均分public String SubjectAvg(String subject)String s = null;float t = 0 ;this , Connect ();if (subject .equals (计算机网络“) (s = select avg(grade) from transcript where Cno=003125n; try(st = this.Connect().prepareStatement(s);

13、rs = st.executeQuery();while(rs.next()(t = rs.getFloat (1);)catch(Exception e)e printStackTrace();)if (subject .equals (”数据库系统原理”) (s = select avg(grade) from transcript where Cno=003126H; try(st = this . Connect() .prepareStatement(s);rs = st.executeQuery();while(rs.next()(t = rs.getFloat (1);)catc

14、h(Exception e)e.printStackTrace ();if (subject. equals (多媒体技术基础”) (s = select avg(grade) from transcript where Cno=003127; try(st = this . Connect() .prepareStatement(s);rs = st.executeQuery();while(rs.next()t = rs.getFloat (1);catch(Exception e)e printStackTrace ();if （subject. equals （概率论与数理统计”）s

15、= select avg(grade) from transcript where Cno=003128; try(st = this . Connect() .prepareStatement(s);rs = st.executeQuery();while(rs.next()t = rs.getFloat (1);catch(Exception e)e printStackTrace();return Float.toString(t);/总分平均分统计public String allAvg()float sum = 0;int count = 0;st = this.Connect().

16、prepareStatement(sql);String s = select sum(grade) as total from transcript;System.out.printIn(”s=+s);tryst = this . Connect() .prepareStatement(s);rs = st.executeQuery ();System.out.printin(nrs=n+rs);if(rs.next ()(sum = rs.getFloat(total);System.out.printin(nsum=H+sum);)rs = null;s = select sum(gra

17、de) from transcript where Cno=001325n;st = this . Connect() .prepareStatement(s);rs = st.executeQuery ();if (rs.next ()(sum =sum + rs.getFloat(1);)rs = null;s = nselect sum(grade) from transcript where Cno=001326n;st = this . Connect() .prepareStatement(s);rs = st.executeQuery ();if(rs.next()(sum =s

18、um + rs.getFloat(1);)rs = null;s = select sum(grade) from transcript where Cno=001328n;st = this . Connect () .prepareStatement(s);rs = st.executeQuery ();if(rs.next ()(sum =sum + rs.getFloat(1);)rs = null;s = select count(distinct Sno) from transcript;st = this . Connect() .prepareStatement(s);rs =

19、 st.executeQuery ();if (rs.next ()(count = rs.getlnt(1);)catch(Exception e)e.printStackTrace ();)if(count = 0)return n 0 n;elsesum = sum/count;return Float.toString(sum);/获得各科的分数段人数public int gethigh(String subjectrint grade) /总的人数int num = 0;String s = null;this Connect();if (subject.equals (计算机网络”

20、)grade60grade70grade80grade=60 and a . Cno=b . Cno and Cname=计算机网络”； if(grade = 80)s = select count (sno) from transcript a,course b and grade =70 and a . Cno=b. Cno and Cnama=计算机网络”； if(grade = 90)s = nselect count (sno) from transcript a,course b and grade =80 and a . Cno=b. Cno and Cnam=计算机网络”； i

21、f(grade = 100)s = select count (sno) from transcript a,course bwherewherewherewherewheregrade=90 and a . Cno=b . Cno and Cname=计算机网络； tryst = this.Connect().prepareStatement(s);rs = st.executeQuery();while(rs.next()num= rs.getlnt (1);)catch(Exception e)e , printStackTrace ();)if (subject. equals (”数

22、据库系统原理”)if(grade = 60)s = select count (sno) from transcript a,course b where grade 60 and a . Cno=b . Cno and Cname=数据库系统原理”;if(grade = 70)s = select count (sno) from transcript a,course b where grade =60 and a . Cno=b . Cno and Cname=数据库系统原理”; if(grade = 80)s = select count (sno) from transcript a

23、,course b where grade =70 and a . Cno=b . Cno and Cnam=数据库系统原理”； if(grade = 90)s = nselect count (sno) from transcript a,course b where grade =80 and a . Cno=b. Cno and Cname=数据库系统原理”; if (grade = 100)s = select count (sno) from transcript a,course b where grade =90 and a. Cno=b. Cno and Cname=数据库系统

24、原理”； try(st = this.Connect().prepareStatement(s);rs = st.executeQuery();while(rs.next() (num= rs . getlnt (1);)catch(Exception e)e printStackTrace ();) ) if (subject. equals (多媒体技术基石出”) (if(grade = 60)s = select count (sno) from transcript a,course b where grade 60 and a . Cno=b. Cno and Cnam=多媒体技术基

25、石出”； if(grade = 70)s = select count (sno) from transcript a,course b where grade =60 and a . Cno=b . Cno and Cnama=多媒体技术基不出； if(grade = 80)s = nselect count (sno) from transcript a,course b where grade =70 and a . Cno=b . Cno and Cname=多媒体技术基石出”； if(grade = 90)s = select count (sno) from transcript

26、a,course b where grade =80 and a . Cno=b . Cno and Cnama=多媒体技术基石出”； if(grade = 100)s = nselect count (sno) from transcript a,course b where grade =90 and a . Cno=b . Cno and Cname=多媒体技术基石出”； tryst = this . Connect() .prepareStatement(s);rs = st.executeQuery();while(rs.next()(num= rs.getlnt(1);)catch

27、(Exception e) e printStackTrace (); )if (subject. equals (概率论与数理统计”) (if(grade = 60)s = select count (sno) from transcript a,course b where grade 60 and a . Cno=b. Cno and Cname=概率论与数理统i+； if(grade = 70)s = select count(sno) from transcript a,course b where grade =60 and a . Cno=b . Cno and Cname=概率

28、论与数理统计”; if(grade = 80)s = select count (sno) from transcript a,course b where grade =70 and a . Cno=b. Cno and Cname=概率论与数理统计”; if(grade = 90)s = nselect count (sno) from transcript a,course b where grade =80 and a . Cno=b. Cno and Cname=概率论与数理统计”; if(grade = 100)s = nselect count (sno) from transc

29、ript a,course b where grade =90 and a . Cno=b. Cno and Cnam=概率论与数理统计;tryst = this.Connect().prepareStatement(s);rs = st.executeQuery();while(rs.next() (num= rs.getlnt (1);)catch(Exception e)e , printStackTrace (); )return num;)/获得总的人数public int count () int count = 0;目录摘要21项目研究开发的背景及意义21.1 本课题设计学术价值

30、、理论意义和实践意义21.2 本课题设计拟研究的主要问题2L3重点和难点31.4 研究方法、预期效益31.5 本项目创新点和特色32需求分析32.1 开发背景32.2 项目目标42.3 运行环境42.4 任务说明书43技术路线及关键技术73.1 系统总体功能图73.2 学生成绩管理系统的功能模块简介： 103.3 系统运用的主要技术：233.4 数据库设计243.5 连接数据库274测试报告及系统评价284.1 系统简介：284.2 系统特色及缺点： 285 系统使用说明295.1 用户操作指南： 296个人感受及收获307大作业总结31感谢318参考文献：31String s = selec

31、t count（distinct Sno） from transcript;this , Connect（）;tryst = this . Connect（） .prepareStatement（s）;rs = st.executeQuery （）;while （rs.next （）（count = rs.getlnt（1）;）catch（Exception e）e.printStackTrace（）;return count; 主要功能：对各科成绩和总成绩进行统计，算出它的平均分。同时显示每科小于60或者大于60 分的同学成绩列表。并且用直方图将每个分数段的学生数量形象地表示出来。主要目的：

32、在实际的学生成绩管理过程中，计算平均分是很重要的，便于学校和老师对学生总体 成绩的了解。从而不断发现新的教学方法来提高总体学生的学习成绩。同时成绩分布图给予 协助。（3）管理员界面及主函数入口模块：MainAndGULjava主界面（管理员界面）import javax.swing.*import java.awt.*;import java.awt.event.*;import java.text.DateFormat;import java.util.Date;public class Grade extends JFrame private static final long seria

33、lVersionUID = IL;定义主框架private JFrame frame 二 new JFrame（学生成绩管理系统）定义菜单栏private JMenuBar Bar 二 new JMenuBar（）;定义菜单private JToolBar statusBar=new JTbolBar（）; 状态栏 statusprivate JMenu JMedit = new JMenu（成绩信息）private JMenu JMcount = new JMenu（“统计）；private JMenu JMhelp = new JMenu（帮助）；private JMenu JMinfor

34、= new JMenu（基本信息管理”）;/定义菜单项private JMenuItem JMIinput = new JMenuItem（信息添力IT）;private JMenuItem JMImodify = new JMenuItem（成绩查询）；private JMenuItem JMIall = new JMenuItem（成绩统计）;private JMenuItem JMIgraphics = new JMenuItem（图形统计）/private JMenuItem JMIsignal = new JMenuItem（个人成绩”）；private JMenuItem JMIh

35、elp = new JMenuItem（系统信息”）；private JMenuItem tohelp=new JMenuItem（帮助主题”）；private JMenuItem JMstudent=new JMenuItem（学生信息管理）；private JMenuItem JMteacher=new JMenuItem（教师信息管理）；private JMenuItem JMcourse=new JMenuItem(课程信息管理)private JMenuItem JMts=new JMenuItem(授课管理)；private JMenuItem JMsc=new JMenuItem

36、(成绩管理)；Imageicon image;Icon tupian;JLabel label_pic;Component com = null;/定义文本标签private JLabel text = new JLabel(,n, SwingConstants.CENTER);定义面板private Container con = frame.getContentPane();显示当前时间DateFormatdfl=DateFormat.getDateTimeInstance(DateFormat.MEDIUM,DateFormat.MEDIUM);Date d = new Date();当

37、前日期和时间String mystring=df 1 .format(d);JLabel StatusLabel 1 =new JLabel。欢迎您的使用,SwingConstants.LEFT);添加时间JLabel StatusLabel2=new JLabel。显示当前状态,SwingConstants.CENTER);JLabel StatusLabel4=new JLabel(mystring,SwingConstants.CENTER);构造函数public Grade() 把菜单栏加入框架frame.setJMenuBar(Bar);/frame.setJToolBar(stat

38、usBar);把菜单加入菜单栏Bar.add(JMedit);Bar.add(JMcount);B ar. add(JMinfor);Bar.add(JMhelp);/把菜单项加入菜单/JMedit.add(JMIinput);JMedit.add(JMsc);JMedit.addSeparator();JMedit.add(JMImodify);JMcount.add(JMIall);JMcount.addSeparator();/JMcount.add(JMIsignal);/JMcount.addSeparator();JMcount.add(JMIgraphics);JMhelp.ad

39、d(JMIhelp);JMhelp.addSeparator();JMhelp.add(tohelp);JMinfor.add(JMstudent);JMinfor.addSeparator();JMinfor.add(JMteacher);JMinfor.addSeparator();JMinfor.add(JMcourse);JMinfor.addSeparator();JMinfor.add(JMts);tupian二new Imagelcon(piclianhua.jpg);力口载图片label_pic=new JLabel(tupian);con.setLayout(new Bord

40、erLayout();con.add(label_pic,BorderLayout.CENTER);com = label_pic;con.add(DesignStatusBar(),BorderLayout.SOUTH);设置框架frame.setLocation(200,200);frame.setSize(400,400);frame.setVisible(true);增加监听器JMImodify.addActionListener(new ActionListener()public void actionPerformed(ActionEvent argO) score_query

41、s=new score_query();s.setVisible(true);StatusLabel2.setText(JMImodify.getText();)；JMIall.addActionListener(new ActionListener()public void actionPerformed(ActionEvent argO) new AllgradeCount();StatusLabel2.setText(JMIall.getText();)；JMIgraphics.addActionListener(new ActionListener()public void actio

42、nPerformed(ActionEvent argO) Photo a = new Photo();StatusLabel2.setText(JMIgraphics.getText();)；JMstudent.addActionListener(new ActionListener() public void actionPerformed(ActionEvent argO) con.remove(com);Manage_student a = new Manage_student(); a.setVisible(true);con.add(a, BorderLayout.CENTER);

43、com 二 a;StatusLabel2.setText(JMstudent.getText();)；JMteacher.addActionListener(new ActionListener()public void actionPerformed(ActionEvent argO) con.remove(com);Manage_teacher a = new Manage_teacher(); a.setVisible(true);con.add(a, BorderLayout.CENTER); com = a;StatusLabel2.setText(JMteacher.getText

44、();)；JMcoursc.addActionListcncr(ncw ActionListcncr() public void actionPerformed(ActionEvent argO) con.remove(com);Manage_course a = new Manage_course(); a.setVisible(true);con.add(a, BorderLayout.CENTER); com = a;StatusLabel2.setText(JMcourse.getText(););JMts.addActionListener(new ActionListener()public void actionPerformed(ActionEvent argO) con.remove(com);Manage_teach a = n