test.jsp

来自「JAVA案例开发集锦源代码 袁然 郑自国编」· JSP 代码 · 共 32 行

<%@ page contentType="text/html;charset=gb2312" language="java" import="javax.naming.Context,javax.sql.DataSource,javax.naming.InitialContext,java.sql.*"%>

<%
	DataSource ds=null;
	try
	{
		Context initCtx=new InitialContext();
		Context envCtx=(Context)initCtx.lookup("java:comp/env");
		// Given the JNDI Context, we lookup the object and are returned 
    // our DataSource
		ds=(DataSource)envCtx.lookup("jdbc/MyDataSource");
		// Now we get a database connection and proceed to do our job.
		if(ds!=null)
		{
			out.println("connection is ok!");
			out.println("<br>");
			Connection conn=ds.getConnection();
			Statement stmt=conn.createStatement();
			ResultSet rs=stmt.executeQuery("select * from forumuser");
			while(rs.next())
			{
				out.println(rs.getString("UserName"));
				out.println(rs.getString("UserPassword"));
				out.println("<br>");
			}
		}
		else
			out.println("fail!");
	}
	catch(Exception e){out.println(e);}
%>