SYSTEMDB-HANA STUDIO-无法连接

2020-08-27 14:33发布

点击此处---> 群内免费提供SAP练习系统(在群公告中)加入QQ群:457200227(SAP S4 HANA技术交流) 群内免费提供SAP练习系统(在群公告中)你好 我的SAP HANA D...

         点击此处--->   EasySAP.com群内免费提供SAP练习系统(在群公告中)

加入QQ群:457200227(SAP S4 HANA技术交流) 群内免费提供SAP练习系统(在群公告中)


你好

我的SAP HANA DB已从2.0 SPS 0升级到2.00.037

我现在正在尝试从HANA Studio连接到SYSTEMDB,但这是不可能的。 重设了系统密码,但仍然无法连接。 我可以访问它的唯一方法是从操作系统级别使用hdbsql。 有什么建议吗? 我只能通过租户与SYSTEM和任何其他用户建立连接。

此致

弗洛林

6条回答
ZJXianG
2020-08-27 15:19

克里斯蒂安你好普莉雅

我已通过连接从Hana Studio开始跟踪-出于安全原因,我已将主机名更改为xxx :)

  Java版本:  8 ClassLoader:com.sap.ndb.studio.jdbc.JDBCPlugin $ 2 [id = 215438,parents = System @ 7428]进程ID:9968驱动程序版本:com.sap.db.jdbc软件包,Java Platform API Specification,版本1.6,  SAP HANA JDBC驱动程序,SAP SE,2.4.63-956d351aa013aa9647b14219e56abec2298beb20跟踪配置:级别:数据包,连接显示明文客户端加密的值:禁用显示时间戳:禁用跟踪文件大小:无限错误停止:禁用---- 线程65b4d45线程-24连接打开:com.sap.db.jdbc.HanaConnectionFinalize@36fe7f87属性:{connectTimeout = 10000,databaseName = SYSTEMDB,encrypt == false,instanceNumber = 02,locale = en_US,password = ***,reconnect =  true,tableOutputParameterMetaData = false,transactionalLobs = false,user = FLORIN} PreferredAddresses:[xxx:30213] ResolvedAddresses:[xxx:30213]会话开放:com.sap.db.jdbc.BasicSession@24b9b682 Ha  naConnectionFinalize @ 36fe7f87 xxx:30213 RTEException:SQLSTART_REQUIRED(5)-813无法连接到主机xxx:30213 [连接超时(本地端口64457到地址0.0.0.0,远程端口30213到地址9.20.210.139(cisbw4hana)))]--  813。  com.sap.db.jdbc.exceptions.RTEException。<init>(RTEException.java:44)处的com.sap.db.jdbc.exceptions.RTEException。<init>(RTEException.java:44)处的com.sap.db.jdbc.trace.Tracer.printCurrentStackTrace(Tracer.java:275)处的java.lang.Throwable  com.sap.db.jdbc.Exceptions.RTEException。<init>(RTEException.java:24)位于com.sap.db.jdbc.Session._throwRTEException(Session.java:938)位于com.sap.db.jdbc。  Session._openSocket(Session.java:551)位于com.sap.db.jdbc.BasicSession。<init>(BasicSession.java:50)位于com.sap.db.jdbc.BasicSession $ 1.newInstance(BasicSession.java:29  )的com.sap.db.jdbc.DriverSapDB的com.sap.db.jdbc.ConnectionSapDB._connectAnchor(ConnectionSapDB.java:2214)的com.sap.db.jdbc.Session.newInstance(Session.java:116)。  _connect(DriverSapDB.java:2407)com.sap.db.jdbc.DriverSapDB.connect(DriverSapDB.java:2063)com.sap.ndb.studio.jdbc.JDBCConnection $ 1.run(JDBCConnection.java:173)</p>
 我的计算机(Windows)中的<p>/etc/hosts已调整。 通过主机可以Ping通。  </p>
 <p>此致</p>
 <p>弗洛林</p>                                                                    <div class="appendcontent">
                                                        </div>
            </div>
           
            <div class="tool-group">
             <!-- cdn节点 回答操作 -->
<div class="cdn_question_answer107891"></div>
<script type="text/javascript">
  getquestioncaozuo(5,38500,107891);
