Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ACCESS²úÉú.ldb

ÕâÒ»´ÎÀ´¼òµ¥½éÉÜÒ»ÏÂÎÒÔÚѧϰÖÐÓöµ½µÄÒ»¸öÎÊÌ⣬ÎÒÏÈÃèÊöһϣ¬È»ºó¿´²Ù×÷(ÉùÃ÷Ò»µã£ºÕâÒ»´ÎÎÒûÓаÑÕâ¸öÎÊÌâ½â¾öµô£¬Ï£ÍûÓÐÈ˰ïÎÒ½â´ð)
-------------------------------------------------------------------------
»·¾³£ºwin2003  tomcat6  jsp»·¾³
ÎÒʹÓÃaccess2003×öÊý¾Ý¿â£¬Êý¾ÝÔ´ÒѾ­ÅäÖúã¬Á¬½ÓÊý¾Ý¿âÒ²³É¹¦¡£
ÎÒµÄÄ¿µÄºÜ¼òµ¥£º×öÒ»¸öÁôÑÔϵͳ
µÇ½(login.jsp)——¡·ÑéÖ¤Êý¾Ý¿âÖÐÊÇ·ñÓÐÕâ¸öÓû§(login_conf.jsp)-->Èç¹ûÓÐÔòµÇ½³É¹¦--¡·¿ÉÒԲ鿴ÁôÑÔµÄÄÚÈÝ
ÏÂÃæ½ØÍ¼£º
Êý¾Ý¿â
±í
ÏÖÔÚÎÒĿ¼ÏµÄÎļþÇé¿ö£º
×¢ÒâÕâÀïûÓÐ.ldbÎļþ
ÏÂÃæÎÒÔËÐгÌÐò£ºÎªÁË·½±ãÎÒÖ±½ÓÓÃÕýÈ·µÄÓû§µÇ½
ΪÁ˹۲ìÔËÐÐÇé¿ö£¬ÎÒÔÚºǫ́´òÓ¡ÁËЩÎÄ×ÖÈçÏ£¬Í¬Ê±¹Û²ìºǫ́ÏÖÔÚËäÈ»²Ù×÷ÁËÊý¾Ýµ«ÊÇûÓвúÉúÄǸö.ldbÎļþ
ÏÂÃæ½øÈë²é¿´ÁôÑÔ³ÌÐò£º
ÎÒÔÚºóÃæ¸½ÉÏÎÒµÄÁ½¸ö´úÂ룬ÏÖÔÚ³öÏÖÁËldbÎļþ£¬·þÎñÆ÷ÖдòÓ¡Ò²ÖÕÖ¹ÁË¡£ÓÃEditPlus´ò¿ªÕâ¸öldbÎļþÊÇÎҵĻúÆ÷Ãû»¹ÓÐAdmin£¬¿´ÆðÀ´ÊÇÕâ¸öÓû§²¢Ëø¶¨¡£¡£
ÉÏÍø²éÕÒÁ˺ö෽·¨£¬²¢Ã»ÓÐʵÖÊÐÔ½â¾öµÄ¡£¿ÉÄÜÊÇÎÒÊý¾Ý¿â¹Ø±Õ´íÎ󣬵«ÎÒʵÔÚûÓп´³öÄÄÀï´íÁË¡£¡£
--------------------------------------------
ÉÏ´úÂ룺
longin_conf.jsp
<%@page contentType="text/html;charset=gb2312"%>
<%@page import="java.sql.*"%>
<html>
<head><title>JSP+JDBCÁôÑÔ¹ÜÀí³ÌÐò--µÇ½</title></head>
<body>
<center>
<h1>ÁôÑÔ¹ÜÀí·¶Àý--JSP+JDBCʵÏÖ</h1>
<hr>
<br/>
<%!
String DBDRIVER ="sun.jdbc.odbc.JdbcOdbcDriver";
String DBURL ="jdbc:odbc:notedemo";
Connection conn = null;
PreparedStatement pstmt = null;
ResultSet rs = null;
//ÉùÃ÷Ò»¸öBoolean±äÁ¿£¬ÓÃÓÚ±£´æÓû§ÊÇ·ñºÏ·¨µÄ״̬
boolean flag = false;
%>
<%
//½ÓÊܲÎÊý
String id=request.getParameter("id");
String password=request.getParameter("password");
%>
<%
String sql="select name from person where id=? and password = ?";
try
{
System.out.println("login_conf.jspÕýÔÚ²éÕÒÊý¾Ý¿â1...");
Class.forName(DBDRIVER);

System.out.println("login_conf.jspÕýÔÚ²éÕÒÊý¾Ý¿â2...");
conn=DriverManager.getConnection(DBURL);


Ïà¹ØÎĵµ£º

vb.net²Ù×÷Êý¾Ý¿âÖ®ACCESS£¨3£©

ÕâһƪÎÒÔÙ˵˵ˮ¾§±¨±íµÄÇé¿ö¡£ACCESSÖжÔӦˮ¾§±¨±í·½Ã棬´ó¼Ò¿ÉÄÜ»áÓöµ½µÄ×î¶àµÄÎÊÌâÓ¦¸Ã¾ÍÊÇ´ò¿ª±¨±íºó
»á³öÏÖÐèÒªµÇ¼µÄÎÊÌâ¡£
Õâ¸öÊÇÎªÊ²Ã´ÄØ£¿Ã÷Ã÷ÎÒûÓÐÉèÖÃÃÜÂ룬Ôõô»áÓÐÒªÊäÈëÃÜÂëÄØ£¿Èç¹ûÄã¹»³Á×Å£¬Èç¹ûÄãµÄdebug¾­Ñ鲻ȱ·¦µÄ»°£¬
Äã»á·¢ÏÖÔÚË®¾§±¨±íÌø³öÊäÈëÃÜÂëµÄµÇ¼¿òÖУ¬accessµÄ·¾¶²»ÊÇÎÒÏÖÔÚÊý¾Ý¿â· ......

C#²Ù×÷AccessÀà Re

using System;
using System.Data;
using System.Data.OleDb;
namespace AccessDb
{
/**//// <summary>
/// AccessDb µÄժҪ˵Ã÷£¬ÒÔÏÂÐÅÏ¢ÇëÍêÕû±£Áô
/// ÇëÔÚÊý¾Ý´«µÝÍê±Ïºóµ÷ÓÃClose()·½·¨£¬¹Ø±ÕÊý¾ÝÁ´½Ó¡£
/// </summary>
public class AccessDbClass
{
±äÁ¿Éù ......

9.3 ͨ¹ýPHP²Ù×÷AccessÊý¾Ý¿â

9.3  ͨ¹ýPHP²Ù×÷AccessÊý¾Ý¿â
9.3.1  Á¬½ÓAccessÊý¾Ý¿â
ÔÚPHPÖÐÁ¬½ÓAccessÓÐÈçÏÂ3ÖÖ·½Ê½¡£
£¨1£©´´½¨ÏµÍ³Êý¾ÝÔ´£¬ÓÃPHPÌṩµÄODBCº¯Êý
¼´¿É¡£
£¨2£©Í¬Ñù¿ÉÒÔʹÓÃPHPµÄODBCº¯Êý£¬µ«²»´´½¨
Êý¾ÝÔ´¡£¿ª·ÅÊý¾Ý¿âÁ¬½Ó£¨Open DateBase
Conection£¬ODBC£©ÊÇWindows Open
Server£¨¿ª·Å·þÎñ£©API£¨WOSA£©²úÆ·Ö®Ò ......

ÈçºÎѹËõ´øÓÐmdw°²È«Îļþ»úÖÆºÍÃÜÂëµÄµÄaccessÊý¾Ý¿â

a £½ “Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\Êý¾Ý¿â.mdb;Password=¹ÜÀíÔ±ÃÜÂë;User ID=¹ÜÀíÔ±ÕʺÅ;Jet OLEDB:Database Password=Êý¾Ý¿âÃÜÂë;Jet OLEDB:System database=d:\system.MDW;”  ' ´Ë´¦Óû§ÕÊ»§±ØÐë¾ßÓйÜÀíԱȨÏÞ²ÅÐÐ,´Ë´¦ÊÇÖ¸Á¬½ÓÐèҪѹËõµÄÊý¾Ý¿âµÄÁ¬½Ó´úÂë.
 
b £½ &ldq ......

JavaScript Access´úÂë²Î¿¼

///ÏÂÃæÊǶÔAccessµÄÁ´½Ó
function getCountfromDB() {
    //ÒÔµ±Ç°Ò³ÃæÎļþΪ»ù´¡£¬ÕÒµ½ÎļþËùÔڵľø¶Ô·¾¶¡£
    var filePath = location.href.substring(0, location.href.indexOf("Cnt.htm"));
    var path = filePath + "MyData.mdb";
    //È¥µ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