เป็นการเขียน XML ช่วยแก้จาก PHP เป็น JSP หน่อยครับ

<%@ page import="java.sql.ResultSet" %>
<%@ page import="java.sql.SQLException" %>
<%@ page import="java.sql.Statement" %>
<%@ page import="java.sql.Connection" %>
<%@ page import="java.sql.DriverManager" %>

<%
response.setContentType("Content-type:text/xml:charset=UTF-8");
Connection connect = null;
Statement s = null;

try {
	Class.forName("com.mysql.jdbc.Driver");

	connect =  DriverManager.getConnection("jdbc:mysql://localhost/mydatabase" +
			"?user=root&password=root");
	
	s = connect.createStatement();
	
	String sql = "SELECT * FROM  customer ORDER BY CustomerID ASC";
	
	ResultSet rec = s.executeQuery(sql);
	%>
	<markers>	
		<%while((rec!=null) && (rec.next())) { %>
		<markers id="<%=rec.getString("CustomerID")%>">
		<name><%=rec.getString("Name")%></name>
		</markers>
	<%}%>
	</markers>      
    <%	
	} catch (Exception e) {
		// TODO Auto-generated catch block
		out.println(e.getMessage());
		e.printStackTrace();
	}

	try {
		if(s!=null){
			s.close();
			connect.close();
		}
	} catch (SQLException e) {
		// TODO Auto-generated catch block
		out.println(e.getMessage());
		e.printStackTrace();
	}
%>

response.setContentType("XXXXX"); 

<%@ page contentType="xxxx" %>