代码如下
<%@page import="java.io.*" %>
<%@page import="java.util.*" %>
<%@page import="java.sql.*" %>
<%@page contentType="text/html;charset=gbk" %><html>
<head>
<title>I连接数据库</title>
</head>
<body>
<%
try{
Connection con;
Statement stmt;
ResultSet rs;

//加载 驱动程序 
//Class.forName("org.gjt.mm.mysql.Driver");//旧版本 
Class.forName("com.mysql.jdbc.Driver");
//注册驱动程序 
//DriverManager.registerDriver(new com.mysql.jdbc.Driver());
//连接数据库 
String dbURL="jdbc:mysql://localhost:3306/test0?useUnicode=true&characterEncoding=gbk";
String user="root";
String password="851120";
//建立连接 
con=java.sql.DriverManager.getConnection(dbURL,user,password);
//创建JDBC声明
stmt=con.createStatement();
//添加 纪录
stmt.executeUpdate("insert into test(id,name) values('1','Dora')");
//查询纪录
rs=stmt.executeQuery("select * from test");
out.println("<table>");
while(rs.next()){
String myid=rs.getString("id");
String myname=rs.getString("name");
out.println("<tr><td>"+myid+"</td><td>"+myname+"</td></tr>");
}
out.println("</table>");
rs.close();
stmt.close();
con.close();
}catch(Exception e){
out.println("数据库 连接操作出错");
//e.printStackTrace();
}
%>
</body>
</html>
结果
type Exception reportmessage description The server encountered an internal error () that prevented it from fulfilling this request.exception org.apache.jasper.JasperException: An exception occurred processing JSP page /conDb.jsp at line 20
17: 
18:  //加载 驱动程序 
19:  //Class.forName("org.gjt.mm.mysql.Driver");//旧版本 
20:  Class.forName("com.mysql.jdbc.Driver");
21:  //注册驱动程序 
22:  //DriverManager.registerDriver(new com.mysql.jdbc.Driver());
23:  //连接数据库  org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:554)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:413)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:319)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
root cause javax.servlet.ServletException: org/aspectj/lang/Signature
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:854)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:783)
org.apache.jsp.conDb_jsp._jspService(conDb_jsp.java:113)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:389)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:319)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
root cause java.lang.NoClassDefFoundError: org/aspectj/lang/Signature
java.lang.Class.forName0(Native Method)
java.lang.Class.forName(Unknown Source)
org.apache.jsp.conDb_jsp._jspService(conDb_jsp.java:75)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:389)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:319)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)好心人帮忙阿!!
还有mysql-connector-java-5.0.4我放在了jdk1.5的jre/lib/ext下