QuestionAsk Questions?
Harshu
Actually there is an error in placeorder.jsp file where there are 5 fields OrderNo ,Name , Address, Email, PhoneNo
where if I delete an order of client based on orderno then suppose in database if there are 5 orders then if i delete an order no 3
then the next order no i.e is 4 should not get replaced by order no 3
other wise if that want to delete his order then ,he knows that his order no was 4 but he dont know the new order no that is 3 that got replaced by orderno 3 when it got deleted.
Only that deleted spaced should get removed by moving the order to that free space but the order no should not get replaced.
So please reply me Sir what to do and how to do??
And please reply me the answers of questions i asked you before and i have send you the fields of place ad.
i.e there are 11 fields
State
city
Main Category
Sub Category
Title
DraftAd
Count
Image
Email
phoneNo
Newspaper
Date
Month
Year
Days
<%@ page language="java" import="java.sql.*" %>
<%@ page import="java.lang.String.*" %>
<%
Connection con=null;
//ResultSet state=null;
Statement stmt=null;
String st;
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection("jdbc:odbc:Advdsn");
stmt=con.createStatement();
}
catch(SQLException se)
{
out.println("Database Error:"+se.getMessage());
}
catch(Exception e)
{
e.toString();
}
%>
<HTML>
<HEAD>
<TITLE> Place Ad </TITLE>
<script type="text/javascript">
var cnt=0;
<!--var str="How are you doing today?";-->
var str=getValue("DraftAd");
String s=(str.split(" "));
cnt=cnt+s;
</script>
</HEAD>
<BODY BGCOLOR="lightblue">
<marquee behavior="alternate" scrollamount=5 scrolldelay=10><h1><font size=4 face="Stroustroup" color="#993355">Advertisement Management System</h1></font></marquee><br>
<p align=center><b> <font color="669933" size=4>Create Ad </font></b></p><br>
<form method=post action="http://localhost:8080/ProjectAd/Preview">
State: <select name="State" size=1>
<%
ResultSet state=stmt.executeQuery("Select * from PlaceAd");
while(state.next())
{
%>
<option>
<%
out.println(state.getString(1));
%>
</option>
<%}%>
</select><br>
City: <select name="City" size=1>
<%
ResultSet city=stmt.executeQuery("Select * from PlaceAd");
while(city.next())
{
%>
<option>
<%
out.println(city.getString("City")); %>
</option>
<%}%>
</select><br>
Main Category: <select name="mainCat" size=1>
<%
ResultSet mainC=stmt.executeQuery("Select * from PlaceAd");
while(mainC.next())
{
%>
<option>
<%
out.println(mainC.getString("Main Category")); %>
</option>
<%}%>
</select><br>
Sub Category:<select name="subCat" size=1>
<%
ResultSet subC=stmt.executeQuery("Select * from PlaceAd");
while(subC.next())
{
%>
<option>
<%
out.println(subC.getString("Sub Category")); %>
</option>
<%}%>
</select><br>
Title: <input type=text name="Title" size=25><br>
<p>Draft Your Ad Here:<textarea name="DraftAd" rows=3 cols=25 size=25 id="DraftAd"></textarea>
Count:<input type=text name="cnt" size=5 id="cnt" ></p>
<p>Image:<input type=text name="Image1" size=25>
<input type=submit name=SubmitBrowse value="Browse" onSubmitBrowse="return Browse();" ></p>
Add another Image<br>
Email:<input type=text name="Email" size=25><br>
Phone No:<input type=text name="PhoneNo" size=25><br>
Select Newspaper:<select name="NewsPaper" size=1>
<%
ResultSet newspaper=stmt.executeQuery("Select * from PlaceAd");
while(newspaper.next())
{
%>
<option>
<%
out.println(newspaper.getString("NewsPaper")); %>
</option>
<%}%>
</select><br>
Select Your Date:<select name="Date" size=1>
<%for (int date=1;date<=31;date++)
{
%>
<br><option>
<%out.println(date);
%>
</option>
<%}%>
</select>
Month:<select name="Month" size=1>
<%
for (int month=1;month<=12;month++)
{
%>
<option>
<%
out.println(month);
%>
</option>
<%}%>
</select>
Year:<select name="Year" size=1>
<%
for (int year=1960;year<=2010;year++)
{
%>
<option>
<%
out.println(year);
%>
</option>
<%}%>
</select><br>
Select Number of Days:<input type=text name="Days" size=5><br>
<p>Confirm:<input type=checkbox name=confirm ><input type=submit name=SubmitSave value=Save><br>
<p><input type=submit name=submit value=Submit><br>
</form>
</BODY>
</HTML>
where if I delete an order of client based on orderno then suppose in database if there are 5 orders then if i delete an order no 3
then the next order no i.e is 4 should not get replaced by order no 3
other wise if that want to delete his order then ,he knows that his order no was 4 but he dont know the new order no that is 3 that got replaced by orderno 3 when it got deleted.
Only that deleted spaced should get removed by moving the order to that free space but the order no should not get replaced.
So please reply me Sir what to do and how to do??
And please reply me the answers of questions i asked you before and i have send you the fields of place ad.
i.e there are 11 fields
State
city
Main Category
Sub Category
Title
DraftAd
Count
Image
phoneNo
Newspaper
Date
Month
Year
Days
<%@ page language="java" import="java.sql.*" %>
<%@ page import="java.lang.String.*" %>
<%
Connection con=null;
//ResultSet state=null;
Statement stmt=null;
String st;
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection("jdbc:odbc:Advdsn");
stmt=con.createStatement();
}
catch(SQLException se)
{
out.println("Database Error:"+se.getMessage());
}
catch(Exception e)
{
e.toString();
}
%>
<HTML>
<HEAD>
<TITLE> Place Ad </TITLE>
<script type="text/javascript">
var cnt=0;
<!--var str="How are you doing today?";-->
var str=getValue("DraftAd");
String s=(str.split(" "));
cnt=cnt+s;
</script>
</HEAD>
<BODY BGCOLOR="lightblue">
<marquee behavior="alternate" scrollamount=5 scrolldelay=10><h1><font size=4 face="Stroustroup" color="#993355">Advertisement Management System</h1></font></marquee><br>
<p align=center><b> <font color="669933" size=4>Create Ad </font></b></p><br>
<form method=post action="http://localhost:8080/ProjectAd/Preview">
State: <select name="State" size=1>
<%
ResultSet state=stmt.executeQuery("Select * from PlaceAd");
while(state.next())
{
%>
<option>
<%
out.println(state.getString(1));
%>
</option>
<%}%>
</select><br>
City: <select name="City" size=1>
<%
ResultSet city=stmt.executeQuery("Select * from PlaceAd");
while(city.next())
{
%>
<option>
<%
out.println(city.getString("City")); %>
</option>
<%}%>
</select><br>
Main Category: <select name="mainCat" size=1>
<%
ResultSet mainC=stmt.executeQuery("Select * from PlaceAd");
while(mainC.next())
{
%>
<option>
<%
out.println(mainC.getString("Main Category")); %>
</option>
<%}%>
</select><br>
Sub Category:<select name="subCat" size=1>
<%
ResultSet subC=stmt.executeQuery("Select * from PlaceAd");
while(subC.next())
{
%>
<option>
<%
out.println(subC.getString("Sub Category")); %>
</option>
<%}%>
</select><br>
Title: <input type=text name="Title" size=25><br>
<p>Draft Your Ad Here:<textarea name="DraftAd" rows=3 cols=25 size=25 id="DraftAd"></textarea>
Count:<input type=text name="cnt" size=5 id="cnt" ></p>
<p>Image:<input type=text name="Image1" size=25>
<input type=submit name=SubmitBrowse value="Browse" onSubmitBrowse="return Browse();" ></p>
Add another Image<br>
Email:<input type=text name="Email" size=25><br>
Phone No:<input type=text name="PhoneNo" size=25><br>
Select Newspaper:<select name="NewsPaper" size=1>
<%
ResultSet newspaper=stmt.executeQuery("Select * from PlaceAd");
while(newspaper.next())
{
%>
<option>
<%
out.println(newspaper.getString("NewsPaper")); %>
</option>
<%}%>
</select><br>
Select Your Date:<select name="Date" size=1>
<%for (int date=1;date<=31;date++)
{
%>
<br><option>
<%out.println(date);
%>
</option>
<%}%>
</select>
Month:<select name="Month" size=1>
<%
for (int month=1;month<=12;month++)
{
%>
<option>
<%
out.println(month);
%>
</option>
<%}%>
</select>
Year:<select name="Year" size=1>
<%
for (int year=1960;year<=2010;year++)
{
%>
<option>
<%
out.println(year);
%>
</option>
<%}%>
</select><br>
Select Number of Days:<input type=text name="Days" size=5><br>
<p>Confirm:<input type=checkbox name=confirm ><input type=submit name=SubmitSave value=Save><br>
<p><input type=submit name=submit value=Submit><br>
</form>
</BODY>
</HTML>
View Answers
Related Pages:
- Exception handling mechanism
- DHTML Tutorial
- Checking if a file or directory exist
- How to get New Gmail Inbox?
- What is License Terms for using your code
- Difference between equals() and == ?
- Assignment operator in java
- Hibernate Video Tutorial
- Conditional operator in java
- jQuery Tutorial For Beginners
