合肥网站建设方案服务,广西智能网站建设报价,中国核工业二三建设有限公司太平岭项目部,外国食品优秀设计网站一、源码特点 java servlet 学生管理系统是一套完善的web设计系统#xff0c;对理解JSP java编程开发语言有帮助servletbeandao (mvc模式开发)#xff0c;系统具有完整的源代码和数据库#xff0c;开发环境为 TOMCAT7.0,Myeclipse8.5开发#xff0c;数据库为Oracle 10g…一、源码特点 java servlet 学生管理系统是一套完善的web设计系统对理解JSP java编程开发语言有帮助servletbeandao (mvc模式开发)系统具有完整的源代码和数据库开发环境为 TOMCAT7.0,Myeclipse8.5开发数据库为Oracle 10g使用java语言开发系统主要采用B/S模式开发。 java oracle学生管理系统 二、功能介绍 (1)学生管理对学生信息进行添加、删除、修改和查看 (2)教师管理对教师信息进行添加、删除、修改和查看 (3)管理员管理对管理员信息进行添加、删除、修改和查看 (4)课程管理对课程信息进行添加、删除、修改和查看 (5)选课管理对选课信息进行添加、删除、修改和查看 (6)成绩管理对成绩信息进行添加、删除、修改和查看 (7)学分预警管理对学分预警信息进行添加、删除、修改和查看 (8)用户登录、身份验证不同的权限不同的菜单
数据库设计 [表xuesheng] 学生列属性表格 序号字段名称数据类型长度主键描述1xsidINTEGER11是学生编号2yhmVARCHAR40否用户名3mmVARCHAR40否密码4xmVARCHAR40否姓名5bjVARCHAR40否班级6zyVARCHAR40否专业7xbVARCHAR40否性别8nlVARCHAR40否年龄9lxdhVARCHAR40否联系电话10lxdzVARCHAR40否联系地址11xfVARCHAR40否学分 [表jiaoshi] 教师列属性表格 序号字段名称数据类型长度主键描述1jsidINTEGER11是教师编号2yhmVARCHAR40否用户名3mmVARCHAR40否密码4xmVARCHAR40否姓名5lxdhVARCHAR40否联系电话6lxdzVARCHAR40否联系地址 [表gly] 管理员列属性表格 序号字段名称数据类型长度主键描述1glyidINTEGER11是管理员编号2yhmVARCHAR40否用户名3mmVARCHAR40否密码4xmVARCHAR40否姓名 [表kecheng] 课程列属性表格 序号字段名称数据类型长度主键描述1kcidINTEGER11是课程编号2kcmcVARCHAR40否课程名称3jsVARCHAR40否介绍4rkjsVARCHAR40否任课教师5xfVARCHAR40否学分6sksjVARCHAR40否上课时间7skddVARCHAR40否上课地点 [表xuanke] 选课列属性表格 序号字段名称数据类型长度主键描述1xkidINTEGER11是选课编号2xsVARCHAR40否学生3kcVARCHAR40否课程4xksjVARCHAR40否选课时间5xkztVARCHAR40否选课状态 [表chengji] 成绩列属性表格 序号字段名称数据类型长度主键描述1cjidINTEGER11是成绩编号2xsVARCHAR40否学生3kcVARCHAR40否课程4djsjVARCHAR40否登记时间5cjVARCHAR40否成绩6hdxfVARCHAR40否获得学分7jgVARCHAR40否及格
代码设计
private void insertM(HttpServletRequest request, HttpServletResponse response){//学生添加xueshengDao daonew xueshengDao();xuesheng xueshengnew xuesheng();xuesheng.setXsid((String)request.getParameter(keyid));
xuesheng.setYhm((String)request.getParameter(yhm));
xuesheng.setMm((String)request.getParameter(mm));
xuesheng.setXm((String)request.getParameter(xm));
xuesheng.setBj((String)request.getParameter(bj));
xuesheng.setZy((String)request.getParameter(zy));
xuesheng.setXb((String)request.getParameter(xb));
xuesheng.setNl((String)request.getParameter(nl));
xuesheng.setLxdh((String)request.getParameter(lxdh));
xuesheng.setLxdz((String)request.getParameter(lxdz));
xuesheng.setXf((String)request.getParameter(xf));response.setCharacterEncoding(gb2312);
String sql;
String yhm(String)request.getParameter(yhm);
DBO dbnew DBO();
ResultSet rsnull;int num0;
try{
sqlselect count(1) as num from xuesheng where yhmyhm;rsdb.query(sql);
if(rs.next()){numrs.getInt(num);
}
if(num0){request.setAttribute(flag, 操作失败、用户名重复);
}else{dao.insert(xuesheng);request.setAttribute(flag, 操作成功);
}request.getRequestDispatcher(xuesheng/xueshengadd.jsp).forward(request, response);} catch (Exception e) {e.printStackTrace();}}private void ListM(HttpServletRequest request, HttpServletResponse response){//学生信息列表ResultSet rsnull;xueshengDao dao new xueshengDao();System.out.println(alist);String sql;response.setCharacterEncoding(gb2312);try{String xm(String)request.getParameter(xm);if(xm!null!xm.equals()){sql and xm like %xm%;}String bj(String)request.getParameter(bj);if(bj!null!bj.equals()){sql and bj like %bj%;}String zy(String)request.getParameter(zy);if(zy!null!zy.equals()){sql and zy like %zy%;}rsdao.qlist(sql);PrintWriter out response.getWriter();request.setAttribute(rs, rs); request.getRequestDispatcher(xuesheng/xueshenglist.jsp).forward(request, response);}catch(Exception e){e.toString();e.printStackTrace();}}private void PListM(HttpServletRequest request, HttpServletResponse response){//测试信息列表ResultSet rsnull;xueshengDao dao new xueshengDao();String str(String)request.getParameter(Page);String sql;response.setCharacterEncoding(gb2312);try{if(strnull){str0;}
rsdao.qlist(sql);PrintWriter out response.getWriter();request.setAttribute(rs, rs); request.getRequestDispatcher(xuesheng/xueshenginfo.jsp?Page1).forward(request, response);}catch(Exception e){e.toString();e.printStackTrace();}}private void modifyIndex(HttpServletRequest request, HttpServletResponse response){//学生修改首页ResultSet rsnull;response.setCharacterEncoding(gb2312);xueshengDao dao new xueshengDao();String keyid(String)request.getParameter(keyid);String sql;if(keyid!null!keyid.equals()){sql and xsidkeyid;}try{rsdao.qlist(sql);PrintWriter out response.getWriter();request.setAttribute(rs, rs); request.getRequestDispatcher(xuesheng/xueshengmodify.jsp).forward(request, response);//response.sendRedirect(xuesheng/xueshengmodify.jsp);}catch(Exception e){e.toString();e.printStackTrace();}}private void detailM(HttpServletRequest request, HttpServletResponse response){//学生详细信息页面ResultSet rsnull;response.setCharacterEncoding(gb2312);xueshengDao dao new xueshengDao();String keyid(String)request.getParameter(keyid);String sql;if(keyid!null!keyid.equals()){sql and xsidkeyid;}try{rsdao.qlist(sql);request.setAttribute(rs, rs); request.getRequestDispatcher(xuesheng/xueshengdetail.jsp).forward(request, response);}catch(Exception e){e.toString();e.printStackTrace();}}private void deleteM(HttpServletRequest request, HttpServletResponse response){//学生删除ResultSet lstnull;xueshengDao dao new xueshengDao();response.setCharacterEncoding(gb2312);String keyid(String)request.getParameter(keyid); try{dao.delete(keyid);request.setAttribute(flag, 删除成功); request.getRequestDispatcher(xueshengServlet?methodlist).forward(request, response);//response.sendRedirect(xueshengServlet?methodlist);}catch(Exception e){e.toString();e.printStackTrace();}}三、注意事项 1、管理员账号admin密码admin 数据库配置文件DBO.java 2、开发环境为TOMCAT7.0,Myeclipse8.5开发数据库为Oracle 10g使用java语言开发。 3、数据库文件名是re data.sql re table.sql 系统名称stu 4、系统首页地址http://127.0.0.1:8080/stu/login.jsp
四 系统实现
源码获取 下方联系卡片↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓
