C#Á¬½ÓAccessÊý¾Ýʱ×ܱ¨ÕÒ²»µ½dbo.mdbµÄÎÊÌâ
½ñÌìÓÃOleDbÁ¬½ÓAccessʱ×ܱ¨ÕÒ²»µ½dbo.mdbµÄÎÊÌâ¡£¿ÉÊÇÎÒµÄÁ¬½Ó×Ö·û´®ÖÐÃ÷Ã÷д×Ålocal.mdb¡£µ¥²½¸ú×Ùµ÷ÊÔ·¢ÏÖConnectionÖеÄÁ¬½Ó×Ö·û´®Ò²ÊÇ”Provider=Microsoft.Jet.OLEDB.4.0; Data Source=local.mdb;”£¬¸ù±¾Ã»ÓÐdbo.mdbµÄÊ¡£ºóÀ´²é¹ýÅŲ鷢ÏÖÊÇschemaµÄÎÊÌâ¡£SQL ServerÖÐÓÐschemaµÄ¸ÅÄîËùÒÔÎÒÃÇÒ»°ã¶¼Ï°¹ßд³Édbo.xxxTable£¬ËùÒÔÈç¹ûÄãÒªÊÇÒ²ÔÚAccessÖÐÕâÑùдµÄ»°£¬¾Í»á±¨ÈçÉÏÕÒ²»µ½dbo.mdbµÄÎÊÌâ¡£ÐÞ¸ÄSQLÓï¾ä£¬È¥µôdboºó£¬ÎÊÌâ½â¾ö¡£
Ïà¹ØÎĵµ£º
import java.sql.*;
/*
* JAVAÁ¬½ÓACCESS£¬SQL Server,MySQL,OracleÊý¾Ý¿â
*
* */
public class JDBC {
public static void main(String[] args)throws Exception {
Connection conn=null;
//====Á¬½ÓACCESSÊý¾Ý¿â ......
ÈÕÆÚת»¯Ò»
ΪÁË´ïµ½²»Í¬µÄÏÔʾЧ¹ûÓÐʱ£¬ÎÒÃÇÐèÒª¶Ôʱ¼ä½øÐÐת»¯£¬Ä¬ÈϸñʽΪ£º2007-01-03 14:33:34 £¬Òª×ª»¯ÎªÆäËû¸ñʽ£¬ÒªÓõ½DateTime.ToStringµÄ·½·¨(String, IFormatProvider)£¬ÈçÏÂËùʾ£º
using System;
using System.Globalization;
String format="D";
DateTime date=DataTime,Now;
Response.Write(date.ToS ......
OAÔ´ÂëΪÎÒ¹¤×÷ÊÒ¾«ÐÄ´òÔì,ÓÃÁËÈýÄêµÄʱ¼ä,²ÅÐÞÕýÍêÉÆµÄ´óÐͰ칫ϵͳ.
Ϊ¶ÀÁ¢¿ª·¢,²»´æÔÚ°æÈ¨¾À·×,²»»á¸øÄú´øÀ´Âé·³,´úÂëÍêÕû£¬Öø×÷ȨµÇ¼ÇºÅ£º2008SR14608.
OA×îÐÂÉý¼¶£¬¹¤×÷Á÷¸üÇ¿´ó£¬±íµ¥¶¨Òå¸üÎȶ¨
ÇëÈÏ×¼ÁªÏµ·½Ê½£¬½÷·À¼Ùð¡£
Ϊ½ÚÔ¼¿ª·¢³É±¾£¬OAÔ´Âë¿ÉÒÔ·ÖÄ£¿é½øÐÐÌṩ
ÓÀ¾Ãά»¤£¬Óг¥2´Î¿ª·¢
Èí¼þ¹¦ÄÜ·ÖΪרҵ° ......
Data Source=sqlservername;Initial Catalog=dbname;User ID=userid;Password=userpwd
Data Source=(local)\\SQLEXPRESS;Initial Catalog=Êý¾Ý¿âÃû;Integrated Security=True
Data Source=(local);Initial Catalog=Êý¾Ý¿âÃû;User ID=ÕʺÅ;Password=ÕʺÅÃÜÂë
Provider=Microsoft.Jet.OleDb.4.0;Data Source=C:\BegASPNET\ ......
Ëùν“´æÈ¡¼ü”¾ÍÏñ windows Ó¦ÓóÌÐòÖÐµÄ Alt ¿ì½Ý¼ü£¬Í¬Ê±°´ Alt ¼üºÍij¸ö×Öĸ¼ü£¬¿ÉÒÔ¿ìËÙÇл»µ½Îı¾¿ò¡¢°´Å¥µÈÒ³Ãæ¶ÔÏóÉÏ¡£
(1)¡¢Îı¾¿òµÄ Access Key£º
<FORM>
<LABEL FOR="Namebox" ACCESSKEY="N"><U>N</U>ame:</LABEL>
<INPUT TYPE="TEXT" ID="Namebox" SIZE=30> ......