• Java项目：JSP高校新生报到迎新管理系统

    作者主页：源码空间站2022

     简介：Java领域优质创作者、Java项目、学习资料、技术互助

    文末获取源码

    项目介绍

    辅导员角色包含以下功能：
    辅导员登录,学生留言管理,新生报到管理,宿舍分配管理等功能。

    财务管理角色包含以下功能：
    财务管理员登录,管理学生缴费,个人密码管理等功能。

    管理员角色包含以下功能：
    管理员登录,管理人员管理,校园新闻管理,校园风光管理,宿舍楼管理,班级信息管理,留言管理,专业信息查询,新生报到管理,宿舍分配管理,大学公告管理,入校须知管理,系统公告管理,学校简介管理,友情链接管理,新生报到模板管理等功能。

    学生角色包含以下功能：
    学生首页,校园新闻管理,报道流程管理,学校简介查看,在线留言,校园风光查看,入校须知查看,大学公告查看,学生信息后台,缴费记录查看,宿舍分配查看等功能。

    环境需要

    1.运行环境：最好是java jdk 1.8，我们在这个平台上运行的。其他版本理论上也可以。
    2.IDE环境：IDEA，Eclipse,Myeclipse都可以。推荐IDEA;
    3.tomcat环境：Tomcat 7.x,8.x,9.x版本均可
    4.硬件环境：windows 7/8/10 1G内存以上；或者 Mac OS； 

    5.数据库：MySql 5.7版本；

    技术栈

    HTML+CSS+JavaScript+jsp+mysql

    使用说明

    1. 使用Navicat或者其它工具，在mysql中创建对应名称的数据库，并导入项目的sql文件；
    2. 使用IDEA/Eclipse/MyEclipse导入项目，Eclipse/MyEclipse导入时，若为maven项目请选择maven;若为maven项目，导入成功后请执行maven clean;maven install命令，然后运行；
    3. 将项目中application.yml配置文件中的数据库配置改为自己的配置;

    4. 运行项目，输入localhost:8080/login.jsp 登录

    运行截图

    相关代码 

    Upload

    1. package control;
    2.  
    3. import java.io.BufferedInputStream;
    4. import java.io.BufferedOutputStream;
    5. import java.io.FileInputStream;
    6. import java.io.IOException;
    7. import java.io.InputStream;
    8. import java.io.OutputStream;
    9. import java.io.PrintWriter;
    10. import java.io.UnsupportedEncodingException;
    11. import java.net.URLEncoder;
    12.  
    13. import javax.servlet.ServletException;
    14. import javax.servlet.http.HttpServlet;
    15. import javax.servlet.http.HttpServletRequest;
    16. import javax.servlet.http.HttpServletResponse;
    17.  
    18. import util.Info;
    19.  
    20. public class Upload extends HttpServlet {
    21.  
    22. 	/**
    23. 	 * Constructor of the object.
    24. 	 */
    25. 	public Upload() {
    26. 		super();
    27. 	}
    28.  
    29. 	/**
    30. 	 * Destruction of the servlet. 
    31. 	 */
    32. 	public void destroy() {
    33. 		super.destroy(); // Just puts "destroy" string in log
    34. 		// Put your code here
    35. 	}
    36.  
    37. 	/**
    38. 	 * The doGet method of the servlet. 
    39. 	 *
    40. 	 * This method is called when a form has its tag value method equals to get.
    41. 	 * 
    42. 	 * @param request the request send by the client to the server
    43. 	 * @param response the response send by the server to the client
    44. 	 * @throws ServletException if an error occurred
    45. 	 * @throws IOException if an error occurred
    46. 	 */
    47. 	public void doGet(HttpServletRequest request, HttpServletResponse response)
    48. 			throws ServletException, IOException {
    49.  
    50. 		this.doPost(request, response);
    51. 	}
    52.  
    53. 	/**
    54. 	 * The doPost method of the servlet. 
    55. 	 *
    56. 	 * This method is called when a form has its tag value method equals to post.
    57. 	 * 
    58. 	 * @param request the request send by the client to the server
    59. 	 * @param response the response send by the server to the client
    60. 	 * @throws ServletException if an error occurred
    61. 	 * @throws IOException if an error occurred
    62. 	 */
    63. 	public void doPost(HttpServletRequest request, HttpServletResponse response)
    64. 			throws ServletException, IOException {
    65.  
    66. 		StringBuffer   sb   =   new   StringBuffer(50);   
    67. 		 response.setContentType("application/x-msdownload;charset=utf-8");   
    68.         try {
    69. 			response.setHeader("Content-Disposition",   new   String(sb.toString()   
    70. 			         .getBytes(),   "ISO8859-1"));
    71. 		} catch (UnsupportedEncodingException e1) {
    72. 			// TODO Auto-generated catch block
    73. 			e1.printStackTrace();
    74. 		}
    75. 		 String filename = request.getParameter("filename");
    76. 		  if (request.getHeader("User-Agent").toLowerCase().indexOf("firefox") > 0){
    77. 		     try {
    78. 				filename = new String(filename.getBytes("UTF-8"), "ISO8859-1");
    79. 			} catch (UnsupportedEncodingException e) {
    80. 				// TODO Auto-generated catch block
    81. 				e.printStackTrace();
    82. 			}
    83. 		 }
    84. 		 else 
    85. 		      if (request.getHeader("User-Agent").toUpperCase().indexOf("MSIE") > 0){
    86. 		           try {
    87. 					filename = URLEncoder.encode(filename, "UTF-8");
    88. 				} catch (UnsupportedEncodingException e) {
    89. 					// TODO Auto-generated catch block
    90. 					e.printStackTrace();
    91. 				}
    92. 		      }
    93. 		 response.setContentType("text/plain");
    94. 		 response.setHeader("Location",filename);
    95. 		 response.reset();
    96. 		 response.setHeader("Cache-Control", "max-age=0" );
    97. 		 response.setHeader("Content-Disposition", "attachment; filename=" + filename);
    98. 		   
    99.  
    100. 		    try {
    101. 				       BufferedInputStream bis = null;
    102. 					   BufferedOutputStream bos = null;
    103. 					   OutputStream fos = null;
    104. 					  // File f = new File(request.getRealPath("/upfile/")+"/"+filename);
    105. 					   //System.out.println(f);
    106. 					   bis = new BufferedInputStream((InputStream)new FileInputStream(request.getRealPath("/upfile/")+"/"+filename));
    107. 					    fos = response.getOutputStream();
    108. 					    bos = new BufferedOutputStream(fos);
    109.  
    110. 					    int bytesRead = 0;
    111. 					    byte[] buffer = new byte[5 * 1024];
    112. 					    while ((bytesRead = bis.read(buffer)) != -1) {
    113. 					     bos.write(buffer, 0, bytesRead);
    114. 					    }
    115. 					    bos.close();
    116. 					    bis.close();
    117. 					    fos.close();
    118. 				
    119. 		     } catch (Exception e) {
    120. 				e.printStackTrace();
    121. 			}finally{
    122. 			}
    123. 	}
    124.  
    125. 	/**
    126. 	 * Initialization of the servlet. 
    127. 	 *
    128. 	 * @throws ServletException if an error occurs
    129. 	 */
    130. 	public void init() throws ServletException {
    131. 		// Put your code here
    132. 	}
    133.  
    134. }

    CommDAO

    1. package dao;
    2.  
    3. import java.sql.Connection;
    4. import java.sql.ResultSet;
    5. import java.sql.ResultSetMetaData;
    6. import java.sql.SQLException;
    7. import java.sql.Statement;
    8. import java.text.ParseException;
    9. import java.text.SimpleDateFormat;
    10. import java.util.ArrayList;
    11. import java.util.Date;
    12. import java.util.HashMap;
    13. import java.util.List;
    14.  
    15. import util.SimpleDataSource;
    16.  
    17. public class CommDAO {
    18.  
    19. 	public Connection getConn() {
    20. 		Connection conn = null;
    21. 		try {
    22. 			conn = SimpleDataSource.instance().getConnection();
    23. 		} catch (Exception e) {
    24. 			e.printStackTrace();
    25. 		}
    26. 		return conn;
    27. 	}
    28.  
    29. 	public int getInt(String sql) {
    30. 		int i = 0;
    31. 		Connection conn = getConn();
    32. 		Statement st = null;
    33. 		try {
    34. 			st = conn.createStatement();
    35. 			ResultSet rs = st.executeQuery(sql);
    36. 			if (rs.next()) {
    37. 				i = rs.getInt(1);
    38. 			}
    39.  
    40. 		} catch (SQLException e) {
    41. 			e.printStackTrace();
    42. 		} finally {
    43. 			try {
    44. 				SimpleDataSource.freeConnection(conn);
    45. 				if (null != st) {
    46. 					st.close();
    47. 				}
    48.  
    49. 			} catch (Exception e) {
    50.  
    51. 			}
    52.  
    53. 		}
    54. 		return i;
    55. 	}
    56.  
    57. 	public double getDouble(String sql) {
    58. 		double i = 0;
    59. 		Connection conn = getConn();
    60. 		Statement st = null;
    61. 		try {
    62. 			st = conn.createStatement();
    63. 			ResultSet rs = st.executeQuery(sql);
    64. 			if (rs.next()) {
    65. 				i = rs.getDouble(1);
    66.  
    67. 			}
    68. 		} catch (SQLException e) {
    69. 			e.printStackTrace();
    70. 		} finally {
    71. 			try {
    72. 				if (null != conn) {
    73. 					conn.close();
    74. 				}
    75. 				if (null != st) {
    76. 					st.close();
    77. 				}
    78.  
    79. 			} catch (Exception e) {
    80.  
    81. 			}
    82.  
    83. 		}
    84. 		return i;
    85. 	}
    86.  
    87. 	public void commOper(String sql) {
    88. 		Connection conn = getConn();
    89. 		Statement st = null;
    90. 		try {
    91. 			st = conn.createStatement();
    92. 			st.execute(sql);
    93. 		} catch (SQLException e) {
    94. 			// TODO Auto-generated catch block
    95. 			e.printStackTrace();
    96. 		} finally {
    97. 			try {
    98. 				SimpleDataSource.freeConnection(conn);
    99. 				if (null != st) {
    100. 					st.close();
    101. 				}
    102.  
    103. 			} catch (Exception e) {
    104.  
    105. 			}
    106.  
    107. 		}
    108. 	}
    109.  
    110. 	public void commOperSqls(ArrayList sql) {
    111. 		Connection conn = getConn();
    112. 		Statement st = null;
    113. 		try {
    114. 			conn.setAutoCommit(false);
    115. 			for (int i = 0; i < sql.size(); i++) {
    116. 				st = conn.createStatement();
    117.  
    118. 				st.execute(sql.get(i));
    119. 				st.close();
    120. 			}
    121. 			conn.commit();
    122. 		} catch (SQLException e) {
    123. 			try {
    124. 				conn.rollback();
    125. 			} catch (SQLException e1) {
    126. 				e1.printStackTrace();
    127. 			}
    128. 			e.printStackTrace();
    129. 		} finally {
    130. 			try {
    131. 				conn.setAutoCommit(true);
    132. 				SimpleDataSource.freeConnection(conn);
    133. 				if (null != st) {
    134. 					st.close();
    135. 				}
    136.  
    137. 			} catch (SQLException e) {
    138. 				e.printStackTrace();
    139. 			}
    140. 		}
    141. 	}
    142.  
    143. 	public List select(String sql) {
    144. 		int END = Integer.MAX_VALUE;
    145. 		int START = END - 100;
    146. 		SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
    147.  
    148. 		List list = new ArrayList();
    149. 		Connection conn = getConn();
    150. 		Statement st = null;
    151. 		try {
    152. 			st = conn.createStatement();
    153. 			ResultSet rs = st.executeQuery(sql);
    154. 			ResultSetMetaData rsmd = rs.getMetaData();
    155.  
    156. 			while (rs.next()) {
    157. 				HashMap map = new HashMap();
    158. 				int i = rsmd.getColumnCount();
    159. 				for (int j = 1; j <= i; j++) {
    160. 					if (!rsmd.getColumnName(j).equals("ID")) {
    161. 						map.put(rsmd.getColumnName(j),
    162. 								rs.getString(j) == null ? "" : rs.getString(j));
    163. 					} else {
    164.  
    165. 						map.put("id", rs.getString(j));
    166. 					}
    167. 				}
    168. 				list.add(map);
    169. 			}
    170. 			rs.close();
    171. 		} catch (SQLException e) {
    172. 			// TODO Auto-generated catch block
    173. 			System.out.println("--" + sql);
    174. 			e.printStackTrace();
    175. 		} finally {
    176. 			try {
    177. 				conn.setAutoCommit(true);
    178. 				SimpleDataSource.freeConnection(conn);
    179. 				if (null != st) {
    180. 					st.close();
    181. 				}
    182.  
    183. 			} catch (SQLException e) {
    184. 				e.printStackTrace();
    185. 			}
    186. 		}
    187. 		return list;
    188. 	}
    189.  
    190. 	/**
    191. 	 * 执行一条查询sql,以 List 的形式返回查询的记录，记录条数，和从第几条开始，由参数决定，主要用于翻页 pageno 页码
    192. 	 * rowsize 每页的条数
    193. 	 */
    194. 	public List select(String sql, int pageno, int rowsize) {
    195. 		List list = new ArrayList();
    196. 		List mlist = new ArrayList();
    197. 		try {
    198. 			list = this.select(sql);
    199. 			int min = (pageno - 1) * rowsize;
    200. 			int max = pageno * rowsize;
    201.  
    202. 			for (int i = 0; i < list.size(); i++) {
    203.  
    204. 				if (!(i < min || i > (max - 1))) {
    205. 					mlist.add(list.get(i));
    206. 				}
    207. 			}
    208. 		} catch (RuntimeException re) {
    209. 			re.printStackTrace();
    210. 			throw re;
    211. 		}
    212.  
    213. 		return mlist;
    214. 	}
    215.  
    216. 	// 该方法返回一个table 用于流动图片
    217. 	public String DynamicImage(String categoryid, int cut, int width, int height) {
    218.  
    219. 		StringBuffer imgStr = new StringBuffer();
    220. 		StringBuffer thePics1 = new StringBuffer();
    221. 		StringBuffer theLinks1 = new StringBuffer();
    222. 		StringBuffer theTexts1 = new StringBuffer();
    223.  
    224. 		imgStr.append("
      \n"      );
    225. 		return imgStr.toString();
    226. 	}
    227.  
    228. 	public static void main(String[] args) {
    229. 		System.out.println(new CommDAO());
    230. 	}
    231. }

    LoginFilter

    1. package util;
    2.  
    3. import java.io.IOException;
    4. import java.io.PrintWriter;
    5.  
    6. import javax.servlet.Filter;
    7. import javax.servlet.FilterChain;
    8. import javax.servlet.FilterConfig;
    9. import javax.servlet.ServletException;
    10. import javax.servlet.ServletRequest;
    11. import javax.servlet.ServletResponse;
    12. import javax.servlet.http.HttpServletRequest;
    13. import javax.servlet.http.HttpServletResponse;
    14. import javax.servlet.http.HttpSession;
    15.  
    16.  
    17. public class LoginFilter implements Filter {
    18.  
    19. 	public void destroy() {
    20. 		// TODO Auto-generated method stub
    21. 		
    22. 	}
    23.  
    24. 	public void doFilter(ServletRequest req, ServletResponse res, FilterChain chain) throws IOException, ServletException {
    25. 		// TODO Auto-generated method stub
    26. 		HttpServletRequest request = (HttpServletRequest) req;
    27. 		HttpServletResponse response = (HttpServletResponse) res;
    28. 		HttpSession session = request.getSession();
    29. 		// 如果session不为空，则可以浏览其他页面
    30. 		String url = request.getServletPath();
    31. 		//System.out.println(url);
    32. 		String path = request.getRequestURI();
    33. 		//这里判断目录，后缀名，当然也可以写在web.xml中，用url-pattern进行拦截映射
    34. 		if ((!request.getServletPath().equals("/admin/login.action"))
    35. 				&& (!request.getServletPath().equals("/admin/login.jsp"))
    36. 				&& (!request.getServletPath().equals("/admin/relogin.jsp"))
    37. 				&& (!request.getServletPath().equals("/admin/lib/font-awesome/css/font-awesome.css"))
    38. 				&& (!request.getServletPath().equals("/admin/lib/bootstrap/js/bootstrap.js"))
    39. 				&& (!request.getServletPath().equals("/admin/lib/jquery-1.7.2.min.js"))
    40. 				&& (!request.getServletPath().equals("/admin/stylesheets/theme.css"))
    41. 				&& (!request.getServletPath().equals("/admin/lib/bootstrap/css/bootstrap.css"))
    42. 				) {
    43. 			// 登陆页面无需过滤
    44. 			if(path.indexOf("/admin/login.jsp") > -1) {
    45. 				chain.doFilter(request, response);
    46. 				return;
    47. 			}
    48. 			
    49. 			
    50.  
    51. 			if (session.getAttribute("admin") == null) {
    52. 				session.invalidate();
    53. 				response.setContentType("text/html;charset=gb2312");
    54. 				PrintWriter out = response.getWriter();
    55. 				out.println("");
    56. 			} else {
    57. 				chain.doFilter(request, response);
    58. 			}
    59. 		} else {
    60. 			chain.doFilter(request, response);
    61. 		}
    62.  
    63. 	}
    64.  
    65. 	public void init(FilterConfig arg0) throws ServletException {
    66. 		// TODO Auto-generated method stub
    67.  
    68. 	}
    69.  
    70. }

    如果也想学习本系统，下面领取。关注并回复：076jsp

     

  • 相关阅读:
    机器学习/人工智能的笔试面试题目——SVM算法相关问题总结
    有含金量的AI证书
    基于springboot实现校园疫情防控系统项目【项目源码+论文说明】计算机毕业设计
    跨境电商迎来全球5日达革命？菜鸟全球化再提速！
    计算机网络性能指标：速率，带宽，吞吐量
    如何利用数字创新使您的企业脱颖而出
    服务器使用ssl证书有哪些好处
    C#A类调用B类的方法，在方法中更新B类的控件
    探索数据结构：从基础到高级
    prometheus 监控实战篇
  • 原文地址：https://blog.csdn.net/m0_74967853/article/details/128031765