retrive record from the text field and insert into to database

the following code is inserting values in the my sql database but i want to insert the data into oracle database , i want what changes i have to make in the following code...

import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.util.*;
import java.lang.String;
import java.sql.Connection; import javax.servlet.RequestDispatcher;

import java.sql.Statement;
import java.sql.ResultSet;
import javax.naming.*;
import javax.naming.directory.*;
import oracle.jdbc.pool.OracleDataSource;

public class AddUser extends HttpServlet{

public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException,IOException{ response.setContentType("text/html"); PrintWriter out = response.getWriter();

        String LASTNAME = request.getParameter("LASTNAME").toString();
        String FIRSTNAME = request.getParameter("FIRSTNAME").toString();
        String ADDRESS = request.getParameter("ADDRESS").toString();
        String CITY = request.getParameter("CITY").toString();

    Connection con = null;   
            Statement st1 = null;   

            ResultSet rs = null;   

     try {   

             Context initContext = new InitialContext();                     
             Context envContext = (Context) initContext.lookup("java:/comp/env");                     
            OracleDataSource ds = (OracleDataSource) envContext.lookup("jdbc/abc");                      
             if (envContext == null)throw new Exception("Error: No Context");                   
            if (ds == null) throw new Exception("Error: No DataSource");                    
            if (ds != null)                           
             con = ds.getConnection();   

            st1 = con.createStatement();   




            ArrayList al=null;
            ArrayList userList =new ArrayList();
            String query = "insert into LTCINFO.PERSONS set LASTNAME='"+LASTNAME+"',FIRSTNAME='"+FIRSTNAME+"',ADDRESS='"+ADDRESS+"',CITY='"+CITY+"'";


            int i = st1.executeUpdate(query);

            if(i>0)
            {
                response.sendRedirect("SHome");
            }
             rs.close();   
                st1.close(); 
             con.close();   

    } catch (SQLException se) {   
        out.println("An Error Had occurred while accessing the database");   
        out.println("<HR>");   

        out.println(se.getMessage());   
    }   

    catch (Exception e) {   
        e.printStackTrace();   

    } finally {   
        try {   
            if (rs != null)   
                rs.close();   
            if (st1 != null)   
                st1.close();  

            if (con != null)   
                con.close();   
        } catch (Exception e) {   
            out.println(e);   
        }   
    }

} } when i run this code i am getting followinng error "ORA-00926: missing VALUES keyword "

March 26, 2012 at 3:30 PM

import javax.swing.*;
import java.awt.*;
import java.io.*;
import java.awt.event.*;
import java.sql.*;
class Form extends JFrame
{
JButton ADD;
JPanel panel;
JLabel label1,label2,label3,label4,label5;
final JTextField text1,text2,text3,text4,text5;
Form(){
label1 = new JLabel();
label1.setText("UserID:");
text1 = new JTextField(20);

label2 = new JLabel();
label2.setText("First Name:");
text2 = new JTextField(20);

label3 = new JLabel();
label3.setText("Last Name:");
text3 = new JTextField(20);

label4 = new JLabel();
label4.setText("ADDRESS:");
text4 = new JTextField(20);

label5 = new JLabel();
label5.setText("Email:");
text5 = new JTextField(20);

ADD=new JButton("ADD");

panel=new JPanel(new GridLayout(6,2));
panel.add(label1);
panel.add(text1);
panel.add(label2);
panel.add(text2);
panel.add(label3);
panel.add(text3);
panel.add(label4);
panel.add(text4);
panel.add(label5);
panel.add(text5);
panel.add(ADD);
add(panel,BorderLayout.CENTER);
setTitle("FORM");
ADD.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent ae){
String value1=text1.getText();
String value2=text2.getText();
String value3=text3.getText();
String value4=text4.getText();
String value5=text5.getText();
try{
Class.forName("com.mysql.jdbc.Driver").newInstance();
        Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/test", "root", "root" );
        Statement st=conn.createStatement();

             st.executeUpdate("insert into data(id,fname,lname,address,email) values('"+value1+"','"+value2+"','"+value3+"','"+value4+"','"+value5+"')");
            JOptionPane.showMessageDialog(null,"Inserted Successfully!");
        }
catch(Exception e){}
}
});
}
}
class FormDemo
{
public static void main(String arg[])
{
try
{
Form frame=new Form();
frame.setSize(300,300);
frame.setVisible(true);
}
catch(Exception e)
{
}
}
}

March 26, 2012 at 3:52 PM

Thanx...