inteconnecting forms

View Answers

April 2, 2009 at 3:40 PM

Hi friend,

Following code will be helpful for you.

step1) Create a form in jsp page to enter table name.

<html>
<form name="form" action="retrieveData.jsp" method="post">
<table>
<tr><td>Enter table name:</td><td><input type="text" id="name" name="name"></td>
<tr><td><input type="submit" value="Submit"></td></tr>
</form>
</html>

step2) Now to retrieve the data of entered table name,create another jsp page.

<%@ page import="java.sql.*"%>
<%@ page import="java.io.*" %>
<html>
<head>
<title>database connectivity</title>
</head>
<body>
<%
try{
Class.forName("com.mysql.jdbc.Driver");
Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/register","root","root";);
Statement stmt=con.createStatement();
String table=request.getParameter("name");
ResultSet rs=null ;
DatabaseMetaData meta = con.getMetaData();
rs = meta.getTables(null, null, null, new String[]{"TABLE"});
String tableName=null;
while (rs.next()) {
tableName = rs.getString("TABLE_NAME");
if(table.equals(tableName)){
out.println("Table Name= "+tableName);
out.println("<br>");
String strquery = "select * from "+tableName;
rs=stmt.executeQuery(strquery);
ResultSetMetaData md=rs.getMetaData();
int col= md.getColumnCount();
for (int i=0; i<col; i++) {
out.println(md.getColumnName(i+1));
}
out.println("<br>");
while(rs.next()){
for (int i=0; i<col; i++) {
out.println(rs.getString(i+1)+"\t");
}
out.println("<br>");
}
}
}
if(table.equals("")){
out.println("Enter table");
}
else if(!table.equals(tableName)) {
out.println("Table does not exist");
}
con.close();
}
catch(SQLException e) {
out.println("exception occured" +e);
}
%>
</body>
</html>

Thanks









