根据id查询数据(向前台返回json格式的数据)

/**
*@description 根据主键查询Bean
*/
@RequestMapping(value="/getBean/{getId}")
public void getBean(HttpServletRequest request,HttpServletResponse response,@PathVariable Object getId)
{
if(getId!=null && getId.toString().length()>0){
AppActivityDetails appActivityDetails=new AppActivityDetails();
appActivityDetails.setId(Long.parseLong(getId.toString()));
appActivityDetails=appActivityDetailsService.getT(appActivityDetails);
super.writeClient(response, super.ObjectChangJSONObject(appActivityDetails).toString(), "");}
}
 
  
 {field:"opt",title:"操作",width:60,align:"center",
                formatter:function(value,rowData,rowIndex){
                  var html="<img class='op-enable' src='"+appPath+"/js/lib/jquery-easyui/themes/icons/pencil.png' onClick='showWinMsGoods("+rowData.id+")' title='编辑'/>";
                  return html;
                }


 toolbar:[
          {
              id:'btnadd',
              text:'添加',
              iconCls:'icon-add',
              handler:function(){    
                 showWinDetails(null);
              }    
          },"-",
]

 

function showWinMsGoods(id){
      $("#idHiddenMsImage").val("");
      $("#addtitleMsImage").val("");
      $("#uploadImg1").attr("src", appPath + "/images/common/emptyImg.jpg");
      $("#adddetailsImgMsImage").val("");
      $("#uploadImg2").attr("src", appPath + "/images/common/emptyImg.jpg");
      $("#addlinkMsImage").val("");

      $("#addbeginTimeMsImage").datebox("setValue","");
      $("#addendTimeMsImage").datebox("setValue","");
      $("#addgoodsNoMsImage").val("");
      var iconStr="icon-add";
      if(id!=null){
         iconStr="icon-edit";
         $.post(
            appPath+"/page/appActivityDetailsAct/getBean/"+id, 
            {}, 
            function(data){
               $("#idHiddenMsImage").val(data.id);
               $("#addtitleMsImage").val(data.title);
               
               $("#adddetailsImgMsImage").val(data.detailsImg);
               $("#uploadImg1").attr("src",data.detailsImg);
               $("#addlinkMsImage").val(data.link);
               $("#uploadImg2").attr("src",data.link);
               
//               $('#colorSelector3').css("background-color", data.backgroundColor);
               $("#addbeginTimeMsImage").datebox("setValue",data.beginTime);
               $("#addendTimeMsImage").datebox("setValue",data.endTime);
               $("#addgoodsNoMsImage").val(data.goodsNo);
            },"json");
      }
      $('#opreateHtmlMsGoods').window({
            title:'编辑',
            iconCls:iconStr,
            width:500,
            height:420,
            left:200,
            modal: true,
            shadow: true,
            collapsible:false,
            minimizable:false,
            maximizable:false
      });
      $('#opreateHtmlMsGoods').window('move',{top:100});
      $('#opreateHtmlMsGoods').window('open');
    }
 /**
  *@description 根据主键查询Bean
  */
  @RequestMapping(value="/getBean/{getId}")
  public void getBean(HttpServletRequest request,HttpServletResponse response,@PathVariable Object getId)
  {
    if(getId!=null && getId.toString().length()>0){
    AppActivityDetails appActivityDetails=new AppActivityDetails();
    appActivityDetails.setId(Long.parseLong(getId.toString()));
    appActivityDetails=appActivityDetailsService.getT(appActivityDetails);
    super.writeClient(response, super.ObjectChangJSONObject(appActivityDetails).toString(), "");}
  }
@Override
    public T getT(T t) {
        return (T)commonDao.queryForObject(t.getClass().getSimpleName()+".get"+t.getClass().getSimpleName(), t);
 
  
                                                                          // getAppActivityDetails(与sql中的id名称一致)
      //return commonDao.queryForObject("PharmacistComment.getpharmacistCommentPageByPageId",pharmacistComment);
 
  

 


}
 <resultMap id="AppActivityDetailsMap" class="AppActivityDetails">
    <result column="DETAILS_IMG" property="detailsImg" />
    <result column="STANDBY2" property="standby2" />
    <result column="STANDBY1" property="standby1" />
    <result column="ADD_USER_ID" property="addUserId" />
    <result column="EDIT_TIME" property="editTime" />
    <result column="IS_DELETE" property="isDelete" />
    <result column="BACKGROUND_COLOR" property="backgroundColor" />
    <result column="GOODS_NO" property="goodsNo" />
    <result column="ADD_TIME" property="addTime" />
    <result column="PUBLISH_ID" property="publishId" />
    <result column="EDIT_USER_ID" property="editUserId" />
    <result column="BEGIN_TIME" property="beginTime" />
    <result column="LINK" property="link" />
    <result column="ID" property="id" />
    <result column="END_TIME" property="endTime" />
    <result column="APP_ACTIVITY_LIST_ID" property="appActivityListId" />
    <result column="TITLE" property="title" />
  </resultMap>



 <select id="getAppActivityDetails"  parameterClass="AppActivityDetails"  resultMap="AppActivityDetailsMap">
       select id, 
       app_activity_list_id, 
       title, 
       details_img, 
       link, 
       publish_id, 
       goods_no, 
       background_color, 
       begin_time, 
       end_time, 
       standby1, 
       standby2, 
       is_delete, 
       add_time, 
       add_user_id, 
       edit_time, 
       edit_user_id from app_activity_details where IS_DELETE='N'  and  id=#id#
  </select>

 

 

//另一种方法

formatter : function(value, rowData,
                                            rowIndex) {
                                        var html = '';
                                        html += "<img class='op-enable' src='"+ appPath+ "/js/lib/jquery-easyui/themes/icons/pencil.png' onClick='showWin("    + rowData.pharmacistCommentId+ ")' title='编辑'/>&nbsp;";
                                        
                                        }
                                        return html;
                                    }
