?? restleader.jsp
字號:
<%@ page language="java" import = "java.sql.*,java.util.*" contentType="text/html;charset=gb2312"%>
<jsp:useBean id="db" scope="page" class="opendb.opendb"/>
<html>
<head>
<title>個人請假查詢</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body background="/DSN/b.files/bj.gif">
<form id="S_form" name="S_form" method="post" action="restleader1.jsp" >
<table>
<tr>
<td bgcolor="#00FFFF">
<p align="center">人員姓名</p><td><input type=text name="personname" size="18" maxlength="20"></td>
<td><input type=submit value="查詢" name="add"></td>
</tr></table>
<%
String getpersonname=request.getParameter("personname");
String sql = "SELECT b.EMP_CODE,a.EMP_NAME,b.M_TIMES,b.M_STIME,b.M_ETIME,b.M_HOURS,b.M_CAUSE,b.M_TIME,M_NOTE FROM wglMESSAGE b left join wglPERSON a on a.EMP_CODE=b.EMP_CODE WHERE a.EMP_NAME like '"+"%"+getpersonname+"%"+"' order by M_TIME ASC";
ResultSet rs=db.executeQuery(sql);
%>
<table border=1 align="center" bordercolor="#008000">
<tr bgcolor="#99FFFF">
<td width="10%" height="16">
<p align="center">人員姓名</p></td>
<td width="10%" height="16">
<p align="center">開始時間</p></td>
<td width="10%" height="16">
<p align="center">結束時間</p></td>
<td width="5%" height="16">
<p align="center">小時數</p></td>
<td width="10%" height="16">
<p align="center">原因</p></td>
<td width="10%" height="16">
<p align="center">申請時間</p></td>
<td width="10%" height="16">
<p align="center">批示</p></td>
</tr>
<% while(rs.next())
{
String personname=rs.getString("EMP_NAME");
String Stime=rs.getString("M_STIME");
Stime=Stime.trim();
String Syear=Stime.substring(0,4);
String Smonth=Stime.substring(4,6);
String Sday=Stime.substring(6,8);
String Shour=Stime.substring(8,10);
String Sminute=Stime.substring(10,12);
String Etime=rs.getString("M_ETIME");
Etime=Etime.trim();
String Eyear=Etime.substring(0,4);
String Emonth=Etime.substring(4,6);
String Eday=Etime.substring(6,8);
String Ehour=Etime.substring(8,10);
String Eminute=Etime.substring(10,12);
int hours=rs.getInt("M_HOURS");
String cause=rs.getString("M_CAUSE");
String time=rs.getString("M_TIME");
String answer=rs.getString("M_NOTE");
%>
<tr>
<td width="10%" height="16" ><p align="center"><%=personname%></p></td>
<td width="10%" height="16" ><p align="center"><%=Syear %>-<%=Smonth %>/<%=Sday %>/<%=Shour %>:<%=Sminute %></p></td>
<td width="5%" height="16" ><p align="center"><%=Eyear %>-<%=Emonth %>/<%=Eday %>/<%=Ehour %>:<%=Eminute %></p></td>
<td width="10%" height="16" ><p align="center"><%=hours%></p></td>
<td width="10%" height="16" ><p align="center"><%=cause%></p></td>
<td width="10%" height="16" ><p align="center"><%=time%></p></td>
<td width="10%" height="16" ><p align="center"><%
if(answer!=null)
{ if(answer.equals("0"))
{out.print("有薪休假");}
if(answer.equals("1"))
{out.print("無薪休假");}
else
{out.print("無事故");}
}else
{out.print("未批示");}%></p></td>
</tr>
<%
}
%>
</table>
</form>
<p align="center"><a href="leaderBack.jsp">返回</a></p>
</body>
</html>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -