access_JDBC驱动资源-CSDN文库

共18个文件

html：16个

jar：1个

mf：1个

JAVA

access

JDBC

JDBC驱动

5星 · 超过95%的资源需积分: 10 49 浏览量 2011-06-29 15:16:26 上传评论 1 收藏 2.41MB ZIP 举报

资源推荐

资源详情

资源评论

收起资源包目录

access.zip （18个子文件）

docs

document.html 8KB

advanced.html 35KB

function.html 50KB

transaction.html 6KB

start.html 8KB

resultset.html 7KB

statement.html 8KB

index.html 2KB

sqlsyntax.html 47KB

openapi.html 18KB

faq.html 36KB

download.html 3KB

introduction.html 3KB

installation.html 14KB

history.html 15KB

components.html 4KB

META-INF

MANIFEST.MF 71B

lib

Access_JDBC30.jar 2.42MB

demo

src

classes

<html><head><TITLE>function.html - HXTT Access JDBC Drivers for Microsoft Access (MS Access) 95/97/2000/XP/2002/2003/2007/2010 v5.0</TITLE><meta name="keywords" content="Access, JDBC, jdbc drivers, Java, database, HXTT"><meta http-equiv="Content-Type" content="text/html; charset=UTF-8"></head><body> Chapter 7. Scalar Functions and Aggregate Functions Index: <ol> <li><a href="#mathematical ">Mathematical Functions</a></li> <li><a href="#trigonometric">Trigonometric Functions</a></li> <li><a href="#string">String Functions</a></li> <li><a href="#date">Date/Time Functions</a></li> <li><a href="#boolean">Boolean Functions</a></li> <li><a href="#system">System Functions</a></li> <li><a href="#conversion">Conversion Functions</a></li> <li><a href="#security">Security Functions</a></li> <li><a href="#sequence">Sequence Functions</a></li> <li><a href="#miscellaneous">Miscellaneous Functions</a></li> <li><a href="#aggregate">Aggregate Functions</a></li> </ol> <A name=mathematical>Mathematical Functions</a> <ol> <ol> <li>ABS(x): the absolute value</li> <li>BITAND(x, y): returns the result of performing a bitwise AND on x and y.</li> <li>BIT_COUNT(x): returns the number of bits of x.</li> <li>CEIL(x), CEILING(x): the smallest integer that is not less than x</li> <li>DEGREES(x): converts radians to degrees</li> <li>EXP(x): exponential, e(2.718...) raised to the power of x</li> <li>FLOOR(x): the largest integer not greater than argument x</li> <li>INT(x) : truncates x to nearest integer</li> <li>LOG(x), LN(x): the natural logarithm</li> <li>LOG(b,x): returns the logarithm of X for an arbitary base B</li> <li> LOG10(x): the base 10 logarithm</li> <li>LOG2(X): the base 2 logarithm</li> <li>LN(x): the natural logarithm</li> <li>MOD(y, x): the remainder of y/x, you can use y%x too.</li> <li>PI(): pi constant, 3.14159265358979323846.</li> <li>POW(x, y), POWER(x, y): x raised to the power of y</li> <li>RADIANS(x): converts degrees to radians</li> <li>RAND([seed]): a random value between 0.0 and 1.0</li> <li>ROUND(x [,y]): rounds x to nearest integer without y, or round x to y digits after the decimal point.</li> <li>SIGN(x): returns -1 if x is smaller than 0, 0 if x==0 and 1 if x is bigger than 0.</li> <li>SQRT(x): the square root</li> <li>TRUNC(x[,y]), TRUNCATE(x[,y]): truncates x to nearest integer without y, truncates x to y digits after the decimal point</li> </ol> </ol> <A name=trigonometric>Trigonometric Functions</a> <ol> <ol> <li>ACOS(x): the inverse cosine of an angle</li> <li>ASIN(x): the inverse sine of an angle</li> <li>ATAN(x),ATN(x): the inverse tangent of an angle</li> <li>ATAN2(x, y): the inverse tangent of x/y</li> <li>COS(x): the cosine of an angle</li> <li>COT(x): the cotangent of an angle</li> <li>SIN(x): the sine of an angle</li> <li>TAN(x): the tangent of an angle</li> </ol> </ol> <A name=string>String Functions</a> <ol> <ol> <li>ALLTRIM(string1): removes all leading and trailing blanks in string1</li> <li>ASC(string1), ASCII(string1): the ASCII code of the leftmost character of the argument</li> <li>AT(cSearchExpression, cExpressionSearched [, nOccurrence]): returns the beginning numeric position of the first occurrence of a character expression or memo field within another character expression or memo field, counting from the leftmost character. If the character expression isn't found, AT( ) returns 0.</li> <li>ATC(cSearchExpression, cExpressionSearched [, nOccurrence]): returns the beginning numeric position of the first occurrence of a character expression or memo field within another character expression or memo field, counting from the leftmost character. If the character expression isn't found, AT( ) returns 0. It is case insensitive.</li> <li>BIN(number1): returns a string representation of the binary value of number1, where number1 is a integer(TINYINT, SMALLINT, INT, or BIGINT) number. Returns NULL if N is NULL. </li> <li>BIT_LENGTH(string1): the length of the string str in bits </li> <li>CHAR_LENGTH(string1), CHARACTER_LENGTH(string1): the number of characters in string1 </li> <li>CHAR(integer), CHR(integer): a character with the given ASCII code</li> <li>CHAR(integer1,...): interprets the arguments as integers and returns a string consisting of the characters given by the unicode values of those integers. NULL values are skipped. </li> <li>CHRTRAN(cSearchedExpression, cSearchExpression, cReplacementExpression): Replaces each character in a character expression that matches a character in a second character expression with the corresponding character in a third character expression. CHRTRAN( ) translates the character expression cSearchedExpression using the translation expressions cSearchExpression and cReplacementExpression and returns the resulting character string. If a character in cSearchExpression is found in cSearchedExpression, the character in cSearchedExpression is replaced by a character from cReplacementExpression that's in the same position in cReplacementExpression as the respective character in cSearchExpression. If cReplacementExpression has fewer characters than cSearchExpression, the additional characters in cSearchExpression are deleted from cSearchedExpression. If cReplacementExpression has more characters than cSearchExpression, the additional characters in cReplacementExpression are ignored. </li> <li>CONCAT(string1, string2): string concatenation, you can use string1+string2 too.</li> <li>CONCAT(string1, string2,...): returns the string that results from concatenating the arguments. NULL values are skipped.</li> <li>CONCAT_WS(separator,string1, string2,...): returns the string that results from concatenating the arguments. The first argument is the separator for the rest of the arguments. The separator is added between the strings to be concatenated. If the separator is NULL, the result is NULL. The function skips any NULL values after the separator argument.</li> <li>CONV(number1,base): returns a string representation of the first argument in the radix specified by the second argument. The minimum base is 2 and the maximum base is 36.</li> <li>DIFFERENCE(string1, string2): the difference between the sound of string1 and string2</li> <li>HEX(number1): returns a string representation of the hexadecimal value of number1, where number1 is a integer(TINYINT, SMALLINT, INT, or BIGINT) number. Returns NULL if N is NULL. </li> <li>INITCAP(string1): converts first letter of each word (whitespace-separated) to upper case</li> <li>INSERT(string1, start1, length1, string2): a string where length1 number of characters beginning at start1 has been replaced by string2</li> <li>INSTR(string1, string2 [,start1]): the first index (>0:left location, 0:not found) where string2 is found in string1, starting at start1</li> <li>INSTR(start1, string1, string2): (Compatible purpose) the first index (>0:left location, 0:not found) where string2 is found in string1, starting at start1.</li> <li>LCASE(string1): converts string1 to lower case</li> <li>LEFT(string1, count1): the leftmost count1 of characters of string1</li> <li>LENGTH(string1), LEN(string1): the number of characters in string1</li> <li>LOCATE(string1, string2 [,start1]): the first index (>0:left location, 0:not found) where string1 is found in string2, starting at start1</li> <li>LOWER(string1): converts

评论收藏

内容反馈