user authentication

[kimi lynn]

hello,
could somebody please point me a nice tutorial to do user authentication like to check user name and password in a database table.
Thanks in advance

[Balaji Loganathan]

This link might help you.,.
http://www.tutorgig.com/showurls.jsp?group=1201&index=0

[kimi lynn]

Thanks for the links balaji.
well, am quite confused with this authentication.could somebody please clarify me.
I've a user interface done in swing.Now, the user enter the username and password and this has to be checked with the one's stored in the table.This table(db) is on the server.when the user is authenticated, the user can start matlab on the server.To start matlab, as well as the other things are working fine.I'm only confused with this authentication.
Thanks for your time

[Balaji Loganathan]

To do the authentication check...

Pick one basic tutorial and try to learn how to connect,open a database like MsAccess/SQL Server/ or any JDBC complaint database.

Now try to learn how to retrieve select and display a table from a database using SQL Query

then try to learn how you can compare the given(from swing)username and password literals with the database table using SQL Query

Depending on step 3, you can allow or deny the user.

[kimi lynn]

Balaji, thanks once again.
I've written a simple example in-order to display the records from a table and its working fine on my local pc.Now, I've placed my db on a drive which is accessible to all the pc's in our network and changed the path accordingly.
when i try to run the program, it throws me off with this error:
[Microsoft][ODBC Microsoft Access Driver] data '(unknown)' canot be found.
How can i fix this error, thanks in advance.
Heres the part of the code which I've used.

import java.lang.*;
import java.sql.*;
import sun.jdbc.odbc.*;
public class sample1
{
public static void main(String arg[]) {
int emp_id;
String emp_name, emp_job, result;
//String result;
try {
//Connect to ODBC database
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url = "jdbc :o dbc:Employees";
//Connect
Connection con = DriverManager.getConnection(url,"dba", "sql");
//Create Statement object
Statement stmt = con.createStatement();
String sqlselect = "Select emp_id, emp_name, emp_job"
+ " from TBL_EMP";
//Execute query
ResultSet rs = stmt.executeQuery(sqlselect);
//Process the results

[ January 20, 2004: Message edited by: kimi lynn ]

[kimi lynn]

OK, I fixed it