class InitializeDatabase implements EstablishConnection

{
Connection con;

static Statement stmt;

ResultSet rs;

ItemsDataBase load;

public boolean makeConnection()

{

try

{

Class.forName
("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection("jdbc:odbc:first","scott","tiger");
}

catch(ClassNotFoundException e)
{

System.out.println("Driver can not be loaded");

return false;
}

catch(SQLException e)
{

System.out.println("The Sql En caught is");

return false;
}

return true;

}

public void loadDatabase()
{


load=new ItemsDataBase();

int a=0;

try{

stmt=con.createStatement();

rs=stmt.executeQuery("select * from Books");

while(rs.next()){a++; }

rs=stmt.executeQuery("select * from garments");

while(rs.next()){a++;}
rs=stmt.executeQuery("select * from medicens");

while(rs.next()){a++; }


ItemsDataBase.setNoOfRecords(a);


rs=stmt.executeQuery("select * from books");

while(rs.next())
{

String id=rs.getString("id");

String description=rs.getString("description");
double
price=rs.getDouble("price");
String
category=rs.getString("category");
long stock=rs.getLong("stock");

String bookname=rs.getString("bookname");
String
authorname=rs.getString("authorname");

load.setBooks(id,description,price,category,stock,bookname,authorname);
}

}
}

I jope now u can understand