Passing textfield info to connection string

SELECT DECODE(count(*),0,'F','T')
  FROM
    user_tables
  WHERE
    table_name = 'table name';

Select allOpen in new window

/*
 * Glen A. Currier
 * Video DB Project
 * "VideoLdrMain.java"
 * 26.02.2011
 */
package Loader;

import java.sql.*;
import javax.swing.JFrame;

public class VideoLdrMain {

    public static void main(String[] args) throws ClassNotFoundException, SQLException {

        JFrame frame = new DBAuthenticate();
        frame.setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);
        frame.setTitle("Database Authentication");
        frame.setResizable(false);
        frame.setLocationRelativeTo(null);
        frame.pack();
        frame.setVisible(true);
        
        new DBCreateTable();

    }
}

Select allOpen in new window

package Loader;

public class VideoDBTable extends DBAuthenticate{

    public static final String table_maint = "drop table videos";
    public static final String video_table =
            "create table videos ("
            + "id INT PRIMARY KEY not null,"
            + "type   varchar2(20),"
            + "genre1 VARCHAR(20),"
            + "genre2 VARCHAR(20),"
            + "genre3 VARCHAR(20),"
            + "title  VARCHAR(20), "
            + "year   VARCHAR(20),"
            + "video  BLOB,"
            + "uploaded date"
            + ")";
}

Select allOpen in new window

package Loader;

import java.awt.BorderLayout;
import java.awt.GridLayout;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JPanel;
import javax.swing.JPasswordField;
import javax.swing.JTextArea;
import javax.swing.JTextField;

public class DBAuthenticate extends JFrame implements ActionListener  {

    private static JTextField userAuth;
    private static JPasswordField pwordAuth;
    private static JLabel userName, passWord;
    private static JPanel helpPanel, authPanel, okPanel, combinedPanel;
    private static JTextArea helpText;
    private JButton okButton;
    static String getUser, getPass;


    public DBAuthenticate() {

        //create panels
        helpPanel = new JPanel(new GridLayout(1, 1));
        authPanel = new JPanel(new GridLayout(2, 2));
        okPanel = new JPanel(new GridLayout(1, 1));
        combinedPanel = new JPanel(new BorderLayout());

        //create items that go into panels
        helpText = new JTextArea("Please enter your credentials and press \"OK\"");

        userName = new JLabel("User:      ");
        userAuth = new JTextField();
        passWord = new JLabel("Password:  ");
        pwordAuth = new JPasswordField();

        okButton = new JButton("OK");
        okButton.addActionListener((ActionListener) this);

        //add items to panels
        helpPanel.add(helpText);

        authPanel.add(userName);
        authPanel.add(userAuth);
        authPanel.add(passWord);
        authPanel.add(pwordAuth);

        okPanel.add(okButton);

        //add panels to combinedPanel
        combinedPanel.add(helpPanel, BorderLayout.NORTH);
        combinedPanel.add(authPanel, BorderLayout.CENTER);
        combinedPanel.add(okPanel, BorderLayout.SOUTH);

        //add combinedPanel to JFrame
        add(combinedPanel);

        //actionListener
//        ListenerClass listen = new ListenerClass();
//        okButton.addActionListener(listen);

    
        
    }
    
    
    public void actionPerformed(ActionEvent e){
        if(e.getSource()==okButton){
            this.getUser = userAuth.getText();
            this.getPass = pwordAuth.getSelectedText();
            
            try {
                getDBConnection();
            } catch (Exception ee) {
                System.out.println("Error during button click event");
                ee.printStackTrace();
            }            
        }
    }
    
    public Connection getDBConnection() throws ClassNotFoundException, SQLException {
        
        String driver = "oracle.jdbc.driver.OracleDriver";
        String url = "jdbc:oracle:thin:@localhost:1521/orcl";
        String user = getUser;
        String password = getPass;
        Class.forName(driver);
        Connection conn = DriverManager.getConnection(url, user, password);
        conn.setAutoCommit(false);
        return conn;
    }

    
//    public class DBConnection{
//
//        private String user, password;
//
//        public void DBConnection(){}
//
//        public void DBConnection(String user,String password){
//            setUser(user);
//            setPass(password);
//        }
//
//        String getUser(String user){
//            return this.user;
//        }
//
//        String getPass(String password){
//            return this.password;
//        }
//
//        void setUser(){
//            this.user = user;
//        }
//
//        void setPass(){
//            this.password = password;
//        }
//
//    }

}

Select allOpen in new window

/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

package Loader;


import java.sql.Connection;
import java.sql.SQLException;
//import java.sql.ClassNotFoundException;
import java.sql.Statement;

/**
 *
 * @author gcurrier
 */
public class DBCreateTable extends DBAuthenticate{

    public DBCreateTable()throws ClassNotFoundException,SQLException {
        Connection conn = super.getDBConnection();
        Statement stmt = null;
        VideoDBTable vTable = null;
        try {
            //create a connection
            //conn = new super.getDBConnection();
            //prepare a statement
            stmt = conn.createStatement();
            //drop table

            /*
             * error if no table previously defined - program exits (need a fix here)
             */
            
            stmt.execute(vTable.table_maint);
            //create table
            stmt.executeUpdate(vTable.video_table);
            //commit changes
            conn.commit();
            System.out.println("Create table \"videos\" successful.");
        }
//        catch (ClassNotFoundException e) {
//            System.err.println("Failed to load the Oracle driver.");
//            e.printStackTrace();
//        }
        catch (SQLException e) {
            System.err.println("Failed to create a connection to the database.");
            e.printStackTrace();
        } catch (Exception e) {
            System.err.println("other error:");
            e.printStackTrace();
        } finally {
            try {
                stmt.close();
                conn.close();
            } catch (Exception e) {
                System.err.println("Unsuccessful attempt to close connections.");
                e.printStackTrace();
            }
        }
    }

}

Select allOpen in new window