package com.fgkj.mapper.impl;
|
|
import java.sql.Blob;
|
import java.util.List;
|
|
import com.fgkj.dto.User_Chart;
|
import com.fgkj.dto.User_inf;
|
import org.apache.ibatis.annotations.Delete;
|
import org.apache.ibatis.annotations.Select;
|
import org.apache.ibatis.reflection.MetaObject;
|
import org.springframework.stereotype.Repository;
|
|
public interface User_ChartMapper{
|
|
//添加图标
|
public boolean add(Object obj);
|
|
//修改图标信息
|
public boolean update(Object obj) ;
|
//删除图标
|
@Delete("delete from web_site.tb_user_Chart where chart_file=#{chart_file}")
|
public int del(User_Chart obj) ;
|
|
//查询所有chart_file
|
@Select("select num,chart_name,chart_file from web_site.tb_user_Chart order by num ")
|
public List<User_Chart> searchAll();
|
|
//根据用户id查图表
|
@Select("select distinct(chart_file) from web_site.tb_user_Chart,db_user.tb_user_inf " +
|
" where web_site.tb_user_Chart.chart_name=db_user.tb_user_inf.ujobgroup " +
|
" and db_user.tb_user_inf.uname=#{uName}")
|
public List<User_Chart> serchByCondition(User_inf obj);
|
|
//根据chart_file和列名查询图片(Chart_name放列名字)
|
// String sql="select "+uchart.getChart_name()+" from web_site.tb_user_Chart where chart_file=? ";
|
@Select("select Chart_name from web_site.tb_user_Chart where chart_file= #{chart_file}")
|
public List<Blob> serchByInfo(User_Chart obj);
|
|
}
|
