posts - 20,comments - 6,trackbacks - 0
          frame錨點靜態chm書/Files/spiritahead/frame.rar
          posted @ 2010-02-02 16:31 Johnhe 閱讀(239) | 評論 (0)編輯 收藏
          System.out.println("-------------2----------"+uuid);
              
          if(flag == 1){
                  String url_success
          ="wangdian_extend_update.jsp?dwdm="+dwdm+"&wxyid="+wxyid+"&uuid="+uuid;
                  out.println(
          "<script>window.setTimeout(\"window.location='"+url_success+"'\",10)</script>");
              }
          else{
                  out.println(
          "添加失敗!");
                  String url_fail
          ="wangdian_extend.jsp?dwdm="+dwdm+"&wxyid="+wxyid;
                  out.println(
          "<script>window.setTimeout(\"window.location='"+url_fail+"'\",10)</script>");
              }
          posted @ 2009-07-02 18:02 Johnhe 閱讀(171) | 評論 (0)編輯 收藏
          <table align="center" width="640">
              
          <tr >
                  
          <td>
                      對應網點:
          &nbsp;&nbsp;&nbsp;&nbsp;
                      
          <select name="wangdian" id="wangdian" style="width:80pt;" onchange="window.location='/safety-wxy/ent/wangdian_extend_update.jsp?dwdm=<%=dwdm%>&wxyid=<%=wxyid%>&uuid='+this.value;">
                      <option value="0"></option>
                      
          <%
                          String oid 
          = "";
                          String wdname 
          = "";

                          Connection connection;
                          
          try
                          
          {
                              connection 
          = DataFactory.getConnection("wxyinfor");
                          }

                          
          catch(Exception e)
                          
          {
                              
          throw new SQLException(e.toString());
                          }

                          
                          Statement statement
          =null;
                          ResultSet resultset
          =null;
                          
          //System.out.println("--------"+uuid);
                          String sql = "select oid,wdname,wdaddress,wdfzr,wdlxdh from T_xzwdext where dwdm = '"+dwdm+"' and wxyid = '"+wxyid+"'";
                          System.out.println(
          "----test sql ---"+sql);

                          
          try
                          
          {
                              statement 
          = connection.createStatement();

                              
          //resultset = statement.executeUpdate(sql);
                              resultset=statement.executeQuery(sql);

                              
          while (resultset.next()) 
                              
          {
                                  
          //oid = resultset.getString("oid");
                      %>

                      
          <option value="<%=resultset.getString("oid") %>"><%=resultset.getString("wdname"%></option>
                      
          <%
                          
          //wdname = resultset.getString("wdname");
                          
                      }
             
              }

              
          catch(Exception e)
              
          {
                  System.out.println(e.getMessage());
              }

              
          finally
              
          {
                  
          try
                  
          {
                      
          if(null!=resultset)
                      
          {
                          resultset.close();
                          resultset 
          = null;
                      }

                  }
          catch(SQLException e1){}

                  
          try
                  
          {
                      
          if(null!=statement)
                      
          {
                          statement.close();
                          statement 
          = null;
                      }

                  }

                  
          catch(SQLException e2){}

                  
          try
                  
          {
                      
          if(null!=connection)
                      
          {
                          connection.close();
                          connection 
          = null;
                      }

                  }

                  
          catch(SQLException e3){}    
              }

              
                      
          %>

                      
          <%
                          System.out.println(usertype);    
                          
          if(usertype!=null & !"adm".equals(usertype)){
                      
          %>
                              
          <input name="wadd" type="button" id="wadd"
                                  value
          ="添加網點" onclick="window.location='/safety-wxy/ent/wangdian_extend.jsp?dwdm=<%=dwdm%>&wxyid=<%=wxyid%>'">
                      
          <%
                          }

                      
          %>
                  
                  
          </td>
              
          </tr>
          </table>
          posted @ 2009-07-02 15:07 Johnhe 閱讀(171) | 評論 (0)編輯 收藏
          <select name="wangdian" id="wangdian" style="width:80pt;" onchange="window.location='/safety-wxy/ent/wangdian_extend_update.jsp?dwdm=<%=dwdm%>&wxyid=<%=wxyid%>&uuid='+this.value;">
          解決onchange時候 獲得value的值
          posted @ 2009-06-25 16:28 Johnhe 閱讀(198) | 評論 (0)編輯 收藏

          怎么取得oracle里面的時分秒
          取得當前時間的時分秒

          select to_char(sysdate,'yyyymmdd hh24:mi:ss'from dual
          select substr(to_char(sysdate,'yyyymmdd hh24:mi:ss'),10,2 )from dual
          select substr(to_char(sysdate,'yyyymmdd hh24:mi:ss'),13,2 )from dual
          select substr(to_char(sysdate,'yyyymmdd hh24:mi:ss'),16,2 )from dual

          可以試試看這玩意
          不知道是否有問題?

          posted @ 2009-05-18 17:25 Johnhe 閱讀(4920) | 評論 (0)編輯 收藏
          public static String isNull(Object obj){
              
          if(null == obj || ((String)obj).equals("")||obj.equals("null")||obj.equals("NULL")){
                      
          return "" ;
                  }

                  
          return (String)obj;
              }
          posted @ 2009-05-15 09:41 Johnhe 閱讀(198) | 評論 (0)編輯 收藏
          主站蜘蛛池模板: 阳山县| 清水河县| 清涧县| 商城县| 湖南省| 原阳县| 安西县| 合江县| 二手房| 金沙县| 赞皇县| 大化| 通许县| 兴义市| 玉溪市| 闻喜县| 阿拉善右旗| 隆回县| 平武县| 武陟县| 青田县| 涿鹿县| 汽车| 琼中| 邵阳县| 蚌埠市| 西藏| 卢氏县| 三河市| 灵台县| 莱西市| 格尔木市| 宜良县| 齐齐哈尔市| 大港区| 汶上县| 隆昌县| 柞水县| 鹤岗市| 舟山市| 息烽县|