</script>

                </div>
                </div>
             
                </div>
                <div class="comments-mod "  style="display: none; float:none;padding-top:10px;" id="comment_107891">
                    <div class="areabox clearfix">


                  <div class="input-group">
             <input type="text" placeholder="请输入评论内容,不少于5个字" AUTOCOMPLETE="off" class="comment-input form-control" name="content" />
                        <input type='hidden' value='0' name='replyauthor' />
              <span class="input-group-btn"><input type="button" value="评论"  class="btn btn-green" name="submit" onclick="addcomment(107891);"/> </span>
            </div>

                    </div>
                    <ul class="my-comments-list nav">
                        <li class="loading">
                        <img src='https://www.easysap.com/static/css/default/loading.gif' align='absmiddle' />
                        &nbsp;加载中...
                        </li>
                    </ul>
                </div>
                </div>

                         
   
               </div>
               </div>
     <div>
        
                 
        </div>
               </div>
                              <div class="noreplaytext bb">
<center><div>   <a href="https://www.easysap.com/q-38500.html">  查看其它6个回答
</a>
</div></center>
</div>             <!-- cdn 问答邀请 -->
<div class="cdn_question_invate"></div>		
<script type="text/javascript">
getquestioncaozuo(7,38500);
</script>
                                     <div class="new-answer bb">
       <h3 class="title">一周热门 <a href="content/solve" target="_blank" class="more">更多<font>&gt; </font></a></h3>
       <div class="inf-list">
          <ul class="clearfix">
                   
                        
                      </ul>
       </div>
    </div>
    
               </div>
    </div>


</div>

   </div>

   <div class="col-md-7  aside ">
   <div class="standing">
  <div class="positions bb" id="rankScroll">
      <h3 class="title">相关问答</h3>
      <ul>
      
                  <li class="no-video">
        <a href="https://www.easysap.com/q-111055.html" title="HANA MDX提供商" >   HANA MDX提供商 </a>
               <div class="num-ask">
               <a href="https://www.easysap.com/q-111055.html"  class="anum"> 6 个回答</a>
               </div>
              </li>
                                  
                  <li class="no-video">
        <a href="https://www.easysap.com/q-110942.html" title="SAP HANA 2.0用户管理:"发生了意外的错误"" >   SAP HANA 2.0用户管理:"发生了意外的错误" </a>
               <div class="num-ask">
               <a href="https://www.easysap.com/q-110942.html"  class="anum"> 4 个回答</a>
               </div>
              </li>
                                  
                  <li class="no-video">
        <a href="https://www.easysap.com/q-110917.html" title="HANA Studio-添加系统" >   HANA Studio-添加系统 </a>
               <div class="num-ask">
               <a href="https://www.easysap.com/q-110917.html"  class="anum"> 1 个回答</a>
               </div>
              </li>
                                  
                  <li class="no-video">
        <a href="https://www.easysap.com/q-110882.html" title="IDT错误curDate()" >   IDT错误curDate() </a>
               <div class="num-ask">
               <a href="https://www.easysap.com/q-110882.html"  class="anum"> 1 个回答</a>
               </div>
              </li>
                                  
                  <li class="no-video">
        <a href="https://www.easysap.com/q-110862.html" title="如何获得bais人的Hana认证" >   如何获得bais人的Hana认证 </a>
               <div class="num-ask">
               <a href="https://www.easysap.com/q-110862.html"  class="anum"> 1 个回答</a>
               </div>
              </li>
                                  
                </ul>
  </div>
  </div>
                                 


            <!--广告位5-->
           </div>
</div>
</div>

<div class="modal fade" id="dialogadopt">
<div class="modal-dialog">
  <div class="modal-content">
    <div class="modal-header">
      <button type="button" class="close" data-dismiss="modal"><span aria-hidden="true">×</span><span class="sr-only">关闭</span></button>
      <h4 class="modal-title">采纳回答</h4>
    </div>
    <div class="modal-body">

     <form class="form-horizontal"  name="editanswerForm"  method="post" >
        <input type="hidden"  value="38500" id="adopt_qid" name="qid"/>
        <input type="hidden" id="adopt_answer" value="0" name="aid"/>
        <table  class="table ">
            <tr valign="top">
                <td>向帮助了您的知道网友说句感谢的话吧!</td>
            </tr>
            <tr>
                <td>
                    <div class="inputbox mt15">
                        <textarea class="form-control" id="adopt_txtcontent"  name="content">非常感谢!</textarea>
                    </div>
                </td>
            </tr>
            <tr>
                <td><button type="button" id="adoptbtn" class="btn btn-success" >确&nbsp;认</button></td>
            </tr>
        </table>
    </form>

    </div>

  </div>
