Output data in database as XML : Database « JSP « Java Tutorial

1. Java Tutorial
2. JSP
3. Database

<%@ page contentType="application/xml" import="java.sql.*" %>

<% Class.forName("sun.jdbc.odbc.JdbcOdbcDriver") ; %>
<?xml version="1.0"?>
<publishers>
<% 
Connection connection = DriverManager.getConnection(
    "jdbc:odbc:data", "YourName", "password");

Statement statement = connection.createStatement() ;
ResultSet resultset = statement.executeQuery("select name, id from Publishers");%>

    <% 
        while(resultset.next()){ 
    %>
    <publisher>
    <<%=resultset.getMetaData().getColumnName(1)%>> 
        <% 
            String s = resultset.getString(1);
            int index = s.indexOf("&");
            StringBuffer sb = new StringBuffer(s);
            if(index > 0){
                sb.replace(index, index + 1, "and");
            }
            out.println(sb);
        %>  
    </<%=resultset.getMetaData().getColumnName(1)%>> 
    <<%=resultset.getMetaData().getColumnName(2)%>> 
            <%= resultset.getString(2) %>
    </<%=resultset.getMetaData().getColumnName(2)%>> 
    </publisher>
    <% 
        } 
    %>
</publishers>

23.52.Database
	23.52.1.	Make Database connection
	23.52.2.	Accessing the Database Table
	23.52.3.	Retrieve data in Database based on form input
	23.52.4.	Output ResultSet
	23.52.5.	Joining Tables
	23.52.6.	Creating a Table
	23.52.7.	Insert data to a table
	23.52.8.	Navigate Database Table With Javascript and JSP
	23.52.9.	Database Table Navigation Based On Form
	23.52.10.	Connect to Database in Servlet
	23.52.11.	Using Table Metadata
	23.52.12.	Output data in database as XML