欢迎来到天天文库
浏览记录
ID:39276221
大小:43.01 KB
页数:6页
时间:2019-06-29
《用java编写的学生成绩管理系统代码》由会员上传分享,免费在线阅读,更多相关内容在行业资料-天天文库。
1、//studentimportjava.sql.*;publicclassStudent{privateStringid;privateStringname;privateintmath;privateintenglish;privateintjava;privateintcomputer;publicStringgetId(){returnid;}publicvoidsetId(Stringid){this.id=id;}publicStringgetName(){returnname;}publicvoidsetName(Stri
2、ngname){this.name=name;}publicintgetMath(){returnmath;}publicvoidsetMath(intmath){this.math=math;}publicintgetEnglish(){returnenglish;}publicvoidsetEnglish(intenglish){this.english=english;}publicintgetJava(){returnjava;}publicvoidsetJava(intjava){this.java=java;}public
3、intgetComputer(){returncomputer;}publicvoidsetComputer(intcomputer){this.computer=computer;}publicstaticvoidmain(String[]args)throwsException{Stringid;Stringcid;Stringname;intmath;intenglish;intjava;intcomputer;StringDBDriver="sun.jdbc.odbc.JdbcOdbcDriver";StringconStr=
4、"jdbc:odbc:student";Connectioncon=null;Statementstmt=null;ResultSetrs=null;Class.forName(DBDriver);con=DriverManager.getConnection(conStr,"student","123");stmt=con.createStatement();Strings="ttt学生成绩tt1新增tt2更改tt3删除tt4查找tt5显示tt0退出";Sys
5、tem.out.print(s);intchoice=Keyboard.getInteger();switch(choice){//添加学生case1:System.out.print("请输入学生信息");System.out.print("学号:");id=Keyboard.getString();System.out.print("姓名:");name=Keyboard.getString();System.out.print("数学:");math=Keyboard.getInteger();System.out.prin
6、t("英语:");english=Keyboard.getInteger();System.out.print("JAVA:");java=Keyboard.getInteger();System.out.print("计算机:");computer=Keyboard.getInteger();stmt.executeUpdate("insertintolxh1values('"+id+"','"+name+"','"+math+"','"+english+"','"+java+"','"+computer+"')");System.
7、out.println("添加完成。");break;//更改成绩case2:System.out.println("请输入要改的学生学号:");cid=Keyboard.getString();System.out.println("数学:");math=Keyboard.getInteger();System.out.println("英语:");english=Keyboard.getInteger();System.out.println("JAVA:");java=Keyboard.getInteger();System
8、.out.println("计算机:");computer=Keyboard.getInteger();stmt.executeUpdate("updatelxh1setmath='"+math+"',english='
此文档下载收益归作者所有