Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import java.sql.*;
- import javax.swing.*;
- import java.awt.*;
- import java.awt.event.*;
- public class test1 extends JFrame implements ActionListener
- {
- JTextField t;
- JButton b;
- test1()
- {
- super("Test");
- t = new JTextField(20);
- b = new JButton("Save");
- JPanel p = new JPanel();
- p.add(t);
- p.add(b);
- b.addActionListener(this);
- this.getContentPane().add(p);
- this.setSize(300,200);
- this.setVisible(true);
- }
- public void actionPerformed(ActionEvent e)
- {
- if(e.getSource() == b)
- {
- String id = t.getText();
- try
- {
- Class.forName("oracle.jdbc.driver.OracleDriver");
- Connection conn = DriverManager.getConnection("jdbc:oracle:oci8:@", "scott", "tiger");
- Statement stmt = conn.createStatement();
- stmt.executeUpdate("insert into emp(empno) values("+id+")");
- stmt.close();
- conn.close();
- }
- catch(Exception er)
- {
- }
- }
- }
- public static void main (String [] args)
- {
- new test1();
- }
- }
Add Comment
Please, Sign In to add comment