一、源码特点
JSP 优秀本科毕业论文系统是一套完善的web设计系统,对理解JSP java serlvet 编程开发语言有帮助,系统具有完整的源代码和数据库,系统主要采用B/S模式开发。开发环境为TOMCAT7.0,eclipse开发,数据库为Mysql5.0,使用java语言开发。
java Servlet 优秀本科毕业论文系统
二、功能介绍
密码管理
用户管理
论文管理
手机论文
录入论文
审核情况
论文查看
论文下载和浏览次数统计
注销退出系统
数据库设计
/*
Navicat MySQL Data Transfer
Source Server : aa
Source Server Version : 50554
Source Host : localhost:3306
Source Database : e0175
Target Server Type : MYSQL
Target Server Version : 50554
File Encoding : 65001
Date: 2020-02-22 10:51:33
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for admin
-- ----------------------------
DROP TABLE IF EXISTS `admin`;
CREATE TABLE `admin` (
`id` int(4) NOT NULL AUTO_INCREMENT,
`username` varchar(50) DEFAULT NULL,
`password` varchar(50) DEFAULT NULL,
`realname` varchar(50) DEFAULT NULL,
`sex` varchar(50) DEFAULT NULL,
`age` varchar(50) DEFAULT NULL,
`address` varchar(50) DEFAULT NULL,
`tel` varchar(50) DEFAULT NULL,
`addtime` varchar(50) DEFAULT NULL,
`sf` varchar(50) DEFAULT '普通管理员',
UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=gb2312;
-- ----------------------------
-- Records of admin
-- ----------------------------
INSERT INTO `admin` VALUES ('1', 'admin', '123', '李梅', '男', '25', '1111', '13900000011', '2019-03-09 ', '系统管理员');
INSERT INTO `admin` VALUES ('2', 'sa', '123', '王建', '男', '30', '1111', '18356086895', '2019-04-06 ', '普通用户');
-- ----------------------------
-- Table structure for view1
-- ----------------------------
DROP TABLE IF EXISTS `view1`;
CREATE TABLE `view1` (
`id` int(4) NOT NULL AUTO_INCREMENT,
`xm` varchar(500) DEFAULT NULL,
`xb` varchar(500) DEFAULT NULL,
`nl` varchar(500) DEFAULT NULL,
`st` varchar(500) DEFAULT NULL,
UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=gb2312;
-- ----------------------------
-- Records of view1
-- ----------------------------
INSERT INTO `view1` VALUES ('17', '计算机学院', '电子信息工程', '无线传感器网络', '2020-01-02');
INSERT INTO `view1` VALUES ('19', '计算机学院', '计算机科学与技术', 'java web选题系统设计', '2020-02-01');
INSERT INTO `view1` VALUES ('20', '海洋学院', '海洋科学', '新型航海技术对船舶避碰自动化的影响研究', '2020-02-01');
INSERT INTO `view1` VALUES ('21', '海洋学院', '海洋科学', '“航海+信息”学科交叉新工科人才培养模式', '2020-02-01');
INSERT INTO `view1` VALUES ('22', '海洋学院', '海洋科学', '航海技术专业人才培养模式现状分析', '2020-02-01');
INSERT INTO `view1` VALUES ('23', '计算机学院', '计算机科学与技术', '基于PLC的烟密度检测系统设计', '2020-02-01');
INSERT INTO `view1` VALUES ('24', '计算机学院', '计算机科学与技术', '基于PLC的压力机控制系统设计', '2020-02-01');
INSERT INTO `view1` VALUES ('25', '计算机学院', '计算机科学与技术', '基于PLC的自动纸箱控制系统设计', '2020-02-01');
INSERT INTO `view1` VALUES ('26', '海运学院', '航海技术', '航海技术的发展及人才的培养面临的新挑战', '2020-02-01');
INSERT INTO `view1` VALUES ('27', '海运学院', '航海技术', '航海技术的发展', '2020-02-01');
INSERT INTO `view1` VALUES ('28', '海运学院', '航海技术', '我国航海面临的人才问题及相应的对策', '2020-02-01');
-- ----------------------------
-- Table structure for view2
-- ----------------------------
DROP TABLE IF EXISTS `view2`;
CREATE TABLE `view2` (
`id` int(4) NOT NULL AUTO_INCREMENT,
`lr` varchar(500) DEFAULT NULL,
`sj` varchar(500) DEFAULT NULL,
`xx` varchar(500) DEFAULT NULL,
UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=gb2312;
-- ----------------------------
-- Records of view2
-- ----------------------------
INSERT INTO `view2` VALUES ('10', '李建', '网络工程', '物联网在脚手架中安全监测');
INSERT INTO `view2` VALUES ('11', '王静', '海洋科学', '新型航海技术对船舶避碰自动化的影响研究');
INSERT INTO `view2` VALUES ('12', '胡静', '海洋科学', '“航海+信息”学科交叉新工科人才培养模式');
INSERT INTO `view2` VALUES ('13', '王台', '海洋科学', '航海技术专业人才培养模式现状分析');
INSERT INTO `view2` VALUES ('14', '张华', '航海技术', '航海技术的发展及人才的培养面临的新挑战');
INSERT INTO `view2` VALUES ('15', '李静', '航海技术', '航海技术的发展');
INSERT INTO `view2` VALUES ('16', '丁伟', '航海技术', '我国航海面临的人才问题及相应的对策');
-- ----------------------------
-- Table structure for view3
-- ----------------------------
DROP TABLE IF EXISTS `view3`;
CREATE TABLE `view3` (
`id` int(4) NOT NULL AUTO_INCREMENT,
`lr` varchar(500) DEFAULT NULL,
`sj` varchar(500) DEFAULT NULL,
`xx` varchar(500) DEFAULT NULL,
UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=gb2312;
-- ----------------------------
-- Records of view3
-- ----------------------------
INSERT INTO `view3` VALUES ('7', '张媛', '扣件式钢管脚手架安全监测系统', '通过');
INSERT INTO `view3` VALUES ('8', '王静', '新型航海技术对船舶避碰自动化的影响研究', '通过');
INSERT INTO `view3` VALUES ('9', '胡静', '“航海+信息”学科交叉新工科人才培养模式', '通过');
INSERT INTO `view3` VALUES ('10', '王台', '专业人才培养模式现状分析', '通过');
INSERT INTO `view3` VALUES ('11', '张华', '航海技术的发展及人才的培养面临的新挑战', '通过');
INSERT INTO `view3` VALUES ('12', '李静', '航海技术的发展', '通过');
-- ----------------------------
-- Table structure for view4
-- ----------------------------
DROP TABLE IF EXISTS `view4`;
CREATE TABLE `view4` (
`id` int(4) NOT NULL AUTO_INCREMENT,
`lr` varchar(500) DEFAULT NULL,
`fy` varchar(500) DEFAULT NULL,
`kc` varchar(500) DEFAULT NULL,
`zt` varchar(500) DEFAULT NULL,
`xx` varchar(500) DEFAULT NULL,
UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=gb2312;
-- ----------------------------
-- Records of view4
-- ----------------------------
INSERT INTO `view4` VALUES ('3', '李明', 'java web选题系统设计', '2020-02-07', '已修改', '2020-02-09');
INSERT INTO `view4` VALUES ('4', '胡静', '无线传感器网络', '2020-02-07', '已修改', '2020-02-09');
INSERT INTO `view4` VALUES ('5', '张静', '新型航海技术对船舶避碰自动化的影响研究', '2020-02-07', '已修改', '2020-02-09');
INSERT INTO `view4` VALUES ('6', '张华', '“航海+信息”学科交叉新工科人才培养模式', '2020-02-07', '已修改', '2020-02-09');
INSERT INTO `view4` VALUES ('7', '张媛', '航海技术专业人才培养模式现状分析', '2020-02-07', '已修改', '2020-02-09');
INSERT INTO `view4` VALUES ('8', '周原', '基于PLC的烟密度检测系统设计', '2020-02-07', '已修改', '2020-02-09');
INSERT INTO `view4` VALUES ('9', '徐勇', '基于PLC的压力机控制系统设计', '2020-02-07', '已修改', '2020-02-09');
INSERT INTO `view4` VALUES ('10', '李靖', '航海技术的发展及人才的培养面临的新挑战', '2020-02-07', '已修改', '2020-02-09');
INSERT INTO `view4` VALUES ('11', '王继', '航海技术的发展', '2020-02-07', '已修改', '2020-02-09');
INSERT INTO `view4` VALUES ('12', '郭浩', '我国航海面临的人才问题及相应的对策', '2020-02-07', '已修改', '2020-02-09');
-- ----------------------------
-- Table structure for view5
-- ----------------------------
DROP TABLE IF EXISTS `view5`;
CREATE TABLE `view5` (
`id` int(4) NOT NULL AUTO_INCREMENT,
`lr` varchar(500) DEFAULT NULL,
`fy` varchar(500) DEFAULT NULL,
`kc` varchar(500) DEFAULT NULL,
`zt` varchar(500) DEFAULT NULL,
`xx` varchar(500) DEFAULT NULL,
UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=gb2312;
-- ----------------------------
-- Records of view5
-- ----------------------------
INSERT INTO `view5` VALUES ('3', '20201100', '网络投稿系统的设计与实现 ', '12', '20', '2020-2-10');
INSERT INTO `view5` VALUES ('4', '20201102', '超市管理系统的设计与实现\r\n', '13', '23', '2020-2-10');
INSERT INTO `view5` VALUES ('5', '20201103', '小区物业管理系统的设计与实现\r\n', '14', '26', '2020-2-10');
INSERT INTO `view5` VALUES ('6', '20201104', '医院后勤管理系统的设计与实现\r\n', '20', '28', '2020-2-10');
INSERT INTO `view5` VALUES ('7', '20201105', '景区门票购票系统的设计与实现\r\n', '28', '26', '2020-2-10');
INSERT INTO `view5` VALUES ('8', '20201106', '印务企业的安全管理系统设计\r\n', '20', '24', '2020-2-10');
INSERT INTO `view5` VALUES ('9', '20201107', '基于物联网技术的智慧物流系统的设计与实现\r\n', '26', '66', '2020-2-10');
INSERT INTO `view5` VALUES ('10', '20201108', '门禁管理系统设计', '27', '56', '2020-2-10');
INSERT INTO `view5` VALUES ('11', '20201109', '安防监控系统设计', '28', '89', '2020-2-10');
INSERT INTO `view5` VALUES ('12', '20201144', '新能源仓储管理系统的设计与实现', '29', '58', '2020-2-10');
INSERT INTO `view5` VALUES ('13', '20201155', '房屋交易平台的设计', '30', '89', '2020-2-10');
系统开发
/**
* Constructor of the object.
*/
public ComServlet() {
super();
}
/**
* Destruction of the servlet. <br>
*/
public void destroy() {
super.destroy(); // Just puts "destroy" string in log
// Put your code here
}
/**
* The doGet method of the servlet. <br>
*
* This method is called when a form has its tag value method equals to get.
*
* @param request the request send by the client to the server
* @param response the response send by the server to the client
* @throws ServletException if an error occurred
* @throws IOException if an error occurred
*/
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
doPost(request,response);
}
/**
* The doPost method of the servlet. <br>
*
* This method is called when a form has its tag value method equals to post.
*
* @param request the request send by the client to the server
* @param response the response send by the server to the client
* @throws ServletException if an error occurred
* @throws IOException if an error occurred
*/
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType(Constant.CONTENTTYPE);
request.setCharacterEncoding(Constant.CHARACTERENCODING);
HttpSession session = request.getSession();
ComBean cBean = new ComBean();
String date=new SimpleDateFormat("yyyy-MM-dd").format(Calendar.getInstance().getTime());
String date2=new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(Calendar.getInstance().getTime());
String method = request.getParameter("method");
if(method.equals("addview1")){
//String xm="";String xb="";String nl="";String st="";String hj="";String sfz="";String lxr="";
//String dh="";String zz="";String cw="";String hg="";String rz="";String cy="";
String xm = request.getParameter("xm");
String xb = request.getParameter("xb");
String nl = request.getParameter("nl");
String st = request.getParameter("st");
int flag = cBean.comUp("insert into view1(xm,xb,nl,st) values('"+xm+"','"+xb+"','"+nl+"','"+st+"')");
if(flag == Constant.SUCCESS){
request.setAttribute("message", "操作成功!");
request.getRequestDispatcher("admin/view1/index.jsp").forward(request, response);
}
else{
request.setAttribute("message", "操作失败!");
request.getRequestDispatcher("admin/view1/index.jsp").forward(request, response);
}
}
else if(method.equals("upview1")){ 修改信息
String id=request.getParameter("id");
String xm = request.getParameter("xm");
String xb = request.getParameter("xb");
String nl = request.getParameter("nl");
String st = request.getParameter("st");
int flag = cBean.comUp("update view1 set xm='"+xm+"',xb='"+xb+"',nl='"+nl+"',st='"+st+"' where id='"+id+"'");
if(flag == Constant.SUCCESS){
request.setAttribute("message", "操作成功!");
request.getRequestDispatcher("admin/view1/index.jsp").forward(request, response);
}
else{
request.setAttribute("message", "操作失败!");
request.getRequestDispatcher("admin/view1/index.jsp").forward(request, response);
}
}
else if(method.equals("delview1")){//删除信息
String id = request.getParameter("id");
int flag = cBean.comUp("delete from view1 where id='"+id+"'");
if(flag == Constant.SUCCESS){
request.setAttribute("message", "操作成功!");
request.getRequestDispatcher("admin/view1/index.jsp").forward(request, response);
}
else{
request.setAttribute("message", "系统维护中,请稍后再试!");
request.getRequestDispatcher("admin/view1/index.jsp").forward(request, response);
}
}
else if(method.equals("addview2")){
String lr = request.getParameter("lr");
String sj = request.getParameter("sj");
String xx = request.getParameter("xx");
int flag = cBean.comUp("insert into view2(lr,sj,xx) values('"+lr+"','"+sj+"','"+xx+"' )");
if(flag == Constant.SUCCESS){
request.setAttribute("message", "操作成功!");
request.getRequestDispatcher("admin/view2/index.jsp").forward(request, response);
}
else{
request.setAttribute("message", "操作失败!");
request.getRequestDispatcher("admin/view2/index.jsp").forward(request, response);
}
}
else if(method.equals("upview2")){
String id=request.getParameter("id");
String lr = request.getParameter("lr");
String sj = request.getParameter("sj");
String xx = request.getParameter("xx");
int flag = cBean.comUp("update view2 set lr='"+lr+"',sj='"+sj+"',xx='"+xx+"' where id='"+id+"'");
if(flag == Constant.SUCCESS){
request.setAttribute("message", "操作成功!");
request.getRequestDispatcher("admin/view2/index.jsp").forward(request, response);
}
else{
request.setAttribute("message", "操作失败!");
request.getRequestDispatcher("admin/view2/index.jsp").forward(request, response);
}
}
else if(method.equals("delview2")){
String id = request.getParameter("id");
int flag = cBean.comUp("delete from view2 where id='"+id+"'");
if(flag == Constant.SUCCESS){
request.setAttribute("message", "操作成功!");
request.getRequestDispatcher("admin/view2/index.jsp").forward(request, response);
}
else{
request.setAttribute("message", "系统维护中,请稍后再试!");
request.getRequestDispatcher("admin/view2/index.jsp").forward(request, response);
}
}
else if(method.equals("addview3")){
String lr = request.getParameter("lr");
String sj = request.getParameter("sj");
String xx = request.getParameter("xx");
int flag = cBean.comUp("insert into view3(lr,sj,xx) values('"+lr+"','"+sj+"','"+xx+"' )");
if(flag == Constant.SUCCESS){
request.setAttribute("message", "操作成功!");
request.getRequestDispatcher("admin/view3/index.jsp").forward(request, response);
}
else{
request.setAttribute("message", "操作失败!");
request.getRequestDispatcher("admin/view3/index.jsp").forward(request, response);
}
}
else if(method.equals("upview3")){
String id=request.getParameter("id");
String lr = request.getParameter("lr");
String sj = request.getParameter("sj");
String xx = request.getParameter("xx");
int flag = cBean.comUp("update view3 set lr='"+lr+"',sj='"+sj+"',xx='"+xx+"' where id='"+id+"'");
if(flag == Constant.SUCCESS){
request.setAttribute("message", "操作成功!");
request.getRequestDispatcher("admin/view3/index.jsp").forward(request, response);
}
else{
request.setAttribute("message", "操作失败!");
request.getRequestDispatcher("admin/view3/index.jsp").forward(request, response);
}
}
else if(method.equals("delview3")){
String id = request.getParameter("id");
int flag = cBean.comUp("delete from view3 where id='"+id+"'");
if(flag == Constant.SUCCESS){
request.setAttribute("message", "操作成功!");
request.getRequestDispatcher("admin/view3/index.jsp").forward(request, response);
}
else{
request.setAttribute("message", "系统维护中,请稍后再试!");
request.getRequestDispatcher("admin/view3/index.jsp").forward(request, response);
}
}
else if(method.equals("addview4")){
String lr = request.getParameter("lr");
String fy = request.getParameter("fy");
String kc = request.getParameter("kc");
String zt = request.getParameter("zt");
String xx = request.getParameter("xx");
int flag = cBean.comUp("insert into view4(lr,fy,kc,zt,xx) values('"+lr+"','"+fy+"','"+kc+"','"+zt+"','"+xx+"')");
if(flag == Constant.SUCCESS){
request.setAttribute("message", "操作成功!");
request.getRequestDispatcher("admin/view4/index.jsp").forward(request, response);
}
else{
request.setAttribute("message", "操作失败!");
request.getRequestDispatcher("admin/view4/index.jsp").forward(request, response);
}
}
else if(method.equals("upview4")){
String id=request.getParameter("id");
String lr = request.getParameter("lr");
String fy = request.getParameter("fy");
String kc = request.getParameter("kc");
String zt = request.getParameter("zt");
String xx = request.getParameter("xx");
int flag = cBean.comUp("update view4 set lr='"+lr+"',fy='"+fy+"',kc='"+kc+"',zt='"+zt+"',xx='"+xx+"' where id='"+id+"'");
if(flag == Constant.SUCCESS){
request.setAttribute("message", "操作成功!");
request.getRequestDispatcher("admin/view4/index.jsp").forward(request, response);
}
else{
request.setAttribute("message", "操作失败!");
request.getRequestDispatcher("admin/view4/index.jsp").forward(request, response);
}
}
else if(method.equals("delview4")){
String id = request.getParameter("id");
int flag = cBean.comUp("delete from view4 where id='"+id+"'");
if(flag == Constant.SUCCESS){
request.setAttribute("message", "操作成功!");
request.getRequestDispatcher("admin/view4/index.jsp").forward(request, response);
}
else{
request.setAttribute("message", "操作失败!");
request.getRequestDispatcher("admin/view4/index.jsp").forward(request, response);
}
}
三、注意事项
1、管理员账号:admin密码:admin 数据库配置文件DBO.java
2、开发环境为TOMCAT7.0,eclipse开发,数据库为Mysql5.0,使用java语言开发。
3、数据库文件名是e0715.sql ,系统名称E0715
4、系统首页地址:http://127.0.0.1:8080/E0715/login.jsp
四系统设计
下载地址:
http:// https://download.csdn.net/download/qq_41221322/89512485
需要源码 其他的定制服务 下方联系卡片↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓ 或者私信作者