PViewMode.jsp
<%@page contentType="text/html"%>
<%@page pageEncoding="UTF-8"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<%@ page language="java" import="java.sql.*"%>
<html> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <title>Product View Mode</title>
<SCRIPT LANGUAGE="JAVASCRIPT">
<!--
function valid(form)
{
var field1=form.EditProduct;
EditProduct=field1.value;
if(EditProduct.length==0)
{
alert("The Product Descrition Field Cannot Be Left Blank");
field1.focus();
return false;
}
}
//-->
</SCRIPT> </head>
<body>
<%
Connection con=null;
Statement s=null;
ResultSet rs=null;
String ViewModeSelected=request.getParameter("ViewMode");
ViewModeSelected=ViewModeSelected.trim();
%>
<div style="position: absolute; width: 997; height: 178; z-index: 1; left:0px; top: 36px; right: 2; bottom:1024" id="layer4">
<div style="position: absolute; width: 181; height: 31; z-index: 1; left: 10px; top: -33px" id="layer1">
<img border="0" src="images/logo5.GIF" width="181" height="31"></div>
<img border="0" src="images/contacttop-img.jpg" width="997" height="178"></div>
<div style="position: absolute; width: 831px; height: 325px; z-index: 2; left: 166px; top: 225px" id="layer6">
<img border="0" src="images/bkg.gif" width="831" height="325"></div>
<div style="position: absolute; width: 831px; height: 19px; z-index: 3; left: 166px; top: 558px" id="layer7">
<div style="position: absolute; width: 148px; height: 219px; z-index: 1; left: -163px; top: -301px;right: 2" id="layer5">
<!-- Begin Free-Web-Buttons.com -->
<style>#web-buttons-idhyzy6 a{display:block;color:transparent;} #web-buttons-idhyzy6 a:hover{background-position:left bottom;}a#web-buttons-idhyzy6a {display:none}</style>
<table id="web-buttons-idhyzy6" width=0 cellpadding=0 cellspacing=0 border=0>
<tr><td style="padding-bottom:15px" title ="Home">
<a href="AdminHome.jsp" title="Home" style="background-image:url(images/bthyzy6.png);width:153px;height:25px;display:block;"><br/></a></td></tr>
<tr><td style="padding-bottom:15px" title ="Products">
<a href="ProductList.jsp" title="Products" style="background-image:url(images/btjyzy6.png);width:153px;height:25px;display:block;"><br/></a></td></tr>
<tr><td style="padding-bottom:15px" title ="Contact Us">
<a href="ContactUs.jsp" title="Contact Us" style="background-image:url(images/btkyzy6.png);width:153px;height:25px;display:block;"><br/></a></td></tr>
<tr><td style="padding-bottom:15px" title ="About Us">
<a href="AboutUs.jsp" title="About Us" style="background-image:url(images/btgyzy6.png);width:153px;height:25px;display:block;"><br/></a></td></tr>
<tr><td style="padding-bottom:15px" title ="Add">
<a href="PAdd.jsp" title="Add" style="background-image:url(images/bt5xzy6.png);width:153px;height:25px;display:block;"></a></td></tr>
</table></div>
<div style="position: absolute; width: 361px; height: 18px; z-index: 1; left: 194px; top: 20px" id="layer8" align="center"><font size="3">Copyright © SureVac Call Management, 2009. All Rights Reserved.</font></div><p><img border="0" src="images/bg_footer.gif" width="832" height="32"></div>
<div style="position: absolute; left: 889px; top: 13px; width: 97px; height: 18px; z-index: 4" id="layer2">
<a href="AdminHome.jsp">Home</a>
<a href="PView.jsp">Back</a><div style="position: absolute; width: 1; height: 18; z-index: 1; left: 35px; top: 0px" id="layer3"><img border="0" src="images/htc.gif" width="1" height="18"></div></div>
<%
if(ViewModeSelected.equals("ListAll"))
{
%>
<div style="position: absolute; left: 476px; top: 261px; width: 500; height: 255; z-index: 6; border: 3px groove #0000FF" id="layer10">
<img border="0" src="images/445.jpg" width="500" height="255"></div>
<div style="position: absolute; left: 205px; top: 344px; width: 272px; height: 19px; z-index: 5" id="layer9">
<b><font color="#0000FF" size="4" face="Calibri">To view all the products
use the following link.</font></b><p><b>
<font color="#0000FF" size="4" face="Calibri"><a href="ProductList.jsp">
ListAll</a></font></b></div>
<%
}
else if(ViewModeSelected.equals("Delete"))
{
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
// con=DriverManager.getConnection("jdbc:odbc:ds","sa","niit");
con=DriverManager.getConnection("jdbc:odbc:SureVacCallDS","sa","P@ssw0rd");
s=con.createStatement();
rs=s.executeQuery("Select code from Product");
%>
<form method="post" action="PDelete.jsp">
<div style="position: absolute; left: 723px; top: 296px; width: 150; height: 150; z-index: 7; border: 3px groove #0000FF" id="layer10">
<img border="0" src="images/error.jpg" width="150" height="150"></div>
<div style="position: absolute; left: 261px; top: 300px; width: 387px; height: 25px; z-index: 5" id="layer9">
<table border="0" width="100%">
<tr>
<td width="232" align="center"><b><font size="4" face="Calibri" color="#0000FF">
To delete a product select any one from the drop down list.</font></b></td>
<td width="145" align="center">
<p> </p>
<p><select option name="ProdId">
<%
while(rs.next())
{
%>
<option><%=rs.getString(1)%></option>
<%
}
%>
</select></p>
<p> </td>
</tr>
<tr>
<td width="232" height="48" align="center">
<input type="submit" value="Submit" name="submit">
<input type="reset" value="Reset" name="reset"></td>
<td width="145" height="48" align="center"> </td>
</tr></table></div>
<%
}
catch(Exception e)
{
out.println("There are some invalid data::: "+"\n"+e);
}
finally
{
con.close();
}
%>
</form>
<%
}
else if(ViewModeSelected.equals("Edit"))
{
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
// con=DriverManager.getConnection("jdbc:odbc:ds","sa","niit");
con=DriverManager.getConnection("jdbc:odbc:SureVacCallDS","sa","P@ssw0rd");
s=con.createStatement();
rs=s.executeQuery("Select code from Product");
%>
<form onsubmit="return valid(this)" method="post" action="PEdit.jsp">
<div style="position: absolute; left: 827px; top: 308px; width: 115; height: 116; z-index: 7; border: 3px groove #0000FF" id="layer10">
<img border="0" src="images/CAV9SKQC.jpg" width="115" height="116"></div>
<div style="position: absolute; left: 241px; top: 315px; width: 498px; height: 25px; z-index: 5" id="layer9">
<table border="0" width="500" height="116">
<tr>
<td width="494" align="center" height="55"><b><font size="4" face="Calibri" color="#0000FF">
To edit a product select any one from the drop down list.</font></b></td>
</tr>
<tr>
<td width="494" height="55" align="center">
<p><select option name="ProdId">
<%
while(rs.next())
{
%>
<option><%=rs.getString(1)%></option>
<%
}
%>
</select>
<input type="text" name="EditProduct">
<input type="Submit" value="SAVE" name="Submit">
<input type="reset" name="Cancel" value="CANCEL"></p>
</td>
</tr>
</table>
</div>
<%
}
catch(Exception e)
{
out.println("There are some invalid data::: "+"\n"+e);
}
finally
{
con.close();
}
%>
</form>
<%
}
else
{
%>
<div style="position: absolute; left: 476px; top: 261px; width: 500; height: 255; z-index: 6; border: 3px groove #0000FF" id="layer10">
<img border="0" src="images/445.jpg" width="500" height="255"></div>
<div style="position: absolute; left: 205px; top: 344px; width: 272px; height: 19px; z-index: 5" id="layer9">
<b><font color="#0000FF" size="4" face="Calibri">To view all the products
use the following link.</font></b><p><b>
<font color="#0000FF" size="4" face="Calibri"><a href="ProductList.jsp">
ListAll</a></font></b></div>
<%
}
%>
</body>
</html>
No comments:
Post a Comment