package com.whyc.mapper;
|
|
import com.whyc.pojo.ExperimentPrecondition;
|
import net.sf.jsqlparser.expression.JdbcNamedParameter;
|
import org.apache.ibatis.annotations.Select;
|
import org.apache.ibatis.annotations.Update;
|
|
import java.util.List;
|
|
public interface CommonMapper {
|
|
@Select("select TABLE_NAME FROM information_schema.TABLES where TABLE_SCHEMA= #{dBName} and TABLE_NAME like concat(#{tableLike},'%')")
|
List<String> getTableName(String dBName, String tableLike);
|
|
@Select("select ${field} as actualValue from ${tableName} where dev_id in (#{deviceId})")
|
Object getPreconditionStatus(ExperimentPrecondition precondition);
|
|
@Update("update ${tableName} set ${field} = #{value} where dev_id in (${deviceId})")
|
int setPrecondition(String tableName,String deviceId,String field,String value);
|
}
|
