Oracle Database Connection in GUI Application

-

Write the following code in a java file named "insertDemo.java"

import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.sql.*;
public class insertData extends JFrame implements ActionListener
 {
     JTextField name,addr,sal;
     JLabel n,a,s;
     JButton ins,canc,clr;
    insertData()
     {
       setLayout(null);   
       name=new JTextField(15); 
       addr=new JTextField(15);
       sal=new JTextField(15);
       n=new JLabel("Enter Employee Name :");
       a=new JLabel("Enter Employee Address :");
       s=new JLabel("Enter Employee Salary :");
       ins=new JButton("Insert");
       canc=new JButton("Close");
       clr=new JButton("Clear");
       add(n); add(name);
       add(a);  add(addr);
       add(s);  add(sal);
      add(ins); add(canc); add(clr);
      n.setBounds(10,10,130,25);     name.setBounds(170,10,130,25);
      a.setBounds(10,50,150,25);     addr.setBounds(170,50,130,25);
      s.setBounds(10,90,150,25);     sal.setBounds(170,90,130,25);
      ins.setBounds(20,130,80,30);   canc.setBounds(110,130,80,30);
      clr.setBounds(200,130,80,30);
       setBounds(150,100,330,210);
       getContentPane().setBackground(new Color(200,208,247));
       setTitle("Insert Records..."); 
      setVisible(true);
      ins.addActionListener(this);
      canc.addActionListener(this);
      clr.addActionListener(this);
     }
public void actionPerformed(ActionEvent ae)
 {
      if(ae.getSource()==ins)
      {
     try{
      String nm=name.getText();
      String ad=addr.getText();
      int salry=Integer.parseInt(sal.getText()); 
     Class.forName("oracle.jdbc.driver.OracleDriver");       
     Connection con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521","system","123456");

      PreparedStatement pst=con.prepareStatement("insert into emp values(?,?,?)");
     pst.setString(1,nm);
     pst.setString(2,ad);
     pst.setInt(3,salry);
     int n= pst.executeUpdate();
       ////////////////////////////////////////////////////   OR ///////////////////////////////////////////////// 
/* 
      Statement st=con.createStatement();
      String query="insert into emp values(' "+nm+" ' , ' "+ad+" ' , "+salry+")";
      System.out.println(query);
       int n= st.executeUpdate(query);
*/

      if(n>0)
          JOptionPane.showMessageDialog(this,"Record Inserted..");
      else
          JOptionPane.showMessageDialog(this,"Record Insertion Error..");
         }catch(Exception ex) {}
      }
   else if(ae.getSource()==canc)
         this.dispose();
   else if(ae.getSource()==clr) 
       {
           name.setText("");         addr.setText("");         sal.setText("");
       }
 }
public static void main(String arg[])
 {
    new insertData();
 }
 }

 To Execute this Program you will have to set class path first.... 
       i.e.
              set classpath= .; C:\oraclexe\app\oracle\product\10.2.0\server\jdbc\lib\ojdbc14.jar

Then Compile & run
                       javac insertDemo.java
                       java insertDemo

Output :

Comments

Post a Comment

Popular posts from this blog

JDatePicker In Java

-
Image
Hi. Friends . This is a Library named "JDatePicker" created by me, through which you can use pick desired Date. How to use.. Step 1- Download "DatePick.jar file" from this blog. Step 2- Follow the following Steps Step 3- Choose Tools>>Palette>>Swing/AWT Component  Step 4-  Select the Downloaded "DatePick.jar" file by clicking "Add from JAR" option   Step- 5  Choose JDatePicker Component Step-6   Select Palette Category to add Component and click on finish. Step-7  Select JDatePicker from Swing Controls and draw in a Container (JFrame,JDialog,JPanel, etc.) OUTPUT : Thank you.. Please Download it. from following link. DatePick.jar (JDatePicker)
Read more

Setting Background image of JFrame containg Components

-
Image
Step 1- Save the following source code in a file named "LoginPanel.java" import java.awt.*; import javax.swing.*; class BgPanel extends JPanel {     Image bg = new ImageIcon("Back.jpg").getImage();     public void paintComponent(Graphics g) {         g.drawImage(bg, 0, 0, getWidth(), getHeight(), this);     }   BgPanel()   {        JLabel l1=new JLabel("Username: ");        JLabel l2=new JLabel("Password: ");        JTextField t1=new JTextField(15);        JTextField t2=new JTextField(15);        JButton b1=new JButton("Login");        JButton b2=new JButton("Cancel");        l1.setBounds(20,40,90,25);        l2.setBounds(20,70,90,25);        t1.setBounds(120,40,170,25);        t2.setBounds(120,70,170,25); ...
Read more

Applet Progarm with Combo box, radio button,Check box

-
Image
Step 1 : Create a source file named "testapp2.java". Step 2: Write the following code with applet tag. import java.applet.*; import java.awt.*; import java.awt.event.*; /* <APPLET CODE="testapp2" HEIGHT =240  WIDTH=370 > </APPLET> */ public class testapp2 extends Applet implements ActionListener,ItemListener {     Label l1,l2,l3,l4;     Button ok,cancel;     TextField n1,n2;     Choice ch,colorchoice;     Color clr;     Checkbox cb1,cb2,cb3,cb4;     CheckboxGroup cgroup;     public void init()      {        clr=new Color(219,240,251);       setBackground(clr);       setLayout(null);       cgroup=new CheckboxGroup();        cb1=new Checkbox("ADD",true,cgroup);        cb2=new Checkbox("SUBTRACT",false,cgroup);        cb3=new ...
Read more