update

whycrzg

2021-02-23 351b9a53cb9ecebdf8f79db0117f540d9c42c2a4

 src/main/java/com/fgkj/mapper/impl/User_ChartMapper.java

@@ -1,6 +1,14 @@
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{

@@ -10,15 +18,22 @@
   //修改图标信息
   public boolean update(Object obj) ;
   //删除图标
   public boolean del(Object obj) ;
    @Delete("delete from web_site.tb_user_Chart where chart_file=#{chart_file}")
   public int del(User_Chart obj) ;

   //查询所有chart_file
   public List searchAll();
    @Select("select num,chart_name,chart_file from web_site.tb_user_Chart order by num ")
   public List<User_Chart> searchAll();

   //根据用户id查图表
   public List serchByCondition(Object obj);
    @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放列名字)
   public List serchByInfo(Object obj);
//   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);
   
}