FoodTypeDao.java

package com.rlovep.dao.impl;

import java.sql.SQLException;
import java.util.List;

import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.handlers.BeanHandler;
import org.apache.commons.dbutils.handlers.BeanListHandler;
import org.apache.commons.dbutils.handlers.ScalarHandler;

import com.rlovep.dao.IFoodTypeDao;
import com.rlovep.entity.FoodType;
import com.rlovep.utils.JdbcUtils;


public class FoodTypeDao implements IFoodTypeDao{
	private QueryRunner qr = JdbcUtils.getQuerrRunner();
	
	@Override
	public Integer getFirstType() {
		try {
			String sql = "select * from foodType";
			//返回第一行第一列语句
			return qr.query(sql, new ScalarHandler<Integer>());
		} catch (SQLException e) {
			throw new RuntimeException(e);
		}
	}
	
	@Override
	public void add(FoodType foodtype) {
		try {
			String sql ="INSERT INTO foodType(typeName) VALUES(?);";
			qr.update(sql, foodtype.getTypeName());
		} catch (Exception e) {
			throw new RuntimeException(e);
		}
	}

	@Override
	public void delete(int id) {
		try {
			String sql ="DELETE FROM foodType WHERE id=?";
			qr.update(sql,id);
		} catch (Exception e) {
			throw new RuntimeException(e);
		}
	}

	@Override
	public void updata(FoodType foodtype) {
		try {
			String sql ="UPDATE foodType SET typeName=? WHERE id =?";
			qr.update(sql,foodtype.getTypeName(),foodtype.getId());
		} catch (Exception e) {
			throw new RuntimeException(e);
		}
		
	}

	@Override
	public List<FoodType> query() {
		try {
			String sql ="SELECT * FROM foodType";
			return  qr.query(sql,new BeanListHandler<FoodType>(FoodType.class));
		} catch (Exception e) {
			throw new RuntimeException(e);
		}
	}

	@Override
	public FoodType findById(int id) {
		try {
			String sql ="SELECT * FROM foodType where id =?";
			return qr.query(sql,new BeanHandler<FoodType>(FoodType.class), id);
		} catch (Exception e) {
			throw new RuntimeException(e);
		}
	}

	@Override
	public List<FoodType> query(String keyword) {
		try {
			String sql ="SELECT * FROM foodType WHERE typeName LIKE ?";
			return qr.query(sql,new BeanListHandler<FoodType>(FoodType.class) , "%"+keyword+"%");
		} catch (Exception e) {
			throw new RuntimeException(e);
		}
	}

}