public string validateuser(string inputuserid, string inputpwd)

throws sqlexception{

string returnstring = null;

string dbuserid = "userid"; // your database user id

string dbpassword = "password" ; // your database password

class.forname("sun.jdbc.odbc.jdbcodbcdriver");

connection con = drivermanager.getconnection("jdbc:odbc:mydriver",

dbuserid ,dbpassword );

statement stmt = con.createstatement();

string sql= "select userid from usertable where userid = "" +

inputuserid + "" and password = "" + inputpwd +"" ;" ;

resultset rs = stmt.executequery(sql);

if (rs.next())

{

returnstring = rs.getstring("userid");

}

stmt.close();

con.close();

return returnstring ;

}