display corresponding values

[gautam.ap]

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

[kvprajapati]

Using request, response and SQL API.

[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?

[kvprajapati]

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.

...
   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");
  ...