各个文件路径说明如下:
1、JDBConnection类路径:%tomcat5.5%/src/com/JDBConnection.java
2、数据库路径::%tomcat5.5%/Database/database.mdb
3、index.jsp路径::%tomcat5.5%/index.jsp
JDBConnection类代码如下:package com;
import java.sql.*;public class JDBConnection {
private final String dbDriver = "sun.jdbc.odbc.JdbcOdbcDriver"; //连接sql数据库的方法
private final String spath="/database/database.mdb";
private final String url = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ="+spath;
private final String userName = "";
private final String password = "";
private Connection con = null; public JDBConnection() {
try {
Class.forName(dbDriver).newInstance(); //加载数据库驱动
} catch (Exception ex) {
System.out.println("数据库加载失败");
}
}//创建数据库连接
public boolean creatConnection() {
try {
con = DriverManager.getConnection(url, userName, password);
con.setAutoCommit(true); } catch (SQLException e) {
System.out.println(e.getMessage());
System.out.println("creatConnectionError!");
}
return true;
}
index.jsp调用如下:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>修改数据时下拉列表的默认值为数据库中原数据信息</title>
<jsp:useBean id="connection" scope="request" class="com.JDBConnection"/>
<link href="Css/Css.css" type="text/css" rel="stylesheet">
</head><body>
<table width="500" height="259" border="0" align="center" cellpadding="0" cellspacing="0" background="images/0.jpg">
<tr align="center">
<td height="82" colspan="2"><strong><font color="#FFFFFF" size="+2">修改用户信息模块</font></strong></td>
</tr>
<tr>
<td width="87"> </td>
<td width="413" valign="top"><table width="382" border="0" align="center">
<tr align="center">
<td width="66">账号</td>
<td width="66">性别</td>
<td width="66">年龄</td>
<td width="66">职业</td>
<td width="84">操作</td>
</tr>
<%
String sql="select * from tb_userInfo";
ResultSet rs=connection.executeQuery(sql);
try{
while(rs.next()){
String id=rs.getString(1);
%>
<tr align="center">
<td><%=rs.getString(2)%></td>
<td><%=rs.getString(3)%></td>
<td><%=rs.getString(4)%></td>
<td><%=rs.getString(5)%></td>
<td><a href="dealwith.jsp?id=<%=id%>">修改</a></td>
</tr>
<%}}catch (Exception e){}%>
</table></td>
</tr>
</table>
</body>
</html>
结果提示连接错误,是不是连接路径的问题?谢谢!!
1、JDBConnection类路径:%tomcat5.5%/src/com/JDBConnection.java
2、数据库路径::%tomcat5.5%/Database/database.mdb
3、index.jsp路径::%tomcat5.5%/index.jsp
JDBConnection类代码如下:package com;
import java.sql.*;public class JDBConnection {
private final String dbDriver = "sun.jdbc.odbc.JdbcOdbcDriver"; //连接sql数据库的方法
private final String spath="/database/database.mdb";
private final String url = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ="+spath;
private final String userName = "";
private final String password = "";
private Connection con = null; public JDBConnection() {
try {
Class.forName(dbDriver).newInstance(); //加载数据库驱动
} catch (Exception ex) {
System.out.println("数据库加载失败");
}
}//创建数据库连接
public boolean creatConnection() {
try {
con = DriverManager.getConnection(url, userName, password);
con.setAutoCommit(true); } catch (SQLException e) {
System.out.println(e.getMessage());
System.out.println("creatConnectionError!");
}
return true;
}
index.jsp调用如下:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>修改数据时下拉列表的默认值为数据库中原数据信息</title>
<jsp:useBean id="connection" scope="request" class="com.JDBConnection"/>
<link href="Css/Css.css" type="text/css" rel="stylesheet">
</head><body>
<table width="500" height="259" border="0" align="center" cellpadding="0" cellspacing="0" background="images/0.jpg">
<tr align="center">
<td height="82" colspan="2"><strong><font color="#FFFFFF" size="+2">修改用户信息模块</font></strong></td>
</tr>
<tr>
<td width="87"> </td>
<td width="413" valign="top"><table width="382" border="0" align="center">
<tr align="center">
<td width="66">账号</td>
<td width="66">性别</td>
<td width="66">年龄</td>
<td width="66">职业</td>
<td width="84">操作</td>
</tr>
<%
String sql="select * from tb_userInfo";
ResultSet rs=connection.executeQuery(sql);
try{
while(rs.next()){
String id=rs.getString(1);
%>
<tr align="center">
<td><%=rs.getString(2)%></td>
<td><%=rs.getString(3)%></td>
<td><%=rs.getString(4)%></td>
<td><%=rs.getString(5)%></td>
<td><a href="dealwith.jsp?id=<%=id%>">修改</a></td>
</tr>
<%}}catch (Exception e){}%>
</table></td>
</tr>
</table>
</body>
</html>
结果提示连接错误,是不是连接路径的问题?谢谢!!
解决方案 »
- 偷个懒,求一段字符串处理方法
- 做webservice 一定需要使用UDDI吗?
- <input type="file">如何取到文本框里的路径值并传递到下一个页面
- 如何选定某一行,并把选定行对应的值传递给方本框中,如图。
- logic:iterate 数据就迭代一半,后面的数据报NULLPOINTEREXCEPTION
- java项目中,用Tomcat5.5.27版本时,在程序运行时出现javax.servlet.ServletException: Java heap space异常,很急!!!!!!!!!!!!!!!
- 一个有关数据库连接池的问题!求救!
- 现在流行的消息推送机制是怎么实现的?
- 初学javaBean,请大家多多指教
- 怎么把SQL SERVER 2000里面DateTime类型里面的年,月,日分别取出来??
- 在jsp页面如何用键盘的上下左右键控制<html:text>框中的焦点自由的移动?现在做项目遇到这样一个问题谢谢大家给宝贵意见!!!!
- 隔页选择后,一起提交,如何保持前页选择的(如ID)?
private final String spath="/database/database.mdb";
private final String dbpath = application.getRealPath(spath); //转化成物理路径
private final String url = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ="+dbpath;
你把spath定义成String类型的了是不是应该这样写
private final String url = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ='"+spath+"' ";
ResultSet rs=connection.executeQuery(sql);
这里错了,应改成:
Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
String sql="select * from tb_userInfo";
rs = stmt.executeQuery(sqls);