java connecting to oracle db

Ads
 

java connecting to oracle db

PLZ SAY ME HOW TO INSERT THE VALUES INTO ORACLE THIS IS THE CODE:

import java.io.*;
import java.sql.*;
import java.awt.*;
import javax.swing.*;
import java.awt.event.*;
import javax.swing.event.*;
public class emp1 extends JFrame implements ActionListener
{
       private JTextField eid,ename,esal,eaddr;
       private JButton submit;
       public emp1()
         {
              setSize(300,300);
              setVisible(true);                    
              eid=new JTextField ("emp no here");
             ename=new JTextField ("emp name here");
             esal=new JTextField ("emp sal here");
             eaddr=new JTextField ("emp eaddr here");
             submit=new JButton("store");
             submit.addActionListener(this);
             Container c=getContentPane();
            c.setLayout(new FlowLayout());
            c.add(eid);
            c.add(ename);
            c.add(esal);
            c.add(eaddr);
            c.add(submit);
            setTitle("add new emp1 Record");
          }
               public void actionPerformed(ActionEvent ae)
                  {
                 String veid,vename,vesal,veaddr;
                  veid=eid.getText();
                  vename=ename.getText();
                 vesal=esal.getText();
                  veaddr=eaddr.getText();
                  String sqlstmt="insert into emp1 values(' "+veid+" ',' "+vename+" ',' "+vesal+" ',' "+veaddr+" ')";
                  System.out.println(sqlstmt);
                    try
                     {
                     Class.forName("oracle.jdbc.driver.OracleDriver");
                    Connection con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","scott","tiger");
                     Statement stmt=con.createStatement();

                 stmt.executeUpdate(sqlstmt);
                      con.close();
                       }

                 catch(Exception e)
                    {
                    System.out.println(e);
                       }
}
public static void main(String[] ar)
{
emp1 e=new emp1();
e.addWindowListener(new WindowAdapter()
{
public void windowClosing(WindowEvent we)
{
System.exit(0);
}
});
}  
}           

I GOT ERROR FOR THIS PROGRAM
ERROR:java.lang.ClassNotFoundException:oracle.jdbc.driver.OracleDriver
View Answers

Ads