toolbar : [ {
                            id : 'btnExcel',
                            text : '导出文件',
                            iconCls : 'icon-exportExcel',
                            handler : function() {
                                exportExcel();
                            }
                        }, "-", {
                            id : 'btnPass',
                            text : '批量删除',
                            iconCls : 'icon-cancel',
                            handler : function() {
                                deletes('');
                            }
                        }, "-", {
                            id : 'btnOpen',
                            text : '批量启动',
                            iconCls : 'icon-ok',
                            handler : function() {
                                isOpen('');
                            }
                        }, "-", {
                            id : 'btnClose',
                            text : '批量关闭',
                            iconCls : 'icon-cancel',
                            handler : function() {
                                isClose('');
                            }
                        }, "-", {
                            id : 'btnMessage',
                            text : '药师点评设置',
                            iconCls : 'icon-search',
                            handler : function() {
                                showWin(null);
                            }
                        } ]



/**
 * 编辑
 * @param id
 */
function showWin(id) {
    $("#idHidden").val("");
    CKEDITOR.instances.addpharmacistCommentMessage.setData('');
    $("#addgoodsNo").val("");
    $("#addgoodsName").val("");
    $("#uploadImg").attr("src", '');
    var iconStr = "icon-add";
    var title = "添加药师点评设置";
    if (id != null) {
        iconStr = "icon-edit";
        title = "编辑药师点评设置";
        $.post(appPath + "/page/pharmacistCommentAct/getBean/" + id, {},
                function(data) {
                    $("#idHidden").val(data.pharmacistCommentId);
                    CKEDITOR.instances.addpharmacistCommentMessage
                            .setData(data.pharmacistCommentMessage);
                    $("#addgoodsNo").val(data.goodsNo);
                    $("#addgoodsName").val(data.goodsName);
                    $("#uploadImg").attr("src", data.imgUrl);
                }, "json");
        $('#queryGoods').css('display', 'none');
    } else {
        $('#queryGoods').css('display', 'block');
    }
    $('#opreateHtml').window({
        title : title,
        iconCls : iconStr,
        width : 800,
        height : 600,
        left : 200,
        modal : true,
        shadow : true,
        collapsible : false,
        minimizable : false,
        maximizable : false
    });
    $('#opreateHtml').window('move', {
        top : 0
    });
    $('#opreateHtml').window('open');

}
 
  
/**
     * @author wangchuanfu
     * @description 用ID查询对象
     */
    @RequestMapping(value = "/getBean/{getId}")
    @ResponseBody
    public PharmacistComment getBean(HttpServletRequest request,
            HttpServletResponse response, @PathVariable Long getId) {
        PharmacistComment pharmacistComment = new PharmacistComment();
        pharmacistComment.setPharmacistCommentId(getId);

        return pharmacistCommentService
                .getpharmacistCommentPageByPageId(pharmacistComment);
    }
@Override
    public PharmacistComment getpharmacistCommentPageByPageId(
            PharmacistComment pharmacistComment) {
        return (PharmacistComment) commonDao.queryForObject(
                "PharmacistComment.getpharmacistCommentPageByPageId",
                pharmacistComment);
    }
<resultMap id="PharmacistCommentMapEdit" class="PharmacistComment">
        <result column="IS_ONLINE" property="isOnline" />
        <result column="PHARMACIST_COMMENT_MESSAGE" property="pharmacistCommentMessage" />
        <result column="GOODS_NO" property="goodsNo" />
        <result column="EDIT_USER_NAME" property="editUserName" />
        <result column="PHARMACIST_COMMENT_ID" property="pharmacistCommentId" />
        <result column="GOODS_NAME" property="goodsName" />
        <result column="PRO_IMAGE_URL" property="imgUrl" />
    </resultMap>

<select id="getpharmacistCommentPageByPageId" resultMap="PharmacistCommentMapEdit"
        parameterClass="PharmacistComment">

        select pi.pro_image_url,
        pc.goods_no,
        DECODE(pc.is_online, 'N', '关闭', 'Y', '开启') as is_online,
        pc.PHARMACIST_COMMENT_MESSAGE,
        pc.PHARMACIST_COMMENT_ID,
        su.user_real_name as EDIT_USER_NAME,
        g.goods_name
        from PHARMACIST_COMMENT pc
        inner join goods g
        on pc.goods_no = g.goods_no
        and g.is_delete = 'N'
        left join fecerp.sys_user su
        on pc.edit_user_id = su.user_id
        and su.is_delete = 'N'
        left join product_img pi
        on pi.product_id = g.product_id
        where pc.IS_DELETE = 'N'
        and rownum = 1
        and pc.PHARMACIST_COMMENT_ID=#pharmacistCommentId#
    </select>

 

 
 

 

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值