我的代码是这样的:
//-----------------------DBConnect.java-------------------------------------
package mypackage;
import java.sql.*;public class DBConnection
{
public static Connection getConnection()
{
String URL = "jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=D:\\myhome\\data\\myhomedb.mdb";
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn = DriverManager.getConnection(URL);
return conn;
}
catch(Exception e)
{
return null;
}
}
}
//-------------------------------------------------------------------------//--------------------login.jsp--------------------------------------------
<%@ page language="java" import="java.sql.*" contentType="text/html; charset=GBK"
import="mypackage.*"
%><html>
<head>
<title>幸福之家</title>
</head>
<body>
<%
Connection conn = mypackage.DBConnection.getConnection();
if (conn==null)
{
%> 加载数据库错误!<br>
<%
}
else
{
Statement stmt=conn.createStatement();
ResultSet rs=stmt.executeQuery("select * from username");
while(rs.next())
{
out.println(rs.getString("nickname") + " 出生日期 " + rs.getString("birthday"));
%>
<br>
<%
}
rs.close();
stmt.close();
conn.close();
}
%>
</body>
</html>
//----------------------------------------------------------------------------------我用“run on server”命令即可以浏览数据库中的数据,但我启动Tomcat服务之后,再浏览login.jsp却提示这样的异常信息:
org.apache.jasper.JasperException: Unable to compile class for JSP
An error occurred at line: 8 in the jsp file: /login.jsp
Generated servlet error:
D:\myhome\myhome\bin\org\apache\jsp\login_jsp.java:51: package mypackage does not exist
Connection conn = mypackage.DBConnection.getConnection();
//-----------------------DBConnect.java-------------------------------------
package mypackage;
import java.sql.*;public class DBConnection
{
public static Connection getConnection()
{
String URL = "jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=D:\\myhome\\data\\myhomedb.mdb";
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn = DriverManager.getConnection(URL);
return conn;
}
catch(Exception e)
{
return null;
}
}
}
//-------------------------------------------------------------------------//--------------------login.jsp--------------------------------------------
<%@ page language="java" import="java.sql.*" contentType="text/html; charset=GBK"
import="mypackage.*"
%><html>
<head>
<title>幸福之家</title>
</head>
<body>
<%
Connection conn = mypackage.DBConnection.getConnection();
if (conn==null)
{
%> 加载数据库错误!<br>
<%
}
else
{
Statement stmt=conn.createStatement();
ResultSet rs=stmt.executeQuery("select * from username");
while(rs.next())
{
out.println(rs.getString("nickname") + " 出生日期 " + rs.getString("birthday"));
%>
<br>
<%
}
rs.close();
stmt.close();
conn.close();
}
%>
</body>
</html>
//----------------------------------------------------------------------------------我用“run on server”命令即可以浏览数据库中的数据,但我启动Tomcat服务之后,再浏览login.jsp却提示这样的异常信息:
org.apache.jasper.JasperException: Unable to compile class for JSP
An error occurred at line: 8 in the jsp file: /login.jsp
Generated servlet error:
D:\myhome\myhome\bin\org\apache\jsp\login_jsp.java:51: package mypackage does not exist
Connection conn = mypackage.DBConnection.getConnection();
解决方案 »
- Mysql怎么设置记录的ID编号,使每次取出的记录都是当前最新更新的前几条记录?
- 向各位大侠们求教!STRUTS1 的验证码问题 要求足够详细~
- 怎么JSP中把小说的文字变成图片类型的..
- 严重: Servlet /strtustest threw load() exception
- 通过FCKeditor上传到服务器上的图片或文件,怎样才能通过FCKeditor删除?在WEB.XML中有配置吗?
- jsp+javabean 实现简单留言本出现问题,附全部代码!急!在线等!
- CSDN论坛在加载用户头像的时候是怎样设计的。
- java 图片上传
- 如何获取一个url多次跳转之后的url
- Apache对于学习JSP是必须安装的环境吗?它的功能是什么?(有了想要的答案马上结)
- 小型模块增加、修改、删除、查询,有谁有类似的代码请教一下!
- hibernate开发web应用,实际运行问题!
Connection conn = mypackage.DBConnection.getConnection();
说明是找不到mypackage包啊,楼主的包怎么弄的啊
还有一点说一下String URL = "jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=D:\\myhome\\data\\myhomedb.mdb";
DBQ这里应该写的是DBQ=myhomedb.mdb,你用的是ODBC桥接方式在控制面板--管理工具--数据源那里设置啊
原来是在Web-inf下建一个classes文件夹,把*.class文件拷贝过去就可以了。