</div>
</div>
<script>
function checkpay(_qid,_aid){

var url="https://www.easysap.com/answerpay/poppay/"+_qid+"/"+_aid+".html";
var myModalTrigger = new $.zui.ModalTrigger({url:url});
myModalTrigger.show({
'backdrop':'static'
});


}
if(typeof($(".work-show-box").find("img").attr("data-original"))!="undefined"){
var imgurl=$(".work-show-box").find("img").attr("data-original");
$(".work-show-box").find("img").attr("src",imgurl);
}
$(".work-show-box").find("img").attr("data-toggle","lightbox");

$("#adoptbtn").click(function(){
  var data={
    			content:$("#adopt_txtcontent").val(),
    			qid:$("#adopt_qid").val(),
    			aid:$("#adopt_answer").val()

    	}

$.ajax({
    //提交数据的类型 POST GET
    type:"POST",
    //提交的网址
    url:"https://www.easysap.com/question/ajaxadopt.html",
    //提交的数据
    data:data,
    //返回数据的格式
    datatype: "json",//"xml", "html", "script", "json", "jsonp", "text".
    //在请求之前调用的函数
    beforeSend:function(){},
    //成功返回之后调用的函数
    success:function(data){
    	var data=eval("("+data+")");
       if(data.message=='ok'){
    	   new $.zui.Messager('采纳成功!', {
    		   type: 'success',
    		   close: true,
       	    placement: 'center' // 定义显示位置
       	}).show();
    	   setTimeout(function(){
               window.location.reload();
           },1500);
       }else{
    	   new $.zui.Messager(data.message, {
        	   close: true,
        	    placement: 'center' // 定义显示位置
        	}).show();
       }


    }   ,
    //调用执行后调用的函数
    complete: function(XMLHttpRequest, textStatus){

    },
    //调用出错执行的函数
    error: function(){
        //请求出错处理
    }
 });
})

</script>
</div>
<!-- 编辑标签 -->

<div class="modal fade" id="dialog_tag">
<div class="modal-dialog">
  <div class="modal-content">
    <div class="modal-header">
      <button type="button" class="close" data-dismiss="modal"><span aria-hidden="true">×</span><span class="sr-only">关闭</span></button>
      <h4 class="modal-title">编辑标签</h4>
    </div>
    <div class="modal-body">

    <form onsubmit=" return checktagsubmit()" class="form-horizontal"  name="edittagForm"  action="https://www.easysap.com/question/edittag.html" method="post" >
        <input type="hidden"  value="38500" name="qid"/>

                <p>最多设置5个标签!</p>

                    <div class="inputbox mar-t-1">
                      <div class=" dongtai ">
          <div class="tags">
                       <div class="tag"><span tagid="115">SAP HANA studio</span><i class="fa fa-close"></i></div>
                          <div class="tag"><span tagid="2503">sap hana</span><i class="fa fa-close"></i></div>
                          <div class="tag"><span tagid="14107">        hana 2.0</span><i class="fa fa-close"></i></div>
                          <div class="tag"><span tagid="4755">multitenant</span><i class="fa fa-close"></i></div>
                          <div class="tag"><span tagid="14108">system user</span><i class="fa fa-close"></i></div>
                          <div class="tag"><span tagid="14109">systemdb</span><i class="fa fa-close"></i></div>
                       </div>
            <input type="text" autocomplete="off"  data-toggle="tooltip" data-placement="bottom" title="" placeholder="检索标签,最多添加5个,添加标签更容易被回答" data-original-title="检索标签,最多添加5个" name="topic_tagset" value=""  class="txt_taginput" >
            <i class="fa fa-search"></i>
           <div class="tagsearch">
        
          
           </div>
            
          </div>
          
                        <input type="hidden"  class="form-control" id="qtags" name="qtags" value=""/>
                    </div>

            <div class="mar-t-1">

                <button type="submit" class="btn btn-success">保存</button>
                 <button type="button" class="btn btn-default" data-dismiss="modal">关闭</button>
      </div>
    </form>

    </div>

  </div>
