problem on jsp, inserting data into table(mysql).

problem on jsp, inserting data into table(mysql).

hello friends, I have a problem in jsp.I want to insert data, which is given by user through a html page into a table.And the table name also is given by the user.My database is in mysql.I want to use placeholder("?") to insert data into table.Plsssss help me... Thanks in advance.

View Answers

March 31, 2011 at 1:19 PM

1)form.html:

<html>
<form method="post" action="http://localhost:8080/examples/jsp/insertdata.jsp">
<table>
<tr><td>Table Name:</td><td><input type="text" name="tname"></td></tr>
<tr><td>Name:</td><td><input type="text" name="name"></td></tr>
<tr><td>Address:</td><td><input type="text" name="address"></td></tr>
<tr><td><input type="submit" value="Submit"></td></tr>
</table>
</form>
</html>

2)insertdata.jsp:

<%@page import="java.sql.*,java.util.*"%>
<%
String tname=request.getParameter("tname");
String name=request.getParameter("name");
String address=request.getParameter("address");
        try{
        Class.forName("com.mysql.jdbc.Driver");
        Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/test", "root", "root");
        PreparedStatement pst=con.prepareStatement("insert into "+tname+"(name, address)values(?,?)");

            pst.setString(1, name);
            pst.setString(2, address);
            pst.executeUpdate();
        con.close();
        out.println("Data is successfully inserted into database.");
        }
        catch(Exception e){
        System.out.println(e);
        }
        %>

Ads

Related Tutorials/Questions & Answers:

problem on jsp, inserting data into table(mysql).
problem on jsp, inserting data into table(mysql). hello friends, I have a problem in jsp.I want to insert data, which is given by user through a html page into a table.And the table name also is given by the user.My database

problem in inserting data in databases created in netbeans using jsp..
problem in inserting data in databases created in netbeans using jsp.. i am trying to make a virtual classroom website in jsp using netbeans.i created table inside netbeans through sql editor.and tried to make a login page whose

Advertisements

problem in inserting data in databases created in ecplise using jsp
problem in inserting data in databases created in ecplise using jsp <%@ page language="java" contentType="text/html; charset=ISO-8859-1...;table class="contact"> <tr><td align="right

problem in inserting data in databases created in ecplise using jsp
problem in inserting data in databases created in ecplise using jsp <%@ page language="java" contentType="text/html; charset=ISO-8859-1...;table class="contact"> <tr><td align="right

dynamic retrivel of data from mysql database in table format at jsp
dynamic retrivel of data from mysql database in table format at jsp ... the data from database and display it as table format in jsp... For example, i have... and also details of each member should be displayed in the table format in jsp

unable to display table data on JSP page that is coming from mysql and servlet.
unable to display table data on JSP page that is coming from mysql and servlet. I am unable to show table data on JSP page using servlet and mysql. only two rows data i showing but in my database I have five fields

unable to display table data on JSP page that is coming from mysql and servlet.
unable to display table data on JSP page that is coming from mysql and servlet. I am unable to show table data on JSP page using servlet and mysql. only two rows data i showing but in my database I have five fields

unable to display table data on JSP page that is coming from mysql and servlet.
unable to display table data on JSP page that is coming from mysql and servlet. I am unable to show table data on JSP page using servlet and mysql. only two rows data i showing but in my database I have five fields

Inserting values into a database table of selected DropDown in jsp.
Inserting values into a database table of selected DropDown in jsp. ... to insert all selected values in data base correspondent to each like if user selected india and then goa. I want to insert it to a table which has two fields

Data is not inserting correctly in mysql database.
Data is not inserting correctly in mysql database. Hello Sir, below is my code to insert data into database by list iteration... for each data cloumn ..at the time of end of the query... PLz see my code and point my

how to display data from mysql table in text box using jsp??
how to display data from mysql table in text box using jsp?? <p>hi, i have a written a code to display data from a mysql table into txtboxes... at line: 113 in the jsp file: /Cat1.jsp The local variable v_RGPC may not have

how to fetch data from mysql database table and draw a bar chart on that data using in jsp
how to fetch data from mysql database table and draw a bar chart on that data using in jsp how to create bar chart fetch data from mysql database using in jsp.please give me a right code. yhanks in advance

