Access×Ö·û´®´¦Àíº¯Êý
1.Asc
˵Ã÷:·µ»Ø×ÖĸµÄAcsiiÖµ
¾ÙÀý:select Asc("A")·µ»Ø65
2.Chr
˵Ã÷:½«asciiֵת»»µ½×Ö·û
¾ÙÀý:select chr(65)·µ»Ø"A"
3.Format
˵Ã÷:¸ñʽ»¯×Ö·û´®
¾ÙÀý:Select Format(now(),"yyyy-mm-dd")·µ»ØÀàËÆÓÚ"2008-04-03"
Select Format(3/9,"0.00")·µ»Ø0.33
4.InStr
˵Ã÷:²éѯ×Ó´®ÔÚ×Ö·û´®ÖеĵÚÒ»¸ö³öÏÖµÄλÖÃ,ûÓзµ»Ø0
¾ÙÀý:select Instr("abc","a") ·µ»Ø1
5.LCase
˵Ã÷:·µ»Ø×Ö·û´®µÄСдÐÎʽ
¾ÙÀý:select LCase("ABC") ·µ»Ø"abc"
6.Left
˵Ã÷:×ó½ØÈ¡×Ö·û´®
¾ÙÀý:select Left("ABC",1) ·µ»Ø"A"
7.Len
˵Ã÷:·µ»Ø×Ö·û´®³¤¶È
¾ÙÀý:select Len("ABCÄãºÃ")·µ»Ø5
8.LTrim
˵Ã÷:×ó½ØÈ¡¿Õ¸ñ
¾ÙÀý:select LTrim(" 111") ·µ»Ø"111"
9.Mid
˵Ã÷:È¡µÃ×Ó×Ö·û´®
¾ÙÀý:select mid("abcd",1,2) ·µ»Ø"ab"
10.Right
˵Ã÷:ÓÒ½ØÈ¡×Ö·û´®
¾ÙÀý:select Right("ABC",1) ·µ»Ø"C"
11.RTrim
˵Ã÷:ÓÒ½ØÈ¡¿Õ¸ñ
¾ÙÀý:select Right("ABC ") ·µ»Ø"ABC"
12.Space
˵Ã÷:²úÉú¿Õ¸ñ
¾ÙÀý:select Space(5) ·µ»Ø5¸ö¿Õ¸ñ
13.StrComp
˵Ã÷:±È½ÏÁ½¸ö×Ö·û´®ÊÇ·ñÄÚÈÝÒ»ÖÂ(²»Çø·Ö´óСд)
¾ÙÀý:select StrComp("abc","ABC")·µ»Ø0
select StrComp("abc","123")·µ»Ø-1
14.Trim
˵Ã÷:½ØÈ¡×Ö·û´®Á½Í·µÄ¿Õ¸ñ
¾ÙÀý:select Trim(" ABC ") ·µ»Ø"ABC"
15.UCase
˵Ã÷:½«×Ö·û´®×ª´óд
¾ÙÀý:select UCase("abc") ·µ»Ø"ABC"
Ïà¹ØÎĵµ£º
//¶ÁÈ¡±ê×¼Áбí
private void setModelList()
{
OleDbConnection Connection = null;
&n ......
Double action
fingerprint
and access code security door lock for your home,
office or small business. Get modern biometric security at your entry point with
this standard door handle style double action doorlock.
This is the most secure and convenient method in assuring only authorized peo ......
´ó¸ÅµÄ¹¦ÄܾÍÊÇÈÕÆÚÌáÐÑ£¬°ÑͨѶ¼ºÍÈÕÆÚÌáÐÑÏà½áºÏ¡£
ÌáÐÑ·½Ãæ×öµÄºÜ²î£¬¼¼ÊõÓÐÏÞ¡£
Ƥ·ôÓõÄÊÇSkin++
µÚÒ»´Î·¢£¬µ«Ö®Ç°Ð޸Ĺý¼¸´Î£¬Ä¿Ç°°æ±¾0.7
×öÕâ¸ö¶«Î÷ÍêÈ«ÊÇÒòΪÎÒ¸öÈËÐèÒª¡£
ÊÇÒ»¸ö¶àÓû§µÄ¹¤¾ß¡£
ÓÐ×Ô¶¯Éý¼¶¹¦ÄÜ¡£
Ó¦Ó÷¶Î§ºÜÕ¡£
ÏÂÔØµØÖ·£ºhttp://www.cppblog.com/Files/pencil/GoodFriendV0.7.rar
Ô ......
Á¬½ÓACCESSÊý¾Ý¿âµÄ¼òµ¥JSP´úÂ룺
<%@ page language="java" contentType="text/html; charset=GB18030"
pageEncoding="GB18030"%>
<%@ page import="java.sql.*" %>
<%
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver") ;
String url="jdbc:odbc:Driver={MicroSoft Access Drive ......
½ÓÉÏÃæµÄһƪ¡£
·½·¨2£º
´´½¨Ò»¸öµ¥ÎĵµÓ¦ÓóÌÐò -> ÏÂÒ»²½ -> Ñ¡Ôñ Database view without file support £¬
µ¥»÷ Data Source ÔÚµ¯³öµÄ "Êý¾ÝÁ¬½ÓÊôÐÔ" ¶Ô»°¿òÖУ¬Ñ¡Ôñ " Microsoft Jet 4.0 OLE DB Provider " ¡£
µ¥»÷ ÏÂÒ»²½ ÔÚ"Ñ¡Ôñ»òÊäÈëÊý¾Ý¿âÃû³Æ ÖУ¬Ñ¡Ôñ Êý¾Ý¿âÎļþËùÔڵķ¾¶¡£Í¬µÚһƪËùÊö·½·¨£¬Ê¹ÓÃĬ ......