how to insert data in database using html+jsp

anyone know what is wrong with my code?

    print("<%


          /* Create string of connection url within specified format with machine
          name, port number and database name. Here machine name id localhost and 
          database name is student. */
        String URL = "jdbc:oracle:thin:@10.2.160.244:1521:prodasdb";

          // declare a connection by using Connection interface
        Connection conn = null;

          /* declare object of Statement interface that is used for executing sql 
          statements. */
        Statement stmt = null;

          // declare a resultset that uses as a table for output data from tha table.
        ResultSet rs = null;

          // Load JBBC driver "com.mysql.jdbc.Driver"
        Class.forName("oracle.jdbc.OracleDriver").newInstance();

          /* Create a connection by using getConnection() method that takes parameters 
          of string type connection url, user name and password to connect to database.*/
        conn = DriverManager.getConnection(URL, "qascodvp", "qascodvp");

          /* createStatement() is used for create statement object that is used for 
          sending sql statements to the specified database. */
        stmt = conn.createStatement();

        String PID = request.getParameter("PID");
        String MSG_TEXT = request.getParameter("msg_text");

        PreparedStatement pstatement = null;
        int updateQuery = 0;





          // sql query to retrieve values from the specified table.



        String QueryString = "insert into xxqc_announcement(PID,msg_text) values (?,?)";
                pstatement = conn.prepareCall(QueryString);
       pstatement.setString(1,PID);
       pstatement.setString(2,MSG_TEXT);

       updateQuery = pstatement.executeUpdate();



%>
 ");

<form action="index.jsp" method="get">

    <input style="width: 850px; " type="text" name="msg_text" />

    <input style=" background-color: #999999; color: white" type="submit" value="Save" />
    </form>

View Answers

August 1, 2011 at 3:45 PM

Here we have used MySQL database:

1)form.html:

<html>
<form method="post" action="http://localhost:8080/examples/jsp/insert.jsp">
<table>
<tr><td>First Name:</td><td><input type="text" name="fname"></td></tr>
<tr><td>Last Name:</td><td><input type="text" name="lname"></td></tr>
<tr><td>Email:</td><td><input type="text" name="email"></td></tr>
<tr><td>Password:</td><td><input type="password" name="pass"></td></tr>
<tr><td>Confirm Password:</td><td><input type="password" name="cpass"></td></tr>
<tr><td>Date Of Birth</td><td><input type="text" name="dob"></td></tr>
<tr><td>Age:</td><td><input type="text" name="age"></td></tr>
<tr><td>Gender</td><td><input type="text" name="gender"></td></tr>
<tr><td>Address:</td><td><input type="text" name="address"></td></tr>
<tr><td>Country</td><td><input type="text" name="country"></td></tr>
<tr><td>State:</td><td><input type="text" name="state"></td></tr>
<tr><td>City</td><td><input type="text" name="city"></td></tr>
<tr><td>Telephone No:</td><td><input type="text" name="tno"></td></tr>
<tr><td>Mobile:</td><td><input type="text" name="mobile"></td></tr>
<tr><td></td><td><input type="submit" value="Submit"></td></tr>
</table>
</form>
</html>

2)insert.jsp:

<%@page import="java.sql.*,java.util.*"%>
<%
String fname=request.getParameter("fname");
String lname=request.getParameter("lname");
String email=request.getParameter("email");
String pass=request.getParameter("pass");
String cpass=request.getParameter("cpass");
String dob=request.getParameter("dob");
int age=Integer.parseInt(request.getParameter("age"));
String gender=request.getParameter("gender");
String address=request.getParameter("address");
String country=request.getParameter("country");
String state=request.getParameter("state");
String city=request.getParameter("city");
int telephone=Integer.parseInt(request.getParameter("tno"));
int mobile=Integer.parseInt(request.getParameter("mobile"));
        try{
         Class.forName("com.mysql.jdbc.Driver");
           Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/roseindia", "root", "root");
           Statement st=con.createStatement();
           int i=st.executeUpdate("insert into student(firstname,lastname,email,pass,confirm_pass,dob,age,gender,address,country,state,city,telephone,mobile) values('"+fname+"','"+lname+"','"+email+"','"+pass+"','"+cpass+"','"+dob+"',"+age+",'"+gender+"','"+address+"','"+country+"','"+state+"','"+city+"',"+telephone+","+mobile+")");
        out.println("Data is successfully inserted!");
        }
        catch(Exception e){
        System.out.print(e);
        e.printStackTrace();
        }
        %>