</div>
</div>
 <!-- 举报 -->
<div class="modal fade panel-report" id="dialog_inform">
<div class="modal-dialog">
  <div class="modal-content">
    <div class="modal-header">
      <button type="button" class="close" data-dismiss="modal"><span aria-hidden="true">×</span><span class="sr-only">关闭</span></button>
      <h4 class="modal-title">举报内容</h4>
    </div>
    <div class="modal-body">

<form id="rp_form" class="rp_form"  action="https://www.easysap.com/inform/add.html" method="post">
<input value="" type="hidden" name="qid" id="myqid">
<input value="" type="hidden" name="aid" id="myaid">
<input value="" type="hidden" name="qtitle" id="myqtitle">
<div class="js-group-type group group-2">
<h4>检举类型</h4><ul>
<li class="js-report-con">
<label><input type="radio" name="group-type" value="1"><span>检举内容</span></label>
</li>
<li class="js-report-user">
<label><input type="radio" name="group-type" value="2"><span>检举用户</span></label>
</li>
</ul>
</div>
<div class="group group-2">
<h4>检举原因</h4><div class="list">
<ul>
<li>
<label class="reason-btn"><input type="radio" name="type" value="4"><span>广告推广</span></label>
</li>
<li>
<label class="reason-btn"><input type="radio" name="type" value="5"><span>恶意灌水</span></label>
</li>
<li>
<label class="reason-btn"><input type="radio" name="type" value="6"><span>回答内容与提问无关</span>
</label>
</li>
<li>
<label class="copy-ans-btn"><input type="radio" name="type" value="7"><span>抄袭答案</span></label>
</li>
<li>
<label class="reason-btn"><input type="radio" name="type" value="8"><span>其他</span></label>
</li>
</ul>
</div>
</div>
<div class="group group-3">
<h4>检举说明(必填)</h4>
<div class="textarea">
<ul class="anslist" style="display:none;line-height:20px;overflow:auto;height:171px;">
</ul>
<textarea name="content" maxlength="200" placeholder="请输入描述200个字以内">
</textarea>
</div>
</div>
    <div class="mar-t-1">

                <button type="submit" id="btninform" class="btn btn-success">提交</button>
                 <button type="button" class="btn btn-default mar-ly-1" data-dismiss="modal">关闭</button>
      </div>
</form>


    </div>

  </div>
</div>
</div>

<!-- 微信分享 -->
<div class="modal share-wechat animated" style="display: none;"><div class="modal-dialog"><div class="modal-content"><div class="modal-header"><button type="button" data-dismiss="modal" class="close">×</button></div> <div class="modal-body"><h5>打开微信“扫一扫”,打开网页后点击屏幕右上角分享按钮</h5> <div data-url="https://www.easysap.com/answer/38500/107891.html" class="qrcode" title="https://www.easysap.com/answer/38500/107891.html"><canvas width="170" height="170" style="display: none;"></canvas>
<div id="qr_wxcode">
</div></div></div> <div class="modal-footer"></div></div></div></div>

<!-- 设置付费金额 -->
<div class="modal pay-money animated" style="display: none;">
<div class="modal-dialog">
<div class="modal-content">
<div class="modal-header">

<button type="button" data-dismiss="modal" class="close">×</button>
</div>
<div class="modal-body">
<h5>付费偷看金额在0.1-10元之间</h5>
<div class="mar-t-1">

<input type="number" value="0" id="chakanjine" class="form-control" />

</div>
 <button id="comfirm_pay" class="btn btn-success mar-t-1">确定</button>
</div>
 <div class="modal-footer">

 </div>
 </div>
 </div>
 </div>

 <!-- 邀请回答 -->

