• 
  EXCEL导入后标题被改变了

  Desktop.rar如图，导入excel后表头被改变了，按表头匹配但是为啥表头被改变了，这是导入的表格

  449个浏览 1个回答 2023年02月24日发布
• 
  服务器决策平台打不开，报错数据库连接，数据库连接不上，想修改数据库连接也修改不了

  2023-01-31 16:49:01 Druid-ConnectionPool-Create-157535728jdbc:oracle:thin:@172.16.20.1:1521:wh ERROR  create connection error, url: jdbc:oracle:thin:@172.16.20.1:1521:wh, errorCode 17002, state nulljava.sql.SQLException: Io 异常: The Network Adapter could not establish the connection        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:111)        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:145)        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:254)        at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:386)        at oracle.jdbc.driver.PhysicalConnection.

  1856个浏览 5个回答 2023年02月01日发布
• 
  填报提交不生效，表是视图，在数据库update可以修改，但是填报修改不生效，report不能对视图填

  488个浏览 3个回答 2022年09月13日发布
• 
  数据集if判断用那个sql，带参数

  为啥里面加了一个if，外面这个参数就没有了，然后里面的if去掉，外面这个参数才能用${if((OA='1'),"select *       from newsoft_cs.oa_wt_temp tmpleft join newsoft_cs.oa_wt t on tmp.file_id = t.file_idwhere t.status in ('S','A','ST') and${if(len(zt) == 0,"","and t.status in ('" + zt + "')")}${if(len(dybh) == 0,"","and tmp.print_code in ('" + dybh + "')")}${if(len(sfz) == 0,"","and tmp.user_id in ('" + sfz + "')")}${if(len(khmc) == 0,"","and tmp.customer_name in ('" + khmc + "')")}${if(len(strxm) == 0,"","and tmp.user_name in ('" + strxm + "')")}${if(len(stime) == 0,"","and tmp.begin_time >= ('" + stime + "')")}${if(len(etime) == 0,"","and tmp.end_time < ('" + etime + "')")}","select * from newsoft_cs.oa_wt_view WHERE 1=1${if(len(zt) == 0,"","and t.status in ('" + zt + "')")}${if(len(dybh) == 0,"","and tmp.print_code in ('" + dybh + "')")}${if(len(sfz) == 0,"","and tmp.user_id in ('" + sfz + "')")}${if(len(khmc) == 0,"","and tmp.customer_name in ('" + khmc + "')")}${if(len(strxm) == 0,"","and tmp.user_name in ('" + strxm + "')")}${if(len(stime) == 0,"","and tmp.begin_time >= ('" + stime + "')")}${if(len(etime) == 0,"","and tmp.end_time < ('" + etime + "')")}")}

  768个浏览 3个回答 2022年09月02日发布
• 
  数据集能直接用if判断用那个sql语句么

  if(${OA}==0,select 1 from dump,select 0 from dump)怎么判断当参数选折1的时候，用第一个sql语句，否则用第二个，

  603个浏览 3个回答 2022年09月01日发布

5

132

5

10