Advertisements

how to insert data from database using oops concepts - Development process
how to insert data from database using oops concepts Hi, How to insert data from database using oops based concepts.please write the code... the following code: import java.sql.*; class Insert{ public static String url

How to insert data from textfields into database using hibernate?
How to insert data from textfields into database using hibernate? try{ Session session = HibernateUtil.getSessionFactory().openSession...); System.out.println("Successfully data insert in database"); tx.commit

insert data in the database using checkbox
insert data in the database using checkbox i am fetching data from the database using servlet on the jsp page and there is checkbox corresponding... should i insert only checked data into database on submission. We

How to insert multiple drop down list data in single column in sql database using servlet
How to insert multiple drop down list data in single column in sql database using servlet i want to insert date of birth of user by using separate drop down list box for year,month and day into dateofbirth column in sql server

i need program to insert data in database using javascript
i need program to insert data in database using javascript please help me

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

using ajax i want to insert data into oracle database
using ajax i want to insert data into oracle database i would like to insert/update/select/delete from jsp to oracle database using ajax? please send a code for this iam using oracl database thank you

Insert excel file data into database Using Java Programming
Insert excel file data into database in Java Program In this PHP tutorial section, you will learn how to insert excel file data into the database. We have... excel file data into Database Using java programming: import java.io.

how to insert checkbox value into database using jsp
how to insert checkbox value into database using jsp How to insert check box value to the oracle database using jsp? I want to create hotel's...; Here is a simple jsp code that insert the selected checkbox values

how to insert checkbox value into database using jsp
how to insert checkbox value into database using jsp how to insert check box value to the database using jsp my code is <link href="font&colors.css" rel="stylesheet" type="text/css"> <p></p>

Insert data in mysql database through jsp using prepared statement
; This is detailed jsp code that how to insert data into database by using prepared statement... Insert data in mysql database through jsp using prepared statement...*" %> <HTML> <HEAD> <TITLE>insert data using

how to insert checkbox value into database using jsp
how to insert checkbox value into database using jsp How to insert check box value to the oracle database using jsp? I want to create hotel's package. where the admin will select the activities to insert in the PACKAGE table. I

insert and delete data in database
insert and delete data in database insert and delete data in database from servlets through JDBC Hi Friend, Please visit the following links:ADS_TO_REPLACE_1 Insert Data Delete Data ThanksADS_TO_REPLACE_2

how to insert data into databasse by using jdbc
how to insert data into databasse by using jdbc �?� Create a Registration Form with 10 input fields using HTML and get those inputs using JSP and insert those inputs into database using JDBC. Here is a jsp code

insert data into database
insert data into database hi,thanks for reply just i am doing... and studentmaster is the database table name. i am using same details. Now give the data into the jsp page that data stored into the database.Here the error

How to insert image in sql database from user using servlet
How to insert image in sql database from user using servlet pls tell me accept image from user and insert image in sql server 2005 database using servlet and jsp

Problem insert data into database using servlet n javabean - Java Beginners
Problem insert data into database using servlet n javabean I created... to solve it.. i really new in jsp+servlet+javabean,dont really unnderstand 1)my... = conn.createStatement(); rs = stmt.executeUpdate("INSERT INTO login(name,userid

insert data using drop down box in java into database postgresql
insert data using drop down box in java into database postgresql can... data into database using an drop down box .....as i m using eclipse as jdbc and postgresql as data base syntax which i m using is like:- java class

database is connected but not insert the data
database is connected but not insert the data hi, i am getting connected to database.Retrive the data also but cannot insert the data into database. i am using msaccess2007.my inserstudententry.jsp code is follows,pls help me

Insert XML file data to database
Insert XML file data to database In this tutorial, you will learn how to insert the xml file data to database using dom parser. You all are aware of XML... to read the xml file data and save the values of an XML file to a Database

How to insert dynamic textbox values into database using Java?
How to insert dynamic textbox values into database using Java? Hi I am trying to insert dynamic textbox values to database, my jsp form have 2... of dynamic textboxes with Name and Address will display....Now I want to Insert

Insert file data into database
Insert file data into database In this section, you will learn how to insert.... Now to insert this data into the database, we have established a database connection. Then using the insert query, we have inserted whole file data

How to save database data into excelsheet using hibernate
How to save database data into excelsheet using hibernate How to save database data into excelsheet using hibernate

unable to insert data into database
unable to insert data into database hello.i have a problem in inserting data into database.i have used two prepared statement.one for retrieving the eid based on ename and the other is inserting data into database based

To insert maximum number of data in database.
To insert maximum number of data in database. how to change string data type into clob data type in jsp Hi Friend, Please visit the following link:ADS_TO_REPLACE_1 http://www.roseindia.net/jdbc/insert-clob

callable statement,stored procedure for insert data and also for update data into oracle database using jsp
callable statement,stored procedure for insert data and also for update data into oracle database using jsp iam a fresher newbie to softparsing i... procedure for inserting data into oracle database as bind variable and same

Insert text file data into Database
Insert text file data into Database In this section, you will learn how to insert the text file data into the database. For this purpose, we have created... the data to the ArrayList. This list is then iterated through the Iterator

insert date into database using jsf
insert date into database using jsf Hello I need a simple example of source code to insert a date into a database using jsf what do I have to put in backing bean and page jsf ( i need juste a date ) thanks

insert data into database
insert data into database type Exception report message...)Go to the start->Control Panel->Administrative Tools-> data sources. 2... selecting the driver, click finish button. 4)Then give Data Source Name

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

