package com.ekexiu.console.system.dao;

import com.ekexiu.console.system.po.ProfessorEduBg;
import org.jfw.apt.annotation.Nullable;
import org.jfw.apt.orm.annotation.dao.DAO;
import org.jfw.apt.orm.annotation.dao.method.From;
import org.jfw.apt.orm.annotation.dao.method.OrderBy;
import org.jfw.apt.orm.annotation.dao.method.operator.*;

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

/**
 * Created by TT on 2017/7/14.
 */
@DAO
public interface ProfessorEduBgDao {
    @Insert
    int insert(Connection con, ProfessorEduBg edu) throws SQLException;

    @Update
    int update(Connection con, ProfessorEduBg edu) throws SQLException;

    @SelectList
    @OrderBy(" ORDER BY YEAR DESC ")
    List<ProfessorEduBg> query(Connection con, String professorId) throws SQLException;

    @Nullable
    @SelectOne
    ProfessorEduBg queryOne(Connection con, String id) throws SQLException;

    @DeleteWith
    @From(ProfessorEduBg.class)
    int delete(Connection con, String id) throws SQLException;
}