Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

sql 2005 ´æ´¢¹ý³Ì·ÖÒ³ java ´úÂë

 create PROCEDURE pagelist
@tablename nvarchar(50),
@fieldname nvarchar(50)='*',         
@pagesize int output,--ÿҳÏÔʾ¼Ç¼ÌõÊý
@currentpage int output,--µÚ¼¸Ò³
@orderid nvarchar(50),--Ö÷¼üÅÅÐò
@sort int,--ÅÅÐò·½Ê½£¬1±íʾÉýÐò£¬0±íʾ½µÐòÅÅÁÐ
@rowcount int output,--×ܼǼÊý£¬¹²Óм¸ÌõÐÅÏ¢
@pagecount int output--×ÜÒ³Êý£¬¹²ÓжàÉÙÒ³
AS
declare @countsql nvarchar(50)
declare @sql nvarchar(200)
declare @subsql nvarchar(100)--not in×ÓsqlÓï¾ä
declare @tmpOrderid nvarchar(50)
--·µ»Ø×ܼǼÊý£¬²¢¸³Öµ¸øÊä³ö²ÎÊý@rowcount
set @countsql='select @totalcount=count(*) from '+@tablename
exec sp_executesql @countsql,N'@totalcount int out',@rowcount output
--ÅжÏ×Ö¶ÎÃûÊÇ·ñΪ¿Õ
if @fieldname is null or @fieldname=''
set @fieldname=' * '
--ÅжÏÊÇ·ñÅÅÐò¼°ÅÅÐò·½Ê½
if @orderid is null or @orderid=''
set @tmpOrderid=' '
else
begin
if @sort=0
set @tmpOrderid='order by '+@orderid+' desc'
else
set @tmpOrderid='order by '+@orderid+' asc'
end


Ïà¹ØÎĵµ£º

java mail Ïà¹Ø

¡¾ÉùÃ÷¡¿×ªÌûµØÖ· £º http://tech.ddvip.com/2009-04/1239788309115180.html
MailSenderInfo .java :
package com.util.mail;
import java.util.Properties;
/**
* @author AllanKing
* @date 2009-11-12
*/
public class MailSenderInfo {
// ·¢ËÍÓʼþµÄ·þÎñÆ÷µÄIPºÍ¶Ë¿Ú
private String mailServerHost; ......

´ø×Åjavaѧpython

 pythonÕýÎÄ£º     ºÍÆäËüÓïÑÔÒ»Ñù£¬ÎÒÃÇ¿ÉÒÔÒÔÃüÁîÐеÄÐÎʽ¸øÄãµÄpython³ÌÐò´«µÝ²ÎÊý£¬pyhtonÄܹ»×Ô¶¯°ÑÃüÁîÐвÎÊýÒÔ×Ö·û´®ÁбíµÄÐÎʽ´æ´¢ÔÚsysÄ£¿éµÄarv±äÁ¿¡£ok£¬ÎÒÃÇÏÈÀ´¿´¸öÀý³Ì£º
 
#  ÎļþÃû: printargs.py
#ÓÃ;£ºÑÝʾpythonµÄ´«²Î
import sys
print sys.argv
ÔÚÃü ......

SQL 2000 Óë SQL 2005 ¼æÈÝÎÊÌâ

 ×°ÁËSQL2000ºó°²×°SQL2005,ËäȻʹÓñðÃû¼ÓÒÔÇø±ðÁË£¬µ«·¢ÏÖ2005ÖÐûÓпɹ©·ÃÎʵÄÀàËÆÆóÒµ¹ÜÀíÆ÷£¬Ò»Ê±³å¶¯£¬Ð¶ÁË2000£¬ÍêÕû°²×°ÁË2005£¬·¢ÏÖ»¹ÊÇûÓÐÆóÒµ¹ÜÀíÆ÷£¬ËÑË÷¹ýºó²Å·¢ÏÖÐèÒª°²×°SQLServer2005_SSMSEE.msi£¨¼´SQLServerManagerStudioExpressEdition£©£¬ËüÌṩÁËÀàËÆÆóÒµ¹ÜÀíÆ÷µÄͼÐλ¯²Ù×÷½çÃæ¡£
×°ºÃºó£¬SQL ......

SQL Server 2000µÄJDBCÁ¬½ÓÎÊÌâ½â¾ö·½·¨

 ¾­¹ýºÃ¼¸ÌìµÄ·ÜÕ½£¬JDBCÖÕÓڳɹ¦Á¬½ÓÁËSQL Server 2000£¬ÆÚ¼ä×ßÁ˲»ÉÙÍä·£¬ÔÚÕâÀï·ÖÏíÎÒµÄÒ»µã¾­Ñé
Ò»¡¢ÎҵĻ·¾³
   Windows XP+JDK6u15+Microsoft SQL Server 2000£¨SP4£©+JCreator
   ÎÒÏÈÔÚÍøÉÏÏÂÔØÊý¾Ý¿âÇý¶¯³ÌÐò£¬Ä¿Â¼ÏÂÓÐÈý¸ö°ümsbase.jar mssqlserver.jar msutil.jar
   1 ......

SQL Server Ë«»úÈȱ¸1(based on log shipping)

        ÈÕÖ¾´«ËÍÊÇSQL SERVER2000ÆóÒµ°æ½øÐÐË«»úÈȱ¸µÄÒ»¸öÖ÷Òª½â¾ö·½°¸£¬ÆäÔ­Àí±È½Ï¼òµ¥£¬ÊµÏÖÒ²±È½Ï·½±ã£¬Ö»ÊÇÓÉÓÚºÍWindowsÖ®¼ä´í×Û¸´ÔӵĹØÏµ£¬µ¼ÖÂÉèÖÃÆðÀ´Óв»ÉÙÀ§ÄÑ£¬³öÏÖÎÊÌâÒ²²»ÈÝÒ×Õï¶Ï¡£
1.ʵÏÖ¸ÅÊö
 *Ë«»úÈȱ¸Õë¶ÔµÄÊǾßÌåµÄij¸öÊý¾Ý¿â¶ø²»ÊÇÕû¸ö·þÎñÆ÷
 Ë«» ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