📄 viewall.jsp
字号:
<html>
<head>
<title></title>
</head>
<body bgcolor="#FFFFFF" text="#000000">
<%
java.util.List allList = null;
java.util.List compempsList = null;
java.util.List emptaskList = null;
if(request.getAttribute("allList") != null) allList = (java.util.List)request.getAttribute("allList");
if(request.getAttribute("compempsList") != null) compempsList = (java.util.List)request.getAttribute("compempsList");
if(request.getAttribute("emptaskList") != null) emptaskList = (java.util.List)request.getAttribute("emptaskList");
java.util.List compsList = (java.util.List)allList.get(0);
java.util.List empsList = (java.util.List)allList.get(1);
java.util.List tasksList = (java.util.List)allList.get(2);
%>
<%
if(request.getAttribute("msg") != null) {
%>
<table align="center" bgcolor="black">
<tr>
<td bgcolor="white"><%= (String)request.getAttribute("msg") %></td>
</tr>
</table>
<br>
<%
}
%>
<hr>
Inserted records
<br>
<table align="center">
<tr>
<td valign="top">
<form method="post" action="ActionServlet">
<input type="hidden" name="action" value="deletecomp">
<table border="1">
<tr>
<td bgcolor="black" align="center" colspan="5"><font color="white">company</font></td>
</tr>
<tr>
<td bgcolor="black"> </td>
<td bgcolor="black"><font color="white">name</font></td>
<td bgcolor="black"><font color="white">country</font></td>
<td bgcolor="black"><font color="white">address</font></td>
<td bgcolor="black"><font color="white">phone</font></td>
</tr>
<%
if(compsList.size() > 0) {
for(int i = 0;i < compsList.size();i+=4) {
%>
<tr>
<td bgcolor="white"><input type="radio" name="comptodel" value="<%= compsList.get(i) %>"></td>
<td><%= compsList.get(i) %></td>
<td><%= compsList.get(i+1) %></td>
<td><%= compsList.get(i+2) %></td>
<td><%= compsList.get(i+3) %></td>
</tr>
<%
}
}
%>
<tr>
<td colspan="5" bgcolor="white"><input type="submit" value="delete"></td>
</tr>
</table>
</form>
</td>
<td valign="top">
<form method="post" action="ActionServlet">
<input type="hidden" name="action" value="deleteemp">
<table border="1">
<tr>
<td bgcolor="black" align="center" colspan="4"><font color="white">employee</font></td>
</tr>
<tr>
<td bgcolor="black"> </td>
<td bgcolor="black"><font color="white">name</font></td>
<td bgcolor="black"><font color="white">surname</font></td>
<td bgcolor="black"><font color="white">phone</font></td>
</tr>
<%
if(empsList.size() > 0) {
for(int i = 0;i < empsList.size();i+=3) {
%>
<tr>
<td bgcolor="white"><input type="radio" name="emptodel" value="<%= empsList.get(i) %>"></td>
<td><%= empsList.get(i) %></td>
<td><%= empsList.get(i+1) %></td>
<td><%= empsList.get(i+2) %></td>
</tr>
<%
}
}
%>
<tr>
<td colspan="4" bgcolor="white"><input type="submit" value="delete"></td>
</tr>
</table>
</form>
</td>
<td valign="top">
<form method="post" action="ActionServlet">
<input type="hidden" name="action" value="deletetask">
<table border="1">
<tr>
<td colspan="2" bgcolor="black" align="center"><font color="white">task</font></td>
</tr>
<tr>
<td colspan="2" bgcolor="black"><font color="white">name</font></td>
</tr>
<%
if(tasksList.size() > 0) {
for(int i = 0;i < tasksList.size();i++) {
%>
<tr>
<td bgcolor="white"><input type="radio" name="tasktodel" value="<%= tasksList.get(i) %>"></td>
<td><%= tasksList.get(i) %></td>
</tr>
<%
}
}
%>
<tr>
<td colspan="2" bgcolor="white"><input type="submit" value="delete"></td>
</tr>
</table>
</form>
</td>
</tr>
</table>
<br>
<hr>
Existing associations
<br>
<table align="center">
<tr>
<td valign="top">
<form method="post" action="ActionServlet">
<input type="hidden" name="action" value="deletecompemp">
<table border="1">
<tr>
<td bgcolor="black" align="center" colspan="5"><font color="white">company-employees associations</font></td>
</tr>
<tr>
<td bgcolor="black"> </td>
<td bgcolor="black"><font color="white">company</font></td>
<td bgcolor="black"><font color="white">employee</font></td>
</tr>
<%
if(compempsList.size() > 0) {
for(int i = 0;i < compempsList.size();i+=2) {
%>
<tr>
<td bgcolor="white"><input type="radio" name="compemptodel" value="<%= compempsList.get(i) %>"></td>
<td><%= compempsList.get(i+1) %></td>
<td><%= compempsList.get(i) %></td>
</tr>
<%
}
}
%>
<tr>
<td bgcolor="white" colspan="5"><input type="submit" value="delete"></td>
</tr>
</table>
</form>
</td>
<td valign="top">
 
