Bommaraju Chaitanya

Greenhorn
+ Follow
since Aug 06, 2007
Merit badge: grant badges
For More
Cows and Likes
Cows
Total received
0
In last 30 days
0
Total given
0
Likes
Total received
0
Received in last 30 days
0
Total given
0
Given in last 30 days
0
Forums and Threads
Scavenger Hunt
expand Ranch Hand Scavenger Hunt
expand Greenhorn Scavenger Hunt

Recent posts by Bommaraju Chaitanya

Hi,
I got the Application.

JSP To Excel Easily.
By using POI jar file.
And Code as
String Filename="UsersList.xls";
response.setContentType("application/vnd.ms-excel");
response.setHeader("Expires","01 Jan 2007");
response.setHeader("Content-Disposition", "attachment;filename="+Filename);

OutputStream out1 = response.getOutputStream();
16 years ago
JSP
Hi,
This is Chaitu.In My application i need to send the data from database to excel sheet using jsp.
I am getting the Excel sheet but, I am not getting the values retrieved from database.
Can any one have idea. Please help me
16 years ago
JSP
First Two tables in the database.

1)In one table maintain two fields one is kno as primary key, and second field as List of Keywords in your site.

2)In the second table maintain three fields one for urlid, urls and kno (foreign key)

insert your urlid's as about.html,contactus.html

In the html page use the input tag.
<form action="search.jsp" method="post">
<input type="text" name="search">
<input type="submit" value="go">

then get the request in jsp page as follows
<% String search=request.getParameter("search");
Then in the jsp page write the query as
rs=st.executeQuery("select * from urls where urls.kno=(select kno from keywords where keyword='"+search+"')");
16 years ago