01.<%@ page import="java.sql.ResultSet" %>
02.<%@ page import="java.sql.SQLException" %>
03.<%@ page import="java.sql.Statement" %>
04.<%@ page import="java.sql.Connection" %>
05.<%@ page import="java.sql.DriverManager" %>
06.
07.<%
08.response.setContentType("Content-type:text/xml:charset=UTF-8");
09.Connection connect = null;
10.Statement s = null;
11.
12.try {
13. Class.forName("com.mysql.jdbc.Driver");
14.
16. "?user=root&password=root");
17.
18. s = connect.createStatement();
19.
20. String sql = "SELECT * FROM customer ORDER BY CustomerID ASC";
21.
22. ResultSet rec = s.executeQuery(sql);
23. %>
24. <markers>
25. <%while((rec!=null) && (rec.next())) { %>
26. <markers id="<%=rec.getString("CustomerID")%>">
27. <name><%=rec.getString("Name")%></name>
28. </markers>
29. <%}%>
30. </markers>
31. <%
32. } catch (Exception e) {
33.
34. out.println(e.getMessage());
35. e.printStackTrace();
36. }
37.
38. try {
39. if(s!=null){
40. s.close();
41. connect.close();
42. }
43. } catch (SQLException e) {
44.
45. out.println(e.getMessage());
46. e.printStackTrace();
47. }
48.%>
