Java源码社

基于javaweb的JSP+Servlet高校学生宿舍管理系统(java+mysql+jsp+servlet+tomcat)

更新于

运行环境

Java≥8、MySQL≥5.7、Tomcat≥8

开发工具

eclipse/idea/myeclipse/sts等均可配置运行

适用

课程设计，大作业，毕业设计，项目练习，学习演示等

功能说明

042123543111

042123543110

052123543110

062123543110

082123543110

092123543110

102123543110

112123543110

122123543110

132123543110

142123543110

基于javaweb的JSP+Servlet高校学生宿舍管理系统(java+mysql+jsp+servlet+tomcat)

管理员：
admin 123456

宿管员：
manager 123456

班主任：
teacher 123456

学生：
user1 123456
user2 123456
user3 123456

*学生可以注册、登录、修改详细资料、报修、水电费等

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
					request.setAttribute("message", "操作失败！");
					request.getRequestDispatcher("admin/ds/index.jsp").forward(request, response); 
				} 
		}
		else if(method.equals("delds2")){  //add 删除
			 String id = request.getParameter("id");
				String sql="delete from ds where id='"+id+"'";
				int flag = cBean.comUp(sql);
				if(flag == Constant.SUCCESS){  
					request.setAttribute("message", "操作成功！");
					request.getRequestDispatcher("admin/ds/index.jsp").forward(request, response); 
				}
				else { 
					request.setAttribute("message", "操作失败！");
					request.getRequestDispatcher("admin/ds/index.jsp").forward(request, response); 
				} 
		}
		
		
		else if(method.equals("cx")){  //add 删除
			 String lx = request.getParameter("lx");
			 String word = request.getParameter("word");
			 
					request.setAttribute("word", word);
					request.setAttribute("lx", lx);
					request.getRequestDispatcher("member/cx/"+lx+".jsp").forward(request, response); 
				 
		}
	}

	/**
	 * Initialization of the servlet. <br>
	 *
	 * @throws ServletException if an error occure
	 */
	public void init() throws ServletException {
		// Put your code here
	}

}

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
	String dz=request.getParameter("dz");
	String dh=request.getParameter("dh");
	String qq=request.getParameter("qq"); 
	String member=(String)session.getAttribute("member");
	int flag = cBean.comUp("insert into bx(xm,dz,dh,qq,member,sj) values('"+xm+"','"+dz+"','"+dh+"','"+qq+"','"+member+"','"+date2+"')");
	if(flag == Constant.SUCCESS){
		request.setAttribute("message", "操作成功！");
		request.getRequestDispatcher("member/bx/index.jsp").forward(request, response);
	}
	else{
		request.setAttribute("message", "系统维护中，请稍后再试！");
		request.getRequestDispatcher("member/bx/index.jsp").forward(request, response);
	} 
}
else if(method.equals("upbx")){//修改
	String id = request.getParameter("id"); 
	String xm=request.getParameter("xm");
	String dz=request.getParameter("dz");
	String dh=request.getParameter("dh");
	String qq=request.getParameter("qq"); 
	int flag = cBean.comUp("update bx set xm='"+xm+"', dz='"+dz+"', dh='"+dh+"', qq='"+qq+"'  where id='"+id+"'");
	if(flag == Constant.SUCCESS){
		request.setAttribute("message", "操作成功！");
		request.getRequestDispatcher("member/bx/index.jsp").forward(request, response);
	}
	else{
		request.setAttribute("message", "系统维护中，请稍后再试！");
		request.getRequestDispatcher("member/bx/index.jsp").forward(request, response);
	} 
}
else if(method.equals("delbx")){  //add 删除
	 String id = request.getParameter("id");
		String sql="delete from bx where id='"+id+"'";
		int flag = cBean.comUp(sql);
		if(flag == Constant.SUCCESS){  
			request.setAttribute("message", "操作成功！");
			request.getRequestDispatcher("member/bx/index.jsp").forward(request, response); 
		}
		else { 
			request.setAttribute("message", "操作失败！");
			request.getRequestDispatcher("member/bx/index.jsp").forward(request, response); 
		} 
}
else if(method.equals("delbx2")){  //add 删除
	 String id = request.getParameter("id");
		String sql="delete from bx where id='"+id+"'";
		int flag = cBean.comUp(sql);
		if(flag == Constant.SUCCESS){  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
 * 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);
	try{
		String method=request.getParameter("method").trim();
		AdminBean loginbean = new AdminBean();
		HttpSession session = request.getSession();
		session.setMaxInactiveInterval(1200);
		SystemBean systembean = new SystemBean();
		String sysdir = systembean.getDir();
		if(method.equals("one")){//admin登录
			String username = request.getParameter("username");
			String password = request.getParameter("password");
			if(username == null||username.trim().equals("")){
				request.setAttribute("message", "请正确输入用户名！");
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
    if(s == null)
    {
        return null;
    }
    i = s.lastIndexOf('.') + 1;
    j = s.length();
    s1 = s.substring(i,j);
    if(s.lastIndexOf('.') > 0)
    {
        return s1;
    }
    else
    {
        return "";
    }
}

private String getContentType(String s)
{
    String s1 = ""; // = new String();
    String s2 = ""; // = new String();
    int i = 0;
    //boolean flag = false;
    s1 = "Content-Type:";
    i = s.indexOf(s1) + s1.length();
    if(i != -1)
    {
        int j = s.length();
        s2 = s.substring(i,j);
    }
    return s2;
}

private String getTypeMIME(String s)
{
    //String s1 = new String();
    int i = 0;
    i = s.indexOf("/");
    if(i != -1)
    {
        return s.substring(1,i);
    }
    else
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
    m_response.setContentLength(abyte0.length);
    if(s2 == null)
    {
        m_response.setHeader("Content-Disposition","attachment;");
    }
    else
    {
        if(s2.length() == 0)
        {
            m_response.setHeader("Content-Disposition","attachment;");
        }
        else
        {
            m_response.setHeader("Content-Disposition","attachment; filename=" + s2);
        }
    }
    m_response.getOutputStream().write(abyte0,0,abyte0.length);
}

public void fieldToFile(ResultSet resultset,String s,String s1) throws ServletException,IOException,SmartUploadException,SQLException
{
    try
    {
        if(m_application.getRealPath(s1) != null)
        {
            s1 = m_application.getRealPath(s1);
        }
        InputStream inputstream = resultset.getBinaryStream(s);
        FileOutputStream fileoutputstream = new FileOutputStream(s1);
        int i;
        while((i = inputstream.read()) != -1)
        {
            fileoutputstream.write(i);
        }
        fileoutputstream.close();
    }
    catch(Exception exception)
    {
        throw new SmartUploadException("Unable to save file from the DataBase (1020).");
    }
}

private String getDataFieldValue(String s,String s1)
{
    String s2 = ""; // = new String();
    String s3 = ""; // = new String();
    int i = 0;
    //boolean flag = false;
    //boolean flag1 = false;
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
 *
 * 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);
	String sysdir = new SystemBean().getDir();
	HttpSession session = request.getSession();
	try{
		String username2 = (String)session.getAttribute("user");
		if(username2 == null){
			request.getRequestDispatcher("error.jsp").forward(request, response);
		}
		else{
			AfficheBean afficheBean = new AfficheBean();
			String method = request.getParameter("method").trim();
			if(method.equals("addAffiche")){//增加公告
				String title = Filter.escapeHTMLTags(request.getParameter("title").trim());
				String content = Filter.escapeHTMLTags(request.getParameter("content").trim());
				String adder = username2;
				String ifhide = Filter.escapeHTMLTags(request.getParameter("ifhide").trim());
				int flag = afficheBean.addAffiche(title, content, adder, ifhide);
				if(flag == Constant.SUCCESS){
					request.setAttribute("message", "操作成功！");
					request.getRequestDispatcher(sysdir+"/affiche/index.jsp").forward(request, response);
				}
				else{
					request.setAttribute("message", "系统维护中请稍后再试！");
					request.getRequestDispatcher(sysdir+"/affiche/index.jsp").forward(request, response);
				}
			}
			else if(method.equals("editAffiche")){//修改公告
				String id=Filter.escapeHTMLTags(request.getParameter("id").trim());
				String title = Filter.escapeHTMLTags(request.getParameter("title").trim());
				String content = Filter.escapeHTMLTags(request.getParameter("content").trim());
				String adder = username2;

项目链接：
https://javayms.github.io?id=032123543110201gh
https://javayms.pages.dev?id=032123543110201gh