81,122
社区成员
发帖
与我相关
我的任务
分享高手请进！！！
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<%@ page import="import java.sql.*"%>
<%@ page import="import java.util.*"%>
<%@ page import="import javax.naming.*"%>
<%@ page import="import javax.servlet.*"%>
<%@ page import="import javax.servlet.http.*"%>
<html>
<body>
<%
try
{
// Ñ°ÕÒÊý¾ÝÔ´£¬¾ÍÊÇÄãÔÚwlsÀïÃæÅäÖõÄÊý¾ÝÔ´£¬×¢ÒâÉÏÃæÒýÈëµÄjava°ü¡£
//ÕâÀïµÄÊý¾ÝÔ´¾ÍÊÇÄãÔÚ¿ØÖÆ̨ÀïÃæµÄJDBCDataSourceµÄJNDIName¡£
//javax.sql.DataSource ds = (javax.sql.DataSource) ctx.lookup ("ÄãµÄÊý¾ÝÔ´");
// Get a context for the JNDI look up
Context ctx = new InitialContext();
java.sql.Connection conn = null;
java.sql.Statement stmt = null;
javax.sql.DataSource ds = (javax.sql.DataSource) ctx.lookup ("MysqlDataSource");
//´´½¨Ò»¸öconnection¶ÔÏó
conn = ds.getConnection();
/*ÄãµÄÔÀ´µÄ³ÌÐò
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
String url ="jdbc:mysql://localhost/test?user=root&password=12345&useUnicode=true&characterEncoding=8859_1";
//testDBΪÄãµÄÊý¾Ý¿âÃû
Connection conn= DriverManager.getConnection(url);
*/
stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql="select * from testmysql";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next())
{
%>
ÄúµÄµÚÒ»¸ö×Ö¶ÎÄÚÈÝΪ£º<%=rs.getString(1)%>
ÄúµÄµÚ¶þ¸ö×Ö¶ÎÄÚÈÝΪ£º<%=rs.getString(2)%>
ÄúµÄµÚÈý¸ö×Ö¶ÎÄÚÈÝΪ£º<%=rs.getString(3)%><p>
<%
}
%>
<%out.print("Êý¾Ý¿â²Ù×÷³É¹¦£¬¹§Ï²Äã");%>
<%
rs.close();
stmt.close();
conn.close();
}
catch(Exception e)
{
out.println(e.getMessage());
}
%>
</body>
</html>
错误提示：
Unable to resolve 'MysqlDataSource' Resolved: '' Unresolved:'MysqlDataSource'
可是我配了jdbc呀在控制台里面。
<%@ page import="java.sql.*"%>
<%@ page import="import java.sql.*"%>
<%@ page import="import java.util.*"%>
<%@ page import="import javax.naming.*"%>
<%@ page import="import javax.servlet.*"%>
<%@ page import="import javax.servlet.http.*"%>
<html>
<body>
<%
try
{
// Ñ°ÕÒÊý¾ÝÔ´£¬¾ÍÊÇÄãÔÚwlsÀïÃæÅäÖõÄÊý¾ÝÔ´£¬×¢ÒâÉÏÃæÒýÈëµÄjava°ü¡£
//ÕâÀïµÄÊý¾ÝÔ´¾ÍÊÇÄãÔÚ¿ØÖÆ̨ÀïÃæµÄJDBCDataSourceµÄJNDIName¡£
//javax.sql.DataSource ds = (javax.sql.DataSource) ctx.lookup ("ÄãµÄÊý¾ÝÔ´");
// Get a context for the JNDI look up
Context ctx = new InitialContext();
java.sql.Connection conn = null;
java.sql.Statement stmt = null;
javax.sql.DataSource ds = (javax.sql.DataSource) ctx.lookup ("MysqlDataSource");
//´´½¨Ò»¸öconnection¶ÔÏó
conn = ds.getConnection();
/*ÄãµÄÔÀ´µÄ³ÌÐò
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
String url ="jdbc:mysql://localhost/test?user=root&password=12345&useUnicode=true&characterEncoding=8859_1";
//testDBΪÄãµÄÊý¾Ý¿âÃû
Connection conn= DriverManager.getConnection(url);
*/
stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql="select * from testmysql";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next())
{
%>
ÄúµÄµÚÒ»¸ö×Ö¶ÎÄÚÈÝΪ£º<%=rs.getString(1)%>
ÄúµÄµÚ¶þ¸ö×Ö¶ÎÄÚÈÝΪ£º<%=rs.getString(2)%>
ÄúµÄµÚÈý¸ö×Ö¶ÎÄÚÈÝΪ£º<%=rs.getString(3)%><p>
<%
}
%>
<%out.print("Êý¾Ý¿â²Ù×÷³É¹¦£¬¹§Ï²Äã");%>
<%
rs.close();
stmt.close();
conn.close();
}
catch(Exception e)
{
out.println(e.getMessage());
}
%>
</body>
</html>
错误提示：
Unable to resolve 'MysqlDataSource' Resolved: '' Unresolved:'MysqlDataSource'
可是我配了jdbc呀在控制台里面。
...全文
请发表友善的回复…
发表回复
