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ºó£¬ÎÊÌâ½â¾ö¡£
Ïà¹ØÎĵµ£º
ÈÕÆÚ/ʱ¼ä
CDate ½«×Ö·û´®×ª»¯³ÉΪÈÕÆÚ select CDate("2005/4/5")
Date ·µ»Øµ±Ç°ÈÕÆÚ
DateAdd ½«Ö¸¶¨ÈÕÆÚ¼ÓÉÏij¸öÈÕÆÚselect dateAdd("d",30,Date())½«µ±Ç°ÈÕÆÚ¼ÓÉÏ30Ìì,ÆäÖÐd¿ÉÒÔ»»Îªyyyy»òHµÈ
DateDiff ÅжÏÁ½¸öÈÕÆÚÖ®¼äµÄ¼ä¸ô select DateDiff("d","2006-5-1& ......
Èí¼þÃû³Æ: EA2A(Excel/Access to Access)
Èí¼þ°æ±¾: beta2
ÊÚȨÐÎʽ: Ãâ·ÑÈí¼þ
ÔËÐÐƽ̨: Win9x/Me/NT/2000/XP/2003
Êý¾Ý¿âÉý¼¶ºóÔÓбíÖÐ×ֶλáÔö¼Ó£¬´ËʱÎÒÃǾÍÐèÒªµ¼È루ǨÒÆ£©Êý¾Ý£¬´Ë³ÌÐòΪʵÏִ˹¦Äܶø±àд¡£
ͨ³£Èí¼þÉý¼¶ºó£¬Êý¾Ý¿âÒ²»áÓÐËù¸Ä±ä£¬´Ëʱ¾ÍÐèÒª¶Ô¿Í»§Ê¹ÓõÄÊý¾Ý¿â½øÐÐÉý¼¶¡£Éý¼¶¿Í»§Êý¾Ý¿âµÄ·½Ê½Ó ......
import java.sql.*;
/*
* JAVAÁ¬½ÓACCESS£¬SQL Server,MySQL,OracleÊý¾Ý¿â
*
* */
public class JDBC {
public static void main(String[] args)throws Exception {
Connection conn=null;
//====Á¬½ÓACCESSÊý¾Ý¿â ......
/*
±¾¶Î´úÂëÔÚ¹«Ë¾ÏîÄ¿ÖÐʵ¼ÊÔ¶³Ìµ÷ÓõÚÈý·½¹«Ë¾ÌṩµÄC#¿ª·¢WebServiceµÄʾÀý
*/
/**
* µÇ¼ÓÎÏ·
*
* @param paramPN
* @param paramTerraceID
* @param paramSvrID
*/
private String loginGame(String paramPN, HttpServletRequest req){
&n ......
£¨1£©Ê×ÏÈÒª¶ÔÄÚÈݵÄÌØÊâ×Ö·û½øÐйýÂÇ£º
C# ´úÂ룺
public string res(string partno)
{
partno = partno.Replace("&", "");
partno = partno.Replace("/", "");
partno = partno.Replace("&", "");
return partno;
}
£¨2£©´ÓÊý¾Ý¿âÖлñµÃÒªÉú³ÉµØͼµÄÄÚ ......