这是我的代码:它从excel数据库中检索数据,我必须从excel中逐个获取坐标来移动标记。这实际上是为了追踪公交车。我已经有了经纬度格式的所有坐标。只是通过jsp检索值,并将值一个接一个地放在javascript中通过放置新标记,我也想删除旧标记。请帮助
<%response.setIntHeader("Refresh", 5);
Connection conn=null;
Statement stmt=null;
String sql="";
ResultSet rs=null;
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn=DriverManager.getConnection("jdbc:odbc:kashimiraz","","");
stmt=conn.createStatement(
ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_UPDATABLE);
sql="select * from [Sheet1$]";
rs=stmt.executeQuery(sql);
rs.next();
String latitude =rs.getString("lat");
String longitude = rs.getString("lon");
String last = latitude;
String lastt= longitude;
rs.close();
stmt.close();
conn.close();
rs=null;
stmt=null;
conn=null; %>
<script type="text/javascript">
function initialize()
{
var value="<%=last%>";
var valuee="<%=lastt%>";
var myCenter=new google.maps.LatLng(value,valuee);
var mapProp = {
center:myCenter,
zoom:15,
mapTypeId:google.maps.MapTypeId.ROADMAP
};
var map=new google.maps.Map(document.getElementById("googleMap"),mapProp);
var marker=new google.maps.Marker({
position:myCenter,
});
marker.setMap(map);
var infowindow = new google.maps.InfoWindow({
content:"Bus# 57"
});
infowindow.open(map,marker);
}google.maps.event.addDomListener(window, 'load', initialize);
</script>
<div id="googleMap" style="width:1200px;height:500px;"></div>
</section>
</body></html>
我想你的答案在这里:http://www.w3schools.com/js/js_timing.asp
使用setInterval
示例:setInterval(function(){alert("Hello")},3000);