<div class="modal fade" id="dialog_invate" >
<div class="modal-dialog" style="width:700px;top:-30px;">
  <div class="modal-content">
    <div class="modal-header">
      <button type="button" class="close" data-dismiss="modal"><span aria-hidden="true">×</span><span class="sr-only">关闭</span></button>
      <h4 class="modal-title"></h4>
       <div class="m_invateinfo">
              <span class="m_i_text""> 您已邀请<span class="m_i_persionnum">0</span>人回答</span>
       <span  data-toggle="popover" data-tip-class="popover-info" data-html="ture" data-placement="bottom" data-content="" title="我的邀请列表" class="m_i_view">查看邀请</span>

       <div class="m_i_warrper">
        <input data-qid="38500" type="text" id="m_i_searchusertxt" class="m_i_search" placeholder="搜索你想邀请的人">
        <i class="fa fa-search"></i>
       </div>

       </div>
    </div>
    <div class="modal-body" >
     <!-- 邀请回答 -->
    <ul class="trigger-menu m_invate_tab" data-pjax-container="#list-container">
 <li class="active" data-qid="38500" data-item="1"><a href="javascript:">擅长该话题的人</a></li>
<li class="" data-qid="38500" data-item="2"><a href="javascript:"> 回答过该话题的人</a></li>
<li class="" data-qid="38500" data-item="3"><a href="javascript:">我关注的人</a></li>

 </ul>
     <!-- 邀请回答列表 -->
       <div class="m_invatelist">
       </div>

    </div>

  </div>
</div>
</div>
  <script>
  getquestioncaozuo(1,38500);
  getquestioncaozuo(2,38500);
  getquestioncaozuo(3,38500);
  getquestioncaozuo(4,38500);
  $(".btnshowall").click(function(){
    $(".shortquestioncontent").toggle();
    $(".hidequestioncontent").toggle();
  });

//根据分类读取改分类下有回答的人
  function showeditor(){
$(".canwirteanswer").slideDown();
scrollTo(0,$('#showanswerform').offset().top-200);


  }


    var needcode=0;
      var g_id = 6;
  var qid = 38500;
  function listertext(){
  	 var _content=$("#anscontent").val();
  	 if(_content.length>0&&g_id!=1){

  		 $(".code_hint").show();
  	 }else{
  		 $(".code_hint").hide();
  	 }
  }
    var mobile_localyuyin=0;
  //  var userAgent = window.navigator.userAgent.toLowerCase();
//  $.browser.msie8 = $.browser.msie && /msie 8\.0/i.test(userAgent);
 // if($.browser.msie8==true){
