Java源码社

基于javaweb的JSP+Servlet机房管理系统机房维护与课程安排(java+servlet+mysql+jsp)

更新于

运行环境

Java≥8、MySQL≥5.7、Tomcat≥8

开发工具

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

适用

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

功能说明

402223162309

412223162309

422223162309

432223162309

442223162309

452223162309

462223162309

基于javaweb的JSP+Servlet机房管理系统机房维护与课程安排(java+servlet+mysql+jsp)

管理员：
admin 123456

老师：
老张 123456
老李 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
42
			jigui.setWeizhi(rs.getString("weizhi"));
			jigui.setGaodu(rs.getString("gaodu"));
			jigui.setKeyongkongjian(rs.getString("keyongkongjian"));
			jigui.setShebeishu(rs.getString("shebeishu"));
			jigui.setPeixianjiashu(rs.getString("peixianjiashu"));
			jigui.setQuanzhong(rs.getString("quanzhong"));
			jigui.setDel(rs.getString("del"));				
	    }
		rs.close();
	}catch(Exception e){
		e.printStackTrace();
	}
	mydb.closed();
	req.setAttribute("jigui", jigui);
	req.getRequestDispatcher("admin/jigui/jiguiEdit.jsp").forward(req, res);
}


public void jiguiMana(HttpServletRequest req,HttpServletResponse res) throws ServletException, IOException{
	List jiguiList=new ArrayList();
	String sql="select * from t_jigui where del='no'";
	Object[] params={};
	DB mydb=new DB();
	try
	{
		mydb.doPstm(sql, params);
		ResultSet rs=mydb.getRs();
		while(rs.next())
		{
			Tjigui jigui=new Tjigui();
			
			jigui.setId(rs.getInt("id"));
			jigui.setJiguiName(rs.getString("jiguiName"));
			jigui.setSuoshujifang(rs.getString("suoshujifang"));
			jigui.setWeizhi(rs.getString("weizhi"));
			jigui.setGaodu(rs.getString("gaodu"));
			jigui.setKeyongkongjian(rs.getString("keyongkongjian"));
			jigui.setShebeishu(rs.getString("shebeishu"));
			jigui.setPeixianjiashu(rs.getString("peixianjiashu"));
			jigui.setQuanzhong(rs.getString("quanzhong"));
			jigui.setDel(rs.getString("del"));				
			jiguiList.add(jigui);
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
51
52
            kecheng.setDel(rs.getString("del"));
            kechengList.add(kecheng);
        }
        rs.close();
    } catch (Exception e) {
        e.printStackTrace();
    }
    mydb.closed();

    req.setAttribute("kechengList", kechengList);
    req.getRequestDispatcher("admin/kecheng/kechengMana.jsp").forward(req, res);
}

public void kechengAll(HttpServletRequest req, HttpServletResponse res) throws ServletException, IOException {
    List kechengList = new ArrayList();
    String sql = "select * from t_kecheng where del='no'";
    Object[] params = {};
    DB mydb = new DB();
    try {
        mydb.doPstm(sql, params);
        ResultSet rs = mydb.getRs();
        while (rs.next()) {
            Tkecheng kecheng = new Tkecheng();
            kecheng.setId(rs.getInt("id"));
            kecheng.setBianhao(rs.getString("bianhao"));
            kecheng.setMingcheng(rs.getString("mingcheng"));
            kecheng.setKeshi(rs.getString("keshi"));
            kecheng.setDel(rs.getString("del"));
            kechengList.add(kecheng);
        }
        rs.close();
    } catch (Exception e) {
        e.printStackTrace();
    }
    mydb.closed();

    req.setAttribute("kechengList", kechengList);
    req.getRequestDispatcher("admin/kecheng/kechengAll.jsp").forward(req, res);
}


public void dispatch(String targetURI, HttpServletRequest request, HttpServletResponse response) {
    RequestDispatcher dispatch = getServletContext().getRequestDispatcher(targetURI);
    try {
        dispatch.forward(request, response);
        return;
    } catch (ServletException e) {
        e.printStackTrace();
    } catch (IOException e) {

        e.printStackTrace();
    }
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
	List jifangList=new ArrayList();
	String sql="select * from t_jifang where del='no'";
	Object[] params={};
	DB mydb=new DB();
	try
	{
		mydb.doPstm(sql, params);
		ResultSet rs=mydb.getRs();
		while(rs.next())
		{
			Tjifang jifang=new Tjifang();

			jifang.setId(rs.getInt("id"));
			jifang.setFangjianhao(rs.getString("fangjianhao"));
			jifang.setRenshu(rs.getInt("renshu"));
			jifang.setJieshao(rs.getString("jieshao"));
			jifang.setDel(rs.getString("del"));
			
			jifangList.add(jifang);
	    }
		rs.close();
	}
	catch(Exception e)
	{
		e.printStackTrace();
	}
	mydb.closed();
	
	req.setAttribute("jifangList", jifangList);
	req.getRequestDispatcher("admin/jifang/jifangAll.jsp").forward(req, res);
	 return;
}


