巨牛B巨郁闷的关于jsp中数据库连接的问题。(高分) 是牛b阿,哈哈好像没有jdbc for ms access的驱动吧! 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 JDBC-ODBC桥有问题几乎是零,程序或者数据库录入有问题几乎肯定! jdbc for ms access???这个东西永远都找不到的,需要设置odbc数据源的,JDBC-ODBC桥不会出现问题的给你一个例子<%@ page contentType="text/html;charset=gb2312"%> <%@ page import="java.sql.*"%> <html> <body> <%Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance(); String url="jdbc:odbc:test";//test为你所创建的odbc数据源Connection conn= DriverManager.getConnection(url); Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE); String sql="select * from test"; ResultSet rs=stmt.executeQuery(sql); while(rs.next()) {%> 您的第一个字段内容为:<%=rs.getString(1)%> 您的第二个字段内容为:<%=rs.getString(2)%> <%}%> <%out.print("数据库操作成功,恭喜你");%> <%rs.close(); stmt.close(); conn.close(); %> </body> </html> 数据源是这样的: (access export to txt)"id" "name" "kkk" "password" "right""admin" "aaa" "a" "1234" "0""normal" "bbb" "a" "12" "1"源代码是这样的:1.InfoConnector.javapackage com.info;import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;public class InfoConnector { private String dataBase = "data"; private Statement sta= null; private Connection con = null; public ResultSet rs = null; public InfoConnector() { try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); con = DriverManager.getConnection("jdbc:odbc:" + dataBase); sta = con.createStatement(); } catch (ClassNotFoundException e) { // TODO Auto-generated catch block e.printStackTrace(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } public ResultSet excuteSQL(String sql) throws SQLException { sta.clearBatch(); return sta.executeQuery(sql); }<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"><%@page contentType="text/html; charset = UTF-8"%><%@page import="java.sql.*"%><% ResultSet rs = (ResultSet)session.getAttribute("userInfo"); rs.first();%><html><head><title>Data View</title><meta http-equiv="Content-Type" content="text/html; charset=gb2312"></head><body><table width="100%" border="0"> <tr> <td>welcome : <%out.print(rs.getString("3"));%></td> //就是这个地方了,用3就不行。 </tr> <tr> <td><% java.util.Date time = new java.util.Date(); String sqltime = new Timestamp(time.getTime()).toString(); out.print(time);%> </td> </tr> <tr> <td> </td> </tr></table></body></html> <%out.print(rs.getString("3"));%>昏,用引号就用字段名,如:<%out.print(rs.getString("kkk"));%> 请问下进度条的实现。 hibernate性能优化问题 面试题 急呀.................. 请教 JSP日期验证 mvc模式 js的问题 求牛人帮忙解决hibernate级联问题 树形菜单的管理实现 jspsmartupload 的tomcat设置问题! 怎样在jsp中的两个下拉列表中实现数据连动?(数据从数据库读取) 用Jsp做新闻发布系统时遇到的问题 一个JSP+JavaBean的简单问题,谢谢大家帮帮我。帮我顶也有分,分不够再加
给你一个例子
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<html>
<body>
<%Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
String url="jdbc:odbc:test";//test为你所创建的odbc数据源
Connection conn= DriverManager.getConnection(url);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql="select * from test";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next()) {%>
您的第一个字段内容为:<%=rs.getString(1)%>
您的第二个字段内容为:<%=rs.getString(2)%>
<%}%>
<%out.print("数据库操作成功,恭喜你");%>
<%rs.close();
stmt.close();
conn.close();
%>
</body>
</html>
"id" "name" "kkk" "password" "right"
"admin" "aaa" "a" "1234" "0"
"normal" "bbb" "a" "12" "1"
源代码是这样的:
1.InfoConnector.java
package com.info;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;public class InfoConnector {
private String dataBase = "data";
private Statement sta= null;
private Connection con = null;
public ResultSet rs = null; public InfoConnector() {
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con = DriverManager.getConnection("jdbc:odbc:" + dataBase);
sta = con.createStatement();
}
catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
} public ResultSet excuteSQL(String sql) throws SQLException {
sta.clearBatch();
return sta.executeQuery(sql);
}
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<%@page contentType="text/html; charset = UTF-8"%>
<%@page import="java.sql.*"%>
<%
ResultSet rs = (ResultSet)session.getAttribute("userInfo");
rs.first();
%>
<html>
<head>
<title>Data View</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head><body>
<table width="100%" border="0">
<tr>
<td>welcome : <%out.print(rs.getString("3"));%></td> //就是这个地方了,用3就不行。
</tr>
<tr>
<td>
<%
java.util.Date time = new java.util.Date();
String sqltime = new Timestamp(time.getTime()).toString();
out.print(time);
%>
</td>
</tr>
<tr>
<td> </td>
</tr>
</table>
</body>
</html>
昏,用引号就用字段名,如:
<%out.print(rs.getString("kkk"));%>