JDBC example to populate a regular bean from SQL Server 2000

Well first you will have to create a Database Access Bean to start with.
I am assuming here that you are connecting to your SQL server over a JDBC-ODBC bridge

public class DbBean
{
Connection DataBCon;
Statement stmt;
public Statement connect()
{
try{
DataBDriver = (Driver)Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
DataBCon = DriverManager.getConnection("jdbc:odbc:bdsql");
stmt = DataBCon.createStatement();
return stmt;
}
catch(Exception e)
{
return null;
}
}
}


Now in your beans you can instanciate this class, get a statment and use it for data fetching

Hi,
Sorry for the late reply....but the accepted answer was exactly what I was looking for...

Excellent...

Thanks...

_Esam

Cheers _Esam :-)