Ad:

JSP Discussion Thread
Unsolved
Views: 531

Jun 4th, 2009

display corresponding values

Expand Post »

Hi, everyone i want to display the corresponding values when i click on the primary key ... How to do this in jsp...???

Thanks in advance

Similar Threads

Cannot display values of the array in Java
Display values in these arrays in Java
Display values in listbox from db table regarding selected item in listbox? in PHP
display values from one page to another page in ASP.NET
counting a few numbers and storing the values in C++

gautam.ap

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

1 posts
since Jun 2009

Permalink

Jun 4th, 2009

Re: display corresponding values

Using request, response and SQL API.

adatapost

Moderator

Reputation Points: 2136

Solved Threads: 1228

Posting Genius

Offline

6,527 posts
since Oct 2008

Permalink

Jun 4th, 2009

Re: display corresponding values

request method is one of the more basic one you sure u dont know that? or are you facing a different set of problem?

dreamer14

Reputation Points: 10

Solved Threads: 1

Light Poster

Offline

31 posts
since Sep 2008

Permalink

Jun 4th, 2009

Re: display corresponding values

Click to Expand / Collapse Quote originally posted by dreamer14 ...

request method is one of the more basic one you sure u dont know that? or are you facing a different set of problem?

Why you are not coding? Please code and if you get some problems then ask for help.

Jsp Syntax (Toggle Plain Text)
  ...
   Class.forName("DB Driver");
   Connection cn=DriverManager.getConnection(url,username,password);
   Statement st=cn.createStatement();
   ResultSet rs=st.executeQuery("select * from tab where pkcol='" + request.getParameter("pk_text") + "'");
  if(rs.next()) {  // Found
          ....
          out.println(rs.getString(1) + ...... );
  }
 else
       out.println("Not found");
  ...
  ...
   Class.forName("DB Driver");
   Connection cn=DriverManager.getConnection(url,username,password);
   Statement st=cn.createStatement();
   ResultSet rs=st.executeQuery("select * from tab where pkcol='" + request.getParameter("pk_text") + "'");
  if(rs.next()) {  // Found
          ....
          out.println(rs.getString(1) + ...... );
  }
 else
       out.println("Not found");
  ...

adatapost

Moderator

Reputation Points: 2136

Solved Threads: 1228

Posting Genius

Offline

6,527 posts
since Oct 2008

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in JSP Forum Timeline: email sendin with jsp

Next Thread in JSP Forum Timeline: Session in jsp

DaniWeb Message

Cancel Changes

User Name
Password