public void dispatch(String targetURI,HttpServletRequest request,HttpServletResponse response) 
{
	RequestDispatcher dispatch = getServletContext().getRequestDispatcher(targetURI);
	try 
	{
	    dispatch.forward(request, response);
	    return;
	} 
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
51
	if(type.endsWith("devchangeDel")){
		devchangeDel(req, res);
	}	
	if(type.endsWith("getshebeiList")){
		getshebeiList(req, res);
	
	}	
}

public void getshebeiList(HttpServletRequest req,HttpServletResponse res) throws ServletException, IOException{
	List<Tshebei> shebeiList=new ArrayList<Tshebei>();
	String sql="select * from t_shebei where del='no'";
	Object[] params={};
	DB mydb=new DB();
	try{
		mydb.doPstm(sql, params);
		ResultSet rs=mydb.getRs();
		while(rs.next()){
			Tshebei shebei = new Tshebei();
			shebei.setId(rs.getInt("id"));
			shebei.setSuoshujigui(rs.getString("suoshujigui"));
			shebei.setSuoshujifang(rs.getString("suoshujifang"));
			shebei.setShiyongzhe(rs.getString("shiyongzhe"));
			shebei.setShebeiming(rs.getString("shebeiming"));
			shebei.setIp(rs.getString("ip"));
			shebei.setDianhua(rs.getString("dianhua"));
			shebei.setDel(rs.getString("del"));
			shebeiList.add(shebei);
	    }
		rs.close();
	}
	catch(Exception e){
		e.printStackTrace();
	}
	mydb.closed();
	
	req.setAttribute("shebeiList", shebeiList);
     req.getRequestDispatcher("admin/shebei/devchangeAdd.jsp").forward(req, res);
	//res.sendRedirect("admin/shebei/devchangeAdd.jsp");
     return;
}



public void devchangeDel(HttpServletRequest req,HttpServletResponse res){
	String sql="update t_devchange set del='yes' where id="+Integer.parseInt(req.getParameter("id"));
	Object[] params={};
	DB mydb=new DB();
	mydb.doPstm(sql, params);
	mydb.closed();
	
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
    try {
        mydb.doPstm(sql, params);
        ResultSet rs = mydb.getRs();
        while (rs.next()) {
            Tjifang jifang = new Tjifang();

            jifang.setId(rs.getInt("id"));
            jifang.setFangjianhao(rs.getString("fangjianhao"));
            jifang.setRenshu(rs.getInt("renshu"));
            jifang.setJieshao(rs.getString("jieshao"));
            jifang.setDel(rs.getString("del"));

            jifangList.add(jifang);
        }
        session.setAttribute("jifangList",jifangList);
        rs.close();
    } catch (Exception e) {
        e.printStackTrace();
    }
    mydb.closed();
} catch (Exception e) {
    e.printStackTrace();
}


try {
    List kechengList = new ArrayList();
    String sql = "select * from t_kecheng where del='no'";
    Object[] params = {};
    DB mydb = new DB();
    try {
        mydb.doPstm(sql, params);
        ResultSet rs = mydb.getRs();
        while (rs.next()) {
            Tkecheng kecheng = new Tkecheng();
            kecheng.setId(rs.getInt("id"));
            kecheng.setBianhao(rs.getString("bianhao"));
            kecheng.setMingcheng(rs.getString("mingcheng"));
            kecheng.setKeshi(rs.getString("keshi"));
            kecheng.setDel(rs.getString("del"));
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
		DB mydb=new DB();
		mydb.doPstm(sql, params);
		mydb.closed();
		
		req.setAttribute("message", "操作成功");
		req.setAttribute("path", "admin?type=adminMana");
		
        String targetURL = "/common/success.jsp";
		dispatch(targetURL, req, res);
	}

	public void dispatch(String targetURI,HttpServletRequest request,HttpServletResponse response) 
	{
		RequestDispatcher dispatch = getServletContext().getRequestDispatcher(targetURI);
		try 
		{
		    dispatch.forward(request, response);
		    return;
		} 
		catch (ServletException e) 
		{
                    e.printStackTrace();
		} 
		catch (IOException e) 
		{
			
		    e.printStackTrace();
		}
	}
	public void init(ServletConfig config) throws ServletException 
	{
		super.init(config);
	}
	
	public void destroy() 
	{
		
	}
}

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