mgb生成的代码:
dao:
FoodMapper.java
FoodSqlProvider.java
entity:
Food.java
FoodExample.java
@Service
public class FoodServiceImpl implements FoodService{
@Autowired
FoodMapper foodMapper;
//查询
public List<Food> queryFoodByFoodName(String foodName) {
FoodExample foodExample = new FoodExample();
Criteria criteria = foodExample.createCriteria();
criteria.andFoodnameLike("%"+foodName+"%");
//自己写条件 FoodExample中方法addCriterion的权限改为public
return foodMapper.selectByExample(foodExample);
}
//新增
public void saveFood(String foodName, String price) {
Food food=new Food();
food.setFoodname(foodName);
food.setPrice(Double.valueOf(price));
//foodMapper.insert(food); 该方法是插入表中所有的列
foodMapper.insertSelective(food); //插入有数据的列
}
//更新
public void updateFood(String foodId, String foodName, String price) {
Food food=new Food();
food.setFoodname(foodName);
food.setPrice(Double.valueOf(price));
food.setFoodid(Integer.valueOf(foodId));
//foodMapper.updateByExample(food, foodExample); sql语句:修改所有的列
foodMapper.updateByPrimaryKeySelective(food); //sql语句:修改插入数据的列
}
//删除
public void deleteFood(String foodId) {
foodMapper.deleteByPrimaryKey(Integer.valueOf(foodId));
}
}
dao:
FoodMapper.java
FoodSqlProvider.java
entity:
Food.java
FoodExample.java
@Service
public class FoodServiceImpl implements FoodService{
@Autowired
FoodMapper foodMapper;
//查询
public List<Food> queryFoodByFoodName(String foodName) {
FoodExample foodExample = new FoodExample();
Criteria criteria = foodExample.createCriteria();
criteria.andFoodnameLike("%"+foodName+"%");
//自己写条件 FoodExample中方法addCriterion的权限改为public
return foodMapper.selectByExample(foodExample);
}
//新增
public void saveFood(String foodName, String price) {
Food food=new Food();
food.setFoodname(foodName);
food.setPrice(Double.valueOf(price));
//foodMapper.insert(food); 该方法是插入表中所有的列
foodMapper.insertSelective(food); //插入有数据的列
}
//更新
public void updateFood(String foodId, String foodName, String price) {
Food food=new Food();
food.setFoodname(foodName);
food.setPrice(Double.valueOf(price));
food.setFoodid(Integer.valueOf(foodId));
//foodMapper.updateByExample(food, foodExample); sql语句:修改所有的列
foodMapper.updateByPrimaryKeySelective(food); //sql语句:修改插入数据的列
}
//删除
public void deleteFood(String foodId) {
foodMapper.deleteByPrimaryKey(Integer.valueOf(foodId));
}
}