RSS Feed (xml)
MySQL and Java Developer's Guide
Mark Matthews, Jim Cole, Joseph D. Gradecki
Publisher Wiley,
Published February 2003,
ISBN 0471269239
*/
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.Statement;
import javax.naming.Context;
import javax.naming.InitialContext;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.sql.DataSource;
public class SeeAccount extends HttpServlet {
public void doGet(HttpServletRequest inRequest,
HttpServletResponse outResponse) throws ServletException,
IOException {
PrintWriter out = null;
Connection connection = null;
Statement statement = null;
ResultSet rs;
try {
outResponse.setContentType("text/html");
out = outResponse.getWriter();
Context ctx = new InitialContext();
DataSource ds = (DataSource) ctx
.lookup("java:comp/env/jdbc/AccountsDB");
connection = ds.getConnection();
statement = connection.createStatement();
rs = statement.executeQuery("SELECT * FROM acc_acc");
ResultSetMetaData md = rs.getMetaData();
out
.println("
out.println("");
out.println("Account Information:
");
out.println("
| "); for (int i = 1; i <= md.getColumnCount(); i++) { out.println("Column #" + i + " "); out.println("getColumnName : " + md.getColumnName(i) + " "); out.println("getColumnClassName : " + md.getColumnClassName(i) + " "); out.println("getColumnDisplaySize : " + md.getColumnDisplaySize(i) + " "); out.println("getColumnType : " + md.getColumnType(i) + " "); out.println("getTableName : " + md.getTableName(i) + " "); out.println(" "); } out.println(""); } catch (Exception e) { e.printStackTrace(); } } public void doPost(HttpServletRequest inRequest, HttpServletResponse outResponse) throws ServletException, IOException { doGet(inRequest, outResponse); } } 
Subscribe to:
Post Comments (Atom)
Site Statistics
|
No comments:
Post a Comment