1 package example; 2 3 import java.io.PrintWriter ; 4 import java.io.IOException ; 5 6 import java.sql.Connection ; 7 import java.sql.Statement ; 8 import java.sql.ResultSet ; 9 import java.sql.SQLException ; 10 11 import javax.sql.DataSource ; 12 13 import javax.annotation.Resource; 14 15 import javax.servlet.ServletException ; 16 17 import javax.servlet.http.HttpServlet ; 18 import javax.servlet.http.HttpServletRequest ; 19 import javax.servlet.http.HttpServletResponse ; 20 21 22 28 public class BasicServlet extends HttpServlet { 29 32 @Resource(name="jdbc/basic") 33 private DataSource _ds; 34 35 38 public void setDataSource(DataSource ds) 39 { 40 _ds = ds; 41 } 42 43 46 public void service(HttpServletRequest req, HttpServletResponse res) 47 throws java.io.IOException , ServletException 48 { 49 res.setContentType("text/html"); 50 51 PrintWriter out = res.getWriter(); 52 53 try { 54 doQuery(out); 55 } catch (SQLException e) { 56 throw new ServletException (e); 57 } 58 } 59 60 63 public void doQuery(PrintWriter out) 64 throws IOException , SQLException 65 { 66 Connection conn = _ds.getConnection(); 67 68 try { 69 String sql = "SELECT name, cost FROM jdbc_basic_brooms ORDER BY cost DESC"; 70 71 Statement stmt = conn.createStatement(); 72 73 ResultSet rs = stmt.executeQuery(sql); 74 75 out.println("<table border='3'>"); 76 77 while (rs.next()) { 78 out.println("<tr><td>" + rs.getString(1)); 79 out.println(" <td>" + rs.getString(2)); 80 } 81 82 out.println("</table>"); 83 84 rs.close(); 85 stmt.close(); 86 } finally { 87 conn.close(); 88 } 89 } 90 } 91 | Popular Tags |