PAdd.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 Add</title>
<SCRIPT LANGUAGE="JAVASCRIPT">
<!--
function valid(form)
{
var field1=form.ProdId;
var field2=form.Descp;
ProdId=field1.value;
Descp=field2.value;
if(ProdId.length==0)
{
alert("The ProductId Field Cannot Be Left Blank");
field1.focus();
return false;
}
else if(Descp.length==0)
{
alert("The Description Field Cannot Be Left Blank");
field2.focus();
return false;
}
}
//-->
</SCRIPT>
</head>
<body>
<form onsubmit="return valid(this)" method="post" action="PAdded.jsp">
<div style="position: absolute; width: 997; height: 178; z-index: 1; left:0px; top: 36px; right: 2; bottom:1024" id="layer1">
<div style="position: absolute; width: 181; height: 31; z-index: 1; left: 10px; top: -33px" id="layer5">
<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: 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>
<br>
<div style="position: absolute; width: 357px; height: 153px; z-index: 4; left: 383px; top: 286px" id="layer9" align="center">
<%
Connection con=null;
Statement s;
ResultSet rs=null;
int ctr;
String code,codeval;
String finalcode;
String fcode;
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(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
rs=s.executeQuery("Select code from Product");
if(rs.last()==true)
{
code=rs.getString(1).toString();
codeval=code.substring(1,4);
ctr=Integer.parseInt(codeval);
if((ctr>=1)&&(ctr<9))
{
ctr=ctr+1;
finalcode="P00"+ctr;
fcode=finalcode;
%>
<div style="position: absolute; width: 102px; height: 24px; z-index: 4; left: 500px; top: -277px" id="layer13">
<p style="line-height: 200%; margin-top: 0; margin-bottom: 2px">
<a href="Home.jsp">Home</a>
<a href="Product.jsp">Back</a></div>
<div style="position: absolute; width: 148px; height: 217px; z-index: 1; left: -380px; top: -19px;right: 2" id="layer2">
<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 ="View">
<a href="PView.jsp" title="View" style="background-image:url(images/btmxzy6.png);width:153px;height:25px;display:block;"><br/></a></td></tr>
</table>
</div>
<div style="position: absolute; width: 1px; height: 18; z-index: 3; left: 559px; top: -271px" id="layer12">
<img border="0" src="images/htc.gif" width="1" height="18"></div>
<b><font face="Calibri" size="4" color="#0000CC">
<table width="346" height="151">
<tr>
<td height="54">
<p align="center">
<b><font color="#0000CC"><font size="4">Product Code</font>: </font></b>
</td>
<td height="54" width="156" align="left">
<INPUT TYPE="TEXT" NAME="ProdId" size="4" maxlength="4" VALUE="<%=fcode%>" READONLY="readonly"></td>
</tr>
<tr>
<td height="48">
<p align="center">
<font color="#0000CC" size="4" face="Calibri">
<b>Product Description:</b></font></td>
<td width="156" height="48"><INPUT TYPE="text" NAME="Descp"></td>
</tr>
<tr>
<td><p align="center">
<input type="submit" value="Save" id="web-buttons-idhyzy6a"></td>
<td width="156" rowspan="5" colspan="5" nowrap>
<p align="center">
<b><font face="Calibri" size="4" color="#0000CC">
<input type="Reset" value="Cancel"></font></b> </td> </tr> </table>
</font></b> </div>
<%
}
else if((ctr>=9)&&(ctr<99))
{
ctr=ctr+1;
finalcode="P0"+ctr;
fcode=finalcode;
%>
<div style="position: absolute; width: 102px; height: 24px; z-index: 4; left: 500px; top: -277px" id="layer13">
<p style="line-height: 200%; margin-top: 0; margin-bottom: 2px">
<a href="AdminHome.jsp">Home</a>
<a href="Product.jsp">Back</a></div>
<div style="position: absolute; width: 148px; height: 217px; z-index: 1; left: -380px; top: -19px;right: 2" id="layer2"><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:30px;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:30px;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:28px;display:block;"><br/></a></td></tr>
<tr><td style="padding-bottom:15px" title ="View">
<a href="PView.jsp" title="View" style="background-image:url(images/btmxzy6.png);width:153px;height:30px;display:block;"><br/></a></td></tr></table></div>
<div style="position: absolute; width: 1px; height: 18; z-index: 3; left: 559px; top: -271px" id="layer12"><img border="0" src="images/htc.gif" width="1" height="18"></div>
<b><font face="Calibri" size="4" color="#0000CC"><table width="346" height="151"><tr><td height="54"><p align="center">
<b><font color="#0000CC"><font size="4">Product Code</font>: </font></b></td>
<td height="54" width="156" align="left"><INPUT TYPE="TEXT" NAME="ProdId" size="4" maxlength="4" VALUE="<%=fcode%>" READONLY="readonly"></td>
</tr>
<tr>
<td height="48">
<p align="center">
<font color="#0000CC" size="4" face="Calibri"><b>Product Description:</b></font></td><td width="156" height="48"><INPUT TYPE="text" NAME="Descp"></td>
</tr><tr>
<td>
<p align="center">
<input type="submit" value="Save" id="web-buttons-idhyzy6a"></td><td width="156" rowspan="5" colspan="5" nowrap><p align="center"><b><font face="Calibri" size="4" color="#0000CC"><input type="Reset" value="Cancel"></font></b> </td>
</tr></table></font></b> </div>
<%
}
}
else
{
out.println("Try again");
}
}
catch(Exception e)
{
out.println("There are some invalid data::: "+"\n"+e);
}
finally
{
con.close();
}
%></form></body></html>
No comments:
Post a Comment