Member Avatar for 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

  • 3 Contributors
  • 3 Replies
  • 124 Views
  • 8 Hours Discussion Span
  • Latest Post Latest Post by kvprajapati
Member Avatar for kvprajapati

Using request, response and SQL API.

Member Avatar for 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?

Member Avatar for 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");
  ...
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.