public VehicleCategory searchCategory(String searchText)
throws SQLException, ClassNotFoundException {
Connection connection = DataBaseConnection.getConnection();
Statement createStatement = connection.createStatement();
String sql =
"SELECT description FROM VEHICLECATEGORY where vehiclecategoryid = '" + searchText + "';";
ResultSet set = createStatement.executeQuery(sql);
VehicleCategory category = new VehicleCategory();
while (set.next()) {
category.setDescription(set.getString("description"));
}
return category;
}
