?? empsearch1.jsp
字號:
<%@ page import="javax.servlet.http.*,java.sql.*,javax.servlet.*,dbconnection.DBConnection" %>
<head>
<title>Enterprise Resource Information System</title>
</head>
<body>
<form action="">
<div style="background-color: #C0C0C0">
<p align="center"><b>Enterprise Resource Information System</b></p></div>
<p align="center">EMPLOYEE SEARCH</p>
<%
DBConnection db= new DBConnection();
ResultSet rs=db.executeQuery("select employeeid from employeedetails ");
%>
<p align=center> Employee ID <select size="1" name="empid"><br>
<option>Select Employee ID</option></p>
<%
while(rs.next())
{
%>
<br><br>
<option> <%=rs.getInt(1)%> </option></p>
<%
}
%>
</select>
<input type="submit" value="VIEW" name="B3">
<br><br>
<table border="1" cellspacing="2" style="border-collapse: collapse" bordercolor="#brown" width="100%" id="AutoNumber1">
<tr>
<td width="16%">Employee ID</td>
<td width="16%">
<p align="center">Name</td>
<td width="17%">
<p align="center">Role</td>
<td width="17%">
<p align="center">Phone</td>
<td width="17%">
<p align="center">e-mail</td>
<td width="17%"> Client ID</td>
</tr>
<%
String s=request.getParameter("empid");
if (s!=null)
{
ResultSet rs1=db.executeQuery("select employeeid,firstname,role,mobileno,email,clientid from employeedetails where employeeid=' "+ s +" ' ");
if(rs1.next())
{
%>
<tr>
<td width="16%"><%=request.getParameter("empid")%> </td>
<td width="16%"><%=rs1.getString(2)%> </td>
<td width="17%"><%=rs1.getString(3)%> </td>
<td width="17%"><%=rs1.getString(4)%> </td>
<td width="17%"><%=rs1.getString(5)%> </td>
<td width="17%"><%=rs1.getString(6)%> </td>
</tr>
<%
}
}
%>
</table>
<p align="center"><a href="recruit.htm">BACK</a></p>
</form>
</body>
</html>?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -