本文實例為大家分享了java就業信息管理平臺開發案例，供大家參考，具體內容如下
可查詢公司信息，學生信息，班級信息，針對學生就業與否信息的統計，老師和管理員登錄后的權限不同等
就業信息管理平臺想要實現的是各個班級的學生就業情況，數據庫里建有6張表，分別是班級，公司，職位，學生，登錄用戶。
其中就業信息在界面上顯示的內容是學生信息和職位的組合，在jsp頁面中是拼接來實現，如果這個學生找到工作則需要填寫就業信息，否則空著。如就業截圖。
在企業信息中，需要實現的功能是首先有計劃招聘時間，實際招聘時間，每個都有老師，如果這個公司招聘結束，則要通過后面的編輯把實際招聘時間和實際招聘老師填寫上去，招聘狀態顯示為已結束；否則不填，招聘狀態為招聘中。還有兩個功能就是兩種查詢：一是根據招聘查詢，采用option下拉框中的選擇；而是根據公司名稱查詢，是在框中輸入公司關鍵字查詢，這里用到了like模糊查詢。而在就業信息中只用到了option下拉選擇中的根據班級名的查詢。
在班級信息只用到了輸入關鍵字的精確查詢。他們查詢到的統計信息都會根據每頁能夠顯示的條數進行分頁，尤其是下拉框選擇查詢，它們可能不只一條信息。
基礎信息里有班級信息和學生信息，學生信息顯示的是學生的基本信息。
個人信息里顯示的修改密碼和用戶信息，用戶信息的一個特點是管理員和普通教師的權限問題。普通教師登錄只能查看信息，但不能作任何修改。
所有基本信息都能實現增刪改查，其中作分頁查詢時遇到的難點還是有的——下拉選擇，此外就是分頁時用到的page.js文件，實現的是顯示第幾頁/共幾頁，首頁/上一頁/下一頁/尾頁。
還有就是權限問題，我是在數據庫中注冊登錄用戶時都有一個permission權限，填yes/no，然后在后面的程序中判斷出來。本項目唯一缺憾就是沒有實現導入導出功能，就是在就業信息欄右上角設置一個導入和導出按鈕，就是一個模板，導入實現的是批量輸入excel中的學生信息，導出實現的是把學生的就業情況導出excel表格形式。
1. addCompany_action.java
|
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
53
54
55
56
57
58
|
package com.ben.emp.action; import java.io.IOException;import java.text.ParseException;import java.text.SimpleDateFormat; import javax.servlet.ServletException;import javax.servlet.annotation.WebServlet;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import javax.servlet.http.HttpSession; import com.ben.emp.model.company;import com.ben.emp.model.user;import com.ben.emp.service.companyService;import com.ben.emp.service.impl.companyServiceImpl; @WebServlet("/addCompany.action")public class addCompany_action extends HttpServlet{ @Override protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException { req.getRequestDispatcher("/addCompany.jsp").forward(req, resp); } @Override protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException { String name = req.getParameter("name"); String introduce = req.getParameter("introduce"); String requirement = req.getParameter("requirement"); String address = req.getParameter("address"); String plantime = req.getParameter("plantime"); SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd"); companyService cs = new companyServiceImpl(); company com = new company(); HttpSession session = req.getSession(true); user user = (user) session.getAttribute("user"); com.setName(name); com.setIntroduce(introduce); com.setRequirement(requirement); com.setAddress(address); try { com.setPlantime(sdf.parse(plantime)); } catch (ParseException e) { // TODO Auto-generated catch block e.printStackTrace(); } com.setState("招聘中"); com.setTeach1(user.getName()); com.setTeach2(""); com.setId(0); cs.addCompany(com); resp.sendRedirect(req.getContextPath()+"/company.action"); }} |
2. editStudent_action.java
|
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
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
|
package com.ben.emp.action; import java.io.IOException;import java.text.ParseException;import java.text.SimpleDateFormat; import javax.servlet.ServletException;import javax.servlet.annotation.WebServlet;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse; import com.ben.emp.model.classes;import com.ben.emp.model.student;import com.ben.emp.service.classesService;import com.ben.emp.service.studentService;import com.ben.emp.service.impl.classesServiceImpl;import com.ben.emp.service.impl.studentServiceImpl; @WebServlet("/editStudent.action")public class editStudent_action extends HttpServlet{ @Override protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException { String strid = req.getParameter("id"); int studentId = Integer.valueOf(strid); studentService ss = new studentServiceImpl(); student stu = ss.getStudentById(studentId); req.setAttribute("stu", stu); req.getRequestDispatcher("/editStudent.jsp").forward(req, resp); } @Override protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException { String strid = req.getParameter("id"); int studentId = Integer.valueOf(strid); String name = req.getParameter("studentname"); String sex = req.getParameter("sex"); String school = req.getParameter("school"); String major = req.getParameter("major"); String bytime = req.getParameter("bytime"); SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd"); String tel = req.getParameter("telephone"); String qq = req.getParameter("qq"); studentService ss = new studentServiceImpl(); student stu = new student();// HttpSession session = req.getSession(true); // user user = (user)session.getAttribute("user"); String classname = req.getParameter("selectclass"); classesService cs = new classesServiceImpl(); classes cla = cs.getClassesByName(classname); stu.setName(name); stu.setSex(sex); stu.setSchool(school); stu.setMajor(major); try { stu.setBytime(sdf.parse(bytime)); } catch (ParseException e) { // TODO Auto-generated catch block e.printStackTrace(); } stu.setTel(tel); stu.setQq(qq); stu.setClassid(cla.getId()); stu.setId(studentId); ss.editStudent(stu); resp.sendRedirect(req.getContextPath()+"/student.action"); } } |
3. employ_action.java
|
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
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
|
package com.ben.emp.action; import java.io.IOException;import java.util.ArrayList;import java.util.List; import javax.servlet.ServletException;import javax.servlet.annotation.WebServlet;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse; import com.ben.emp.model.classes;import com.ben.emp.model.info;import com.ben.emp.model.student;import com.ben.emp.service.classesService;import com.ben.emp.service.infoService;import com.ben.emp.service.studentService;import com.ben.emp.service.impl.classesServiceImpl;import com.ben.emp.service.impl.infoServiceImpl;import com.ben.emp.service.impl.studentServiceImpl; @WebServlet("/employ.action")public class employ_action extends HttpServlet{ @Override protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException { classesService cs = new classesServiceImpl(); List<classes> cla = cs.getClasses(); List<String> lst = new ArrayList<String>(); for(classes ele : cla){ String name = ele.getName(); lst.add(name); } studentService ss = new studentServiceImpl(); List<student> lstu = ss.getStudentPage(1, 10); infoService is = new infoServiceImpl(); //連接到就業信息表里 List<info> lin = new ArrayList<info>(); for(student ele : lstu){ info info = new info(); info = is.getInfoByStudentId(ele.getId()); lin.add(info); } List<student> count = ss.getStudentPage(1, Integer.MAX_VALUE); int number = count.size(); int page = number % 10 == 0 ? number / 10 : (number/10) + 1; req.setAttribute("lst", lst); req.setAttribute("value", "全部"); req.setAttribute("number", number); req.setAttribute("page", page); req.setAttribute("index", 1); req.setAttribute("list", lstu); req.setAttribute("lin", lin); req.getRequestDispatcher("/employ.jsp").forward(req, resp); } @Override protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException { String value = req.getParameter("select"); classesService cs = new classesServiceImpl(); List<classes> cla = cs.getClasses(); List<String> lst = new ArrayList<String>(); lst.add("全部"); for(classes ele : cla){ String name = ele.getName(); lst.add(name); } lst.remove(value); studentService ss = new studentServiceImpl(); infoService is = new infoServiceImpl(); //連接到就業信息表里 List<info> lin = new ArrayList<info>(); if(value.equals("全部")){ List<student> count = ss.getStudentPage(1, Integer.MAX_VALUE); int number = count.size(); int page = number % 10 == 0 ? number / 10 : (number/10) + 1; String strpageIndex = req.getParameter("pageIndex"); int index = Integer.valueOf(strpageIndex); List<student> lstu = ss.getStudentPage(index, 10); for(student ele : lstu){ info info = new info(); info = is.getInfoByStudentId(ele.getId()); lin.add(info); } req.setAttribute("number", number); req.setAttribute("page", page); req.setAttribute("index", index); req.setAttribute("list", lstu); req.setAttribute("lin", lin); }else{ List<student> count = ss.getStudentByClassName(value, 1, Integer.MAX_VALUE); int number = count.size(); int page = number % 10 == 0 ? number / 10 : (number/10) + 1; String strpageIndex = req.getParameter("pageIndex"); int index = Integer.valueOf(strpageIndex); List<student> lstu = ss.getStudentByClassName(value, index, 10); for(student ele : lstu){ info info = new info(); info = is.getInfoByStudentId(ele.getId()); lin.add(info); } req.setAttribute("number", number); req.setAttribute("page", page); req.setAttribute("index", index); req.setAttribute("list", lstu); req.setAttribute("lin", lin); } req.setAttribute("value", value); req.setAttribute("lst", lst); req.getRequestDispatcher("/employ.jsp").forward(req, resp); }} |
4. employ.jsp
|
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
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
|
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%><%@ include file="base.jsp" %><%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %><%@ taglib prefix="fmt" uri="http://java.sun.com/jsp/jstl/fmt" %><!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"><html><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8"><title>無標題文檔</title><link href="css/style.css" rel="stylesheet" type="text/css" /><script type="text/javascript" src="js/jquery.js"></script><!-- 自己加的一行 jquery.js --><script type="text/javascript" src="js/jquery-1.11.0.min.js"></script><script type="text/javascript" src="js/page.js"></script><script type="text/javascript">$(function(){ $("select").change(function(){ $("#pageIndex").val(1); $("form").submit(); }); $(".pg").click(subfun);});function subfun(){ var id = $(this).attr("id"); var value = $("#pageIndex").val(); var count = $("#pageCount").val(); if(id == "first"){ $("#pageIndex").val(1); $("form").submit(); }else if(id == "previous"){ if(Number(value) == 1){ return false; }else{ $("#pageIndex").val(Number(value)-1); $("form").submit(); } }else if(id == "next"){ if(value == count){ return false; }else{ $("#pageIndex").val(Number(value)+1); $("form").submit(); } }else{ $("#pageIndex").val(count); $("form").submit(); } return false;//阻止a標簽的網頁跳轉的功能}</script></head><body> <div class="place"> <span>位置：</span> <ul class="placeul"> <li><a href="#">首頁</a></li> <li><a href="#">就業信息</a></li> </ul> </div> <form action="employ.action" method="post"> <div class="rightinfo"> <div class="tools"> <ul class="toolbar"> <li><span>班級名稱： <select style="border:1px solid #056dae" id="select" name="select"> <option>${requestScope.value }</option> <c:forEach items="${requestScope.lst }" var="ele"> <option>${ele }</option> </c:forEach> </select> </span></li> </ul> <ul class="toolbar1"> <li><span><img src="images/t05.png" /></span>下載</li> </ul> </div> <table class="imgtable"> <thead> <tr> <th width="100px;">姓名</th> <th>性別</th> <th>畢業院校</th> <th>專業</th> <th>畢業時間</th> <th>電話</th> <th>就業單位</th> <th>職位</th> <th>工資</th> <th>就業時間</th> </tr> </thead> <tbody> <c:forEach items="${requestScope.list }" var="stu" varStatus="s"> <tr> <td class="imgtd">${stu.name }</td> <td>${stu.sex }</td> <td>${stu.school }</td> <td>${stu.major }</td> <td>${stu.bytime }</td> <td>${stu.tel }</td> <c:if test="${requestScope.lin[s.index] == null }" > <td colspan="4" style="text-align:center;"><a href="addInfo.action?id=${stu.id }">填寫就業信息</a></td> </c:if> <c:if test="${requestScope.lin[s.index] != null }"> <td>${requestScope.lin[s.index].companyname }</td> <td>${requestScope.lin[s.index].post }</td> <td>${requestScope.lin[s.index].salary }</td> <td>${requestScope.lin[s.index].worktime }</td> </c:if> </tr> </c:forEach> </tbody> </table> <input type="hidden" name="pageIndex" id="pageIndex" value="${requestScope.index }"> <input type="hidden" name="pageCount" id="pageCount" value="${requestScope.page }"> <input type="hidden" name="pageNumber" id="pageNumber" value="${requestScope.number }"> <div class="pagin" id="page"> <div class="message">共<i class="blue"> ${requestScope.number } </i>條記錄，共<i class="blue"> ${requestScope.page }</i> 頁，當前顯示第 <i class="blue">${requestScope.index } </i>頁</div> <ul class="paginList"> <li class="paginItem"><a href="javascript:;" class="paginItem" id="first"><span class="pagepre"></span></a></li> <li class="paginItem"><a href="javascript:;" class="paginItem" id="previous">上一頁</a></li> <li class="paginItem"><a href="javascript:;" class="paginItem" id="next">下一頁</a></li> <li class="paginItem"><a href="javascript:;" class="paginItem" id="last"><span class="pagenxt"></span></a></li> </ul> </div> </div> </form></body></html> |
5. page.js
|
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
|
$(function(){ $(".paginItem").click(subfun);});function subfun(){ //必須要知道我獲取的是哪一個class,我點的是哪一個a標簽 var id = $(this).attr("id"); var value = $("#pageIndex").val(); //獲取當前頁 var count = $("#pageCount").val(); //獲取尾頁 if(id == "first"){ $("#pageIndex").val(1); //將pageIndex當前頁 $("form").submit(); //通過a標簽進行表單提交 }else if(id == "previous"){ //判斷 本頁是否為首頁 如果為首頁 如果部位首頁的話 判斷當前頁是否為1 ==1首頁 !=1 不是首頁 if(Number(value) == 1){ return false; }else{ $("#pageIndex").val(Number(value)-1); $("form").submit(); } }else if(id == "next"){ //判斷當前頁是否為尾頁 尾頁如何判斷 計算尾頁 計算數據庫的總條數 / 每頁顯示多少條 結果是否+1 if(value == count){ return false; }else{ $("#pageIndex").val(Number(value)+1); $("form").submit(); } }else{ $("#pageIndex").val(count); $("form").submit(); } return false; //阻止a標簽的網頁跳轉的功能} |
效果圖：
以上就是本文的全部內容，希望對大家的學習有所幫助。
