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 reload current page problem
jsp reload current page problem Hi, i am facing problem while reloading the JSP page

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

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

Statistical charts in JSP - problem
Statistical charts in JSP - problem hey! i get this error when i run... org.apache.jasper.JasperException: Unable to compile class for JSP: An error occurred... An error occurred at line: 11 in the jsp file: /BarChart.jsp

JSP run problem
JSP run problem type Exception report message description... this request. exception org.apache.jasper.JasperException: Exception in JSP...) root cause java.lang.NullPointerException org.apache.jsp.bb_jsp

jsp and bean problem
jsp and bean problem Hi i have the following jsp code... Can you plz help me in separating the code to bean? I'm new to bean and need it for my project...Plz help...Its quite urgent... Regards Priya <%@ page import

Problem in record viewing in jsp - JSP-Servlet
Problem in record viewing in jsp hai i have developed the application using jsp,servlets in eclipse ide i have to insert,delete,update and view . no problem all are working but in view part alone some problem i dont know what

problem in record viewing in jsp - JSP-Servlet
problem in record viewing in jsp hai i send the code can you please find where is the problem it is not showing any error but i cannot able to view the record after eclipse ide is closed and reopen it i have used the jsp

problem in jsp using ms-access
problem in jsp using ms-access after starting server(tomcat) wen v...)Your DSN will get created. 6) Restart your server and run your jsp code. Here... will get created. 6) Restart your server and run your jsp code. Here is your

JSP - Problem of displaying result at webpage
JSP - Problem of displaying result at webpage Can anyone please help to solve my problem below. My webpage has problem in displaying result position. The result should be display below my title. How do i solve it? Thank you so

Java Servlet Problem - JSP-Servlet
method. Please help!! Hi friend, Please explain problem in details for complete solution and send code the where are you problem. Thanks

problem at the time of execution - JSP-Servlet
problem at the time of execution when i was running web applications the exception i.e 404 resource is not available what it means and where it occures what is the solution Hi Friend, This error occurs when

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

Jsp/java-script, spring combination problem
Jsp/java-script, spring combination problem Hi Friends....... I am developing one application using jsp,spring,java script,hibernate,Pojo There is one Jsp form on that I want data as location and ward wise; There is two

problem of static in jsp page by multiple user access
problem of static in jsp page by multiple user access hi , i am continuing my online exam project,but i have a Singleton class which i am invoking from my jsp page , ths page can access by more number of users .every user

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 uploaded value. but the problem is the uploaded file is not stored

Struts2...problem in JSP..unable to get the values for menuTitle!!!
Struts2...problem in JSP..unable to get the values for menuTitle!!! ......n m fairly new in this framework.. there is some problem in this project...my Jsp is displaying the menuId from database but not the menuTitle...where as its

problem in sending more than 500 values to a jsp page
problem in sending more than 500 values to a jsp page when i am trying to send more than 500 values from a html form to a jsp page browser is showing that server is not sending any data...I have configured tomcat5.5

problem in creating web application using servelet, jsp, jdbc and xml - JSP-Servlet
problem in creating web application using servelet, jsp, jdbc and xml Using Servlet, JSP, JDBC and XML create a web application for a courrier...; Hi friend, For solving the problem visit to : http://www.roseindia.net

Problem passing a value from one jsp to another using href
Problem passing a value from one jsp to another using href first page.jsp <a href="common.jsp?param=<%l.get(k).parentname%>"> common.jsp <%String attr=request.getAttribute("param"); out.print(attr

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

this code will be problem it display the error again send jsp for registration form
this code will be problem it display the error again send jsp for registration form I AM ENTERING THE DETAILS OFTER IT DISPLAY THE ERROR PLEASE RESEND THE CODE org.apache.jasper.JasperException: java.lang.NumberFormatException

Ads