Insert Data into Database Using Hibernate Native SQL
Insert Data into Database Using Hibernate Native SQL... how you can use Native SQL with hibernate. You will learn how to use Native to insert data into database. Native SQL is handwritten SQL for all database

How to insert data from a combobox and textbox values into DB using JSP?
How to insert data from a combobox and textbox values into DB using JSP? hi, How to insert a comb-box and a text box values in to DB using JSP? @DB:student; @table:stu_info; Combobox values:(class1,class2,class3); textbox1

How to insert and retreive an image in mysql database using spring mvc framework???
How to insert and retreive an image in mysql database using spring mvc framework??? I ve solved this problem based on the Product Search Application. Those who need this concept and code segment kindly copy it. Thanks and All

How to Insert image and data both together in database in JSP/Servlet ?
How to Insert image and data both together in database in JSP/Servlet ?�... = connection.prepareStatement("insert into data(Name,City,Img) values('"+nn+"','"+cc...;BODY> <FORM ENCTYPE="multipart/form-data" ACTION

please let me get code how to insert a data to mysql using setter and getter method by using java
please let me get code how to insert a data to mysql using setter and getter method by using java please let me get code how to insert a data... to insert data

Insert data in mysql database through jsp using Prepared Statement ---- Please Resolve it
Insert data in mysql database through jsp using Prepared Statement ---- Please Resolve it I have tried the following code Database creation: create database studentdb; create table stu_info ( ID int not null auto

How to insert or delete records in MS access database using jsp - JSP-Servlet
How to insert or delete records in MS access database using jsp Hi friends please provide me a solution that i insert or delete record from a database using java server pages. I used the microsoft access 2003 database. PlZ

Ads