</td>
<td valign="top">
<form method="post" action="ActionServlet">
<input type="hidden" name="action" value="deleteemptask">
<table border="1">
<tr>
<td bgcolor="black" align="center" colspan="5"><font color="white">employee-task associations</font></td>
</tr>
<tr>
<td bgcolor="black"> </td>
<td bgcolor="black"><font color="white">employee</font></td>
<td bgcolor="black"><font color="white">task</font></td>
</tr>
<%
if(emptaskList.size() > 0) {
for(int i = 0;i < emptaskList.size();i+=2) {
%>
<tr>
<td bgcolor="white"><input type="radio" name="emptasktodel" value="<%= emptaskList.get(i)+";"+emptaskList.get(i+1) %>"></td>
<td><%= emptaskList.get(i) %></td>
<td><%= emptaskList.get(i+1) %></td>
</tr>
<%
}
}
%>
<tr>
<td bgcolor="white" colspan="5"><input type="submit" value="delete"></td>
</tr>
</table>
</form>
</td>
</tr>
</table>
<br>
<hr>
Create new associations
<br>
<table align="center">
<tr>
<td valign="top">
<form method="post" action="ActionServlet">
<input type="hidden" name="action" value="associatecompemp">
<table border="1">
<tr>
<td bgcolor="black"><font color="white">company</font></td>
<td bgcolor="black"><font color="white">employee</font></td>
</tr>
<tr>
<td>
<select name="compforemp">
<option selected value="">-
<%
if(compsList.size() > 0) {
for(int i = 0;i < compsList.size();i+=4) {
%>
<option value="<%= compsList.get(i) %>"><%= compsList.get(i) %>
<%
}
}
%>
</select>
</td>
<td>
<select name="empforcomp">
<option selected value="">-
<%
if(empsList.size() > 0) {
for(int i = 0;i < empsList.size();i+=3) {
%>
<option value="<%= empsList.get(i) %>"><%= empsList.get(i) %>
<%
}
}
%>
</select>
</td>
</tr>
<tr>
<td colspan="2" bgcolor="black"><input type="submit" value="submit"></td>
</tr>
</table>
</form>
</td>
<td valign="top">
 
</td>
<td valign="top">
<form method="post" action="ActionServlet">
<input type="hidden" name="action" value="associateemptask">
<table border="1">
<tr>
<td bgcolor="black"><font color="white">employee</font></td>
<td bgcolor="black"><font color="white">task</font></td>
</tr>
<tr>
<td>
<select name="empfortask">
<option selected value="">-
<%
if(empsList.size() > 0) {
for(int i = 0;i < empsList.size();i+=3) {
%>
<option value="<%= empsList.get(i) %>"><%= empsList.get(i) %>
<%
}
}
%>
</td>
<td>
<select name="taskforemp">
<option selected value="">-
<%
if(tasksList.size() > 0) {
for(int i = 0;i < tasksList.size();i++) {
%>
<option value="<%= tasksList.get(i) %>"><%= tasksList.get(i) %>
<%
}
}
%>
</td>
</tr>
<tr>
<td colspan="2" bgcolor="black"><input type="submit" value="submit"></td>
</tr>
</table>
</form>
</td>
</tr>
</table>
<br>
<table align="center" bgcolor="black">
<tr>
<td bgcolor="white"><a href="index.jsp">back</a></td>
</tr>
</table>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -