注册 登录
编程论坛 J2EE论坛

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

风的声音 发布于 2007-10-27 10:19, 576 次点击

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)
就是一个简单的连接数据库的

3 回复
#2
天涯海角2007-10-27 10:30
Statement st=conn.createStatement();
不能缺少
#3
netstriker2007-10-27 15:34
或者你试一下这样

异常说了是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编辑过]

#4
hjlwlyhjl2007-10-27 16: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("数据库连接成功!");
%>

1