package com.sm.graduation.accident.dao;

import java.util.List;
import java.util.Map;

import org.apache.ibatis.annotations.*;
import com.sm.graduation.accident.pojo.AccidentRecord;

@Mapper
public interface AccidentRecordMapper {


	List<AccidentRecord> listAll(Map map);

	@Select("select id,accident,`desc`,acc_time,loss from accident_record where id=#{id}")
	AccidentRecord getById(Long id);

	@Insert("insert into accident_record(accident,`desc`,acc_time,loss) values(#{accident},#{desc},#{accTime},#{loss})")
	int insert(AccidentRecord accidentRecord);

	@Update("update accident_record set accident=#{accident},`desc`=#{desc}, acc_time=#{accTime}, loss=#{loss} where id=#{id}")
	int update(AccidentRecord accidentRecord);

	@Delete("delete from accident_record where id=#{id}")
	int delete(Integer id);

}