Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB
ÈÈÃűêÇ©£º c c# c++ asp asp.net linux php jsp java vb Python Ruby mysql sql access Sqlite sqlserver delphi javascript Oracle ajax wap mssql html css flash flex dreamweaver xml
 ×îÐÂÎÄÕ :

LinuxÖж¨Î»¡¢²éÕÒÎļþµÄÃüÁî

which Óï·¨ which command ˵Ã÷ ÒÀÐò´Ópath»·¾³±äÁ¿ËùÁеÄĿ¼ÖÐÕÒ³öcommandµÄλÖ㬲¢ÏÔʾÍêÕû·¾¶µÄÃû³Æ¡£ÔÚÕÒµ½µÚÒ»¸ö·ûºÏÌõ¼þµÄ³ÌÐòÎļþʱ£¬¾ÍÁ¢¿ÌÍ£Ö¹ËÑË÷£¬Ê¡ÂÔÆäÓàδËÑË÷Ŀ¼¡£ ·¶Àý£¬ÕÒ³ölsÃüÁîµÄ³ÌÐòÎļþµÄλÖ㺠which ls ϵͳÊä³ö£º /usr/bin/ls whereis Óï·¨ whereis [option] name ˵Ã÷ ÕÒ³öÌØ¶¨³ÌÐòµÄ¿ÉÖ´ÐÐÎļþ¡¢Ô´´úÂëÎļþÒÔ¼°manpageµÄ·¾¶¡£ÄãËùÌṩµÄname»á±»ÏȳýȥǰÖõÄ·¾¶ÒÔ¼°ÈκÎ.extÐÎʽµÄÀ©Õ¹Ãû¡£ whereis Ö»»áÔÚ±ê×¼µÄLinuxĿ¼ÖнøÐÐËÑË÷¡£ ³£ÓÃÑ¡Ïî -b Ö»ËÑË÷¿ÉÖ´ÐÐÎļþ¡£ -m Ö»ËÑË÷manpage¡£ -s Ö»ËÑË÷Ô´´úÂëÎļþ¡£ -B directory ¸ü¸Ä»òÏÞ¶¨ËÑË÷¿ÉÖ´ÐеÄÎļþµÄĿ¼¡£ -M directory ¸ü¸Ä»òÏÞ¶¨ËÑË÷manpageµÄĿ¼¡£ -S directory ¸ü¸Ä»òÏÞ¶¨ËÑË÷Ô´´úÂëÎļþµÄĿ¼¡£ find Óï·¨ find paths expression [action] ˵Ã÷ ÒÔpathsΪËÑË÷ÆðµãÖð²ãÍùÏÂÕÒ³öÿһ¸ö·ûºÏexpressionÌõ¼þµÄÎļþ£¬²¢¶Ô¸ÃÎļþÖ´ÐÐactionËù´ú±íµÄ¶¯×÷¡£expressionÊÇËÑË÷Ìõ¼þ£¬ËüÓÉÒ»¸ö´ú±íÆ¥ÅäÏîÄ¿µÄÑ¡ÏîÒÔ¼°Ò»¸ö´ú±íÆ¥ÅäģʽµÄ²ÎÊý¹¹³É¡£ actionÊÇ´¦Àí¶¯×÷£¬ËüÓÐÒ»¸ö´ú±í¡°´¦Àí·½Ê½¡±µÄÑ¡ÏîÒÔ¼°Ò»¸ö²Ù×÷²ÎÊý¹¹³É¡£Èô²»Ö¸¶¨action£¬ÔòĬÈ϶¯×÷ÊÇÏ ......

linux Ó²Á´½ÓÓëÈíÁ¬½ÓµÄÇø±ð