//  var mobile_localyuyin=0;
 // }
  var targetplay=null;
  function checktagsubmit(){
if(gettagsnum()<=0){
alert("请设置标签");
return false;
}
if(gettagsnum()>5){
    alert("最多添加5个标签");
    return false;
}
 var _tagstr=gettaglist();
 $("#qtags").val(_tagstr);
 
  }
  $(".txt_taginput").on(" input propertychange",function(){
 var _txtval=$(this).val();
 if(_txtval.length>1){

 //检索标签信息
 var _data={tagname:_txtval};
 var _url="https://www.easysap.com/tags/ajaxsearch.html";
 function success(result){
 console.log(result)
 if(result.code==200){
 console.log(_txtval)
  $(".tagsearch").html("");
for(var i=0;i<result.taglist.length;i++){

 var _msg=result.taglist[i].tagname
 
           $(".tagsearch").append('<div class="tagitem" tagid="'+result.taglist[i].id+'">'+_msg+'</div>');
}
$(".tagsearch").show();
$(".tagsearch .tagitem").click(function(){
var _tagname=$.trim($(this).html());
var _tagid=$.trim($(this).attr("tagid"));
if(gettagsnum()>=5){
alert("标签最多添加5个");
return false;
}
if(checktag(_tagname)){
alert("标签已存在");
return false;
}
$(".dongtai .tags").append('<div class="tag"><span tagid="'+_tagid+'">'+_tagname+"</span><i class='fa fa-close'></i></div>");
$(".dongtai .tags .tag  .fa-close").click(function(){
$(this).parent().remove();
});
$(".tagsearch").html("");
$(".tagsearch").hide();
$(".txt_taginput").val("");
});
        
 }
 
 }
 ajaxpost(_url,_data,success);
 }else{
$(".tagsearch").html("");
$(".tagsearch").hide();
 }
})
function checktag(_tagname){
var tagrepeat=false;
$(".dongtai .tags .tag span").each(function(index,item){
var _tagnametmp=$.trim($(this).html());
if(_tagnametmp==_tagname){
tagrepeat=true;
}
})
return tagrepeat;
}
function gettaglist(){
var taglist='';
$(".dongtai .tags .tag span").each(function(index,item){
var _tagnametmp=$.trim($(this).attr("tagid"));
taglist=taglist+_tagnametmp+",";

})
taglist=taglist.substring(0,taglist.length-1);

return taglist;
}
function gettagsnum(){
      return $(".dongtai .tags .tag").length;
}
$(".tagsearch .tagitem").click(function(){
var _tagname=$.trim($(this).html());
if(gettagsnum()>=5){
alert("标签最多添加5个");
return false;
}
if(checktag(_tagname)){
alert("标签已存在");
return false;
}
$(".dongtai .tags").append('<div class="tag"><span>'+_tagname+"</span><i class='fa fa-close'></i></div>");
$(".dongtai .tags .tag  .fa-close").click(function(){
$(this).parent().remove();
});
$(".tagsearch").html("");
$(".tagsearch").hide();
$(".txt_taginput").val("");
});
$(".dongtai .tags .tag  .fa-close").click(function(){
$(this).parent().remove();
});
  $(".yuyinplay").click(function(){
  	targetplay=$(this);
  	var _serverid=targetplay.attr("id");
  	   if(_serverid == '') {
  			alert('语音文件丢失');
             return;
         }
  	   $(".wtip").html("免费偷听");
  	   targetplay.find(".wtip").html("播放中..");
  	   if(mobile_localyuyin==1){
  		 $(".htmlview").removeClass("hide");
   $(".ieview").addClass("hide");

  		   var myAudio =targetplay.find("#voiceaudio")[0];
  	  	  // myAudio.pause();
  	  	   //myAudio.play();
  	  	   if(myAudio.paused){
  	  		   targetplay.find(".wtip").html("播放中..");
  	             myAudio.play();
  	         }else{
  	      	   targetplay.find(".wtip").html("暂停..");
  	             myAudio.pause();
  	         }
  	  	   function endfun(){ targetplay.find(".wtip").html("播放结束");alert("播放结束!")}
  	  	   var   is_playFinish = setInterval(function(){
  	             if( myAudio.ended){

  	          	   endfun();
  	  	                    window.clearInterval(is_playFinish);
  	             }
  	     }, 10);
  	   }else{

  		 $(".ieview").removeClass("hide");
  		   $(".htmlview").addClass("hide");
  	   }




  })
