Member Avatar for muhammed.anas.7583

I develop a project that consist of many tables. In admin menu table names shows dynamically in a dropdownlist from a database. Pls help me to do this

  • 3 Contributors
  • 3 Replies
  • 192 Views
  • 1 Month Discussion Span
  • Latest Post Latest Post by radhakrishna.p
Member Avatar for pritaeas

What exactly do you need help with?

Member Avatar for muhammed.anas.7583

In my page iam getting all column names of a particular table with checkboxes. when iam select one or more checkboxes i have to get data of that selected columns only. what is the jsp code for this.

Member Avatar for radhakrishna.p

move the selected column names and table to another page where you want to display the details and there you have to format these two things as the actual sql-query

for example :

anotherPage.jsp

<%
String tab_name = request.getParameter("table_name");
String col_name1 = request.getParameter("column_name1");
String col_name2 = request.getParameter("column_name2");
.
.
.
.

// and make query_string as follows

String sql_query = "Select "+col_name1+","+col_name2+" from "+tab_name;

// then create connection object ,retrive details 
%>

then the remaing code is as it is

Edited by pritaeas because: Added code tags.
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.