建手机网站款软件,怎样给自己做网站,国外免费下载wordpress主题,兼职做设计的网站1、项目功能演示 DC00023基于jsp新生报到管理系统java webMySQL新生管理系统 2、项目功能描述
基于jspMySQL新生报到管理系统项目分为学生、辅导员、财务处和系统管理员四个角色。
2.1 学生功能
1、系统登录 2、校园新闻、报到流程、学校简介、在线留言、校园风光、入校须知…1、项目功能演示 DC00023基于jsp新生报到管理系统java webMySQL新生管理系统 2、项目功能描述
基于jspMySQL新生报到管理系统项目分为学生、辅导员、财务处和系统管理员四个角色。
2.1 学生功能
1、系统登录 2、校园新闻、报到流程、学校简介、在线留言、校园风光、入校须知、大学公告、证书清单 3、个人资料管理 4、缴费记录查看 5、我的宿舍查看
2.2 辅导员功能
1、系统登录 2、留言管理 3、新生报到添加 4、宿舍分配
2.3 财务处功能
1、系统登录 2、个人密码管理 3、学生缴费添加、学生缴费查询
2.4 系统管理员功能
1、系统登录 2、管理员管理 3、校园新闻管理 4、校园风光管理 5、宿舍楼管理 6、班级信息管理 7、留言管理 8、专业信息管理 9、新生报到管理 10、宿舍分配管理 11、大学公告管理 12、入校须知管理 13、系统管理系统公告、学校简介、友情链接、新生报到 14、证件管理
3、项目运行截图部分 4、项目核心代码
4.1 数据库操作类
package db;import java.io.PrintStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;public class db
{private String dbDriver com.mysql.cj.jdbc.Driver;private String sConnStr jdbc:mysql://localhost:3306/arrivals?useSSLfalseserverTimezoneAsia/ShanghaicharacterEncodingutf-8autoReconnecttrue;public Connection connect null;public ResultSet rs null;public db() {try {Class.forName(this.dbDriver).newInstance();this.connect DriverManager.getConnection(this.sConnStr, root, root);}catch (Exception ex){ex.printStackTrace();}}public ResultSet executeQuery(String sql){try {this.connect DriverManager.getConnection(this.sConnStr, root, root);Statement stmt this.connect.createStatement();this.rs stmt.executeQuery(sql);}catch (SQLException ex) {ex.printStackTrace();}return this.rs;}public void executeUpdate(String sql){Statement stmt null;this.rs null;try {this.connect DriverManager.getConnection(this.sConnStr, root, root);stmt this.connect.createStatement();stmt.executeUpdate(sql);stmt.close();this.connect.close();}catch (SQLException ex){ex.printStackTrace();}}
} 4.2 主界面
% page languagejava pageEncodingUTF-8%
%String path request.getContextPath();String basePath request.getScheme() :// request.getServerName() : request.getServerPort() path /;
%
% page languagejava importjava.sql.*%
jsp:useBean idmyconnDbBean scopepage classdb.db /
html
head
base href%basePath%title新生报到系统/title
LINK hrefqtimages/style.css typetext/css relstylesheet
style typetext/css
!--
.style1 {WIDTH: 63px
}.STYLE2 {color: #477641;font-weight: bold;
}.STYLE3 {color: #FFFFFF
}.STYLE4 {color: #FFFFFF;font-weight: bold;
}
--
/style/headbodytable width992 border0 aligncenter cellpadding0cellspacing0trtd colspan2% include fileqttop.jsp%/td/trtrtd width163 valigntop% include fileqtleft.jsp%/tdtd width813 valigntoptable width98% border0aligncenter cellpadding0 cellspacing0tbodytrtd height44 backgroundqtimages/index_r4_c8.jpgtablewidth100% border0 cellpadding0 cellspacing0trtd width8%nbsp;/tdtd width92% classred STYLE2学校简介/td/tr/table/td/trtrtd height182 valigntop classbodertablecellspacing0 cellpadding0 width98% aligncenterborder0tbodytrtd valigntop width487div classintroliness%String sql select content from dx where leibie系统简介;String neirong ;ResultSet RS_result myconnDbBean.executeQuery(sql);while (RS_result.next()) {neirong RS_result.getString(content);out.print(neirong);}%/div/tdtd width13nbsp;/td/tr/tbody/table/td/trtrtd valigntop height9imgsrcqtimages/index_r19_c8.jpg width320 //td/trtrtd height3/td/trtrtd backgroundqtimages/index_r52_c8.jpg height53tablewidth100% border0 cellpadding0 cellspacing0trtd width8%nbsp;/tdtd width92% classred STYLE2校园风光/td/tr/table/td/trtrtd classboder height130table classnewslinecellspacing0 cellpadding0 width98% aligncenterborder0tbody/tbody/tabletable width100% height100% border0 aligncentercellpadding0 cellspacing0trtdtable width100% height100% border0aligncenter cellpadding0 cellspacing0tr%sql select id,mingcheng,tupian from xiaoyuanfengguang where tupian order by id desc limit 0,4;RS_result myconnDbBean.executeQuery(sql);String xingming ;String touxiang ;String id ;while (RS_result.next()) {id RS_result.getString(id);xingming RS_result.getString(mingcheng);touxiang RS_result.getString(tupian);%td aligncentertable width150 border0cellspacing0 cellpadding0trtd height129 aligncenterahref%touxiang% target_blankimgsrc%touxiang% width129 height123border0 //a/td/trtrtd height26 aligncenter%xingming%/td/tr/table/td%}%/tr/table/td/tr/table/td/trtrtdimg height9 srcqtimages/index_r19_c8.jpgwidth320 //td/trtrtd height3/td/trtrtdtable cellspacing0 cellpadding0 width100%border0tbodytrtd width387 valigntoptable cellspacing0cellpadding0 width387 border0tbodytrtd width387 height40backgroundqtimages/index_r22_c8.jpgtablewidth100% border0 cellpadding0 cellspacing0trtd width15%nbsp;/tdtd width85%a hrefnews.jsp?lb大学公告fontclassSTYLE2大学公告/font/a/td/tr/table/td/trtrtd classboder valigntop height131tableclassnewsline cellspacing0 cellpadding0width95% aligncenter border0tbody%sql select id,biaoti,addtime from xinwentongzhi where leibie大学公告 order by id desc limit 0,7;RS_result myconnDbBean.executeQuery(sql);// String id;String biaoti ;String addtime ;int i 0;while (RS_result.next()) {i i 1;id RS_result.getString(id);biaoti RS_result.getString(biaoti);if (biaoti.length() 28) {biaoti biaoti.substring(0, 28);}addtime RS_result.getString(addtime);%trtd width5% height25img height7srcqtimages/index_r9_c9.jpg width7 //tdtd width95% height25ahrefgg_detail.jsp?id%id%%biaoti%/a/td/tr%}%/tbody/table/td/trtrtd backgroundqtimages/index_r29_c8.jpg height10/td/tr/tbody/table/tdtd width5/tdtd width400 valigntoptable width100%border0 aligncenter cellpadding0 cellspacing0tbodytrtd width387 height40backgroundqtimages/index_r22_c14.jpgtablewidth100% border0 cellpadding0 cellspacing0trtd width16%nbsp;/tdtd width84%a hrefnews.jsp?lb入校需知fontclassSTYLE2入校需知/font/a/td/tr/table/td/trtrtd classboder valigntop height131tableclassnewsline cellspacing0 cellpadding0width95% aligncenter border0tbody%sql select id,biaoti,addtime from xinwentongzhi where leibie入校需知 order by id desc limit 0,7;RS_result myconnDbBean.executeQuery(sql);// String id;biaoti ;addtime ;i 0;while (RS_result.next()) {i i 1;id RS_result.getString(id);biaoti RS_result.getString(biaoti);if (biaoti.length() 28) {biaoti biaoti.substring(0, 28);}addtime RS_result.getString(addtime);%trtd width5% height25img height7srcqtimages/index_r9_c9.jpg width7 //tdtd width95% height25ahrefgg_detail.jsp?id%id%%biaoti%/a/td/tr%}%/tbody/table/td/trtrtd backgroundqtimages/index_r29_c8.jpg height10/td/tr/tbody/table/td/tr/tbody/table/td/trtrtd height3/td/tr/tbody/table/td/tr/table% include fileqtdown.jsp%
/body
/html 4.3 登录界面
% page languagejava pageEncodingUTF-8%
%String path request.getContextPath();String basePath request.getScheme() :// request.getServerName() : request.getServerPort() path /;
%
% page languagejava importjava.sql.*%
jsp:useBean idconnDbBean scopepage classdb.db /
html
head
base href%basePath%title用户登录/titlemeta namerenderer contentwebkit|ie-comp|ie-stand
meta http-equivX-UA-Compatible contentIEedge,chrome1
meta nameviewportcontentwidthdevice-width,initial-scale1,minimum-scale1.0,maximum-scale1.0,user-scalableno /
meta http-equivCache-Control contentno-siteapp /
!--[if lt IE 9]script typetext/javascript srclib/html5.js/scriptscript typetext/javascript srclib/PIE_IE678.js/script![endif]--
link hrefcss/H-ui.min.css relstylesheet typetext/css /
link hrefcss/H-ui.login.css relstylesheet typetext/css /
link hrefcss/style.css relstylesheet typetext/css /
link hreflib/Hui-iconfont/1.0.1/iconfont.css relstylesheettypetext/css /
!--[if IE 6]script typetext/javascript srchttp://lib.h-ui.net/DD_belatedPNG_0.0.8a-min.js /scriptscriptDD_belatedPNG.fix(*);/script![endif]--
bodydiv classheader/divdiv classloginWraperdiv idloginform classloginBoxform nameform1 methodpost actionadminyanzheng.jspclassform form-horizontaldiv classrow cllabel classform-label col-3i classHui-iconfont帐号/i/labeldiv classformControls col-8input nameusername typetext idusernameclassinput-text size-L //div/divdiv classrow cllabel classform-label col-3i classHui-iconfont密码/i/labeldiv classformControls col-8input namepwd typepassword idpwdclassinput-text size-L //div/divdiv classrow cllabel classform-label col-3i classHui-iconfont类型/i/labeldiv classformControls col-8select namecx idcx classinput-text size-Loption value管理员管理员/optionoption value财务处财务处/optionoption value辅导员辅导员/option/select input namelogin typehidden idlogin value1/div/divdiv classrowdiv classformControls col-8 col-offset-3/div/divdiv classrowdiv classformControls col-8 col-offset-3input typesubmit nameSubmit value登陆classbtn btn-default radius size-L inputtypereset nameSubmit2 value重置classbtn btn-success radius size-L/div/div/form/div/div/body
/html
5、项目内容包含 6、项目获取
6.1 方式一
私聊或者扫描下方名片获取项目文件。 6.2 方式二
点击此处直接获取项目文件。