function deleteanswer(current_aid){
  if(confirm("是否删除此回答?")){
window.location.href=g_site_url + "index.php" + query + "question/deleteanswer/"+current_aid+"/38500";
  
  }

}
  function adoptanswer(aid) {

      $("#adopt_answer").val(aid);

      $('#dialogadopt').modal('show');
}
  //编辑标签
  function edittag() {
 	 $('#dialog_tag').modal('show');

 }
  if(typeof($(".show-content").find("img").attr("data-original"))!="undefined"){
var imgurl=$(".show-content").find("img").attr("data-original");
$(".show-content").find("img").attr("src",imgurl);
}
$(".show-content").find("img").attr("data-toggle","lightbox");

  var category1 = [["42","S/4HANA"],["17","Fiori"],["45","UI5"],["20","HANA"],["2","ABAP"],["16","FICO"],["47","SD"],["26","MM"],["36","PP"],["34","PM"],["37","PS"],["54","WM"],["38","QM"],["12","CRM"],["8","BPC"],["9","BPM"],["11","BW"],["7","BO"],["32","PI"],["44","PO"],["6","Basis"],["46","SCM"],["49","SRM"],["21","HCM"],["24","Logistics Execution"],["33","PLM"],["15","EWM"],["41","RPA"],["4","Ariba"],["50","SuccessFactors"],["55","Workflow"],["3","APO"],["5","B1"],["10","BSP"],["13","DATA"],["22","HTML5"],["53","Web Dynpro"],["18","GRC"],["43","SAP Cloud"],["19","GTS"],["23","Hybris"],["25","Lumira"],["27","Mobile"],["28","NetWeaver"],["1","SAP Industry Solutions"],["35","PORTAL"],["48","SOLMAN"],["52","UI"],["59","Machine Learning"],["56","Big Data"],["57","Blockchain"],["58","Training"],["31","Others"]];
  var category2 = [];
  var category3 = [];
  var selectedcid = "20,0,0";
  //修改分类
  function change_category() {
      var category1 = $("#category1 option:selected").val();
              var category2 = $("#category2 option:selected").val();
              var category3 = $("#category3 option:selected").val();
              if (category1 > 0) {
      $("#categoryid").val(category1);
      }
      if (category2 > 0) {
      $("#categoryid").val(category2);
      }
      if (category3 > 0) {
      $("#categoryid").val(category3);
      }
      $("#catedialog").model("hide");
              $("form[name='editcategoryForm']").submit();
      }
  //投诉
  function openinform(qid ,qtitle,aid) {
  $("#myqid").val(qid);
  $("#myqtitle").val(qtitle);
  $("#myaid").val(aid);
 	 $('#dialog_inform').modal('show');

 }
  $(".showcommentid").each(function(){
       var dataid=$(this).attr("data-id");
       show_comment(dataid);
  });
  function show_comment(answerid) {
      if ($("#comment_" + answerid).css("display") === "none") {
      load_comment(answerid);
              $("#comment_" + answerid).slideDown();
      } else {
      $("#comment_" + answerid).slideUp();
      }
      }
  //添加评论
  function addcomment(answerid) {
  var content = $("#comment_" + answerid + " input[name='content']").val();
  var replyauthor = $("#comment_" + answerid + " input[name='replyauthor']").val();
  if (g_uid == 0){
      login();
      return false;
  }
  if (bytes($.trim(content)) < 5){
  alert("评论内容不能少于5字");
          return false;
  }
  $.ajax({
  type: "POST",
          url: "https://www.easysap.com/answer/addcomment.html",
          data: "content=" + content + "&answerid=" + answerid+"&replyauthor="+replyauthor,
          success: function(status) {
          if (status == '1') {
          $("#comment_" + answerid + " input[name='content']").val("");
                  load_comment(answerid);
          }else{
          	if(status == '-2'){
          		alert("问题已经关闭,无法评论");
          	}
          }
          }
  });
  }
  
  //删除评论
  function deletecomment(commentid, answerid) {
  if (!confirm("确认删除该评论?")) {
  return false;
  }
  $.ajax({
  type: "POST",
          url: "https://www.easysap.com/answer/deletecomment.html",
          data: "commentid=" + commentid + "&answerid=" + answerid,
          success: function(status) {
          if (status == '1') {
          load_comment(answerid);
          }
          }
  });
  }
  //加载评论
  function load_comment(answerid){
  $.ajax({
  type: "GET",
          cache:false,
          url: "https://www.easysap.com/index.php?answer/ajaxviewcomment/" + answerid,
          success: function(comments) {
          $("#comment_" + answerid + " .my-comments-list").html(comments);
          }
  });
  }

  function replycomment(commentauthorid,answerid){
      var comment_author = $("#comment_author_"+commentauthorid).attr("title");
      $("#comment_"+answerid+" .comment-input").focus();
      $("#comment_"+answerid+" .comment-input").val("回复 "+comment_author+" :");
      $("#comment_" + answerid + " input[name='replyauthor']").val(commentauthorid);
  }
$(function(){
  initcategory(category1);
          fillcategory(category2, $("#category1 option:selected").val(), "category2");
          fillcategory(category3, $("#category2 option:selected").val(), "category3");
        	var qrurl="https://www.easysap.com/answer/38500/107891.html";
//微信二维码生成
$('#qr_wxcode').qrcode(qrurl);
     //显示微信二维码
     $(".share-weixin").click(function(){
    	 $(".share-wechat").show();
     });
     //关闭微信二维码
     $(".close").click(function(){
    	 $(".share-wechat").hide();
    	 $(".pay-money").hide();
     });
  
     $(".button_agree").click(function(){
             var supportobj = $(this);
                     var answerid = $(this).attr("id");
                     $.ajax({
                     type: "GET",
                             url:"https://www.easysap.com/index.php?answer/ajaxhassupport/" + answerid,
                             cache: false,
                             success: function(hassupport){
                             if (hassupport != '1'){






                                     $.ajax({
                                     type: "GET",
                                             cache:false,
                                             url: "https://www.easysap.com/index.php?answer/ajaxaddsupport/" + answerid,
                                             success: function(comments) {

                                             supportobj.find("span").html(comments+"人赞");
                                             }
                                     });
                             }else{
                            	 alert("您已经赞过");
                             }
                             }
                     });
             });

})


                </script>
