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
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
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 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
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
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
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