[求助]连接数据库问题、谢谢了

org.apache.jasper.JasperException: Exception in JSP: /mysql.jsp:13

10: String tablename="goods";
11: String url="jdbc:mysql://localhost/"+dbname+"?user="+userName+"&password="+userpwd;
12: Class.forName("com.mysql.jdbc.Driver").newInstance();
13: java.sql.Connection conn=DriverManager.getConnection(url);
14: out.print("数据库连接成功!");
15: %>

Stacktrace:
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:467)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:371)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:315)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
就是一个简单的连接数据库的

----------------解决方案--------------------------------------------------------
Statement st=conn.createStatement();
不能缺少
----------------解决方案--------------------------------------------------------
或者你试一下这样

异常说了是13行出了问题，或者这样可以
10: String tablename="goods";
11: String url="jdbc:mysql://localhost/"+dbname+"?user="+userName+"&password="+userpwd;
12: Class.forName("com.mysql.jdbc.Driver").newInstance();
13: java.sql.Connection conn=DriverManager.getConnection(url);
//java.sql.Connectionconn=DriverManager.getConnection（"jdbc:mysql://http://localhost:3306/dbname","userName","userpwd");
14: out.print("数据库连接成功!");
15: %>

[此贴子已经被作者于2007-10-27 15:35:12编辑过]

----------------解决方案--------------------------------------------------------

<%
String tablename = "goods";
String url = "jdbc:mysql://localhost:3306/dbname";
String user = "userName";
String password = "userpwd";
Class.forName("com.mysql.jdbc.Driver");
java.sql.Connection con = DriverManager.getConnection(url,user,password);
out.print("数据库连接成功!");
%>

----------------解决方案--------------------------------------------------------