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 name also is given by the user.My database is in mysql.Plsssss help me... Thanks in advance.

View Answers

March 31, 2011 at 11:45 AM

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");
        Statement st=con.createStatement();
        int i=st.executeUpdate("insert into "+tname+"(name, address)values('"+name+"','"+address+"')");
        con.close();
        out.println("Data is successfully inserted into database.");
        }
        catch(Exception e){
        System.out.println(e);
        }
        %>

March 31, 2011 at 12:00 PM

How the data can be inserted with placeholder?

Ads

Advertisements

Jsp problem
Jsp problem Hello friends.I want to share my jsp problem.I want to show all of my database(mysql) tables except two(user,manufacturer) in a jsp page.plssss help me

jsp problem
jsp problem problem:::::::: On JSP form ,when i insert data in text field........at that time action is perform and data is retriev from data base and get assign to other field on that form........ when data is assign to other

jsp problem
jsp problem Hello Friends, I want to show one page for 5 seconds and after that i want to redirect the page to another URL

jsp problem
jsp problem Hi every one plz give me answer for below question ASAP I created one JSP(used pre defined javascript in jsp to get rtf format in browser) which creats RTF Format in browser to enter data. MY question is after i

JSP Problem - JSP-Servlet
JSP Problem Hi, I have problem,this is my senario I have one jsp,this jsp having the 3 fields.let me take 3fields userName,emailAddress... for more information, http://www.roseindia.net/jsp Thanks

jsp problem - JSP-Servlet
jsp problem here is a code for Retrieving image from mysql database through jsp. but i cann't set size of image when it was display so what should... working but my problem is size of image. so can u just help?? code

jsp problem - JSP-Servlet
jsp problem hi, i am working on a project of developing a shopping cart for online book store.can it be done using jsp?if yes, can u please help me doing so? Hi Friend, Please visit the following link: http

problem in programming - JSP-Servlet
problem in programming Hi! I am new with jsp. I am facing a problem in programming to calculate the time interval between login time and logout time of user

problem in jsp programming - JSP-Servlet
problem in jsp programming Write a JSP program which displays a webpage containing arrival of new items within a particular month in the different... in solving the problem : Connection with mysql database

jsp code problem - JSP-Servlet
jsp code problem Hi, I have employee details form in jsp. After... have a problem with open the next form. plz, help me. thanks, Hi.... http://www.roseindia.net/jsp/ Thanks

Session Problem in JSP - JSP-Servlet
Session Problem in JSP I have developed a online feedback form in JSP platform. I have created normal session in JSP page. It is running in my... normally from Remote machine by only writing JSP code. Hi friend

jsp usebean problem - Struts
popupwindow jsp below code run.. ...here iam getting the problem..in the below...jsp usebean problem --Select... jsp

jsp reload current page problem
jsp reload current page problem Hi, i am facing problem while reloading the JSP page

logout problem?? - JSP-Servlet
logout problem?? sir, the logout code which u have send is not the proper solution coz,by using this code the browser get closed which shuold.../Logout.shtml http://www.roseindia.net/jsp/loginstatus.shtml Thanks

logout problem.. - JSP-Servlet
logout problem.. hi... first of all thanks for ur... but their is some problem with the the logout,i m not able to logout when... done in the code i have used session object in project's servlet and jsp

coding problem - JSP-Servlet
coding problem dear sir i m very new to JSP sir i m getting problem in dynamically changing the option of combobox from database(ms acess) .and after that option being selected for that the record from the databse should

jsp image problem - JSP-Servlet
jsp image problem hi everyone, How to display multiple images from mysql database to jsp page. please help me

JSP code problem - JSP-Servlet
JSP code problem Hi friends, I used the following code...: <% //to get the content type information from JSP... of: Please can somebody rectify this problem........

Jsp Code Problem - JSP-Servlet
Jsp Code Problem I use DocType in my Jsp Page. The Links are not functioned after Applying the DocType. Could you tell me any way to activate the link. Thank You. Hi Friend, Please send your code. Thanks

JSP code problem - JSP-Servlet
JSP code problem HI.. I have a DB2 stored procedure wich return a result set. I have made a report basing on this procedure using Crystal Reports. How to pass parameters to this procedure with java code in a JSP page

jsp code problem - JSP-Servlet
jsp code problem i want to make the bill from the barcode. how do i convert a barcode into a decimal number

Java Problem - JSP-Servlet
Java Problem How to run a Simple JSP program ? what steps... the webapps folder of apache tomcat. 5)Create a jsp file 'hello.jsp'.You can put your jsp file either inside the web application folder along with WEB-INF or you

Jsp ,Servlet Problem - JSP-Servlet
Jsp ,Servlet Problem hi, m new to jsp n Servlet. i really find ur tricks very effective.Last time u had helped me to connect my java program with oracle. it worked wonders. now i m starting jsp n servlet learning.. pls

Radio Button Problem in jsp.
Radio Button Problem in jsp. I have a small doubt in my application, my requirement is to get a "single selectible row", I generated a radio button... radio button values from jsp to action using javascript

tomcat problem - JSP-Servlet
perfectly. Kindly let me know what is the problem at an earliest. Thanking... found your problem.. http://www.roseindia.net/web-application-server/tomcat

coding problem - JSP-Servlet
coding problem dear sir will u plz tell me how can we delete a record from the database(MSaccess) when option in the combobox is selected(jsp) If u want to delete the record from database, by seleting

Ads