frame錨點靜態chm書/Files/spiritahead/frame.rar
posted @
2010-02-02 16:31 Johnhe 閱讀(235) |
評論 (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 閱讀(167) |
評論 (0) |
編輯 收藏<table align="center" width="640">
<tr >
<td>
對應網點:
<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 閱讀(164) |
評論 (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 閱讀(194) |
評論 (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 閱讀(4913) |
評論 (0) |
編輯 收藏