谁有测试mysql是否连接jsp的代码？

試試這個：
<%@page language="java" import="java.sql.*" contentType="text/html; charset=ISO8859_1"%>
<%//&iquest;&Eacute;&Ograve;&Ocirc;&ETH;&THORN;&cedil;&Auml;&micro;&Auml;…&cent;”&micro;
String ls_username = "liuyxit"; //&Ugrave;Y&Aacute;&Iuml;&#381;ì&Oacute;&Atilde;‘&ocirc;&Atilde;&ucirc;
String ls_password = "liuyxit"; //&Atilde;&Uuml;&acute;a
String ls_server = "localhost";
String ls_dbname = "guestbook";
Connection con = null;
try
{
//&Ocirc;]&#402;&Ocirc;JDBC&szlig;B&frac12;&Oacute;ò&#338;&#8222;&Oacute;
Class.forName("org.gjt.mm.mysql.Driver");
//&Aring;c&Ugrave;Y&Aacute;&Iuml;&#381;ì&frac12;¨&Aacute;&cent;&szlig;B&frac12;&Oacute;
con = DriverManager.getConnection("jdbc:mysql://"+ls_server+"/"+ls_dbname,ls_username,ls_password);
}
catch(Exception e)
{
System.out.println(e.toString());
}
%><html>
<head>
<title>&#339;y&Ocirc;&#8225;&Ugrave;Y&Aacute;&Iuml;&#381;ì&szlig;B&frac12;&Oacute;</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<%
int li_count = 0;
String ls_sql = "select count(*) from mydata";try
{
Statement Stmt = con.createStatement();
ResultSet rs = Stmt.executeQuery(ls_sql);
if(rs.next())
li_count = rs.getInt(1);
if(rs != null)
rs.close();
if(Stmt != null)
Stmt.close();}
catch(Exception e)
{
out.println("<br>2" + e.toString() + "<br>");
}
out.println("&sup1;&sup2;" + li_count +"—l&Oacute;&#8250;&auml;&#8250;<p>&#339;y&Ocirc;&#8225;&sup3;&Eacute;&sup1;&brvbar;&pound;&iexcl;");
%>
</body>
</html>
<%
try
{
if(con != null)
con.close();
}
catch(SQLException sqle)
{
System.out.println(sqle.toString());
}
%>