PAdded.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 Added</title>
</head>
<body>
<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: 258px; height: 191px; z-index: 4; left: 307px; top: 266px" id="layer9">
<%
Connection con=null;
PreparedStatement ps=null;
ResultSet rs=null;
String ProductId=request.getParameter("ProdId");
String Description=request.getParameter("Descp");
ProductId=ProductId.trim();
Description=Description.trim();
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
%>
<%
try
{
con=DriverManager.getConnection("jdbc:odbc:SureVacCallDS","sa","P@ssw0rd");
ps=con.prepareStatement("insert into product (code,descp) values (?,?)");
ps.setString(1,ProductId);
ps.setString(2,Description);
ps.executeUpdate();
%>
<div style="position: absolute; width: 102px; height: 24px; z-index: 4; left: 569px; top: -258px" 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: 354px; z-index: 1; left: -306px; top: -22px;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: 615px; top: -252px" id="layer12">
<img border="0" src="images/htc.gif" width="1" height="18"></div>
<div style="border:3px groove #0000CC; position: absolute; width: 131; height: 123; z-index: 1; left: 387px; top: -2px; padding-left:4px; padding-right:4px; padding-top:1px; padding-bottom:1px" id="layer10">
<img border="0" src="images/CARRKKO7.jpg" width="131" height="123"></div>
<p><font size="4" face="Calibri" color="#0000CC">Data has been
added successfully.</font></div>
<%
}
catch(Exception e)
{
%>
<div style="position: absolute; width: 102px; height: 24px; z-index: 4; left: 627px; top: -293px" 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: 354px; z-index: 1; left: -250px; top: -40px;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 ="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: 615px; top: -287px" id="layer12">
<img border="0" src="images/htc.gif" width="1" height="18"></div>
<div style="border:3px groove #0000CC; position: absolute; width: 150; height: 150; z-index: 1; left: 428px; top: -34px; padding-left:4px; padding-right:4px; padding-top:1px; padding-bottom:1px" id="layer10">
<img border="0" src="images/error.jpg" width="150" height="150"></div>
<p><font face="Calibri" size="4" color="#0000CC">There are some
invalid data please try again !!!</font></div>
<% }
finally
{
con.close();
}
%></body></html>
No comments:
Post a Comment