publicvoid doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
try {
InitialContext initContext = new InitialContext();
//
DataSource ds=(DataSource)initContext.lookup("test");
Connection conn=ds.getConnection();
Statement statement=conn.createStatement();
StringBuffer sb = new StringBuffer();
sb.append("select * from test");
ResultSet rs=statement.executeQuery(sb.toString());
List<Person> listTemp = new ArrayList<Person>();
while(rs.next()){
Person person = new Person();
person.setId(rs.getInt("id"));
person.setName(rs.getString("name"));
person.setAge(rs.getString("age"));
listTemp.add(person);
}
request.setAttribute("result", listTemp);
System.out.println(listTemp.size());
request.getRequestDispatcher("/test.jsp").forward(request, response);
} catch (Exception e) {
e.printStackTrace();
}
}