posts - 20,comments - 6,trackbacks - 0
frame锚点静态chm书/Files/spiritahead/frame.rar
posted @ 2010-02-02 16:31 Johnhe 阅读(232) | 评论 (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 阅读(164) | 评论 (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 阅读(158) | 评论 (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 阅读(190) | 评论 (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 阅读(4906) | 评论 (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 阅读(187) | 评论 (0)编辑 收藏