【vfp精品源码栏目提醒】:网学会员vfp精品源码为您提供JSP课程设计 - 人力资源参考,解决您在JSP课程设计 - 人力资源学习中工作中的难题,参考学习。
JSP 课程设计学院: XX 学院专业:验目的:1.通过本章实验案例学习和练习,我们能够综合利用所学的知识来完成一 个具体的基于 B/S 结构的 Web 管理信息系统。
2.学习老师提供的源代码,制作 BBS 以及在线考试系统。
实验内容:1.学习老师提供的源代码,并实际操作实现代码功能。
2.通过先前的学习掌握,加上这学期上课所学知识以及课后的实验操作, 实现在线考试系统以及 BBS 的功能。
实验步骤: 1.研究分析现有
vfp 报名系统 webvfp,学习相关的实现技术:2.实现BBS界面: 先将下载的BBS进行解压,放在resin的webapps里面。
然后安装mysql安装好后在mysql的运行程序里输入CREATE DATABASE JForum DEFAULTCHARACTER SET utf8 COLLATE utf8_general_ci代码,在myeclipse里面输入ltpage contentTypequottext/html charsetgb2312quot languagequotjavaquot importquotshenyan.db.java.sql.quotimportquotjava.util.quot importquotjava.io.quotimportquotjava.text.quotgtltresponse.sendRedirectquothttp://localhost:8080/jforum/install.jspquotgt , 进 行 配 置 , start 后 在 浏 览 器 里 面 输 入 网 址http://localhost:8080/jforum/install.jsp,进入到 BBS 安装界面,然后进行安装,安装后添加图片,实现如下界面,可以实现人员注册,发表文章等功能。
3.实现在线考试系统: a.考生登录界面及功能:首先进入考生和管理员入口程序,其界面如图所示Middle.jap:lt page contentTypequottext/html charsetgb2312quotlanguagequotjavaquot importquotjava.sql.quot gtlt page importquotjava.util.quot gtlthtmlgtlttitlegt欢迎lt/titlegtltheadgtltmeta http-equivquotContent-Typequot contentquottext/html charsetgb2312quot /gtltstyle typequottext/cssquotgtlt--.STYLE1 font-family: quot宋体quot font-size: 36px font-weight: bold color: 00FFFF.STYLE2 font-size: 16px font-family: quot宋体quot font-weight: bold body background-image: url01.JPG--gtlt/stylegtlt/headgtltbodygtltdiv alignquotcenterquotgt ltpgtltspan classquotSTYLE1quotgt欢迎使用在线考试系统lt/spangtltbrgtlt/divgtltp alignquotcenterquotgtltspan classquotSTYLE2quotgtlta hrefquotlogin.jspquotgt考生登录lt/agtlt/spangtampnbspampnbspampnbspampnbspampnbspampnbspltspan classquotSTYLE2quotgtlta hrefquotAdminLogin.jspquotgt管理员登录lt/agtlt/spangtlt/pgtlt/bodygtlt/htmlgt 考生登录界面主要用于密码的验证,检查登录的用户是否在考试系统的成绩表中, 如果在而且还没有参加过本科目的考试则可以进入考试,如程序 login.jsp 所示,其界面所示。
Login.Jsp:lt page contentTypequottext/htmlcharsetgb2312quot gtlt page importquotjava.sql.quot gtlt String Noquotquot String Namequotquot String Lessonquotquot String Msgquotquot ifrequest.getParameterquotNamequotnull Norequest.getParameterquotNoquot Namerequest.getParameterquotNamequot Lessonrequest.getParameterquotLessonquot String SQL quotSELECT From chjb quot SQLSQLquotWhere xhquotquotquotNoquotquot quot And xmquotNamequotquot Connection connnull Statement stmtnull ResultSet rsScorenull try Class.forNamequotorg.gjt.mm.mysql.Driverquot.newInstance catchClassNotFoundException ce out.printlnce.getMessage try String dbURL quotjdbc:mysql://quot quot127.0.0.1quot quot/quot quotvfpdbuserrootamppasswordquotquotsy922891quot //System.out.printlndbURL conn DriverManager.getConnectiondbURL stmtconn.createStatement rsScorestmt.executeQuerySQL catchSQLException e System.out.printlne.getMessage ifrsScore.next Msgquot您不是合法考生!quot else ifrsScore.getIntLesson-1 Msgquot您已经考过本科目了!quot else response.sendRedirectquottest.jspLessonquotLessonquotampNamequotNamequotampNoquotNoquotquot gtltHTMLgtlttitlegt考试界面lt/titlegt ltheadgtltmeta http-equivquotContent-Typequot contentquottext/html charsetgb2312quot /gtltstyle typequottext/cssquotgtlt--body background-image: url03.JPG--gtlt/stylegtlt/headgt ltBODYgt ltp alignquotcenterquotgtampnbsplt/pgt ltp alignquotcenterquotgtampnbsplt/pgt ltp alignquotcenterquotgtampnbsplt/pgt ltcentergtltfont colorquotFFFFFFquot facequot楷体_GB2312quot sizequot4quotgt在线考试系统lt/fontgtlt/centergt ltcentergt ltHRgt ltFORM ACTIONquotlogin.jspquot METHODquotGETquotgt ltPgt考试科目:ltSELECT NAMEquotLessonquot SIZEquot1quotgt ltOPTION VALUEquotJSPquotgtJSPlt/OPTIONgt ltOPTION VALUEquotXMLquotgtXMLlt/OPTIONgt ltOPTION VALUEquotASPquotgtASPlt/OPTIONgt lt/SELECTgtlt/Pgt ltPgt姓名:ltINPUT TYPEquotTEXTquot NAMEquotNamequot VALUEquotltNamegtquotgtlt/pgt ltpgtquotpasswordquot NAMEquotNoquot VALUEquotltNogtquotgt lt/pgt ltpgtltINPUT TYPEquotSUBMITquot NAMEquotSENDquot VALUEquot开始考试quotgtlt/pgt lt/FORMgt lt/centergt ltHRgt ltcentergtltFONT Colorquotredquot sizequot2quotgtltMsggtlt/FONTgtlt/centergt lt/BODYgtlt/HTMLgt 首先利用 SQL 语句在数据库成绩表中查询,验证是否有此考生的信息。
如果在数据库中不存在,说明没有该学生。
如果找到了,判断考试科目的分数是否为-1,若不为-1,说明已经考完。
如果考生存在还没有参加考试,转到 test.jsp 页面,显示如下图所示。
考题有单选和多选,所有考题均从数据库中读取。
Test.jsp:lt page contentTypequottext/htmlcharsetGB2312quot gtlt page importquotjava.sql.quotgtlt String Lesson request.getParameterquotLessonquot String Name request.getParameterquotNamequot String No request.getParameterquotNoquot String SQL quotSelect From quot Lesson quot Order By thquot Connection conn null Statement stmt null ResultSet rs null try Class.forNamequotorg.gjt.mm.mysql.Driverquot.newInstance catchClassNotFoundException ce out.printlnce.getMessage try String dbURL quotjdbc:mysql://quot quot127.0.0.1quot quot/quot quotvfpdbuserrootamppasswordquotquotsy922891quot //System.out.printlndbURL conn DriverManager.getConnectiondbURL stmtconn.createStatement rsstmt.executeQuerySQL catchSQLException e System.out.printlne.getMessage gtltHTMLgt lttitlegt考试界面lt/titlegt ltBODY background-image: url09.JPGgt ltCENTERgt ltH1gtltFONT COLOR6699DDgt在线考试系统lt/FONTgtlt/H1gt lt/CENTERgt ltH2gt考试科目 -- ltLessongtltHRgtlt/H2gt ltFORM Actionquotscore.jspquot MethodquotGETquotgt ltINPUT TypequotHiddenquot NamequotLessonquot ValueltLessongtgt ltINPUT TypequotHiddenquot NamequotNoquot ValueltNogtgt ltINPUT TypequotHiddenquot NamequotNamequot ValueltNamegtgtltString TestType quotquotString leixing quotquotString tihao quotquotwhile rs.next //while循环显示所有该科目的题目 leixing rs.getStringquotlxquot tihao rs.getStringquotthquot out.printquotltBgtquot tihao quot.quot rs.getStringquottmquot leixing quot:quot rs.getStringquotfsquot quot分lt/Bgtquot out.printquotltdivgtquot for int i1 ilt5 i //for循环,显示所有该题的选项 if leixing.equalsquot单选quot TestType quotRadioquot else TestType quotCheckBoxquot out.printquotltINPUT Typequot TestType quot NameNoquot tihao quot Valuequot i quotgtquot rs.getStringquotxxquot String.valueOfi quotltBRgtquot out.printquotlt/divgtquotgtltINPUT TypeSubmit Valuequot 交卷quotgtlt/FORMgtltHRgtlt/BODYgtlt/HTMLgt 当学生答完题提交时,系统就会调用 score.jsp 文件来对考生进行自动评分,并将考生的考试信息显示出来,如下图所示。
Score.jsp:lt page contentTypequottext/htmlcharsetGB2312quot gtltpage importquotjava.sql.quotgtlt String Lesson request.getParameterquotLessonquot String No request.getParameterquotNoquot String Name request.getParameterquotNamequot String SQL quotquot Connection conn null Statement stmt null ResultSet rs null ResultSet rsScore null try Class.forNamequotorg.gjt.mm.mysql.Driverquot.newInstance catchClassNotFoundException ce out.printlnce.getMessage try String dbURL quotjdbc:mysql://quot quot127.0.0.1quot quot/quot quotvfpdbuserrootamppasswordquotquotsy922891quot //System.out.printlndbURL conn DriverManager.getConnectiondbURL stmtconn.createStatement rsstmt.executeQueryquotSelect from quot Lesson catchSQLException e System.out.printlne.getMessage gtltHTMLgtlttitlegt成绩单lt/titlegt ltBODY background-image: url08.JPGgt ltH2gtltCENTERgt成绩单lt/CENTERgtltHRgtlt/H2gtlt int Score 0 while rs.next String tihao rs.getStringquotthquot if request.getParameterquotNoquot tihaonull String Sel request.getParameterquotNoquot tihao String Ans rs.getStringquotjdquot if Ans.equalsSel Score Score rs.getIntquotfsquot stmt.close conn.close SQL quotSelect From chjb quot SQL SQL quotWhere xhquot quotquot No quotquot quot And xmquot Name quotquot int iJSP -1 int iXML -1 int iASP -1 try String dbURL quotjdbc:mysql://quot quot127.0.0.1quot quot/quot quotvfpdbuserrootamppasswordquotquotsy922891quot //System.out.printlndbURL conn DriverManager.getConnectiondbURL stmtconn.createStatement rsScorestmt.executeQuerySQL rsScore.next if Lesson.equalsquotJSPquot iJSP rsScore.getIntquotJSPquot else iJSP Score if Lesson.equalsquotXMLquot iXML rsScore.getIntquotXMLquot else iXML Score if Lesson.equalsquotASPquot iASP rsScore.getIntquotASPquot else iASP Score SQL quotupdate chjb set quot Lesson quot quot Score quot where xhquot quotquot No quotquot quot And xmquot Name quotquot stmt.executeUpdateSQL catchSQLException e System.out.printlne.getMessage gt ltNamegt同志您好,您的考试成绩统计为:ltBRgt ltCENTERgt ltTABLE BORDER2 background-image: url07.JPGquot WIDTH80gt ltTR BGCOLORquotDDDDDDquotgtltTDgt您参加的科目lt/TDgtltTDgt您的分数lt/TDgtlt/TRgt ltTRgtltTDgtJSPlt/TDgtltTD AlignRightgtltiJSPgtlt/TDgtlt/TRgt ltTRgtltTDgtXMLlt/TDgtltTD AlignRightgtltiXMLgtlt/TDgtlt/TRgt ltTRgtltTDgtASPlt/TDgtltTD AlignRightgtltiASPgtlt/TDgtlt/TRgt lt/TABLEgtlt/centergt ltHRgt ltA HREFquotlogin.jspNoltNogtNameltNamegtquotgt参加其他科目考试lt/Agt lt/BODYgtlt/HTMLgtb.管理员后台管理界面实现的功能:AdminLogin.jsp:lt page contentTypequottext/html charsetgb2312quot gtlt page importquotjava.sql.quot gtlt String usernamequotquot String passwdquotquot String msg1quotquot String msg2quotquot if request.getParameterquotnamequotnull msg1quot姓名不能为空quot if request.getParameterquotpassquotnull msg2quot密码不能为空quot if request.getParameterquotnamequotnull ampamprequest.getParameterquotpassquotnull usernamerequest.getParameterquotnamequot passwdrequest.getParameterquotpassquot String SQLquotSELECT From adminquot SQLSQLquot Where userquotquotquotusernamequotquotquot Andpasswordquotpasswdquotquot Connection connnull Statement stmtnull ResultSet rsnull try Class.forNamequotorg.gjt.mm.mysql.Driverquot.newInstance catchClassNotFoundException ce out.printlnce.getMessage try String dbURL quotjdbc:mysql://quot quot127.0.0.1quot quot/quot quotvfpdbuserrootamppasswordquotquotsy922891quot //System.out.printlndbURL conn DriverManager.getConnectiondbURL stmtconn.createStatement rsstmt.executeQuerySQL catchSQLException e System.out.printlne.getMessage ifrs.next response.sendRedirectquoterror.htmlquot else response.sendRedirectquotframezt2.jspquot rs.close gtlthtmlgtlttitlegt管理员登录lt/titlegtltheadgtltmeta http-equivquotContent-Typequot contentquottext/html charsetgb2312quot /gtltstyle typequottext/cssquotgtlt--.STYLE1 font-family: quot宋体quot font-size: 36px color: FF33FF font-weight: boldbody background-image: url02.JPG--gtlt/stylegtlt/headgtltbodygtltcentergtltp classquotSTYLE1quotgt管理员登录lt/pgtltform idquotform1quot namequotform1quot methodquotpostquot actionquotryxinxi.jspquotgt 用户名:ltinput namequotnamequot typequottextquot idquotnamequot sizequot18quot /gt ltfont colorquot99FF00quotgtltmsg1gtlt/fontgtltpgt 密码: ltinput namequotpassquot typequotpasswordquot idquotpassquot sizequot18quot /gt ltfont colorquot99FF00quotgtltmsg2gtlt/fontgt ltpgtltinput typequotsubmitquot namequotSubmitquot valuequot进入人员信息界面quot /gtlt/pgtlt/formgtlt/centergtlt/bodygtlt/htmlgt管理员输入正确的用户名和密码后,进入考生信息程序 ryxinxi.jsp,界面如下图所示。
ryxinxi.jsp : lt page contentTypequottext/html charsetgb2312quotlanguagequotjavaquot importquotjava.sql.quot errorPagequotquot gtlthtmlgtlttitlegt人员信息lt/titlegtltheadgtltmeta http-equivquotContent-Typequot contentquottext/html charsetgb2312quot /gtltstyle typequottext/cssquotgtlt--.STYLE1 font-family: quot宋体quot font-size: 36px color: ff3377 font-weight: bold--gtbody background-image: url06.JPGlt/stylegtlt/headgtltbodygtltdiv alignquotcenterquotgtltspan classquotSTYLE1quotgt人员信息界面lt/spangtlt/divgtltpgt ltcentergt学号ampnbspampnbspampnbsp姓名lt/centergt lt/pgtlt String SQL quotSELECT From chjb quot Connection connnull Statement stmtnull ResultSet rsnull try Class.forNamequotorg.gjt.mm.mysql.Driverquot.newInstance catchClassNotFoundException ce out.printlnce.getMessage try String dbURL quotjdbc:mysql://quot quot127.0.0.1quot quot/quot quotvfpdbuserrootamppasswordquotquotsy922891quot //System.out.printlndbURL conn DriverManager.getConnectiondbURL stmtconn.createStatement rsstmt.executeQuerySQL catchSQLException e System.out.printlne.getMessage whilers.next out.printquotltBrgtquotquotltcentergtquotquotampnbspquotrs.getStringquotxhquotquotampnbspquotquotampnbspquotquotampnbspquotquotampnbspquotrs.getStringquotxmquotquotlt/centergtquotquotlt/Brgtquot gtltcentergtlta hrefquotrytianjia.jspquot titlequot人员添加quot targetquot_blankquotgt进入人员添加界面lt/agtlta hrefquotryxiugai.jspquot titlequot人员修改quot targetquot_blankquotgt进入人员修改界面lt/agtlta hrefquotryshanchu.jspquot titlequot人员删除quot targetquot_blankquotgt进入人员删除界面lt/agtlta hrefquotrygrade.jspquot titlequot人员成绩quot targetquot_blankquotgt进入人员成绩界面lt/agtlt/centergtlt/bodygtlt/htmlgt在界面中点击人员添加界面,进入 rytianjia.jsp 程序,如下图所示。
rytianjia.jsp:lt page contentTypequottext/html charsetgb2312quotlanguagequotjavaquot importquotjava.sql.quot gtlt String Namequotquot String Noquotquot ifrequest.getParameterquotNamequotnull ampamprequest.getParameterquotNoquotnull Norequest.getParameterquotNoquot Namerequest.getParameterquotNamequot String SQLquotinsert into chjb xmxh valuesquotNamequotquotNoquotquot Connection connnull Statement stmtnull ResultSet rsnull try Class.forNamequotorg.gjt.mm.mysql.Driverquot.newInstance catchClassNotFoundException ce out.printlnce.getMessage try String dbURL quotjdbc:mysql://quot quot127.0.0.1quot quot/quot quotvfpdbuserrootamppasswordquotquotsy922891quot //System.out.printlndbURL conn DriverManager.getConnectiondbURL stmtconn.createStatement catchSQLException e System.out.printlne.getMessage stmt.executeUpdateSQL response.sendRedirectquotryxinxi.jspquot gtltheadgtltmeta http-equivquotContent-Typequot contentquottext/html charsetgb2312quot /gtlttitlegt人员添加lt/titlegtltstyle typequottext/cssquotgtlt--.STYLE1 font-family: quot宋体quot font-size: 36px color: ff3377 font-.