ÔõÑùÁ¬Ðø¶à´Î¶ÁÈ¡accessÖÐͬһ×ֶεÄÊý¾Ý
ÔõÑù²ÅÄܶÔaccessÊý¾Ý¿â±íÖÐͬһ×ֶεÄÊý¾ÝÁ¬Ðø¶ÁÈ¡Á½´ÎÒÔÉÏ£¬ÀýÈ磺
<td> <%=rs.getObject(1)%> </td>
<td> <%=rs.getObject(1)%> </td>
ΪʲôÔÚSQL ServerÖоÍûÎÊÌ⣬¶øÔÚaccessÖÐÈ´²»ÐУ¬×ÜÊDZ¨´í£¬´úÂë¶¼ÊÇÍêȫһÑùµÄ¡£
ΪʲôҪÕâô×öÄØ£¿Äã¿ÉÒÔÏȶ¨Òå¸ö±äÁ¿È¡³öÀ´ÏÂÃæÔÙµÈÓÚ°¡¡£
accessÊÇÕâÑù£¬ºÜ¶à벡µÄ£¬ÓÃß·group byºó£¬rs.last().getRow()µÃµ½µÄ×ܼǼÊý²»¶ÔµÄ¡£
ÎÒÖ÷ÒªÏëʵÏÖ¼òµ¥µÄÁ´½ÓÐÞ¸Äɾ³ý¹¦ÄÜ£¬Ö÷Òª´úÂëÈçÏ£º
<%
String sql;
String url;
Connection conn;
Statement stmt;
ResultSet rs;
%>
<table align= "center " border= "1px ">
<tr>
<td width= "14% " align= "center "> ѧºÅ </td>
<td width= "14% " align= "center "> ÐÕÃû </td>
<td width= "14% " align= "center "> ÄêÁä </td>
<td width= "14% " align= "center "> ÐÔ±ð </td>
<td width= "16% " align= "center "> Ժϵ </td>
</tr>
<%
try{
url = "jdbc:odbc:MyStudents ";
sql = "select * from MyStudents "; <
Ïà¹ØÎÊ´ð£º
ÄÄÀï³ö´íÁË£¬Êä³öÕâÑùµÄ½á¹û£¿£¿
<%@ Page Language="VB" AutoEventWireup="false" aspcompat="true" CodeFile="Default.aspx.vb" Inherits="_Default" %&g ......
ÕâÁ½Ììѧϰ¡¶Delphi¼¼Êõ·½°¸±¦µä¡·Ò»ÊéÖеÚÈýÕ¹ØÓÚÓû§µÇ¼·½°¸µÄÀý×Ó£¬ÀûÓõÄÊÇSQl ServerÊý¾Ý¿âʵÏÖÓû§µÇ¼£¬±àÒëÔËÐж¼Ã»ÎÊÌ⣬¸ÃʵÏֵŦÄÜÒ²¶¼ÊµÏֵĺܺ㬵«ÊÇÆæ¹ÖµÄÊÇ£¬·´¸´ÔËÐÐÒ»¶Îʱ¼äºó£¬ÓÐʱÔڹرÕÕû¸ö ......
Âé·³¸÷λ°ïæ¿´¿´°¡
´úÂëÈçÏ£º
CoInitialize(NULL);
_ConnectionPtr pConn(__uuidof(Connection));
_RecordsetPtr pRst(__uuidof(Recordset));
pConn->ConnectionString="Provider ......
jsp¿ª·¢µÄʱºòÄܹ»µ¼³öwordºÍexcel£¬µ«ÊÇÊÇ·ñÄܹ»Ö±½Óµ¼³öΪacess¸ñʽ¡¢dbf¸ñʽµÄÎļþ£¿
¸ßÊÖÖ¸µãÏ£¬×îºÃÄܹ»¸ø¸öÀý×Ó£¬Ð»Ð»£¡£¡£¡
javadbfÕâ¸öjarÒ»ÇÐÎÊÌâ½â¾öÁË¡£
ÏÂÔØµØÖ·Îª£ºhttp://sarovar.org/projects/ ......
ÎÒÔÚÇ°Ì¨Ò³ÃæÊäÈë¿òÊäÈë 20091208 µã»÷Ìá½»Ö®ºó±¨´í,˵ÀàÐͲ»Æ¥Åä.
Êý¾Ý¿âÀï Õâ¸ö×ֶεĸñʽӦ¸ÃÊÇ 2009-12-8 14:27:40
ÊDz»ÊÇÒª°Ñ 20091208 ת»»³É¸ñʽ 2009-12-8 14:27:40
ÇëÎÊÎ ......