湖
湖晨
Unregistered / Unconfirmed
GUEST, unregistred user!
本人是初學者﹐希望能詳細一點。
7
7syw
Unregistered / Unconfirmed
GUEST, unregistred user!
<%
@page import="java.sql.*"
import ="java.util.*"
import ="java.io.*"
import="java.text.*"
contentType="text/html;
charset=gb2312"
buffer="20kb"
%>
<%! int all,i,m_count;
String odbcQuery;
Connection odbcconn;
Statement odbcstmt;
ResultSet odbcrs;
String username,title,content,work,email,url,time,date;
String datetime;
%>
<%
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}catch (ClassNotFoundException e)
{ out.print ("驱动程序不存在");
}
try{
odbcconn = DriverManager.getConnection("jdbc
dbc:db1");
odbcstmt = odbcconn.createStatement();
odbcQuery="Select * From book where datetime>2001-4-26 Order By datetime DESC";
odbcrs=odbcstmt.executeQuery(odbcQuery);
int i=0;
while (i<130) odbcrs.next();
while (odbcrs.next())
{
//*/////////////////////////显示数据库的内容用于调试程序是用//
int ii;
try{
try{
for (ii=1;;ii++)
out.print ("＜br＞Cloumn "+ii+" is: "+odbcrs.getString(ii));
}catch (NullPointerException e) {
out.print ("有空的指针");
}
}catch (SQLException e){
}
}
odbcrs.close();
odbcstmt.close();
odbcconn.close();
}catch (SQLException e)
{ out.print (e);
}
%>
@page import="java.sql.*"
import ="java.util.*"
import ="java.io.*"
import="java.text.*"
contentType="text/html;
charset=gb2312"
buffer="20kb"
%>
<%! int all,i,m_count;
String odbcQuery;
Connection odbcconn;
Statement odbcstmt;
ResultSet odbcrs;
String username,title,content,work,email,url,time,date;
String datetime;
%>
<%
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}catch (ClassNotFoundException e)
{ out.print ("驱动程序不存在");
}
try{
odbcconn = DriverManager.getConnection("jdbc
dbc:db1");odbcstmt = odbcconn.createStatement();
odbcQuery="Select * From book where datetime>2001-4-26 Order By datetime DESC";
odbcrs=odbcstmt.executeQuery(odbcQuery);
int i=0;
while (i<130) odbcrs.next();
while (odbcrs.next())
{
//*/////////////////////////显示数据库的内容用于调试程序是用//
int ii;
try{
try{
for (ii=1;;ii++)
out.print ("＜br＞Cloumn "+ii+" is: "+odbcrs.getString(ii));
}catch (NullPointerException e) {
out.print ("有空的指针");
}
}catch (SQLException e){
}
}
odbcrs.close();
odbcstmt.close();
odbcconn.close();
}catch (SQLException e)
{ out.print (e);
}
%>
L
lnboy
Unregistered / Unconfirmed
GUEST, unregistred user!
<!--本程序用来测试Jsp到Access的连接-->
<%@ page contentType="text/html;
charset=GBK" %>
<%@ page errorPage="accesstest_error.jsp" %>
<html>
<head>
<title>
jdbctest
</title>
</head>
<body bgcolor="#ffffff">
<h1>
Jdbc 连接到 Access 数据库的例子</h1>
<%
java.sql.Connection sqlCon;
//数据库连接对象
java.sql.Statement sqlStmt;
//SQL语句对象
java.sql.ResultSet sqlRst;
//结果集对象
java.lang.String strCon;
//数据库连接字符串
java.lang.String strSQL;
//SQL语句
//装载JDBC-ODBC驱动程序
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
//设置数据库连接字符串
strCon = "jdbcdbc:driver={Microsoft Access Driver (*.mdb)};DBQ=D://Jb//BeanServletTest//defaultroot//dbtest.mdb";
//数据库是一个Access文件,里面有一张表user,表里有userid和userpass两个字段
sqlCon = java.sql.DriverManager.getConnection(strCon,"","");
//创建SQL语句对象
sqlStmt = sqlCon.createStatement();
strSQL = "select * from user";
out.println(strSQL);
sqlRst = sqlStmt.executeQuery(strSQL);
//打印测试
if( sqlRst != null ){
out.println("一共有"+sqlRst.getRow()+"条记录");
while( sqlRst.next() ){
out.println("你的用户名字是：/t" + sqlRst.getString("userid")+"<br>");
out.println("你的密码是：/t" + sqlRst.getString("userpass")+"<br>");
out.println("一共有"+sqlRst.getRow()+"条记录<br>");
}
out.println("一共有"+sqlRst.getRow()+"条记录");
}
sqlRst.close();
sqlCon.close();
%>
</body>
</html>
<%@ page contentType="text/html;
charset=GBK" %>
<%@ page errorPage="accesstest_error.jsp" %>
<html>
<head>
<title>
jdbctest
</title>
</head>
<body bgcolor="#ffffff">
<h1>
Jdbc 连接到 Access 数据库的例子</h1>
<%
java.sql.Connection sqlCon;
//数据库连接对象
java.sql.Statement sqlStmt;
//SQL语句对象
java.sql.ResultSet sqlRst;
//结果集对象
java.lang.String strCon;
//数据库连接字符串
java.lang.String strSQL;
//SQL语句
//装载JDBC-ODBC驱动程序
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
//设置数据库连接字符串
strCon = "jdbc
dbc:driver={Microsoft Access Driver (*.mdb)};DBQ=D://Jb//BeanServletTest//defaultroot//dbtest.mdb";//数据库是一个Access文件,里面有一张表user,表里有userid和userpass两个字段
sqlCon = java.sql.DriverManager.getConnection(strCon,"","");
//创建SQL语句对象
sqlStmt = sqlCon.createStatement();
strSQL = "select * from user";
out.println(strSQL);
sqlRst = sqlStmt.executeQuery(strSQL);
//打印测试
if( sqlRst != null ){
out.println("一共有"+sqlRst.getRow()+"条记录");
while( sqlRst.next() ){
out.println("你的用户名字是：/t" + sqlRst.getString("userid")+"<br>");
out.println("你的密码是：/t" + sqlRst.getString("userpass")+"<br>");
out.println("一共有"+sqlRst.getRow()+"条记录<br>");
}
out.println("一共有"+sqlRst.getRow()+"条记录");
}
sqlRst.close();
sqlCon.close();
%>
</body>
</html>
T
thinkjsp
Unregistered / Unconfirmed
GUEST, unregistred user!
email呢？我可以给你源码，都测试过的，而且都有注释!
湖
湖晨
Unregistered / Unconfirmed
GUEST, unregistred user!
xmhuchen@tom.com
T
thinkjsp
Unregistered / Unconfirmed
GUEST, unregistred user!
发了，你查一下邮箱吧！