QuestionAsk Questions?
Http Servlet
<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
pageEncoding="ISO-8859-1"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>Create New Inventory Manager</title>
<link href="style.css" rel="stylesheet" type="text/css" media="screen" />
<script type="text/javascript">
function validation()
{
var name1=inventory.name1.value;
var addr1=inventory.addr1.value;
var number=inventory.cnum.value;
var x=document.forms["inventory"]["name2"].value;
var atpos=x.indexOf("@");
var dotpos=x.lastIndexOf(".");
var sub;
var rand;
if(name1.length==0)
{
alert("Enter your Name");
inventory.name1.focus();
return false;
}
if(addr1.length<20)
{
alert("Enter your address(minimum 20 characters)");
inventory.addr1.focus();
return false;
}
if ((atpos<1) || (dotpos<atpos+2) || (dotpos+2>=x.length))
{
alert("Not a valid e-mail address");
inventory.name2.focus();
return false;
}
if(number.length<10)
{
alert("Enter your 10 digit Contact Number");
inventory.cnum.focus();
return false;
}
sub= onsubmitform();
}
function isNumberKey(evt)
{
var charCode = (evt.which) ? evt.which : event.keyCode;
if ((charCode > 31) && (charCode < 48) || (charCode > 57))
return false;
return true;
}
function isNumberKey1(evt)
{
var charCode = (evt.which) ? evt.which : event.keyCode;
if (charCode > 31 && (charCode < 48) || (charCode > 57))
return true;
return false;
}
function onsubmitform()
{
alert("Account created successfully!");
}
</script>
</head>
<body bgcolor=silver>
<form method ="post" name="inventory" action="CreateIm" onsubmit="return validation()">
<center> Enter the Inventory Manager Details</center>
<table border="0" cellpadding="0" cellspacing="0">
<tr>
<td>Inventory Manager name: </td>
<td><INPUT id="txtChar" onkeypress="return isNumberKey1(event)" type="text" name="name1"></td>
</tr>
<tr>
<td>Address:</td>
<td><textarea rows="2" cols="20" name="addr1"></textarea></td>
</tr>
<tr>
<td>E-mail ID: </td>
<td><input type="text" name="name2" size="20"/></td>
</tr>
<tr>
<td>Phone No.: </td>
<td> <INPUT maxlength = 10 id="txtChar" onkeypress="return isNumberKey(event)" type="text" name="cnum">
</td>
</tr>
<tr>
<td> </td>
<td><input type="submit" value="Submit"/>
<input type="reset" name="B2" value="Reset"/></td>
</tr>
</table>
</form>
</body>
</html>
<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
pageEncoding="ISO-8859-1"%>
<%@ page import="java.lang.*" %>
<%@ page import="java.util.ArrayList" %>
<%@ page import="java.sql.*"%>
<%@ page import="com.ilp.tsi.db.DB" %>
<%@ page import="com.ilp.tsi.um.beans.*" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>Insert title here</title>
<link href="style.css" rel="stylesheet" type="text/css" media="screen" />
<script src="http://code.jquery.com/jquery-latest.js"></script>
<script type="text/javascript" src="http://jzaefferer.github.com/jquery-validation/jquery.validate.js"></script>
<script>
function validation()
{
var name1=edit.user.value;
var addr1=edit.add.value;
var number=edit.num.value;
var x=document.forms["edit"]["email"].value;
var atpos=x.indexOf("@");
var dotpos=x.lastIndexOf(".");
var sub;
if(name1.length==0)
{
alert("Enter your Name");
edit.user.focus();
return false;
}
if(addr1.length<20)
{
alert("Enter your address(minimum 20 characters)");
edit.add.focus();
return false;
}
if ((atpos<1) || (dotpos<atpos+2) || (dotpos+2>=x.length))
{
alert("Not a valid e-mail address");
edit.email.focus();
return false;
}
if(number.length<10)
{
alert("Enter your 10 digit Contact Number");
edit.num.focus();
return false;
}
}
function openPage(pageURL) { window.location.href = pageURL; }
function isNumberKey(evt)
{
var charCode = (evt.which) ? evt.which : event.keyCode;
if ((charCode>31) && (charCode<48) || (charCode>57))
return false;
return true;
}
function isNumberKey1(evt)
{
var charCode = (evt.which) ? evt.which : event.keyCode;
if (charCode>31 && (charCode<48 || charCode>57))
return true;
return false;
}
</script>
</head>
<body>
<h2 align="center">Retailer Details</h2>
<center><form method="post" id="edit" name="edit" action="EditRetailer" onsubmit="return validation()" >
<%
Connection conn=null;
Statement stmt=null;
try
{
DB obj=new DB();
conn=obj.getConnection();
stmt=conn.createStatement();
ResultSet rs=null;
ResultSet rs1=null,rs2=null;;
//RetBean rbean=new RetBean();
String retId=(String)session.getAttribute("retId");
rs=stmt.executeQuery("select * from retailer where RETAILER_ID='"+retId+"'");
while(rs.next())
{
%>
<table border="0" cellspacing="5" cellpadding="5">
<tr>
<td>Retailer Name:</td>
<td><input type="text" name="user" onkeypress="return isNumberKey1(event)" class="Retailer name required" value="<%= rs.getString("retailer_name") %>"></input></td>
</tr>
<tr>
<td>Address:</td>
<td><textarea rows="1" cols="20" name="add" class="address required" ><%= rs.getString("address")%></textarea></td>
</tr>
<tr>
<td>Email ID:</td>
<td><input type="text" name="email" class="email required" value="<%= rs.getString("email_id")%>"></input></td>
</tr>
<tr>
<td>Contact Number:</td>
<td><input type="text" name="num" onkeypress="return isNumberKey(event)" class="contact number required" size="10" value="<%= rs.getString("contact_no")%>"></input></td>
</tr>
<tr><th align="left">Tagged retailer products</th></tr>
<%
}
rs1=stmt.executeQuery("select product.prod_model_name,product.product_id from ret_prod inner join product on ret_prod.product_id=product.product_id where retailer_id='"+retId+"'");
while(rs1.next())
{
%>
<tr>
<td></td>
<td><%=rs1.getString("prod_model_name") %></td>
</tr>
<%
//rs2=stmt.executeQuery("insert into ret_prod values ('"+retId+"','"+rs1.getString("product_id")+"')");
}
%>
<tr>
<td><input type="button" value="Product Catalog" onclick="openPage('tags.jsp')"></input></td>
<td><input type="submit" value="update" name="Edit1"></input></td>
<td><input type="button" value="untag" onclick="openPage('untag.jsp')"></input></td>
<td><input type="button" value="delete" onclick="openPage('deleteretailer.jsp')"></input></td>
</tr>
</table>
</form>
<%
conn.close();
stmt.close();
}
catch(SQLException E)
{
E.printStackTrace();
}
%>
</center>
</body>
</html>
<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
pageEncoding="ISO-8859-1"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title> Retailer Home </title>
<link rel="stylesheet" type="text/css" href="style.css" />
<script type="text/javascript">
window.history.forward();
function noBack()
{
windows.history.forward();
}
</script>
</head>
<body onload="noBack();" onPageshow="if(event.resisted)noBack();" onunload="">
<font>
<p align="right"><a href=changeRetPassword.jsp>Change Password</a>  <a href=welcome.jsp>Logout</a></p>
<h1 align="center">Retailer Home Page </h1>
<%@page language="java" session="true" %>
<%
session.setMaxInactiveInterval(60);
%>
<table align="center" cellpadding="10" cellspacing="2" border="3">
<tr height ="50">
<td width="220" align="center" bgcolor="#FAEBD7">
<input type="button" onclick="window.location = 'viewListModels.jsp';" value="View list of models " style="height: 1.5cm;width:5cm;" >
</td>
</tr>
<tr height="50">
<td width="220" align="center" bgcolor="#FAEBD7">
<input type="button" onclick="window.location = 'orderPlacing.jsp';" value="Order Products " style="height: 1.5cm;width:5cm;" >
</td>
</tr>
<tr height ="50">
<td width="220" align="center" bgcolor="#FAEBD7">
<input type="submit" onclick="window.location = 'deleteOrder.jsp';" name="upViewAll" value="Cancel the order" style="height: 1.5cm;width:5cm;"/>
</td>
</tr>
<tr height ="50">
<td width="220" align="center" bgcolor="#FAEBD7">
<input type="submit" onclick="window.location = 'pdate_customer_info1.jsp';" name="productnameDB" value="Update customer information" style="height: 1.5cm;width:5cm;" >
</td>
</tr>
<tr height ="50">
<td width="220" align="center" bgcolor="#FAEBD7">
<input type="submit" onclick="window.location = 'checkShipment.jsp';" name="productnameDB" value="Check status of shipment" style="height: 1.5cm;width:5cm;" >
</td>
</tr>
<tr height ="50">
<td width="220" align="center" bgcolor="#FAEBD7">
<input type="submit" onclick="window.location = 'defectReplace.jsp';" name="productnameDB" value="Defect Replacement" style="height: 1.5cm;width:5cm;" >
</td>
</tr>
<tr height ="50">
<td width="220" align="center" bgcolor="#FAEBD7">
<input type="submit" onclick="window.location = 'viewListOrders.jsp';" name="productnameDB" value="View List of orders" style="height: 1.5cm;width:5cm;" >
</td>
</tr>
</table>
</font>
</body>
</html>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN""http://www.w3.org/TR/html4/loose.dtd">
<%@ page import="java.sql.*" %><%@ page import="java.io.*" %>
<%@ page import="com.ilp.tsi.utils.*" %>
<%@ page import="com.ilp.tsi.db.*" %>
<html>
<head>
<link rel="stylesheet" type="text/css" href="style.css" />
<title>Display products</title>
</head>
<body>
<font>
<h1 align="center">List of Products</h2>
<% String retailername = (String)session.getAttribute("rid");
System.out.println(retailername);
%>
<%
try
{
Connection connection=null;
Statement statement=null;
ResultSet rs=null;
DB dao=new DB();
connection=dao.getConnection();
statement = connection.createStatement();
rs = statement.executeQuery("SELECT prod_model_name,price,features,description,quantity from product where product_id in(select product_id from ret_prod where retailer_id='"+retailername+"')");
%>
<TABLE cellpadding="15" border="1" >
<tr>
<th>Product Model Name</th>
<th>Price</th>
<th>Features</th>
<th>Description</th>
<th>Availabilty</th>
</tr>
<%
while (rs.next())
{
%>
<tr>
<td><%=rs.getString(1)%>
</td><td><%=rs.getInt(2)%>
</td><td><%=rs.getString(3)%></td>
<td><%=rs.getString(4)%></td>
<td><%=rs.getString(5)%></td>
</tr>
<%
}
%>
<%
rs.close();
statement.close();
connection.close();
}
catch (Exception ex)
{
out.println("Unable to connect to database.");
}
%>
</TABLE>
<TABLE>
<TR>
<TD>
<br><br>
<a href=retailerHome.jsp>Go to Home Page</a>
</TABLE>
</font>
</body>
</html>
View Answers
Related Pages:
If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.
Ask your questions, our development team will try to give answers to your questions.
Tutorial Topics
