Web-based GUI using JDBC

[Jeanne Pierre]

I programmed java when I was in school, but everything was given to us (students). Now I am trying to do some java on my own, and I am having a bit of difficulties. I downloaded apache Tomcat and compiled some servlets from a tutorial that I found online. Now I am trying to make this form but I can't seem to access the form when I enter the url using http://localhost:8080/licenseForm. It is not a servlet so I don't believe I have to enter http://localhost:8080/servlet/licenseForm.

This is my code:

/****************************************************************************************
*
*  This is a program that will allow the user to submit veritas license
attributes to be
*    inserted into a database.
*
****************************************************************************************/
import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
import java.lang.Math;
import java.sql.*;
 
public class licenseForm extends JApplet implements ActionListener
{
        private JTextField prodType, prodKey, prodQuant, prodPONumb;
        private JLabel typeLabel, keyLabel, qtyLabel, poLabel;
        private JButton submit;
        String url;
        Statement mySql;
        Connection myConnection;
 
        public licenseForm()
        {
                Container con = getContentPane();
                con.setLayout(null);
 
                typeLabel = new JLabel("Product Type:");
                typeLabel.setBounds(20, 30, 140, 65);
                con.add(typeLabel);
 
                prodType = new JTextField(200);
                prodType.setBounds(180, 50, 390, 25);
                con.add(prodType);
 
                keyLabel = new JLabel("Product License Key:");
                keyLabel.setBounds(20, 60, 140, 65);
                con.add(keyLabel);
 
                prodKey = new JTextField(100);
                prodKey.setBounds(180, 80, 340, 25);
                con.add(prodKey);
 
                qtyLabel = new JLabel("License Quantity:");
                qtyLabel.setBounds(20, 90, 140, 65);
                con.add(qtyLabel);
 
                prodQuant = new JTextField(100);
                prodQuant.setBounds(180, 110, 30, 25);
                con.add(prodQuant);
 
                poLabel = new JLabel("Purchase Order #:");
                poLabel.setBounds(20, 120, 140, 65);
                con.add(poLabel);
 
                prodPONumb = new JTextField(100);
                prodPONumb.setBounds(180, 140, 140, 25);
                con.add(prodPONumb);
 
                submit = new JButton("SUBMIT");
                submit.setBounds(150, 180, 140, 35);
                con.add(submit);
 
                submit.addActionListener(this);         //this will allow the actionPerformed method to be called
                                                         //once the submit button is pressed
 
                setSize(600,600);
                setVisible(true);
/************************************************************************************************************
******************************************Connecting to Database*********************************************
************************************************************************************************************/
              try
                {
                        Class.forName("oracle.jdbc.driver.OracleDriver");
                        //url = "jdbc :-o	 racle:thin:username/password@servername :-P	 ortnumber:serverinstance";
                        url = "jdbc :-o	 racle:thin:c047647/duwh0p01@cosmos:1530 :mrgreen: ev605";
                        myConnection = DriverManager.getConnection(url);
                        mySql = myConnection.createStatement();
                }catch(Exception ex){ex.printStackTrace();}
        }
 
        public void actionPerformed(ActionEvent action)
        {
                String sql;
                String addType, addKey, addQuant, addPONumb,
                  tname, tsname;
                ResultSet rs;
 
/*                addType = prodType.getText();
                addKey = prodKey.getText();
                addQuant = prodQuant.getText();
                addPONumb = prodPONumb.getText();
*/
                //sql = "INSERT INTO license (prodType, prodKey, prodQuant, prodPONumb) VALUES('" + addType + "', '" + addKey + "', '";
//                sql += addQuant + "', '" + addPONumb + "')";
 
                sql = "SELECT table_name, tablespace_name FROM user_tables";
 
                //JOptionPane.showMessageDialog(null,"Test...Yep!!!!\n" + sql,"Test", JOptionPane.PLAIN_MESSAGE);
                try
                {
 
                        rs = mySql.executeQuery(sql);
                        while(rs.next())
                        {
                                tname = rs.getString(1);
                                tsname = rs.getString(2);
                                System.out.println("Table Name" + tname + "Table Space Name" + tsname + "\n");
                        }
                }catch(Exception ex){System.out.println("Exception" + ex);}
        }
 
        public static void main(String arg[])
        {
                licenseForm license = new licenseForm();
        }
 
}
 

This is the error that I get:
HTTP Status 404 - /licenseForm

type Status report

message /licenseForm

description The requested resource (/licenseForm) is not available.




I am honestly stuck, and don't know what to do....Please help!!

[Jeff Albertson]

Crikey, one doesn't know where to begin. Hmmm... are you familiar with the difference between servlets and applets, or perhaps between chalk and cheese?

[Bear Bibeault]

Since a similar question was already asked (twice), I'm closing this one.

To the OP: I think you need to back up a little and read up on web technologies. Applets and servlets are two very different things.