Leave employee edit2?wtf?
Other Answers:
// Itypeview <%@ page import="java.sql.*,java.util.*" %>
<html>
<SCRIPT language="javascript">
function show()
{
f1.submit();
}
</SCRIPT>
<head>
<meta http-equiv="Content-Language" content="en-us">
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>New Page 1</title>
</head>
<body>
<%
String type=request.getParameter("ltype");
Class.forName("com.mysql.jdbc.Driver")...
Connection conn=DriverManager.getConnection("jdbc:m...
Statement state=conn.createStatement();
ResultSet rst=state.executeQuery("select * from leavetype");
%>
<%@ include file="include.jsp" %>
<p> </p>
<form method="POST" name="f1">
<p> ...? Select
Employee ID
<select size="1" name="ltype" onchange="show()">
<option selected>Select</option>
<% while(rst.next())
{%>
<option value=<%=rst.getString(1)%>><%=rst.getSt...
<%}%>
</select></p>
<div align="center">
<center>
<table border="1" style="border-collapse: collapse" bordercolor="#660033" cellpadding="0" cellspacing="0">
<tr> <td><b>Leave Type</b></td>
<td><b>Description</b></td>
</tr>
<p> </p>
<%
if(type!=null)
{
ResultSet rs=state.executeQuery("Select * from leavetype where ltype='"+type+"'");
while(rs.next())
{%>
<tr>
<td><%=rs.getString(1)%> </td>
<td><%=rs.getString(2)%> </td>
</tr>
<%}
}
%>
</table>
</center>
</div>
<p> </p>
<p> </p>
<p> </p>
</body>
</html>
0 коммент.:
Post a Comment