有个JSP小程序,TOMCAT运行后显示:“the database loading fail! the database connection fail! the database operation fail! close the database fail! ”,请大家看看为什么没连上数据库(mysql)呢 <%@ page language="java" contentType="text/html; charset=ISO-8859-1"
pageEncoding="ISO-8859-1"%>
<%@ page import="java.sql.*" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>JDBCDemo01</title>
</head>
<body>
<%!
String DBDRIVER = "com.mysql.jdbc.Driver";
String DBURL = "jdbc:mysql://localhost/javabook";
String USERNAME = "root";
String DBPWORD = "19760113";
Connection conn = null;
String sql = null;
Statement stmt = null;
%><%
try
{
Class.forName(DBDRIVER);
}
catch(Exception e)
{
out.println("the database loading fail!");
}
try
{
conn = DriverManager.getConnection(DBURL,USERNAME,DBPWORD);
}
catch(Exception e)
{
out.println("the database connection fail!");
}
try
{
stmt = conn.createStatement();
sql = "insert into department (deptId,name,chairId,collegeId) values ('ART','Painting','111221120','SC')";
stmt.executeUpdate(sql);
}
catch(Exception e)
{
out.println("the database operation fail!");
}
try
{
stmt.close();
conn.close();
}
catch(Exception e)
{
out.println("close the database fail!");
}
%>
</body>
</html>
pageEncoding="ISO-8859-1"%>
<%@ page import="java.sql.*" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>JDBCDemo01</title>
</head>
<body>
<%!
String DBDRIVER = "com.mysql.jdbc.Driver";
String DBURL = "jdbc:mysql://localhost/javabook";
String USERNAME = "root";
String DBPWORD = "19760113";
Connection conn = null;
String sql = null;
Statement stmt = null;
%><%
try
{
Class.forName(DBDRIVER);
}
catch(Exception e)
{
out.println("the database loading fail!");
}
try
{
conn = DriverManager.getConnection(DBURL,USERNAME,DBPWORD);
}
catch(Exception e)
{
out.println("the database connection fail!");
}
try
{
stmt = conn.createStatement();
sql = "insert into department (deptId,name,chairId,collegeId) values ('ART','Painting','111221120','SC')";
stmt.executeUpdate(sql);
}
catch(Exception e)
{
out.println("the database operation fail!");
}
try
{
stmt.close();
conn.close();
}
catch(Exception e)
{
out.println("close the database fail!");
}
%>
</body>
</html>
解决方案 »
- JDBC Driver class not found: org.mysql.jdbc.Driver
- dwr中session失效的问题
- ajax导致SESSION失效
- unix jfreechart 无法显示图片
- 文件操作问题!!help!
- 我在windows底下开发的mysql数据库,能否将数据库目录拷贝到Liunx的mysql就行了呢?
- 关于FRAMESET 刷新后找不到框架在线等急
- 各位新春快乐
- 求教!!关于数据大小超出此类型的最大值的错误!!
- sping mvc 导出excel ie6 兼容性问题
- Spring3.0MVC ajax刷新问题,测试请求已经完成,但是页面没反应。请大侠门帮忙,关系到我的工作任务呀,我还在实习中。
- 如何在JDK连接mysql数据库
try
{
Class.forName(DBDRIVER);
}
catch(Exception e)
{
out.println("the database loading fail!");
}修改为:
try {
Class.forName(DBDRIVER);
} catch(Exception e) {
e.printStackTrace();
}然后看看异常信息就知道了。
out.println("the database loading fail!");
修改为
out.println("the database loading fail!");e.printStackTrace();
你屏蔽了原始异常,没有办法查原因的
{
Class.forName(DBDRIVER);
}
catch(Exception e)
{
out.println("the database loading fail!\n" + e.printStackTrace() ); //看看具体是什么异常信息
}
怀疑是jar包没有加载到,你打印出自己的异常 ,但是 这样会影响你排除错误啊 ,还是把 系统的异常信息也打印出来吧