<%@ page import= "java.sql.*" %> <%@ page import="java.io.*" %> <!DOCTYPE html> <head> <title >Site de consultation des médecins | Home</title> <meta charset="utf-8" /> <link rel="stylesheet" href="styles/proj.css" type="text/css" /> <!-- <script src="http://maps.google.com/maps?file=api&v=2&key= ABQIAAAAFw0lDRKsdCra15LPvIxvehS3Kl_ZRrzIrsFqDz8GBXIeW1O52xQh3P31Xg2eTvqFRAyuOMY4dQrRQw" type="text/javascript"></script> --> <script type="text/javascript" src="http://maps.google.com/maps/api/js?sensor=false"></script> <script type="text/javascript">//<![CDATA[ function load() { if (GBrowserIsCompatible()) { var map = new GMap2(document.getElementById("map")); map.addControl(new GLargeMapControl()); map.enableDoubleClickZoom() ; // fin création du zoom // création mode plan sattelite map.addControl ( new GMapTypeControl () ); map.setCenter(new GLatLng( 36.80278, 10.17972), 10); <% try { Class.forName("com.mysql.jdbc.Driver"); } catch(ClassNotFoundException e) { System.err.print("ClassNotFoundException: "); System.err.println(e.getMessage()); } try { Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/projet", "root", ""); Statement st = con.createStatement(); String query = "SELECT longitude, latitude FROM medecin "; System.out.println("query : " +query); ResultSet rs = st.executeQuery(query); while(rs.next()) { %> Select:True!!!!!! | <% float lat =rs.getFloat("latitude"); float lg =rs.getFloat("longitude"); System.out.println("latitude= "+ lat+ "& longitude= "+ lg); %> var point = new GLatLng(<%=lat%>, <%=lg%>); map.addOverlay(new GMarker(point)); <% } rs.close(); con.close(); } catch(SQLException ex) { System.err.println("SQLException: " + ex.getMessage()); } %> } } //]]></script> </head> </html>