QuestionAsk Questions?
gautam jagnani
Hello i need code for.....
I have a car brandimage on my front page.on clicking it it is directed to a model.jsp page.....what i need is on clicking a particular brand only the corresponding models of that brand should be retrieved from database.i have created a table in database which have brand,model,price as attributes.
thanks.
I have a car brandimage on my front page.on clicking it it is directed to a model.jsp page.....what i need is on clicking a particular brand only the corresponding models of that brand should be retrieved from database.i have created a table in database which have brand,model,price as attributes.
thanks.
View Answers
May 28, 2010 at 4:36 PM
Hi Friend,
Try the following code:
1)index.jsp:
<html>
<form action="model.jsp">
<center><input type="image" src="car.jpg" ></center>
</form>
</html>
2)model.jsp:
<script language="javascript" type="text/javascript">
function call(brand){
window.open('info.jsp?brand='+brand,'mywindow','width=400, height=250,toolbar=no,resizable=yes,menubar=yes');
}
</script>
<h1>Car Brands</h1>
<a href ="javascript:call('Tata')">Tata </a><br><br>
<a href ="javascript:call('Ford')">Ford </a><br><br>
<a href ="javascript:call('Maruti')">Maruti </a><br><br>
<a href ="javascript:call('Honda')">Honda </a><br><br>
<a href ="javascript:call('Toyota')">Toyota </a><br><br>
<a href ="javascript:call('Chevrolet')">Chevrolet </a><br><br>
3)info.jsp:
<%@page import="java.sql.*"%>
<%
String brand=request.getParameter("brand");
Class.forName("com.mysql.jdbc.Driver").newInstance();
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root";, "root");
Statement st = conn.createStatement();
ResultSet rs = st.executeQuery("select * from car where brand='"+brand+"'");
if(brand!=null){
%>
<center><h1><%=brand%></h1></center>
<center><table border="1" width="80%" height="50%">
<tr><th>Brand</th><th>Model</th><th>Price</th></tr>
<%
while(rs.next()){
%>
<tr><td><%=rs.getString(2)%></td><td><%=rs.getString(3)%></td><td><%=
rs.getString(4)%></td></tr>
<%
}
%>
</table></center>
<%
}
%>
Thanks
Try the following code:
1)index.jsp:
<html>
<form action="model.jsp">
<center><input type="image" src="car.jpg" ></center>
</form>
</html>
2)model.jsp:
<script language="javascript" type="text/javascript">
function call(brand){
window.open('info.jsp?brand='+brand,'mywindow','width=400, height=250,toolbar=no,resizable=yes,menubar=yes');
}
</script>
<h1>Car Brands</h1>
<a href ="javascript:call('Tata')">Tata </a><br><br>
<a href ="javascript:call('Ford')">Ford </a><br><br>
<a href ="javascript:call('Maruti')">Maruti </a><br><br>
<a href ="javascript:call('Honda')">Honda </a><br><br>
<a href ="javascript:call('Toyota')">Toyota </a><br><br>
<a href ="javascript:call('Chevrolet')">Chevrolet </a><br><br>
3)info.jsp:
<%@page import="java.sql.*"%>
<%
String brand=request.getParameter("brand");
Class.forName("com.mysql.jdbc.Driver").newInstance();
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root";, "root");
Statement st = conn.createStatement();
ResultSet rs = st.executeQuery("select * from car where brand='"+brand+"'");
if(brand!=null){
%>
<center><h1><%=brand%></h1></center>
<center><table border="1" width="80%" height="50%">
<tr><th>Brand</th><th>Model</th><th>Price</th></tr>
<%
while(rs.next()){
%>
<tr><td><%=rs.getString(2)%></td><td><%=rs.getString(3)%></td><td><%=
rs.getString(4)%></td></tr>
<%
}
%>
</table></center>
<%
}
%>
Thanks
May 28, 2010 at 4:37 PM
For the above code, create database table named 'car':
CREATE TABLE `car` (
`id` bigint(255) NOT NULL auto_increment,
`brand` varchar(255) default NULL,
`model` varchar(255) default NULL,
`price` double default NULL,
PRIMARY KEY (`id`)
)
Thanks
CREATE TABLE `car` (
`id` bigint(255) NOT NULL auto_increment,
`brand` varchar(255) default NULL,
`model` varchar(255) default NULL,
`price` double default NULL,
PRIMARY KEY (`id`)
)
Thanks
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
