QuestionAsk Questions?
Harshu
Domain Table:--
Rfcdkey DomainName DomainValue DepDomainValue Statcd
1 StateCd Maharashtra Mumbai A
2 StateCd Maharashtra Pune A
3 StateCd Maharashtra Nashik A
4 StateCd Karnataka Bangalore A
5 StateCd Delhi Delhi A
6 StateCd West Bengal Kolkata A
7 StateCd West Bengal Dargeeling A
8 Category Matrimonial Bride A
9 Category Matrimonial Groom A
PlaceAd.jsp:--code
<%@page import="java.sql.*"%>
<%@page import="java.io.*"%>
<%
Connection con=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>
<script language="JavaScript">
function Draft(text1,text2){
var v1=text1.value;
var v = 0;
v2=v1.replace(/\s/g,' ');
v2=v2.split(' ');
for (i=0; i<v2.length; i++) {if (v2[i].length > 0) v++;}
text2.value=v;
}
function checkPhoneNo(num){
if(isNaN(num)){alert("Invalid Phone Number. The only characters permitted are 0 to 9"); return 0;}
else{return 1;}
}
function Validate()
{
var phone=document.form.PhoneNo;
var email=document.form.Email;
if(email.value=="")
{ alert("Please enter valid Email Id");
return false;
}
apos=email.value.indexOf("@")
dotpos=email.value.lastIndexOf(".")
if (apos<1 || dotpos-apos<2)
{
alert("Invalid Email Id")
email.value=="";
email.focus();
return false;
}
if((phone.value=="")||(phone.value==null))
{ alert("Please enter valid PhoneNo");phone.focus();
return false;
}
if (checkPhoneNo(phone.value)==false){
phone.value="";
phone.focus();
return false;
}
if ((phone.value.length==8)||(phone.value.length==10)){
return true;
}
else{
alert("Phone Number must be of 8 numbers or 10 numbers");
return false;
}
return true;
}
</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>
<% String no=request.getParameter("OrderNo");
out.println("The Placing of Ad is of Order Number "+no+"<br>"); %>
<form name="form" method="post" action="Preview.jsp" onsubmit="return Validate();">
<table>
<tr><td>State:</td><td> <select name="State" size=1>
<%
ResultSet state=stmt.executeQuery("SELECT distinct DomainValue FROM Domain WHERE DomainName = 'StateCd' Order by 1");
while(state.next())
{
String st=state.getString("DomainValue");
%>
<option value="<%=st %>">
<%
out.println(st); %>
</option>
<%}%>
</select></td></tr>
<tr><td>City:</td><td> <select name="City" size=1>
<%
ResultSet city=stmt.executeQuery("Select DepDomainValue from Domain where DomainName='StateCd' and DomainValue=(SELECT distinct DomainValue FROM Domain WHERE DomainName = 'StateCd') ");
while(city.next())
{
String ci=city.getString("DepDomainValue");
%>
<option value="<%=ci %>">
<%
out.println(ci); %>
</option>
<%}%>
</select></td></tr>
<tr><td>Main Category: </td><td><select name="mainCat" size=1>
<%
ResultSet mainC=stmt.executeQuery("SELECT distinct DomainValue FROM Domain WHERE DomainName = 'Category' Order by 1 ");
while(mainC.next())
{
String mc=mainC.getString("DomainValue");
%>
<option value="<%=mc %>">
<%
out.println(mc); %>
</option>
<%}%>
</select></td></tr>
<tr><td>Sub Category:</td><td><select name="subCat" size=1>
<%
ResultSet subC=stmt.executeQuery("Select DepDomainValue from Domain where DomainName='Category' and UCase(DomainValue)=ucase('Matrimonial') Order by 1");
while(subC.next())
{
String sc=subC.getString("DepDomainValue");
%>
<option value="<%=sc %>">
<%
out.println(sc); %>
</option>
<%}%>
</select></td></tr>
<tr><td>Title:</td><td> <input type=text name="Title" size=25 ></td></tr>
<tr><td>Draft Your Ad here:</td><td><textarea name="DraftAd" cols="15" rows="2" onkeyup="Draft(this,document.form.Count)"></textarea></td></tr>
<tr><td>No of words:</td><td><input name="Count" type="text" value="0" onkeyup="Draft(document.form.DraftAd,this)" readonly></td></tr>
<tr><td>Image:</td><td><input type="file" name="img"></td></tr>
<tr><td>Email:</td><td><input type=text name="Email" size=25></td></tr>
<tr><td>Phone No:</td><td><input type=text name="PhoneNo" size=25 maxlength=10></td></tr>
<tr><td>Select Newspaper:</td><td><select name="NewsPaper" size=1>
<%
ResultSet news=stmt.executeQuery("SELECT distinct DomainValue FROM Domain WHERE DomainName = 'Newsp' Order by 1");
while(news.next())
{
String np=news.getString("DomainValue");
%>
<option value="<%=np %>">
<%
out.println(np); %>
</option>
<%}%>
</select></td></tr>
<br>
<tr><td>Select Your Date:</td><td><select name="day" size=1>
<%for (int date=1;date<=31;date++)
{
%>
<option value="<%=date%>"><%=date%></option>
<%}%>
</select></td></tr>
<tr><td>Month:</td><td><select name="Month" size=1>
<%
for (int month=1;month<=12;month++){
%>
<option value="<%=month%>"><%=month%></option>
<%}%>
</select></td></tr>
<tr><td>Year:</td><td><select name="Year" size=1>
<%
for (int year=2010;year<=2050;year++){
%>
<option value="<%=year%>"><%=year%></option>
<%}%>
</select></td></tr>
<tr><td>Select Number of Days:</td><td><input type=text name="numDays" size=5></td></tr>
<tr><td><input type="submit" name="submit" value="Preview"></td></tr>
</form>
</body>
</html>
Above This is the Domain Table created in access.
I loaded all values from Domain table in PlaceAd.jsp
but i want that if user selects Maharashtra then only city related to that state must be visible in city combo box.
Eg: if Maharashtra is selected then only mumbai,pune and nashik must be visible in city combo box ??
Please Reply me Sir how to do this actually i tried but its giving me error??
So Please Reply me.
Thank You Sir.
Rfcdkey DomainName DomainValue DepDomainValue Statcd
1 StateCd Maharashtra Mumbai A
2 StateCd Maharashtra Pune A
3 StateCd Maharashtra Nashik A
4 StateCd Karnataka Bangalore A
5 StateCd Delhi Delhi A
6 StateCd West Bengal Kolkata A
7 StateCd West Bengal Dargeeling A
8 Category Matrimonial Bride A
9 Category Matrimonial Groom A
PlaceAd.jsp:--code
<%@page import="java.sql.*"%>
<%@page import="java.io.*"%>
<%
Connection con=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>
<script language="JavaScript">
function Draft(text1,text2){
var v1=text1.value;
var v = 0;
v2=v1.replace(/\s/g,' ');
v2=v2.split(' ');
for (i=0; i<v2.length; i++) {if (v2[i].length > 0) v++;}
text2.value=v;
}
function checkPhoneNo(num){
if(isNaN(num)){alert("Invalid Phone Number. The only characters permitted are 0 to 9"); return 0;}
else{return 1;}
}
function Validate()
{
var phone=document.form.PhoneNo;
var email=document.form.Email;
if(email.value=="")
{ alert("Please enter valid Email Id");
return false;
}
apos=email.value.indexOf("@")
dotpos=email.value.lastIndexOf(".")
if (apos<1 || dotpos-apos<2)
{
alert("Invalid Email Id")
email.value=="";
email.focus();
return false;
}
if((phone.value=="")||(phone.value==null))
{ alert("Please enter valid PhoneNo");phone.focus();
return false;
}
if (checkPhoneNo(phone.value)==false){
phone.value="";
phone.focus();
return false;
}
if ((phone.value.length==8)||(phone.value.length==10)){
return true;
}
else{
alert("Phone Number must be of 8 numbers or 10 numbers");
return false;
}
return true;
}
</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>
<% String no=request.getParameter("OrderNo");
out.println("The Placing of Ad is of Order Number "+no+"<br>"); %>
<form name="form" method="post" action="Preview.jsp" onsubmit="return Validate();">
<table>
<tr><td>State:</td><td> <select name="State" size=1>
<%
ResultSet state=stmt.executeQuery("SELECT distinct DomainValue FROM Domain WHERE DomainName = 'StateCd' Order by 1");
while(state.next())
{
String st=state.getString("DomainValue");
%>
<option value="<%=st %>">
<%
out.println(st); %>
</option>
<%}%>
</select></td></tr>
<tr><td>City:</td><td> <select name="City" size=1>
<%
ResultSet city=stmt.executeQuery("Select DepDomainValue from Domain where DomainName='StateCd' and DomainValue=(SELECT distinct DomainValue FROM Domain WHERE DomainName = 'StateCd') ");
while(city.next())
{
String ci=city.getString("DepDomainValue");
%>
<option value="<%=ci %>">
<%
out.println(ci); %>
</option>
<%}%>
</select></td></tr>
<tr><td>Main Category: </td><td><select name="mainCat" size=1>
<%
ResultSet mainC=stmt.executeQuery("SELECT distinct DomainValue FROM Domain WHERE DomainName = 'Category' Order by 1 ");
while(mainC.next())
{
String mc=mainC.getString("DomainValue");
%>
<option value="<%=mc %>">
<%
out.println(mc); %>
</option>
<%}%>
</select></td></tr>
<tr><td>Sub Category:</td><td><select name="subCat" size=1>
<%
ResultSet subC=stmt.executeQuery("Select DepDomainValue from Domain where DomainName='Category' and UCase(DomainValue)=ucase('Matrimonial') Order by 1");
while(subC.next())
{
String sc=subC.getString("DepDomainValue");
%>
<option value="<%=sc %>">
<%
out.println(sc); %>
</option>
<%}%>
</select></td></tr>
<tr><td>Title:</td><td> <input type=text name="Title" size=25 ></td></tr>
<tr><td>Draft Your Ad here:</td><td><textarea name="DraftAd" cols="15" rows="2" onkeyup="Draft(this,document.form.Count)"></textarea></td></tr>
<tr><td>No of words:</td><td><input name="Count" type="text" value="0" onkeyup="Draft(document.form.DraftAd,this)" readonly></td></tr>
<tr><td>Image:</td><td><input type="file" name="img"></td></tr>
<tr><td>Email:</td><td><input type=text name="Email" size=25></td></tr>
<tr><td>Phone No:</td><td><input type=text name="PhoneNo" size=25 maxlength=10></td></tr>
<tr><td>Select Newspaper:</td><td><select name="NewsPaper" size=1>
<%
ResultSet news=stmt.executeQuery("SELECT distinct DomainValue FROM Domain WHERE DomainName = 'Newsp' Order by 1");
while(news.next())
{
String np=news.getString("DomainValue");
%>
<option value="<%=np %>">
<%
out.println(np); %>
</option>
<%}%>
</select></td></tr>
<br>
<tr><td>Select Your Date:</td><td><select name="day" size=1>
<%for (int date=1;date<=31;date++)
{
%>
<option value="<%=date%>"><%=date%></option>
<%}%>
</select></td></tr>
<tr><td>Month:</td><td><select name="Month" size=1>
<%
for (int month=1;month<=12;month++){
%>
<option value="<%=month%>"><%=month%></option>
<%}%>
</select></td></tr>
<tr><td>Year:</td><td><select name="Year" size=1>
<%
for (int year=2010;year<=2050;year++){
%>
<option value="<%=year%>"><%=year%></option>
<%}%>
</select></td></tr>
<tr><td>Select Number of Days:</td><td><input type=text name="numDays" size=5></td></tr>
<tr><td><input type="submit" name="submit" value="Preview"></td></tr>
</form>
</body>
</html>
Above This is the Domain Table created in access.
I loaded all values from Domain table in PlaceAd.jsp
but i want that if user selects Maharashtra then only city related to that state must be visible in city combo box.
Eg: if Maharashtra is selected then only mumbai,pune and nashik must be visible in city combo box ??
Please Reply me Sir how to do this actually i tried but its giving me error??
So Please Reply me.
Thank You Sir.
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
