Java and access database user accounts

[whiteyoh]

Hi All,

I have just started learning java. I have a good understanding of UML 2. What i am trying to do is to make a small user authentication applet.

I have completed all of the relevant connection requirements via administration in XP but i just need a little helping hand to nudge me along.

The following script works fine, but I need some direction as to how to modify it to become an applet and to display something other than "1".

Thanks in advance

 
package application;
 
import java.sql.*;
public class Test {
    public static void main(String[] arguments) {
        try {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            /* the next 3 lines are Step 2 method 2 from above - you could use the direct
            access method (Step 2 method 1) istead if you wanted */
            String dataSourceName = "mdbTEST";
            String dbURL = "jdbc:odbc:" + dataSourceName;
            Connection con = DriverManager.getConnection(dbURL, "",""); 
            // try and create a java.sql.Statement so we can run queries
            Statement s = con.createStatement();
            s.execute("create table TEST12345 ( column_name integer )"); // create a table
            s.execute("insert into TEST12345 values(1)"); // insert some data into the table 
            s.execute("select column_name from TEST12345"); // select the data from the table
            ResultSet rs = s.getResultSet(); // get any ResultSet that came from our query
            if (rs != null) // if rs == null, then there is no ResultSet to view
            while ( rs.next() ) // this will step through our data row-by-row
 
 
                {
                /* the next line will get the first column in our current row's ResultSet 
                as a String ( getString( columnNumber) ) and output it to the screen */ 
                System.out.println("Data from column_name: " + rs.getString(1) );
            }
            s.execute("drop table TEST12345");
            s.close(); // close the Statement to let the database know we're done with it
            con.close(); // close the Connection to let the database know we're done with it
        }
 
 
            catch (Exception err) {
            System.out.println("ERROR: " + err);
        }
    }
    }
 

[JosAH]

Where does your database run? An Applet (nor a JApplet) can contact a database running on the client machine without some precautions. It's a security thing.

kind regards,

Jos