Àܳ»î¸³ÍÑJSP¥Õ¥¡¥¤¥ë †
»ÈÍÑÊýË¡ †
1. ½êÄê°ÌÃÖ¤ËÇÛÃÖ
2. ¡ÖDataSource ds¡×¤Î¡Öjava:comp/env/jdbc/mysql¡×¤òÄê´üÀÃͤËÊѹ¹
<%@ page contentType="text/html;charset=UTF-8"%> <%@ page import="javax.naming.*"%> <%@ page import="java.util.*"%> <%@ page import="java.io.*"%> <%@ page import="java.sql.*"%> <%@ page import="javax.sql.*"%> <% Context ctx = new InitialContext(); DataSource ds = (DataSource)ctx.lookup("java:comp/env/jdbc/mysql"); Connection con = ds.getConnection(); Statement stmt = con.createStatement(); ResultSet rset = stmt.executeQuery ("select user()"); %> <HTML> <HEAD> <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=UTF-8"> </HEAD> <BODY> <TABLE border=1> <% while (rset.next ()) { out.print("<tr>"); out.print("<td>" + rset.getString(1) + "</td>"); out.print("</tr>"); } %> </TABLE> </BODY> </HTML>
Last-modified: 2006-11-14 (²Ð) 10:34:41 (6372d)