JavaÁ¬½Ó¸÷ÖÖÊý¾Ý¿âµÄÅäÖ÷½·¨
JavaÁ¬½Ó¸÷ÖÖÊý¾Ý¿âµÄÅäÖ÷½·¨MySQL
£ºString Driver="com.mysql.jdbc.Driver"
; //Çý¶¯³ÌÐòString URL="jdbc:mysql://localhost:3306/db_name"
; //Á¬½ÓµÄURL,db_nameΪÊý¾Ý¿âString Username="username"
; //Óû§ÃûString Password="password"
; //ÃÜÂëClass.forName(Driver);Connection con=DriverManager.getConnection(URL,Username,Password);Microsoft SQL Server 2.0
Çý¶¯(3¸öjar)£ºString Driver="com.microsoft.jdbc
Ïà¹ØÎĵµ£º
create PROCEDURE pagelist
@tablename nvarchar(50),
@fieldname nvarchar(50)='*',
@pagesize int output,--ÿҳÏÔʾ¼Ç¼ÌõÊý
@currentpage int output,--µÚ¼¸Ò³
@orderid nvarchar(50),--Ö÷¼üÅÅÐò
@sort int,--ÅÅÐò·½Ê½£¬1±íʾÉýÐò£¬0±íʾ½µÐòÅÅÁÐ
......
Ò»¡¢Java¶àÏ̻߳¥³â¼°Í¬²½¿ØÖƺÍͨÐÅ
¶à¸öÏ̵߳ÄÖ´ÐÐÊDz¢·¢µÄ£¬Ò²¾ÍÊÇÔÚÂß¼Éϓͬʱ”£¬¶ø²»¹ÜÊÇ·ñÊÇÎïÀíÉϵēͬʱ”¡£Èç¹ûϵͳֻÓÐÒ»¸öCPU£¬ÄÇ̫;ÕýµÄ“ͬʱ”ÊDz»¿ÉÄܵ쬵«ÊÇÓÉÓÚCPUµÄËٶȷdz£¿ì£¬Óû§¸Ð¾õ²»µ½ÆäÖеÄÇø±ð£¬Òò´ËÎÒÃÇÒ²²»ÓùØÐÄËü£¬Ö»ÐèÒªÉèÏë¸÷¸öÏ ......
JavaÕýÔò±í´ïʽµÄ½âÊÍ˵Ã÷
±í´ïʽÒâÒ壺
1.×Ö·û
x ×Ö·û x¡£ÀýÈça±íʾ×Ö·ûa
\\ ·´Ð±Ïß×Ö·û¡£ÔÚÊéдʱҪдΪ\\\\¡££¨×¢Ò⣺ÒòΪjavaÔÚµÚÒ»´Î½âÎöʱ,°Ñ\\\\½âÎö³ÉÕýÔò±í´ïʽ\\£¬ÔÚµÚ¶þ´Î½âÎöʱÔÙ½âÎöΪ\£¬ËùÒÔ·²ÊDz»ÊÇ1.1Áоٵ½µÄתÒå×Ö·û£¬°üÀ¨1.1µÄ\\,¶øÓÖ´øÓÐ\µÄ¶¼ÒªÐ´Á½´Î£©
\0 ......
"^\d+$"¡¡¡¡//·Ç¸ºÕûÊý£¨ÕýÕûÊý + 0£©
"^\[0-9\]*\[1-9\]\[0-9\]*$"¡¡¡¡//ÕýÕûÊý
"^((-\d+)\|(0+))$"¡¡¡¡//·ÇÕýÕûÊý£¨¸ºÕûÊý + 0£©
"^-\[0-9\]*\[1-9\]\[0-9\]*$"¡¡¡¡//¸ºÕûÊý
"^-?\d+$"¡¡¡¡¡¡¡¡//ÕûÊý
"^\d+(\.\d+)?$"¡¡¡¡//·Ç¸º¸¡µãÊý£¨Õý¸¡µãÊý + 0£©
"^((\[0-9\]+\.\[0-9\]*\[1-9\]\[0-9\]*)\|(\[0-9\]*\[1-9\]\[ ......
ÔÚÎÒÃÇ¿ª·¢ÖУ¬¾³£»áÓõ½¼¯ºÏ£¬ÎÒÃÇÒ²ÖªµÀ¼¯ºÏÊÇÓÃÀ´´æ´¢ÔªËص쬵«ËüȴûÓй淶´æ´¢ÔªËصľßÌåÀàÐÍ£¬ÎªÁËÊÇÎÒÃǵijÌÐò¸ü¹æ·¶»¯£¬¾ÍÓ¦µ±Ê¹Ó÷ºÐÍÁË¡£
·ºÐÍÊÇÌṩ¸øjavac±à¼Æ÷ʹÓõģ¬¿ÉÒÔÏÞ¶¨¼¯ºÏÖеÄÊäÈëÀàÐÍ£¬ÈñàÒëÆ÷µ²×¡Ô´³ÌÐòµÄ·Ç·¨ÊäÈ룬±à¼Æ÷±àÒë´øÀàÐÍ˵Ã÷µÄ¼¯ºÏʱ»áÈ¥³ýµô“ÀàÐÍ”ÐÅÏ¢£¬ÊdzÌÐòÔËÐÐÐ ......