Related Tutorials/Questions & Answers:
java connecting to oracle db
java connecting to oracle db  PLZ SAY ME HOW TO INSERT THE VALUES INTO ORACLE THIS IS THE CODE: import java.io.*; import java.sql.*; import..."); Connection con=DriverManager.getConnection("jdbc:oracle:thin
java connecting frames
java connecting frames  how to connect one frame to another frame by using awt or swings?`print("code sample
Advertisements
connection of java file to excel file and put data from excel file into oracle db
connection of java file to excel file and put data from excel file into oracle db  how to create button on excel sheet using java swing and how we... as wellas to oracle db to insert excel data into database
Connecting to MYSQL Database in Java
Connecting to MYSQL Database in Java  I've tried executing the code below but the error that I get is "Error: com.mysql.jdbc.Driver" I downloaded the connection driver and configured the class path but the error persists. Please
URGENT: Export Table in Oracle db to CSV file
URGENT: Export Table in Oracle db to CSV file  Hi, Could you basically help me by providing a program in Java. I want a program to connect and export a table in the oracle database to a folder in my local harddrive. Thankyou
ModuleNotFoundError: No module named 'oracle-db-query'
ModuleNotFoundError: No module named 'oracle-db-query'  Hi, My... named 'oracle-db-query' How to remove the ModuleNotFoundError: No module named 'oracle-db-query' error? Thanks   Hi, In your python
Todd oracle DB connection through PHP
Todd oracle DB connection through PHP  Can u please explain how to connect Todd oracle DB using PHP & What are the setups we need to perform? Thanks
java code for threading example for connecting data base
java code for threading example for connecting data base  Write a program that has two threads First thread queries the database and fetches all the employee records from the emp table. Stores the employee objects
JAVA BEAN WITH ORACLE FORMS
JAVA BEAN WITH ORACLE FORMS  Hi..I am doing my final year Project.. I need the ste-by-step procedure to integrate a bean with oracle forms? Please help me
java with Oracle Database
java with Oracle Database  Hello I have been encountering a problem regarding creating a table with Oracle.When i am creating new table in the Database using Oracle , it is giving error saying an errror occured incursive sql
Java Connection to Oracle database
Java Connection to Oracle database  HI I am ubable to connnect jdbc to Oracle database.i had gone to control panel >>Administrative tool>>>Data source,in that forDNS name i typed Oracle and in TNS i culdn't
Java Barcode Program with Oracle database
Java Barcode Program with Oracle database  Hi Everyone, I need help... no and serial no of the item being scanned to Oracle 10g database. I dont have any idea abt this...Please can anyone give me some idea. Do I need to buy Java
how to migrate java db to mysql
how to migrate java db to mysql  I have an aplication,for migrating java db to mysql db.how it will done
Oracle Certified Java Programmer Assistance
Oracle Certified Java Programmer Assistance  Hi all I wanted to know that I have recently completed my graduation and heading towards Post Graduation. I wanted to know that if I pass the OCJP certification will it be useful after
About connection database oracle to java
About connection database oracle to java  Hi I culdn't connect oracle datebase to java.when i compile the program it is ok.but when i clicked... Oracle and then i clicked add button.Then Dialog box came indicating DNS and TNS
About connection database oracle to java
About connection database oracle to java  **Hi I culdn't connect oracle datebase to java.when i compile the program it is ok.but when i clicked... Oracle and then i clicked add button.Then Dialog box came indicating DNS and TNS
About connection database oracle to java
About connection database oracle to java  Hi I culdn't connect oracle datebase to java.when i compile the program it is ok.but when i clicked... Oracle and then i clicked add button.Then Dialog box came indicating DNS and TNS
About connection database oracle to java
About connection database oracle to java   I culdn't connect oracle... Panel>>Administrative Tools>>Data Sources in that i selected Oracle... just typed DNS as Oracle and for TNS i clicked on the list of TNS. But it has
About connection database oracle to java
About connection database oracle to java   I culdn't connect oracle... Panel>>Administrative Tools>>Data Sources in that i selected Oracle... just typed DNS as Oracle and for TNS i clicked on the list of TNS .But it has
Connecting to a MySQL Database in Java
Connecting to a MySQL Database in Java       In java we have been provided with some... the data in the database with the help of java,  instead of going to database
Insert or retrieve image into oracle 10g by using java
Insert or retrieve image into oracle 10g by using java   How can i insert or retrieve image into oracle10g using java plz i need it urgently,need guidance to do this plz
Installing oracle Java 8 on Ubuntu 18.04
Installing oracle Java 8 on Ubuntu 18.04  Hi, What are the steps for installing oracle java 8 on ubuntu 18.04? I want to install Oracle Java 8... the Oracle Java JDK 8 in Ubuntu 18.04. Here are the steps to install Oracle Java 8
Java DB
Java DB       Java DB is an open source Apache Derby database supported by Sun. Java DB is completely written in the Java programming language having the functionality write once run
connecting databases
connecting databases  I need to connect mysql on 2 or more remote pc'c. how can i giv the ip address for 2 or more systems. is it possible to connect to the required systems by user specifying the database and table name my
oracle
oracle   sir now am doing one project , my frond end is vb and backend is oracle. so 1> how can i store the image in my field 2> how can i back up the table into .txt file
i need latest oracle certified java dumps.. Pleas help me?
i need latest oracle certified java dumps.. Pleas help me?  i need latest oracle certified java dumps.. Pleas help me
Convert the excel sheet data into oracle table through java or jsp
Convert the excel sheet data into oracle table through java or jsp  Hi Friends, Let me help this issue i am phasing Convert the excel sheet data into oracle table through java or jsp
Exception while inserting image in oracle using java
Exception while inserting image in oracle using java  import...()); Connection con=DriverManager.getConnection("jdbc:oracle:thin:@localhost... affected: "+stmt.executeUpdate()); } } My Oracle table description is: create table
Oracle Launches Project Valhalla for Java
Oracle Launches Project Valhalla for Java with an aim to evolve new features..., the Oracle have announced its much awaited Project Valhalla for Java. Certainly a long... of project Java by Oracle, now it has open an experimental OpenJDK project
Null pointer exceptation-Java Servlet web application,Problem connecting with MYSQL database
Null pointer exceptation-Java Servlet web application,Problem connecting.... T_T I have develop my java web application in window Environment and now i.... T_T I have develop my java web application in window Environment and now i
connecting to timesten in web application
connecting to timesten in web application  Please give me the steps connecting to timesten in web application. Am using jsp

Ads