public static ManufacturerPOJO getManufacturerById(int id) throws Exception {
ManufacturerPOJO m = null;
Connection connect = null;
try {
connect = MySqlDataAccessHelper.getConnection();
CallableStatement statement = connect.prepareCall("{Call sp_getManufacturerById(?)}");
statement.setInt(1, id);
ResultSet rs = statement.executeQuery();
if (rs.next()) {
m = new ManufacturerPOJO();
m.setManufacturerId(rs.getInt("manufacturerId"));
m.setManufacturerName(rs.getString("manufacturerName"));
m.setCountry(rs.getString("country"));
}
connect.close();
statement.close();
} catch (Exception ex) {
throw ex;
}
return m;
}
public static ArrayList<ManufacturerPOJO> getManufacturerAll() throws Exception {
ArrayList<ManufacturerPOJO> result = new ArrayList<ManufacturerPOJO>();
Connection connect = null;
try {
connect = MySqlDataAccessHelper.getConnection();
CallableStatement statement = connect.prepareCall("{Call sp_getManufacturerAll()}");
ResultSet rs = statement.executeQuery();
while (rs.next()) {
ManufacturerPOJO m = new ManufacturerPOJO();
m.setManufacturerId(rs.getInt("manufacturerId"));
m.setManufacturerName(rs.getString("manufacturerName"));
m.setCountry(rs.getString("country"));
result.add(m);
}
connect.close();
statement.close();
} catch (Exception ex) {
throw ex;
}
return result;
}