
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 "

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)
{
}
}
}

Thanx...
If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.
Ask your questions, our development team will try to give answers to your questions.