<div id="usercard" style="position:absolute;z-index:999999999;"></div>
   <script src="https://www.easysap.com/static/js/jquery.lazyload.min.js" type="text/javascript"></script>
<script>

   

                    $("img.lazy").lazyload({effect: "fadeIn" });

</script>

  <div class="side-tool" id="to_top"><ul><li data-placement="left" data-toggle="tooltip" data-container="body" data-original-title="回到顶部" >
    <a href="#" class="function-button"><i class="fa fa-angle-up"></i></a>
    </li>



      </ul></div>
      <script>
window.onload = function(){
  $(".edui-upload-video").attr("preload","");
  var oTop = document.getElementById("to_top");

  var screenw = document.documentElement.clientWidth || document.body.clientWidth;
  var screenh = document.documentElement.clientHeight || document.body.clientHeight;
  window.onscroll = function(){
    var scrolltop = document.documentElement.scrollTop || document.body.scrollTop;
 
    if(scrolltop<=screenh){
    	oTop.style.display="none";
    }else{
    	oTop.style.display="block";
    }
    if(scrolltop>30){
     
    	$(".scrollshow").show();
    }else{
    	$(".scrollshow").hide();
    }
  }
  oTop.onclick = function(){
    document.documentElement.scrollTop = document.body.scrollTop =0;
  }
}

</script>

    <footer id="footer">
        <div class="footer-wrapper">
            <div class="footer-wrapper-top">
                <div class="footer-wrapper-top-left">
                    <a href="https://www.easysap.com/tags.html"><i class="hide"></i>标签大全</a>
                    <a href="https://www.easysap.com/new.html" >站内问题</a>
                    <a href="https://www.easysap.com/topic/default.html" >专栏文章</a>
                    <a href="https://www.easysap.com/expert/default.html">站内专家</a>
                    <a href="https://www.easysap.com/category/viewtopic/hot" >站内话题</a>
                    <a href="https://www.easysap.com/note/list.html" >站内公告</a>
                     <a href="https://www.easysap.com/rule/index.html">财富值规则</a>
                       <script>
var _hmt = _hmt || [];
(function() {
  var hm = document.createElement("script");
  hm.src = "https://hm.baidu.com/hm.js?91cd836d35676d254ee158461ecf506f";
  var s = document.getElementsByTagName("script")[0]; 
  s.parentNode.insertBefore(hm, s);
})();
</script>                     
                </div>
               
            </div>
            
                        
         
           
            <div class="footer-wrapper-bottom space-footer-bottom">
                <a href="http://www.12377.cn/" target="_blank">网上有害信息举报专区</a>
                    <i></i>
                    <a href="https://beian.miit.gov.cn/" target="_blank">京ICP备2021023650号</a>
                <i></i>
                <span ><a href="https://www.easysap.com/rss/articlelist.xml" target="_blank">站内文章地图xml</a></span>
                <i></i>
                <span><a href="https://www.easysap.com/rss/list.xml" target="_blank">站内问答地图xml</a></span>
                <i></i>
                <span><a href="https://www.easysap.com/rss/userspace.xml" target="_blank">站内作者地图xml</a></span>
               <i></i>
                <span><a href="https://www.easysap.com/rss/tag.xml" target="_blank">站内标签地图xml</a></span>
            
              <!--<span class="copyrightLink">Copyright © 2024 <a href="https://www.easysap.com/" target="_blank">EasySAP</a></span>-->
              <span class="copyrightLink">Copyright © 2024 <a href="https://www.easysap.com/" target="_blank">EasySAP</a></span>
            </div>
        </div>
    </footer>

</div>

</body>
</html>