/** * displaying rows from element table */ void displayElements () { string sqlStmt = "SELECT element_name, molar_volume, atomic_weight FROM elements \ order by element_name"; stmt = conn->createStatement (sqlStmt); ResultSet *rset = stmt->executeQuery (); try{ cout.precision(7); while (rset->next ()) { string elem_name = rset->getString(1); BFloat mol_vol = rset->getBFloat(2); BDouble at_wt = rset->getBDouble(3); cout << "Element Name: " << elem_name << endl; if ( mol_vol.isNull ) cout << "Molar Volume is NULL" << endl; else cout << "Molar Volume: " << mol_vol.value << " cm3 mol-1" << endl; if ( at_wt.isNull ) cout << "Atomic Weight is NULL" << endl; else cout << "Atomic Weight: " << at_wt.value << " g/mole" << endl; } }catch(SQLException ex) { cout<<"Exception thrown for displayElements"<<endl; cout<<"Error number: "<< ex.getErrorCode() << endl; cout<<ex.getMessage() << endl; } stmt->closeResultSet (rset); conn->terminateStatement (stmt); }