|
|
| jdbc,jsp |
Expert:keerthi
<%@ page import = "java.sql.*;" errorPage = "Error.jsp" %>
<%!
Connection con;
Statement st;
ResultSet rs;
ResultSetMetaData rsmd;
boolean flag = false;
%>
<html>
<body bgcolor = "abcdef">
<center>
<br><br><br>
<table border = 2>
<tr>
<%
String origin = request.getParameter("src");
String dest = request.getParameter("dest");
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
System.out.println("driver is loaded........");
con = DriverManager.getConnection("jdbc:odbc:msdsn");
System.out.println("got the con object ");
st = con.createStatement();
System.out.println("got the st object ");
rs = st.executeQuery("select * from Flightdetails");
System.out.println("got the rs object");
rsmd = rs.getMetaData();
System.out.println("got the rsmd object");
int cnt = rsmd.getColumnCount();
System.out.println("after the cnt " + cnt);
for(int i=1;i<=cnt;i++)
{
%>
<td bgcolor = "##ffccccc"> <%= rsmd.getColumnName(i) %> </td>
<%
}
%>
</tr>
<%
while(rs.next())
{
%>
<tr>
<%
for(int i=1;i<=cnt;i++)
{
%>
<td> <%= rs.getString(i) %> </td>
<%
}
%>
</tr>
<%
}
%>
this is my jsp code
in this code i have to give hyperlink to database(selected row must be deplay) |
| Answers |
Hi keerthi,
replace the line
<td> <%= rs.getString(i) %> </td>
with
<td><a href="#"><%= rs.getString(i)%></a></td>
This will give hyperlinks for all columns. To get only for first column, change the code like this:
for(int i=1;i<=cnt;i++)
{
if(i==1){
%>
<td><a href="#"><%= rs.getString(i)%></a></td>
<%}else{ %>
<td><%= rs.getString(i)%></td>
<%
}
}
I didn't understand about "selected row must be deplay"
Regards,
Sreenivas
|
| More Questions |
|
|
Post Answers
Ask Question
Facing Programming Problem?
|
|
|
|
|