Ê×ÏÈÎÒÃÇÐèÒªÁ˽âlinux
ÏÂÓ²Á´½ÓÒÔ¼°ÈíÁ¬½ÓµÄ»ù±¾¸ÅÄî.
Ó²Á´½Ó£ºÐ½¨µÄÎļþÊÇÒѾ­´æÔÚµÄÎļþµÄÒ»¸ö±ðÃû£¬µ±Ô­Îļþɾ³ýʱ£¬Ð½¨µÄÎļþÈÔÈ»¿ÉÒÔʹÓÃ.
ÈíÁ´½Ó£ºÒ²³ÆÎª·ûºÅÁ´½Ó£¬Ð½¨µÄÎļþÒÔ“
·¾¶”
µÄÐÎʽÀ´±íʾÁíÒ»¸öÎļþ£¬ºÍWindows
µÄ¿ì½Ý·½Ê½Ê®·ÖÏàËÆ£¬Ð½¨µÄÈíÁ´½Ó¿ÉÒÔÖ¸Ïò²»´æÔÚµÄÎļþ.
ÏÂÃæÏêϸ½éÉÜÒ»ÏÂÓ²Á´½ÓºÍÈíÁ¬½ÓÖ®¼äµÄÇø±ð.
1.
Ó²Á´½ÓºÍÔ­À´µÄÎļþûÓÐÊ²Ã´Çø±ð£¬¶øÇÒ¹²ÏíÒ»¸ö
inode
ºÅ£¨ÎļþÔÚÎļþϵͳÉϵÄΨһ±êʶ£©£»¶øÈíÁ´½Ó²»¹²Ïí inode
£¬Ò²¿ÉÒÔ˵ÊǸöÌØÊâµÄ inode
£¬ËùÒÔºÍÔ­À´µÄ inode
ÓÐÇø±ð¡£
2.
ÈôÔ­Îļþɾ³ýÁË£¬Ôò¸ÃÈíÁ¬½ÓÔò²»¿ÉÒÔ·ÃÎÊ£¬¶øÓ²Á¬½ÓÔòÊÇ¿ÉÒԵġ£
3.
ÓÉÓÚ·ûºÅÁ´½ÓµÄÌØÐÔ£¬µ¼ÖÂÆä¿ÉÒÔ¿çÔ½´ÅÅÌ·ÖÇø£¬µ«Ó²Á´½Ó²»¾ß±¸Õâ¸öÌØÐÔ.
ÁíÍâÔÚ×ªÔØÒ»ÏÂÍøÉϵĽéÉÜ.
Ó²Á´½Ó(hard
link)
  
