posts - 20,comments - 6,trackbacks - 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 on 2009-07-02 15:07 Johnhe 閱讀(172) 評論(0)  編輯  收藏  所屬分類: javascript 
          

          







          
	    
    




          








          

				

          



    







          
        
	




主站蜘蛛池模板：
铅山县|
棋牌|
沙河市|
黄龙县|
六安市|
怀仁县|
唐河县|
托克逊县|
江孜县|
盐池县|
深泽县|
大埔区|
榆社县|
镇巴县|
玉门市|
文化|
隆林|
延长县|
蒙阴县|
龙门县|
浦县|
南陵县|
抚宁县|
双峰县|
新郑市|
容城县|
武鸣县|
和平区|
霍山县|
甘洛县|
托里县|
灵璧县|
民县|
广河县|
苏尼特左旗|
鲁甸县|
澎湖县|
竹北市|
富裕县|
新河县|
长治县|