程序是这样写的:<!-- Copyright (c) 2002 by ObjectLearn. All Rights Reserved. -->
<%@ page contentType="text/html; charset=GBK"%><%@ page import="java.sql.*"%><%@ page import="javax.sql.*"%><%@ page import="javax.naming.*"%><%@ page session="false" %><html><head><meta http-equiv="Content-Type" content="text/html; charset=gb2312"><title></title><% out.print("我的测试开始"); DataSource ds = null; try{ InitialContext ctx=new InitialContext(); ds=(DataSource)ctx.lookup("java:comp/env/jdbc/TestDB"); Connection conn = ds.getConnection(); Statement stmt = conn.createStatement(); //提示:testdata必须是数据库已有的表//这里的数据库前文提及的Data Source URL配置里包含的数据库。 String strSql = " select * from testdata"; ResultSet rs = stmt.executeQuery(strSql); while(rs.next()){ out.print(rs.getString("foo")); }out.print("我的测试结束"); } catch(Exception ex){ out.print("出现例外,信息是:"+ex.getMessage()); ex.printStackTrace(); }%></head><body></body></html>
<%@ page contentType="text/html; charset=GBK"%><%@ page import="java.sql.*"%><%@ page import="javax.sql.*"%><%@ page import="javax.naming.*"%><%@ page session="false" %><html><head><meta http-equiv="Content-Type" content="text/html; charset=gb2312"><title></title><% out.print("我的测试开始"); DataSource ds = null; try{ InitialContext ctx=new InitialContext(); ds=(DataSource)ctx.lookup("java:comp/env/jdbc/TestDB"); Connection conn = ds.getConnection(); Statement stmt = conn.createStatement(); //提示:testdata必须是数据库已有的表//这里的数据库前文提及的Data Source URL配置里包含的数据库。 String strSql = " select * from testdata"; ResultSet rs = stmt.executeQuery(strSql); while(rs.next()){ out.print(rs.getString("foo")); }out.print("我的测试结束"); } catch(Exception ex){ out.print("出现例外,信息是:"+ex.getMessage()); ex.printStackTrace(); }%></head><body></body></html>
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货