Related Tutorials/Questions & Answers:
inteconnecting forms - JSP-Servlet
inteconnecting forms  hi, i have several tables in mysql database. i am creating some forms using jsp. i want to enter the name of the table and to get the table specified in the entry box to be displayed in the output
use forms.
use forms.  How do I use forms
Advertisements
Version of jgoodies>forms dependency
List of Version of jgoodies>forms dependency
Version of swt>forms dependency
List of Version of swt>forms dependency
Version of com.jgoodies>forms dependency
List of Version of com.jgoodies>forms dependency
use tables to structure forms
use tables to structure forms  How can I use tables to structure forms
use tables to structure forms
use tables to structure forms  How can I use tables to structure forms
tables to structure forms
tables to structure forms  How can I use tables to structure forms
tables to structure forms
tables to structure forms  How can I use tables to structure forms
Two forms and One Servlet
Two forms and One Servlet  Dear Sir, I have 2 forms in one page and one submit button into second form which submits data to one servlet. If I do... get both forms textbox value. Thanks in advance
JAVA BEAN WITH ORACLE FORMS
JAVA BEAN WITH ORACLE FORMS  Hi..I am doing my final year Project.. I need the ste-by-step procedure to integrate a bean with oracle forms? Please help me
Version of cocoon>cocoon-forms dependency
List of Version of cocoon>cocoon-forms dependency
Version of com.intellij>forms_rt dependency
List of Version of com.intellij>forms_rt dependency
Version of com.jgoodies>jgoodies-forms dependency
List of Version of com.jgoodies>jgoodies-forms dependency
ModuleNotFoundError: No module named 'aldryn-forms'
ModuleNotFoundError: No module named 'aldryn-forms'  Hi, My Python... 'aldryn-forms' How to remove the ModuleNotFoundError: No module named 'aldryn-forms' error? Thanks   Hi, In your python
ModuleNotFoundError: No module named 'aldryn-forms'
ModuleNotFoundError: No module named 'aldryn-forms'  Hi, My Python... 'aldryn-forms' How to remove the ModuleNotFoundError: No module named 'aldryn-forms' error? Thanks   Hi, In your python
ModuleNotFoundError: No module named 'aldryn-forms'
ModuleNotFoundError: No module named 'aldryn-forms'  Hi, My Python... 'aldryn-forms' How to remove the ModuleNotFoundError: No module named 'aldryn-forms' error? Thanks   Hi, In your python
ModuleNotFoundError: No module named 'capybara-forms'
ModuleNotFoundError: No module named 'capybara-forms'  Hi, My... named 'capybara-forms' How to remove the ModuleNotFoundError: No module named 'capybara-forms' error? Thanks   Hi, In your python
ModuleNotFoundError: No module named 'cms-forms'
ModuleNotFoundError: No module named 'cms-forms'  Hi, My Python... 'cms-forms' How to remove the ModuleNotFoundError: No module named 'cms-forms' error? Thanks   Hi, In your python environment you
ModuleNotFoundError: No module named 'Constellation-Forms'
ModuleNotFoundError: No module named 'Constellation-Forms'  Hi, My... named 'Constellation-Forms' How to remove the ModuleNotFoundError: No module named 'Constellation-Forms' error? Thanks   Hi
ModuleNotFoundError: No module named 'djangocms-forms'
ModuleNotFoundError: No module named 'djangocms-forms'  Hi, My... named 'djangocms-forms' How to remove the ModuleNotFoundError: No module named 'djangocms-forms' error? Thanks   Hi, In your python
ModuleNotFoundError: No module named 'dynamic-forms'
ModuleNotFoundError: No module named 'dynamic-forms'  Hi, My... 'dynamic-forms' How to remove the ModuleNotFoundError: No module named 'dynamic-forms' error? Thanks   Hi, In your python
ModuleNotFoundError: No module named 'forms_extras'
ModuleNotFoundError: No module named 'forms_extras'  Hi, My Python... 'forms_extras' How to remove the ModuleNotFoundError: No module named 'forms_extras' error? Thanks   Hi, In your python
ModuleNotFoundError: No module named 'google_forms'
ModuleNotFoundError: No module named 'google_forms'  Hi, My Python... 'google_forms' How to remove the ModuleNotFoundError: No module named 'google_forms' error? Thanks   Hi, In your python
ModuleNotFoundError: No module named 'manhattan-forms'
ModuleNotFoundError: No module named 'manhattan-forms'  Hi, My... named 'manhattan-forms' How to remove the ModuleNotFoundError: No module named 'manhattan-forms' error? Thanks   Hi, In your python
ModuleNotFoundError: No module named 'needle-forms'
ModuleNotFoundError: No module named 'needle-forms'  Hi, My Python... 'needle-forms' How to remove the ModuleNotFoundError: No module named 'needle-forms' error? Thanks   Hi, In your python
ModuleNotFoundError: No module named 'normal-forms'
ModuleNotFoundError: No module named 'normal-forms'  Hi, My Python... 'normal-forms' How to remove the ModuleNotFoundError: No module named 'normal-forms' error? Thanks   Hi, In your python
ModuleNotFoundError: No module named 'normal-forms'
ModuleNotFoundError: No module named 'normal-forms'  Hi, My Python... 'normal-forms' How to remove the ModuleNotFoundError: No module named 'normal-forms' error? Thanks   Hi, In your python
ModuleNotFoundError: No module named 'omero-forms'
ModuleNotFoundError: No module named 'omero-forms'  Hi, My Python... 'omero-forms' How to remove the ModuleNotFoundError: No module named 'omero-forms' error? Thanks   Hi, In your python environment
ModuleNotFoundError: No module named 'pulpo-forms'
ModuleNotFoundError: No module named 'pulpo-forms'  Hi, My Python... 'pulpo-forms' How to remove the ModuleNotFoundError: No module named 'pulpo-forms' error? Thanks   Hi, In your python environment
ModuleNotFoundError: No module named 'pulpo-forms'
ModuleNotFoundError: No module named 'pulpo-forms'  Hi, My Python... 'pulpo-forms' How to remove the ModuleNotFoundError: No module named 'pulpo-forms' error? Thanks   Hi, In your python environment
ModuleNotFoundError: No module named 'pyoracle-forms'
ModuleNotFoundError: No module named 'pyoracle-forms'  Hi, My... named 'pyoracle-forms' How to remove the ModuleNotFoundError: No module named 'pyoracle-forms' error? Thanks   Hi, In your python
ModuleNotFoundError: No module named 'semanticui_forms'
ModuleNotFoundError: No module named 'semanticui_forms'  Hi, My... named 'semanticui_forms' How to remove the ModuleNotFoundError: No module named 'semanticui_forms' error? Thanks   Hi, In your
ModuleNotFoundError: No module named 'tornado-forms'
ModuleNotFoundError: No module named 'tornado-forms'  Hi, My... 'tornado-forms' How to remove the ModuleNotFoundError: No module named 'tornado-forms' error? Thanks   Hi, In your python
ModuleNotFoundError: No module named 'aldryn-forms'
ModuleNotFoundError: No module named 'aldryn-forms'  Hi, My Python... 'aldryn-forms' How to remove the ModuleNotFoundError: No module named 'aldryn-forms' error? Thanks   Hi, In your python
ModuleNotFoundError: No module named 'capybara-forms'
ModuleNotFoundError: No module named 'capybara-forms'  Hi, My... named 'capybara-forms' How to remove the ModuleNotFoundError: No module named 'capybara-forms' error? Thanks   Hi, In your python
ModuleNotFoundError: No module named 'cms-forms'
ModuleNotFoundError: No module named 'cms-forms'  Hi, My Python... 'cms-forms' How to remove the ModuleNotFoundError: No module named 'cms-forms' error? Thanks   Hi, In your python environment you
ModuleNotFoundError: No module named 'Constellation-Forms'
ModuleNotFoundError: No module named 'Constellation-Forms'  Hi, My... named 'Constellation-Forms' How to remove the ModuleNotFoundError: No module named 'Constellation-Forms' error? Thanks   Hi
ModuleNotFoundError: No module named 'djangocms-forms'
ModuleNotFoundError: No module named 'djangocms-forms'  Hi, My... named 'djangocms-forms' How to remove the ModuleNotFoundError: No module named 'djangocms-forms' error? Thanks   Hi, In your python
ModuleNotFoundError: No module named 'djinn_forms'
ModuleNotFoundError: No module named 'djinn_forms'  Hi, My Python... 'djinn_forms' How to remove the ModuleNotFoundError: No module named 'djinn_forms' error? Thanks   Hi, In your python environment
ModuleNotFoundError: No module named 'dougrain-forms'
ModuleNotFoundError: No module named 'dougrain-forms'  Hi, My... named 'dougrain-forms' How to remove the ModuleNotFoundError: No module named 'dougrain-forms' error? Thanks   Hi, In your python
ModuleNotFoundError: No module named 'dynamic-forms'
ModuleNotFoundError: No module named 'dynamic-forms'  Hi, My... 'dynamic-forms' How to remove the ModuleNotFoundError: No module named 'dynamic-forms' error? Thanks   Hi, In your python
ModuleNotFoundError: No module named 'forms_extras'
ModuleNotFoundError: No module named 'forms_extras'  Hi, My Python... 'forms_extras' How to remove the ModuleNotFoundError: No module named 'forms_extras' error? Thanks   Hi, In your python
ModuleNotFoundError: No module named 'frasco-forms'
ModuleNotFoundError: No module named 'frasco-forms'  Hi, My Python... 'frasco-forms' How to remove the ModuleNotFoundError: No module named 'frasco-forms' error? Thanks   Hi, In your python
ModuleNotFoundError: No module named 'genshi-forms'
ModuleNotFoundError: No module named 'genshi-forms'  Hi, My Python... 'genshi-forms' How to remove the ModuleNotFoundError: No module named 'genshi-forms' error? Thanks   Hi, In your python
ModuleNotFoundError: No module named 'gnue-forms'
ModuleNotFoundError: No module named 'gnue-forms'  Hi, My Python... 'gnue-forms' How to remove the ModuleNotFoundError: No module named 'gnue-forms' error? Thanks   Hi, In your python environment you
ModuleNotFoundError: No module named 'google_forms'
ModuleNotFoundError: No module named 'google_forms'  Hi, My Python... 'google_forms' How to remove the ModuleNotFoundError: No module named 'google_forms' error? Thanks   Hi, In your python
What are different normalization forms?
What are different normalization forms?  What are different normalization forms?   Hi, 1NF: Eliminate Repeating Groups- Make a separate table for each set of related attributes, and give each table a primary key. Each
Maven Dependency forms >> 1.0.4
You should include the dependency code given in this page to add Maven Dependency of jgoodies >> forms version1.0.4 in your project
Maven Dependency forms >> 1.0.5
You should include the dependency code given in this page to add Maven Dependency of jgoodies >> forms version1.0.5 in your project

Questions by Category