Retrive only requird data from a table in MYSQL databade to JSP file..on a field submit button.
Retrive only requird data from a table in MYSQL databade to JSP file..on a field submit button. i have MYSQL DB,DB NAME:TRLIST, TABLE NAME:TR_LIST... from table TR_LIST on typing TR values in an input-text-box and by clicking<

Implementing Bean with script let in JSP
it with script let of jsp for inserting the data in mysql table. In this example we create a jsp page for taking the user name to insert in the database table... Implementing Bean with script let in JSP

How to display data fom MySQL DataBase-table in to JSP file by submitting a value in combobox.
How to display data fom MySQL DataBase-table in to JSP file by submitting a value in combobox. I have the same problem.plz help me. I have MySQL DataBase/DB Name:lokesh; Table Name:TR_list; columns:nodename,packageno,TR

Records are not inserting in to main table while running the mysql stored procedure.
Records are not inserting in to main table while running the mysql stored... that procedure records are not inserted into main table from temp table.But im getting msg... me with this issue. My Code: BEGIN select concat('Inserting into SD

php inserting date into mysql
php inserting date into mysql php inserting date into mysql Here is a php code that inserts date into mysql database. In the given code, data is a database table. <?php table $query_manual = "INSERT INTO data

Insert Data in Table Using Stored Procedure
Insert Data in Table Using Stored Procedure In this example we are inserting data into a table using stored procedure. Steps: 1.Create database

Inserting values in MySQL database table
Inserting values in MySQL database table ... insert values in the MySQL database table. We know that tables store data in rows... the facility for inserting the values in MySQL database table. Description

data (image ,audio) inserting to data base (oracle 10g) and retriving the same data from jsp
data (image ,audio) inserting to data base (oracle 10g) and retriving the same data from jsp data (image ,audio) inserting to data base (oracle 10g) and retriving the same data from jsp with script of data base plz help me

How to insert data into MySQL Table?
How to insert data into MySQL Table? Hi, How to insert the data into MySQL Database? Please explain me with the examples and videos thanks. Thanks Hi, The insert into query is used to insert the data into MySQL

inserting dropdown values into database table
inserting dropdown values into database table hi i want to insert dropdown values into a database table by using jsp

JSP with Mysql
JSP with Mysql Hi sir, I trying to several time but i am not get an answer. My questions are 1. How to inserting same field data to different mysql table using jsp. That is creating a form with 5 fields,data's are same

Dynamic table data to Excel in JSP
Dynamic table data to Excel in JSP Iam trying to export dynamic data to excel . But it is displaying only static data .Kindly help viewtrial.jsp...() { document.form1.des.disabled=0; } function view_Table() { } function

To save table format data in pdf/excel in jsp
To save table format data in pdf/excel in jsp Hello, I am doing web application project in jsp. In webform ,I am displaying database data in html table. So my question is ,I want so save this html format data in pdf/excel format

Problem in enctype="multipart/form-data" in JSP
Problem in enctype="multipart/form-data" in JSP im using a page which is in JSP. i have some text boxes and one upload button. i want to load the file itself when i click the submit button. im using enctype="multipart/form-data

Problem in jsp.
Problem in jsp. hello friends, I have a problem in jsp.I want to insert data, which is given by user through a html page into a table.And the table..." action="http://localhost:8080/examples/jsp/insertdata.jsp"> <table> <

MySQL issue: Table 'data_dictionary.CHARACTER_SETS' doesn't exist
MySQL issue: Table 'data_dictionary.CHARACTER_SETS' doesn't exist MySQL issue: Table 'datadictionary.CHARACTERSETS' doesn't exist

Problem in jsp.
Problem in jsp. hello friends, I have a problem in jsp.I want to insert data, which is given by user through a html page into a table.And the table..." action="http://localhost:8080/examples/jsp/insertdata.jsp"> <table> <

Problem in jsp.
Problem in jsp. hello friends, I have a problem in jsp.I want to insert data, which is given by user through a html page into a table.And the table..." action="http://localhost:8080/examples/jsp/insertdata.jsp"> <table> <

MYSQL retrieve record from Data table
MYSQL retrieve record from Data table Hi. I have a field in database...,kanchipuram for a single record. I have to retrieve these data from the field table. Actually they are separated by comma. I want to take the values as single

Ads