1
2 package com.pnpconsult.zeiterfassung.actions;
3
4 import java.io.PrintWriter;
5 import java.sql.Connection;
6 import java.sql.ResultSet;
7 import java.sql.Statement;
8
9 import javax.naming.Context;
10 import javax.naming.InitialContext;
11 import javax.servlet.http.HttpServletRequest;
12 import javax.servlet.http.HttpServletResponse;
13 import javax.sql.DataSource;
14
15 import org.apache.struts.action.Action;
16 import org.apache.struts.action.ActionForm;
17 import org.apache.struts.action.ActionForward;
18 import org.apache.struts.action.ActionMapping;
19
20 /***
21 * @author <a href="mailto:powerpete@users.sf.net">M. Petersen </a>
22 * @version $Id: TestAction.java,v 1.5 2004/06/25 09:08:48 powerpete Exp $
23 * @deprecated
24 * @struts.action path="/test" roles="unknown"
25 */
26 public class TestAction extends Action
27 {
28 public ActionForward execute(
29 ActionMapping mapping,
30 ActionForm form,
31 HttpServletRequest request,
32 HttpServletResponse response) throws Exception
33 {
34 response.setContentType("text/plain");
35 PrintWriter out = response.getWriter();
36
37 Context ctx = new InitialContext();
38 Context env = (Context) ctx.lookup("java:/comp/env");
39 out.write("Got env\n");
40 DataSource ds = (DataSource) env.lookup("jdbc/zeiterfassung");
41 out.write("Got ds\n");
42 Connection con = ds.getConnection();
43 try
44 {
45 out.write("Got con\n");
46 Statement stmt = con.createStatement();
47 try
48 {
49 ResultSet rs = stmt.executeQuery("SELECT login FROM user");
50 try
51 {
52 while (rs.next())
53 {
54 out.write("- " + rs.getString(1) + "\n");
55 }
56 }
57 finally
58 {
59 rs.close();
60 }
61 }
62 finally
63 {
64 stmt.close();
65 }
66 }
67 finally
68 {
69 con.close();
70 }
71 out.write("OK\n");
72 return null;
73 }
74 }