Prog Error

<%@ 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">
function Browse()
{

</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>
<%
for(int i=0;i<=DraftAd.length;i++)
out.println(i);
%>
Count:<input type=text name="count" size=5 id="count" disabled="disabled" value="<%=i%>"></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++)
{
%>
<option>
<%
out.println(--- Please Select ---);
out.println(date);
%>
</option>
<%}%>
</select>Month:<select name="Month" size=1>
<%
for (int month=1;month<=12;month++)
{
%>
<option>
<%
out.println(--- Please Select ---);
out.pritnln(month);
%>
</option>
<%}%>
</select>Year:<select name="Year" size=1>
<%
for (int year=1960;year<=2010;year++)
{
%>
<option>
<%
out.println(--- Please Select ---);
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>

Database fields are:
State
City
Main Category
Sub category
Title
DraftAd
Count
Image
Email
PhoneNo
Newspaper and edition
Date
Month
Year
no of .Days

Here in Main Ctegory eg: Matrimonial is selected
in sub category user can select groom
in no.od days says for how many days you ad should get displayed. if 2 then it will get displayed for 2 dayeform date of ad.

In draft ad when characters are typed then it shold get converted in words and should get displayed in count box.

In image ,there is a browse button if user clicks it he should get a folder of images from where it can select it and it should get saved in database when clicked on save button and should get displayed on next page when clicked on submit.

View Answers