UNIX
ÎļþϵͳÌṩÁËÒ»ÖÖ½«²»Í¬ÎļþÁ´½ÓÖÁͬһ¸öÎļþµÄ»úÖÆ£¬ÎÒÃdzÆÕâÖÖ»úÖÆÎªÁ´½Ó¡£Ëü¿ÉÒÔʹµÃµ¥¸ö³ÌÐò¶ÔͬһÎļþʹÓò»Í¬µÄÃû×Ö¡£ÕâÑùµÄºÃ´¦ÊÇÎļþϵ
ͳֻ´æÔÚÒ»¸öÎļþµÄ¸±±¾¡£ÏµÍ³¼òµ¥µØÍ¨¹ýÔÚĿ¼Öн¨Á¢Ò»¸öеĵǼÇÏîÀ´ÊµÏÖÕâÖÖÁ¬½Ó¡£¸ÃµÇ¼ÇÏî¾ßÓÐÒ»¸öеÄÎļþÃûºÍÒªÁ¬½ÓÎļþµÄinode
ºÅ(inode
ÓëÔ­ÎļþÏ ......

LinuxÏÂÎļþµÄÍøÂç´«Êä

½ñÌìµÄÊÂÌ«¶à£¬Ã»ÓÐÈÏÕæµÄÍê³ÉÈÎÎñ£¬²»¹ý°Ñ·þÎñÆ÷¶ËµÄÎļþ´«Êä×öºÃÁË£¡
Ã÷Ìì°Ñ·þÎñÆ÷¶ËµÄ´úÂ뼯³ÉÆðÀ´²âÊÔһϣ¬²¢°ÑÍøÂç¿Í»§¶Ë³ÌÐò×öºÃ£¡
°Ñ´úÂëÌù³öÀ´°É£¡±ãÓÚ±£´æ£¡
Í·Îļþ£ºserver_udpsocket.h
#ifndef _SERVER_UDPSOCKET_H_
#define _SERVER_UDPSOCKET_H_
#include <stdio.h>
#include <stdlib.h>
#include <unistd.h>
#include <sys/ioctl.h>
#include <pthread.h>
#include <sys/wait.h>
#include <sys/socket.h>
#include <netinet/in.h>
#include <errno.h>
#include <sys/types.h>
#include <sys/stat.h>
#include <fcntl.h>
#define bool int
#define true 1
#define false 0
int errno ;
bool init_udpsocket() ;
bool udpsocket_Run() ;
void *thread_udpsocket() ;
#endif
³ÌÐòÎļþ£ºserver_udpsocket.c
#include "server_udpsocket.h"
int hsockfd;                        // Socket file descriptor
int hnsockfd; &nbs ......

linuxÏÂcÓïÑÔ±à³Ì vi ¼ò½é

 /*±¾ÎÄÑ¡×Ô²©´´linuxʵÑéÖ¸µ¼Êé
*Áô×Å×Ô¼ºÑ§Ï°Ö®ÓÃ
*ÔÚÕâÀï±£´æ×Å£¬·ÖÏíÒ»ÏÂ*/
VI ¼ò½é
    vi ÊÇ Linux/Unix ÊÀ½çÀKΪÆÕ±éµÄ¿ÉÊÓ»¯µÄÈ«ÆÁÄ»Îı¾±à¼­Æ÷(visual edit),¼¸ºõ¿É
ÒÔ˵ÈκÎһ̨ Linux/Unix »úÆ÷¶¼»áÌṩÕâ¸öÈí¼þ¡£
    vi ÓÐÈýÖÖ״̬,¼´±à¼­·½Ê½¡¢²åÈ뷽ʽºÍÃüÁʽ¡£ÔÚÃüÁʽÏÂ,ËùÓÐÃüÁî¶¼Òª
ÒÔ:¿ªÊ¼,Ëù¼üÈëµÄ×Ö·ûϵͳ¾ù×÷ÃüÁîÀ´´¦Àí,Èç:q ´ú±íÍ˳ö,:w ±íʾ´æÅÌ¡£µ±Äã½øÈë
vi ʱ,»áÊ×ÏȽøÈëÃüÁʽ(ͬʱҲÊDZ༭·½Ê½)                        ¡£°´Ï i ¾Í½øÈë²åÈ뷽ʽ,Óû§ÊäÈëµÄ
¿ÉÊÓ×Ö·û¶¼Ìí¼Óµ½ÎļþÖÐ,ÏÔʾÔÚÆÁÄ»ÉÏ¡£°´Ï ESC ¾Í¿ÉÒԻص½ÃüÁî״̬(ͬʱҲÊDZà
¼­·½Ê½)    ¡£
    ±à¼­·½Ê½ºÍÃüÁʽÀàËÆ,¶¼ÊÇÒªÊäÈëÃüÁî,µ«ËüµÄÃüÁî²»ÒªÒÔ:¿ªÊ¼,ËüÖ±½Ó½ÓÊÜ
¼üÅÌÊäÈëµÄµ¥×Ö·û»ò×éºÏ×Ö·ûÃüÁî,ÀýÈçÖ±½Ó°´Ï u ¾Í±íʾȡÏûÉÏÒ»´Î¶ÔÎļþµÄÐÞ¸Ä,Ïà
µ±ÓÚ WINDOWS Ï嵀 Undo ²Ù×÷¡£±àÒ뷽ʽÏÂÓÐһЩÃüÁîÊÇÒªÒÔ/¿ªÊ¼µÄ,ÀýÈç²éÕÒ×Ö·û
´®¾ÍÊÇ:/string ÔòÔÚÎļþ ......

linuxÏÂcÓïÑÔ±à³Ì vi ¼ò½é

 /*±¾ÎÄÑ¡×Ô²©´´linuxʵÑéÖ¸µ¼Êé
*Áô×Å×Ô¼ºÑ§Ï°Ö®ÓÃ
*ÔÚÕâÀï±£´æ×Å£¬·ÖÏíÒ»ÏÂ*/
VI ¼ò½é
    vi ÊÇ Linux/Unix ÊÀ½çÀKΪÆÕ±éµÄ¿ÉÊÓ»¯µÄÈ«ÆÁÄ»Îı¾±à¼­Æ÷(visual edit),¼¸ºõ¿É
ÒÔ˵ÈκÎһ̨ Linux/Unix »úÆ÷¶¼»áÌṩÕâ¸öÈí¼þ¡£
    vi ÓÐÈýÖÖ״̬,¼´±à¼­·½Ê½¡¢²åÈ뷽ʽºÍÃüÁʽ¡£ÔÚÃüÁʽÏÂ,ËùÓÐÃüÁî¶¼Òª
ÒÔ:¿ªÊ¼,Ëù¼üÈëµÄ×Ö·ûϵͳ¾ù×÷ÃüÁîÀ´´¦Àí,Èç:q ´ú±íÍ˳ö,:w ±íʾ´æÅÌ¡£µ±Äã½øÈë
vi ʱ,»áÊ×ÏȽøÈëÃüÁʽ(ͬʱҲÊDZ༭·½Ê½)                        ¡£°´Ï i ¾Í½øÈë²åÈ뷽ʽ,Óû§ÊäÈëµÄ
¿ÉÊÓ×Ö·û¶¼Ìí¼Óµ½ÎļþÖÐ,ÏÔʾÔÚÆÁÄ»ÉÏ¡£°´Ï ESC ¾Í¿ÉÒԻص½ÃüÁî״̬(ͬʱҲÊDZà
¼­·½Ê½)    ¡£
    ±à¼­·½Ê½ºÍÃüÁʽÀàËÆ,¶¼ÊÇÒªÊäÈëÃüÁî,µ«ËüµÄÃüÁî²»ÒªÒÔ:¿ªÊ¼,ËüÖ±½Ó½ÓÊÜ
¼üÅÌÊäÈëµÄµ¥×Ö·û»ò×éºÏ×Ö·ûÃüÁî,ÀýÈçÖ±½Ó°´Ï u ¾Í±íʾȡÏûÉÏÒ»´Î¶ÔÎļþµÄÐÞ¸Ä,Ïà
µ±ÓÚ WINDOWS Ï嵀 Undo ²Ù×÷¡£±àÒ뷽ʽÏÂÓÐһЩÃüÁîÊÇÒªÒÔ/¿ªÊ¼µÄ,ÀýÈç²éÕÒ×Ö·û
´®¾ÍÊÇ:/string ÔòÔÚÎļþ ......

JAVAÁ¬½Ósql server 2005 Êý¾Ý¿âÐĵÃ

Ê×ÏȵÃÏÂÔØÇý¶¯³ÌÐòµ½Î¢ÈíÍøÕ¾ÏÂÔØMicrosoft SQL Server 2005 JDBC Driver 1.2
½âѹMicrosoft SQL Server 2005 jdbc driver1.2.exe£¬°Ñsqljdbc_1.1¸´ÖƵ½%ProgramFiles%£¨Èç¹ûϵͳÔÚCÅÌÔòΪC:\Program Files£©¡£
ÉèÖÃ Classpath
JDBC Çý¶¯³ÌÐò²¢Î´°üº¬ÔÚ Java SDK ÖС£Òò´Ë£¬Èç¹ûҪʹÓøÃÇý¶¯³ÌÐò£¬±ØÐ뽫 classpath ÉèÖÃΪ°üº¬ sqljdbc.jar Îļþ¡£Èç¹û classpath ȱÉÙ sqljdbc.jar ÏӦÓóÌÐò½«Òý·¢“ÕÒ²»µ½Àà”µÄ³£¼ûÒì³£¡£
sqljdbc.jar ÎļþµÄ°²×°Î»ÖÃÈçÏ£º
<°²×°Ä¿Â¼>\sqljdbc_<°æ±¾>\<ÓïÑÔ>\sqljdbc.jar
ÏÂÃæÊÇÓÃÓÚ Windows Ó¦ÓóÌÐòµÄ CLASSPATH Óï¾äʵÀý£º
CLASSPATH =.;%ProgramFiles%\sqljdbc_1.2\chs\sqljdbc.jar
ÉèÖÃSQL Server·þÎñÆ÷
ÎÒʹÓõÄÊÇSQL Server 2005±ê×¼°æSP2£¬ÕâЩ¶¼Ä¬Èϼ´¿É£¬Ò»°ã²»ÓÃÅäÖá£Èç¹ûÐèÒªÅäÖö˿ÚÇë¿´ÏÂÃæ¡£
1¡¢“¿ªÊ¼”→“³ÌÐò”→“Microsoft SQL Server 2005”→“ÅäÖù¤¾ß”→“SQL Server ÅäÖùÜÀíÆ÷”→“SQL Server 2005 ÍøÂçÅäÖÔ→“MSSQLSERVER µÄЭÒé”
2¡¢Èç¹û&ldq ......

JAVAÁ¬½Ósql server 2005 Êý¾Ý¿âÐĵÃ

Ê×ÏȵÃÏÂÔØÇý¶¯³ÌÐòµ½Î¢ÈíÍøÕ¾ÏÂÔØMicrosoft SQL Server 2005 JDBC Driver 1.2
½âѹMicrosoft SQL Server 2005 jdbc driver1.2.exe£¬°Ñsqljdbc_1.1¸´ÖƵ½%ProgramFiles%£¨Èç¹ûϵͳÔÚCÅÌÔòΪC:\Program Files£©¡£
ÉèÖÃ Classpath
JDBC Çý¶¯³ÌÐò²¢Î´°üº¬ÔÚ Java SDK ÖС£Òò´Ë£¬Èç¹ûҪʹÓøÃÇý¶¯³ÌÐò£¬±ØÐ뽫 classpath ÉèÖÃΪ°üº¬ sqljdbc.jar Îļþ¡£Èç¹û classpath ȱÉÙ sqljdbc.jar ÏӦÓóÌÐò½«Òý·¢“ÕÒ²»µ½Àà”µÄ³£¼ûÒì³£¡£
sqljdbc.jar ÎļþµÄ°²×°Î»ÖÃÈçÏ£º
<°²×°Ä¿Â¼>\sqljdbc_<°æ±¾>\<ÓïÑÔ>\sqljdbc.jar
ÏÂÃæÊÇÓÃÓÚ Windows Ó¦ÓóÌÐòµÄ CLASSPATH Óï¾äʵÀý£º
CLASSPATH =.;%ProgramFiles%\sqljdbc_1.2\chs\sqljdbc.jar
ÉèÖÃSQL Server·þÎñÆ÷
ÎÒʹÓõÄÊÇSQL Server 2005±ê×¼°æSP2£¬ÕâЩ¶¼Ä¬Èϼ´¿É£¬Ò»°ã²»ÓÃÅäÖá£Èç¹ûÐèÒªÅäÖö˿ÚÇë¿´ÏÂÃæ¡£
1¡¢“¿ªÊ¼”→“³ÌÐò”→“Microsoft SQL Server 2005”→“ÅäÖù¤¾ß”→“SQL Server ÅäÖùÜÀíÆ÷”→“SQL Server 2005 ÍøÂçÅäÖÔ→“MSSQLSERVER µÄЭÒé”
2¡¢Èç¹û&ldq ......

SQL²éѯÿÐÐÖÐ×î´óÖµµÄ¼¼ÇÉ

--------------------------------------------------------------------------
--  Author : htl258(Tony)
--  Date   : 2010-04-23 08:08:36
--  Version:Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (Intel X86)
--          Jul  9 2008 14:43:34
--          Copyright (c) 1988-2008 Microsoft Corporation
--          Developer Edition on Windows NT 5.1 <X86> (Build 2600: Service Pack 3)
--  Blog   : http://blog.csdn.net/htl258
--  Subject: SQL²éѯÿÐÐÖÐ×î´óÖµµÄ¼¼ÇÉ
--------------------------------------------------------------------------
--> Éú³É²âÊÔÊý¾Ý±í:tb
 
IF NOT OBJECT_ID('[tb]') IS NULL
    DROP TABLE [tb]
GO
CREATE TABLE [tb](
a SMALLINT,
b SMALLINT,
c SMALLINT,
d SMALLINT,
e SMALLINT,
f SMALLINT,
g SMALLINT
)
INSERT [tb]
SELECT 1,2,3,4,5,2,3 UNION A ......
×ܼǼÊý:40319; ×ÜÒ³Êý:6720; ÿҳ6 Ìõ; Ê×Ò³ ÉÏÒ»Ò³ [1402] [1403] [1404] [1405] 1406 [1407] [1408] [1409] [1410] [1411]  ÏÂÒ»Ò³ βҳ
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