<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <%@ page import="javax.naming.*, javax.sql.*, java.sql.*" %> <%@ page import="java.util.Properties"%> WebLogic 12.2.1.3 JDBC

ServerName : <% String instName=System.getProperty("weblogic.Name"); %> <%=instName%>

GTPLUS People

<% Context ctx = new InitialContext(); DataSource ds = (DataSource)ctx.lookup("test"); Connection conn = ds.getConnection(); Statement stmt = conn.createStatement(); ResultSet rs = stmt.executeQuery("SELECT name, gender, age FROM people"); Thread.sleep(1000); while(rs.next()){ out.println(""); out.println(""); } rs.close(); stmt.close(); conn.close(); %>

name	gender	age
"+rs.getString("name")); out.println("	"+rs.getString("gender")); out.println("	"+rs.getString("age")); out.println("