Question

JSP程序实现对MySQL数据库时候出错

这是我的源代码：
<%
String driverName="com.mysql.jdbc.Driver";//驱动程序名
String userName="root";//数据库用户名
String userPasswd="";//密码
String dbName="book";//数据库名
String tableName="bookInfo";//表名
//连接字符串
String url="jdbc:mysql://localhost:3306/"+dbName+"?user="+userName+"&password="+userPasswd;
Class.forName("com.mysql.jdbc.Driver").newInstance();
Connection conn=DriverManager.getConnection(url);
out.println("数据库连接成功");
conn.close（）;
%>

下面是出错提示，请大侠帮我分析一下！感激不尽！
org.apache.jasper.JasperException: Unable to compile class for JSP:

An error occurred at line: 10 in the jsp file: /ConnMysql.jsp
Connection cannot be resolved to a type
7: //连接字符串
8: String url="jdbc:mysql://localhost:3306/"+dbName+"?user="+userName+"&password="+userPasswd;
9: Class.forName("com.mysql.jdbc.Driver").newInstance();
10: Connection conn=DriverManager.getConnection(url);
11: out.println("数据库连接成功");
12: conn.close（）;
13: %>

An error occurred at line: 10 in the jsp file: /ConnMysql.jsp
DriverManager cannot be resolved
7: //连接字符串
8: String url="jdbc:mysql://localhost:3306/"+dbName+"?user="+userName+"&password="+userPasswd;
9: Class.forName("com.mysql.jdbc.Driver").newInstance();
10: Connection conn=DriverManager.getConnection(url);
11: out.println("数据库连接成功");
12: conn.close（）;
13: %>

An error occurred at line: 12 in the jsp file: /ConnMysql.jsp
Syntax error on tokens, delete these tokens
9: Class.forName("com.mysql.jdbc.Driver").newInstance();
10: Connection conn=DriverManager.getConnection(url);
11: out.println("数据库连接成功");
12: conn.close（）;
13: %>
14:

Answer 1

<!--首先导入一些必要的packages-->
<%@ page import="java.io.*"%>
<%@ page import="java.util.*"%>
<!--告诉编译器使用SQL包-->
<%@ page import="java.sql.*"%>
<!--设置中文输出-->
<%@ page contentType="text/html; charset=GBK" %>
<%
String driverName="com.mysql.jdbc.Driver";//驱动程序名
String userName="root";//数据库用户名
String userPasswd="";//密码
String dbName="book";//数据库名
String tableName="bookInfo";//表名
//连接字符串
String url="jdbc:mysql://localhost:3306/"+dbName+"?user="+userName+"&password="+userPasswd;
Class.forName("com.mysql.jdbc.Driver").newInstance();
Connection conn=DriverManager.getConnection(url);//没有引用Connection类
out.println("数据库连接成功");
conn.close();//要用英文括号
%>

Answer 2

12: conn.close（）;

你这里肯定复制出错，是全角的括号了

Answer 3

String dbURL="jdbc:mysql://localhost:3306/book";
try{
Class.forName("com.mysql.jdbc.Driver");
Connection con=DriverManager.getConnection(dbURL,userName,userPasswd);
stat=con.createStatement();
}
catch(Exception e){
e.printStackTrace();
}
这个stat是Statement stat;用这个就直接可以写sql操作数据库了