getting int values from form and insert it in data base in jsp

how can i get form input such as id convert it to int insert it into database

View Answers

December 26, 2010 at 7:35 PM

Hi,

You can get the parameter from the request object:

String s = request.getParameter("formfieldname");

Then convert it into Integer variable:

int i = Integer.parseInt(s);

Then you can write JDBC code to insert data into database.

Read JDBC Insert Statement Example for more detail.

Thanks

December 27, 2010 at 10:57 AM

Hi Friend,

Try the following code:

1)form.jsp:

<%@page import="java.sql.*"%>
<html>
<form method="post" action="insertdata.jsp">
<table>
<tr><td>Name:</td><td><input type="text" name="name"></td></tr>
<tr><td>Age:</td><td><input type="text" name="age"></td></tr>
<tr><td>Address:</td><td><input type="text" name="address"></td></tr>
<tr><td></td><td><input type="submit" value="Submit"></td></tr>
</table>
</form>
</html>

2)insertdata.jsp:

<%@page import="java.sql.*"%>
<%
String name=request.getParameter("name");
int age=Integer.parseInt(request.getParameter("age"));
String address=request.getParameter("address");
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
           Connection con = DriverManager.getConnection("jdbc:odbc:student");
           Statement st=con.createStatement();
           int i=st.executeUpdate("insert into data(name,age, address) values('"+name+"',"+age+",'"+address+"')");
         con.close();
         out.println("Data is successfully inserted into database.");
}
catch(Exception e){
    System.out.println(e);

}
         %>

Thanks

Ads

Advertisements

how to insert the bulk data into the data base from the table of jsp page to another jsp page
how to insert the bulk data into the data base from the table of jsp page... to insert the marks details into the data base i have retrive the rollno and name... to get values in array in next jsp page and insert into the row by row Please do

how to insert values from jsp into ms access
how to insert values from jsp into ms access how to insert values using jsp into ms access database

How to insert data into databse by JSP form registration page in netbeans
How to insert data into databse by JSP form registration page in netbeans ... of data for login purpose. I have created 1 form in JSP netbeans with both username...; password, & after submitting this form it automatically stores data

How to retrieve array values from html form to jsp?
How to retrieve array values from html form to jsp? Hi! I am... it into jsp. Means i just want to retrieve values from html form containing array... sample code for how to retrive array values from html to jsp. hi friend

Retrieving data from data base using jsp combo box
Retrieving data from data base using jsp combo box Hi guys please help me , i have on GUI page int that Server type(like apache,jboss,weblogic) one... of the server it has to display the process name from database into the process name

Displaying the values in text fields of a form from a javascript function in jsp
Displaying the values in text fields of a form from a javascript function... to call a javascript function by passing 3 values from applet. And i have to display these values in 3 text fields of a form in the current web page. Here form

Pass values from form to form
Pass values from form to form Java program to pass values from one form to another form... values from one page to another consecutive page which is being called then we can

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

value is inserted into the sql table through jsp-jdbc but not getting stored into the data base,only row is increasing.
value is inserted into the sql table through jsp-jdbc but not getting stored into the data base,only row is increasing. <html> <... ="INSERT INTO demodb VALUES('"+name+"','"+email+"','"+password

getting values from dropdown list
getting values from dropdown list I am having a dropdown list which has hardcoded values ( we need it hardcoded only and will not be populated from... to the action. My action is getting called however, i am not sure how to pass

Insert Data From File
Insert Data From File Insert Data From File is used to insert data from file... to insert data from file. To understand this example, we create a table 'Stu_Table

JSP data base validation
JSP data base validation please explain how to validate form input string with database n also how its notify that entered data exists already... into student2(id, sName, phno) values(?,?,?)"; String sql2 = "select * from student2

Wrong parameter values while exporting data from jsp to excel
Wrong parameter values while exporting data from jsp to excel This is a jsp report. When i export the report data to an excel, the parameter values on the html report do not match those in the downloaded spreadsheet

data fecth from data base in( sql 2000) htmlform and jsp
data fecth from data base in( sql 2000) htmlform and jsp hi iam using jsp and html form data fecth from database display the textbox help me i want whenever select from dropdown list select the projectname to display

Insert Data From File
Insert Data From File Insert Data From File is used to insert data from file... to insert data from file. To understand this example, we create a table 'Stu_Table

Getting data from servlet into javascript
Getting data from servlet into javascript How do i get json data from my servlet on to a variable in javascript n bind the data to display onto sigma grid.Has anyone Idea how to do

Retrive values from an arraylist and display in a jsp?
Retrive values from an arraylist and display in a jsp? Hi, I need help in jsp to display values of an ArrayList in jsp. There is a java file... of the ArrayList in jsp in a tabular form/way. if (request.getParameter("action

FAILED TO INSERT DATA FROM FUNCTION();
FAILED TO INSERT DATA FROM FUNCTION(); HELLO, I HAVE A PROBLEM TO INSERT DATA FROM OUTPUT FROM FUNCTION()... I WANT TO STORE THE OUTPUT IN DATABASE... bigMac_ac1(){ $sql = "INSERT INTO fkpacademia (MAC) VALUES ('$row1['AVG(MAC

insert values from excel file into database
insert values from excel file into database hi i want to insert values from Excel file into database.Whatever field and contents are there in excel... the following link: Insert values from excel file to database

how to insert array data into sql server using jsp
how to insert array data into sql server using jsp hello, i have problem to insert array data into my sql server from jsp form. beloW is my code... from form, but not insert into my sql database. try { //String

Getting Textbox data from database
Getting Textbox data from database When i m trying to get data in textbox as readonly from database i m getting following error.and my code is shown... data from database and display it on the textboxes. <%@page language="java

what is the jsp coding to insert a data in database tables
what is the jsp coding to insert a data in database tables Dear Sir, I Want to know the coding for insert the data from jsp to oracle database.. my... that insert the form values to MySQL database. 1)register.jsp: <html> <form

code for insert the value from jsp to access database
code for insert the value from jsp to access database code for insert the value from jsp to access database

Getting Textbox data from database
Getting Textbox data from database When i m trying to get data in textbox as readonly from database i m getting following error.and my code is shown...;Here is a jsp code that retrieves data from database and display

How to Retrieve data from database in jsp
How to Retrieve data from database in jsp In this section we will discuss about how to fetch data from database table. We will give a simple example which... is the video tutorial of "How to retrieve data from database and Display in JSP Page

how to read data from excel file through browse and insert into oracle database using jsp or oracle???
how to read data from excel file through browse and insert into oracle database using jsp or oracle??? sir.. i have number of excel sheets which... a browse button which can upload a excelfile and after uploading the data should

how to insert data in database using html+jsp
how to insert data in database using html+jsp anyone know what... = null; // declare a resultset that uses as a table for output data from... = 0; // sql query to retrieve values from the specified

How to pass multiple values from a servlet to JSP?
How to pass multiple values from a servlet to JSP? hi, I want to pass multiple values form a servlet to JSP. Hw do i do that? I am able to send one value at a time without any prb, but I am unable to carry multiple (from two

Ads