81,092
社区成员
发帖
与我相关
我的任务
分享在eclipse中运行如Jsp下代码出现“Drivermanager cannot be resolved”的问题 哪位高手能帮我解决下,谢谢了
<%@ page language="java" contentType="text/html; charset=GBK"
pageEncoding="GBK"%>
<%@ page import="java.util.*" %>
<%@ page import="java.sql.*" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=GBK">
<title>创建数据库</title>
<body><font size=2>
<%
//连接需要的对象
Connection conn=null;
Statement stmt=null;
String sql=null;
ResultSet rs=null;
int ret;
try{
Class.forName("com.mysql.jdbc.Driver");
String strCon="jdbc:mysql:localhost:3306/";
conn=Drivermanager.getConnection(strCon,"root","xy102310");
stmt=conn.createStatement();
sql="creat database JspSamples";
ret=stmt.executeUpdate(sql);
sql="use JspSamples";
ret=stmt.executeUpdate(sql);
sql="CREATE TABLE customers(" +
" Id int(6) unsigned NOT NULL auto_increment," +
" Name varchar(20) default NULL," +
" addTime timestamp NULL default NULL," +
" Tel varchar(15) default NULL," +
" EmaiL varchar(20) default NUlL," +
" PRIMARY KEY (Id)" +
")";
ret= stmt.executeUpdate(sql);
}
catch(ClassNotFoundException e){
e.printStackTrace();
out.println("<h1>无法找到数据库驱动</h1>");
}
catch(SQLException e1){
e1.printStackTrace();
out.println("<h1>数据库操作失败</h1>");
}
out.println("<h1>新建数据库JspSamples成功</h1>");
DatabaseMetaData meta=conn.getMetaData();
out.println("<br>");
out.println("数据库产品:"+meta.getDatabaseProductName());
out.println("<br>");
out.println("连接字:"+meta.getURL());
stmt.close();
conn.close();
%>
</font>
</body>
</html>
pageEncoding="GBK"%>
<%@ page import="java.util.*" %>
<%@ page import="java.sql.*" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=GBK">
<title>创建数据库</title>
<body><font size=2>
<%
//连接需要的对象
Connection conn=null;
Statement stmt=null;
String sql=null;
ResultSet rs=null;
int ret;
try{
Class.forName("com.mysql.jdbc.Driver");
String strCon="jdbc:mysql:localhost:3306/";
conn=Drivermanager.getConnection(strCon,"root","xy102310");
stmt=conn.createStatement();
sql="creat database JspSamples";
ret=stmt.executeUpdate(sql);
sql="use JspSamples";
ret=stmt.executeUpdate(sql);
sql="CREATE TABLE customers(" +
" Id int(6) unsigned NOT NULL auto_increment," +
" Name varchar(20) default NULL," +
" addTime timestamp NULL default NULL," +
" Tel varchar(15) default NULL," +
" EmaiL varchar(20) default NUlL," +
" PRIMARY KEY (Id)" +
")";
ret= stmt.executeUpdate(sql);
}
catch(ClassNotFoundException e){
e.printStackTrace();
out.println("<h1>无法找到数据库驱动</h1>");
}
catch(SQLException e1){
e1.printStackTrace();
out.println("<h1>数据库操作失败</h1>");
}
out.println("<h1>新建数据库JspSamples成功</h1>");
DatabaseMetaData meta=conn.getMetaData();
out.println("<br>");
out.println("数据库产品:"+meta.getDatabaseProductName());
out.println("<br>");
out.println("连接字:"+meta.getURL());
stmt.close();
conn.close();
%>
</font>
</body>
</html>
...全文
请发表友善的回复…
发表回复
XXOYY 2007-11-18
- 打赏
- 举报
“mysql-connector-java-5.0.8-bin.jar”和“commons-dbcp-1.2.2.jar”都放到lib包中了，都弄了很长时间了，就是还不行
真是不知道怎么弄得，希望高手们给于详细解答，万分感激！！
真是不知道怎么弄得，希望高手们给于详细解答，万分感激！！
lx_emperor 2007-11-18
- 打赏
- 举报
你要把数据库驱动部署到Tomcat得lib包中，让他启动得时候就能加载驱动
XXOYY 2007-11-18
- 打赏
- 举报
上面的代码，不是也导入了么
怎么也不行
怎么也不行
xiyuan1999 2007-11-18
- 打赏
- 举报
在eclipse中运行如Jsp下代码出现“Drivermanager cannot be resolved”的问题
java.sql.* 导入就可以了
java.sql.* 导入就可以了
eclipse 创建jsp项目代码出现multiple annotations found at this line - string cannot be resolved to a type错误解决