﻿<?xml version="1.0" encoding="utf-8" standalone="yes"?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:trackback="http://madskills.com/public/xml/rss/module/trackback/" xmlns:wfw="http://wellformedweb.org/CommentAPI/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/"><channel><title>IT博客-痕迹</title><link>http://www.cnitblog.com/wangyaqin2006/</link><description>自己的脚印</description><language>zh-cn</language><lastBuildDate>Wed, 29 Apr 2026 06:04:17 GMT</lastBuildDate><pubDate>Wed, 29 Apr 2026 06:04:17 GMT</pubDate><ttl>60</ttl><item><title>配置weblogic服务器  </title><link>http://www.cnitblog.com/wangyaqin2006/archive/2008/07/25/47139.html</link><dc:creator>wangyaqin</dc:creator><author>wangyaqin</author><pubDate>Fri, 25 Jul 2008 11:32:00 GMT</pubDate><guid>http://www.cnitblog.com/wangyaqin2006/archive/2008/07/25/47139.html</guid><wfw:comment>http://www.cnitblog.com/wangyaqin2006/comments/47139.html</wfw:comment><comments>http://www.cnitblog.com/wangyaqin2006/archive/2008/07/25/47139.html#Feedback</comments><slash:comments>0</slash:comments><wfw:commentRss>http://www.cnitblog.com/wangyaqin2006/comments/commentRss/47139.html</wfw:commentRss><trackback:ping>http://www.cnitblog.com/wangyaqin2006/services/trackbacks/47139.html</trackback:ping><description><![CDATA[<table class=titel style="BORDER-TOP: #ffffff 17px solid" cellSpacing=0 cellPadding=0 width=560 border=0>
    <tbody>
        <tr>
            <td align=middle>
            <h1 class=titel>配置weblogic服务器 </h1>
            </td>
        </tr>
    </tbody>
</table>
<table style="MARGIN: 2px 0px 20px" cellSpacing=0 cellPadding=0 width=560 border=0>
    <tbody>
        <tr>
            <td bgColor=#b1bcc0 height=1></td>
        </tr>
    </tbody>
</table>
<table style="MARGIN-BOTTOM: 20px" cellSpacing=0 cellPadding=0 width=560 border=0>
    <tbody>
        <tr>
            <td align=middle><span class=content01></span><span class=b>&nbsp;</span></td>
        </tr>
    </tbody>
</table>
<table class=p11 cellSpacing=0 cellPadding=0 width=560 border=0>
    <tbody>
        <tr>
            <td style="WORD-WRAP: break-word" align=left>
            <p class=a14c style="TEXT-INDENT: 2em"><span class=a14c id=zoom>
            <p style="TEXT-INDENT: 2em"><span id=post2 style="FONT-SIZE: 12px; COLOR: #000000">///////////////////////////////////////////////////////////////////////////////<br>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;系 统 环 境 与 配 置<br>&nbsp; autoer: &nbsp; feng13<br>///////////////////////////////////////////////////////////////////////////////<br>一.系统环境<br>oracle817<br>jbuilderx<br>weblogic812<br>二。配置步骤：<br>1.oracle817<br>&nbsp;(1)在安装oracle可直接将全局数据库名设为：SDDEPG;<br>&nbsp;(2)安装完以后打开开始菜单中Oracle DBA Studio<br>&nbsp; &nbsp; &nbsp;用户名：system &nbsp; &nbsp;密码：manager<br>&nbsp;(3)使用SDDEPG数据库，并创建用户：SDDEPG 密码为：SDDEPG<br>&nbsp; &nbsp; 并为该用户添加DBA权限<br>&nbsp;(4)给SDDEPG数据库定义名字为SDDEPG的表空间。初步定义为：开发阶段30M，实施时使用500M。<br>&nbsp;(5)使用PL/SQL 并以SDDEPG用户名登陆，密码为SDDEPG，如果登陆正常说明oracle正常安装<br>&nbsp;(6)登陆后选择my objects，并选择Tools中Import Table 中的SQL Inserts浏览并找到《SDDEPG系统文档》即可建立数据库。<br>2.Jbuilderx<br>&nbsp;(1)安装Jbuilderx，默认安装即可，<br>&nbsp;(2)打开Jbuilderx后选择File——new——Pull Project from CVS<br>&nbsp;(3)在Step 1 of 4 中，通过Target directory来更改项目在本机的存放目录；<br>&nbsp;(4)在Step 2 of 4 中，需要填写的内容如下<br>&nbsp; &nbsp; Special port：2401 &nbsp; Server：192.168.0.102 &nbsp; User:lgz<br>&nbsp;(5)在Step 3 of 4 中，需要填写的参数如下<br>&nbsp; &nbsp; Repository path :/sddepg<br>&nbsp; &nbsp; Module name:sddepg<br>&nbsp; &nbsp; 点击next需要添入密码：123<br>&nbsp; &nbsp; 若无错误即可连接成功进入在Step 4 of 4。<br>3.weblogic812<br>&nbsp; (1)安装weblogic，默认安装即可;<br>&nbsp; (2)在开始菜单中选择Weblogic 的Configuration新建weblogic配置<br>&nbsp; &nbsp; &nbsp;在BEA Weblogic Congiguration Wiazard 中默认 Basic Weblogi Server Domain<br>&nbsp; &nbsp; &nbsp;默认快速配置，在配置管理用户名和密码中都统一为：用户名为weblogic &nbsp;密码为12345678<br>&nbsp; &nbsp; &nbsp;设置好以后创建即可。<br>&nbsp; (3)先在开始菜单中打开启动Weblogic服务。BEA Weblogic-User Projects mydomin-StartServer<br>&nbsp; &nbsp; &nbsp;打开internet浏览器，在地址栏输入http://localhost:7001/console<br>&nbsp; &nbsp; &nbsp;登陆weblogic，登录名为weblogic，密码为12345678<br>&nbsp; (4)配置连接池：点击JDBC中的Connection Pools<br>&nbsp; &nbsp; &nbsp;选择Configure a new JDBC Connection Pool 所需要填写的参数如下：<br>&nbsp; &nbsp; &nbsp;DataBase Type:Oracle;<br>&nbsp; &nbsp; &nbsp;Data Driver:Oracle's Driver(Thin) Versions 8.1.7.9.0.1.9.2.0<br>&nbsp; &nbsp; &nbsp;Name:MyJDBC Connection Pool<br>&nbsp; &nbsp; &nbsp;Data base Name:SDDEPG<br>&nbsp; &nbsp; &nbsp;Host Name:localhost<br>&nbsp; &nbsp; &nbsp;Port:1521<br>&nbsp; &nbsp; &nbsp;Datebase User Name:SDDEPG<br>&nbsp; &nbsp; &nbsp;Password:SDDEPG<br>&nbsp; &nbsp; &nbsp;填写好以后点击 Test Driver Configuration 若无错误则显示Connection Successful<br>&nbsp; &nbsp; &nbsp;点击Create and deploy.<br>&nbsp; &nbsp;(5)配置数据源：点击JDBC 中 Data Sources 选择Configure a new JDBC Data Source<br>&nbsp; &nbsp; &nbsp; 参数如下：<br>&nbsp; &nbsp; &nbsp; Name:MyJDBC Data Sourse<br>&nbsp; &nbsp; &nbsp; JNDI Name:sddepgDataSource<br>4.Jbuilderx 与 Weblogic 整合<br>&nbsp; &nbsp; 打开Jbuilderx选择Tools 中 Configure Servers<br>&nbsp; &nbsp; &nbsp; 选择左边的Weblogic Platform Server8x<br>&nbsp; &nbsp; &nbsp; 在右边的General中配置参数如下（本例中weblogic安装在d盘bea中）：<br>&nbsp; &nbsp; &nbsp; Home directory:D:/bea/weblogic81/server;<br>&nbsp; &nbsp; &nbsp; Main class:weblogic.Server<br>&nbsp; &nbsp; &nbsp; VM parameters:78 -Dweblogic.management.username=weblogic;<br>&nbsp; &nbsp; &nbsp; Working directory:D:/bea/user_projects/domains/mydomain.<br>&nbsp; &nbsp; &nbsp; 在Custom中的配置如下：<br>&nbsp; &nbsp; &nbsp; BEA home directory: D:/bea;<br>&nbsp; &nbsp; &nbsp; JDK inStallation directory:D:/bea/jdk141_05;<br>&nbsp; &nbsp; &nbsp; Domain directory:D:/bea/user_projects/domains/mydomain;<br>&nbsp; &nbsp; &nbsp; User name:weblogic;<br>&nbsp; &nbsp; &nbsp; Password:12345678<br>&nbsp; &nbsp; &nbsp; Server name: myserver<br>&nbsp; &nbsp; 最后在Project-Project Properties设置相应属性。</span> </p>
            </span></td>
        </tr>
    </tbody>
</table>
<img src ="http://www.cnitblog.com/wangyaqin2006/aggbug/47139.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.cnitblog.com/wangyaqin2006/" target="_blank">wangyaqin</a> 2008-07-25 19:32 <a href="http://www.cnitblog.com/wangyaqin2006/archive/2008/07/25/47139.html#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Oracle数据导入导出imp/exp命令   </title><link>http://www.cnitblog.com/wangyaqin2006/archive/2008/07/18/46902.html</link><dc:creator>wangyaqin</dc:creator><author>wangyaqin</author><pubDate>Fri, 18 Jul 2008 13:01:00 GMT</pubDate><guid>http://www.cnitblog.com/wangyaqin2006/archive/2008/07/18/46902.html</guid><wfw:comment>http://www.cnitblog.com/wangyaqin2006/comments/46902.html</wfw:comment><comments>http://www.cnitblog.com/wangyaqin2006/archive/2008/07/18/46902.html#Feedback</comments><slash:comments>0</slash:comments><wfw:commentRss>http://www.cnitblog.com/wangyaqin2006/comments/commentRss/46902.html</wfw:commentRss><trackback:ping>http://www.cnitblog.com/wangyaqin2006/services/trackbacks/46902.html</trackback:ping><description><![CDATA[<font color=#006b95>Oracle数据导入导出imp/exp命令</font>&nbsp; &nbsp;<!--
<rdf:rdf xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#"
xmlns:dc="http://purl.org/dc/elements/1.1/"
xmlns:trackback="http://madskills.com/public/xml/rss/module/trackback/">
<rdf:description
rdf:about="http://www.cnblogs.com/jason_lb/archive/2007/02/09/645586.html"
dc:identifier="http://www.cnblogs.com/jason_lb/archive/2007/02/09/645586.html"
dc:title="转：Oracle数据导入导出imp/exp命令"
trackback:ping="http://www.cnblogs.com/jason_lb/services/trackbacks/645586.aspx" />
</rdf:rdf>
-->
<div class=postbody>Oracle数据导入导出imp/exp就相当于oracle数据还原与备份。exp命令可以把数据从远程数据库服务器导出到本地的dmp文件，imp命令可以把dmp文件从本地导入到远处的数据库服务器中。 利用这个功能可以构建两个相同的数据库，一个用来测试，一个用来正式使用。<br>&nbsp;<br>执行环境：可以在SQLPLUS.EXE或者DOS（命令行）中执行，<br>&nbsp;DOS中可以执行时由于 在oracle 8i 中&nbsp; 安装目录ora81BIN被设置为全局路径，<br>&nbsp;该目录下有EXP.EXE与IMP.EXE文件被用来执行导入导出。<br>&nbsp;oracle用java编写，SQLPLUS.EXE、EXP.EXE、IMP.EXE这两个文件有可能是被包装后的类文件。<br>&nbsp;SQLPLUS.EXE调用EXP.EXE、IMP.EXE所包裹的类，完成导入导出功能。<br>&nbsp;<br>下面介绍的是导入导出的实例。<br>数据导出：<br>&nbsp;1 将数据库TEST完全导出,用户名system 密码manager 导出到D:daochu.dmp中<br>&nbsp;&nbsp; exp system/manager@TEST file=d:daochu.dmp full=y<br>&nbsp;2 将数据库中system用户与sys用户的表导出<br>&nbsp;&nbsp; exp system/manager@TEST file=d:daochu.dmp owner=(system,sys)<br>&nbsp;3 将数据库中的表inner_notify、notify_staff_relat导出<br>&nbsp;&nbsp;&nbsp; exp aichannel/aichannel@TESTDB2 file= d:datanewsmgnt.dmp tables=(inner_notify,notify_staff_relat) <br><br>&nbsp;4 将数据库中的表table1中的字段filed1以"00"打头的数据导出<br>&nbsp;&nbsp; exp system/manager@TEST file=d:daochu.dmp tables=(table1) query=" where filed1 like '00%'"<br>&nbsp;<br>&nbsp; 上面是常用的导出，对于压缩，既用winzip把dmp文件可以很好的压缩。<br>&nbsp; 也可以在上面命令后面 加上 compress=y 来实现。<br><br>数据的导入<br>&nbsp;1 将D:daochu.dmp 中的数据导入 TEST数据库中。<br>&nbsp;&nbsp; imp system/manager@TEST&nbsp; file=d:daochu.dmp<br>&nbsp;&nbsp; imp aichannel/aichannel@HUST full=y&nbsp; file=d:datanewsmgnt.dmp ignore=y<br>&nbsp;&nbsp; 上面可能有点问题，因为有的表已经存在，然后它就报错，对该表就不进行导入。<br>&nbsp;&nbsp; 在后面加上 ignore=y 就可以了。<br>&nbsp;2 将d:daochu.dmp中的表table1 导入<br>&nbsp;imp system/manager@TEST&nbsp; file=d:daochu.dmp&nbsp; tables=(table1)<br>&nbsp;<br>&nbsp;基本上上面的导入导出够用了。不少情况要先是将表彻底删除，然后导入。<br>&nbsp;<br>注意：<br>&nbsp;操作者要有足够的权限，权限不够它会提示。<br>&nbsp;数据库时可以连上的。可以用tnsping TEST 来获得数据库TEST能否连上。<br><br>附录一：<br>&nbsp;给用户增加导入数据权限的操作<br>&nbsp;第一,启动sql*puls<br>&nbsp;第二，以system/manager登陆<br>&nbsp;第三，create user 用户名 IDENTIFIED BY 密码 （如果已经创建过用户，这步可以省略）<br>&nbsp;第四，GRANT CREATE USER,DROP USER,ALTER USER ,CREATE ANY VIEW ,<br>&nbsp;&nbsp; DROP ANY VIEW,EXP_FULL_DATABASE,IMP_FULL_DATABASE,<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DBA,CONNECT,RESOURCE,CREATE SESSION&nbsp; TO 用户名字<br>&nbsp;第五, 运行-cmd-进入dmp文件所在的目录,<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; imp userid=system/manager full=y file=*.dmp<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 或者 imp userid=system/manager full=y file=filename.dmp<br><br>&nbsp;执行示例:<br>&nbsp;F:WorkOracle_Databackup&gt;imp userid=test/test full=y file=inner_notify.dmp<br><br>屏幕显示<br>Import: Release 8.1.7.0.0 - Production on 星期四 2月 16 16:50:05 2006<br>(c) Copyright 2000 Oracle Corporation.&nbsp; All rights reserved.<br><br>连接到: Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production<br>With the Partitioning option<br>JServer Release 8.1.7.0.0 - Production<br><br>经由常规路径导出由EXPORT:V08.01.07创建的文件<br>已经完成ZHS16GBK字符集和ZHS16GBK NCHAR 字符集中的导入<br>导出服务器使用UTF8 NCHAR 字符集 (可能的ncharset转换)<br>. 正在将AICHANNEL的对象导入到 AICHANNEL<br>. . 正在导入表&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "INNER_NOTIFY"&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4行被导入<br>准备启用约束条件...<br>成功终止导入，但出现警告。<br><br>&nbsp;<br>附录二：<br>&nbsp;Oracle 不允许直接改变表的拥有者, 利用Export/Import可以达到这一目的.<br>&nbsp; 先建立import9.par,<br>&nbsp; 然后，使用时命令如下：imp parfile=/filepath/import9.par<br>&nbsp; 例 import9.par 内容如下：<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; FROMUSER=TGPMS&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TOUSER=TGPMS2&nbsp;&nbsp;&nbsp;&nbsp; （注：把表的拥有者由FROMUSER改为TOUSER，FROMUSER和TOUSER的用户可以不同）&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ROWS=Y<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; INDEXES=Y<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; GRANTS=Y<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CONSTRAINTS=Y<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; BUFFER=409600<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; file==/backup/ctgpc_20030623.dmp<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; log==/backup/import_20030623.log <br><br>&nbsp;补充：<br>1.在导入导出命令中加上feedback=1000可以让过程显示一个不断增多的&#8220;...&#8221;，以改变以往的闪烁的光标</div>
<img src ="http://www.cnitblog.com/wangyaqin2006/aggbug/46902.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.cnitblog.com/wangyaqin2006/" target="_blank">wangyaqin</a> 2008-07-18 21:01 <a href="http://www.cnitblog.com/wangyaqin2006/archive/2008/07/18/46902.html#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>ftp命令</title><link>http://www.cnitblog.com/wangyaqin2006/archive/2008/07/18/46901.html</link><dc:creator>wangyaqin</dc:creator><author>wangyaqin</author><pubDate>Fri, 18 Jul 2008 12:57:00 GMT</pubDate><guid>http://www.cnitblog.com/wangyaqin2006/archive/2008/07/18/46901.html</guid><wfw:comment>http://www.cnitblog.com/wangyaqin2006/comments/46901.html</wfw:comment><comments>http://www.cnitblog.com/wangyaqin2006/archive/2008/07/18/46901.html#Feedback</comments><slash:comments>0</slash:comments><wfw:commentRss>http://www.cnitblog.com/wangyaqin2006/comments/commentRss/46901.html</wfw:commentRss><trackback:ping>http://www.cnitblog.com/wangyaqin2006/services/trackbacks/46901.html</trackback:ping><description><![CDATA[<p class="g_w_100 g_t_wrap g_t_center g_t_bold g_t_24 g_c_pdin c07" id=blogtitle_fks_087070093083082069087084094095081083087069082082086074>ftp命令</p>
<div class=g_blog_list>
<div class="g_t_center g_c_pdin g_p_center c07 content" id=blogtext_fks_087070093083082069087084094095081083087069082082086074 style="WIDTH: 760px">
<div>文件传输软件的使用格式为：FTP&lt;FTP地址&gt;，若连 接成功，系统将提示用户输入用户名及口令：<br>LOGIN： (输入合法的用户名或者&#8220;ANONMOUS&#8221;)：<br>PASSWORD： (输入合法的口令，若以&#8220;ANONMOUS&#8221;方式登录，一般不用口令)：<br><br>第一节 FTP命令基础<br><br>进入想要连接的FTP站点后，用户就可以进行相应的文件传输操作了，其中一些重要 的命令及相似的命令 如下：<br>1)HELP、 ?、RHEIP、REMOTEHELP<br>HELP显示LOCAL端的命令说明，若不接受则显示所有可用命令；<br>?相当于HELP，例如：?CD：<br>RHELP同HELP，只是它用来显示REMOTE端的命令说明；<br>REMOTEHELP相当于RHELP。<br>2)ASC(ASCll)、Bm(BmARY)、IMAGE、TYPE<br>ASCII切换传输模式为文字模式(只能用来传送DOC文件，因为是7-BIT)；<br>BINARY切换传输模式为二进制模式(除文字文件外皆用此模式)；<br>IMAGE相当于BINARY：<br>TYPE让你更改或显示目前传输模式。<br>3)BYE、QUIT<br>BYE退出FTP：<br>QUIT相当于BYE。<br>4)CD、CDUP、LCD、P～WD、 !<br>CD改变当前工作目录，例如：CD＼PUB；<br>CDUP回到上一层目录，相当于你打CD．．：<br>LCD让你更改或显示LOCAL端的工作目录，例如：LCD＼TMP；<br>PWD显示目前的工作目录(REMOTE端)：<br>!让你执行外壳命令，例如：!LS。<br>5)DELETE、MDELETE、RENAME<br>DELETE删除REMOTE端的文件：<br>MDELETE批量删除文件，需配合?或，*<br>RENAME更改REMOTE端的文件名。<br>6)GET、MGET、PUT、MPUT、RECV、SEND<br>GET下传文件；<br>MGET批量下传文件，需配合万用字元，例如：MGET*．GZ；<br>PUT上传文件；<br>MPUT批量上传文件，需配合万用字元；<br>RECV相当于GET(RECV为RECEWE的简写)：<br>SEND相当于PUT。<br>7)HASH、PROMPT、VERBOSE、STATUS、BELL<br>HASH切换#字号的出现，每一个#字号表示传送了1024／8192BYTES：<br>PROMPT切换iNTERACTIVEON／OFF；<br>VERBOSE切换所有文件传输过程的显示；<br>STATUS显示目前的一些参数：<br>BELL当指令做完时会发出叫声。<br>8)LS、DIR、MLS、MDIR、MKDIR、RMDIR<br>LS有点象UNIX下的LS(LIST)命令：<br>DIR相当于LS-L(LIST-LONG)；<br>MLS只是将远端某目 录下的文件存于LOCAL端的某文件里；<br>MDIR相当于MLS；<br>MKDIR象DOS下的MD(创建子目录)一样：<br>RMDIR象DOS下的RD(删除子目录)一样。<br>9)OPEN、CLOSE、DISCONNECT、USER &#183;<br>OPEN连接某个远端FTP服务器；<br>CLOSE关闭目前的连接； DISCONNECT相当于CLOSE；<br>USER再输入一次用户名和口令(有点像UNIX下的SU)。<br><br>第二节FTP命令完全掌握<br><br>FTP命令是Intemet用户使用最频繁的命令之一，不论在DOS还在UNIX操作系统下使 用FTP，都会遇到大量的 FTP内部命令。熟悉并灵活应用FTP的内部命令，可以大大方便 使用者，并收到事半功倍之效。<br>FTP的命令行格式为：<br>FTP-v-d-i-n-g[主机名]，其中：<br>—v——显示远程服务器的所有响应信息；<br>—n．------限制FTP的自动登录，即不使用； ，<br>n-----etRc文件：<br>-d——使用调试方式：<br>&#183;g——取消全局文件名。<br>FTP使用的内部命令如下(中括号表示可选项)：<br>1)[crud[args)1：在本地机中执行交互shell，exit回到FTP环境， 列如：！LS*．zip． <br>2)$macro-amc[args儿执行宏定义macro-name。<br>3)accountlpassword]：提供登录远程系统成功后访问系统资源所需的补充口令。<br>4)append local-file[remote-file]：将本地文件追加到远程系统主机，若未指定远系统文件名，则使用本地文件名。<br>5)aSCii：使用ascII型传输方式。<br>6)bell：每个命令执行完毕后计算机响铃—次<br>7)bin：使用二进制文件传输方式<br>8)bye．．退出FTP会话过程—<br>9)case：在使用mget时，将远程主文件名中的大写字母转为小写字母<br>10)cdremote&#183;dir：进入远程主机目录。<br>11)cdup．．进入远程主机目录的父目录。<br>12)chmodmodefile-name：将远程主机文件file-name的存取方式设置为mode。列如：chmod777a．OUt。<br>13)close：中断与远程服务器的FTP会话(与open对应)。<br>14)cr：使用aSSC&#8220;方式传输文件时，将回车换行转换为回行<br>15)deleteremote-file-删除远程主机文件：<br>16)debugldebug-value3：．设置调试方式，显示发送至远程主机的每条命令。例如：debup3，若设为0，表示取消debug。<br>17)dir[remote-dir][Local-file]：显示远程主机目录，并将结果存入本地文件local-file：<br>18)disconnection-．同close。<br>19)formformat：将文件传输方式设置为format，缺省为file方式。<br>20)getremote-file[10cal-file]：将远程主机的文件remote-file传至本地 硬盘的local-file。<br>21)glob：设置mdelete，mget，mput的文件名扩展，缺省时不扩展文件名，同命令行的-g参数。<br>22)hash：每传输1024字节，显示一个hash符号(#)。<br>23)help[cmd]：显示FTP内部命令cmd的帮助信息，如．-helpget。<br>24)idle[seconds]：将远程服务器的休眠计时器设为[seconds]秒。<br>25)image：设置二进制传输方式(同binary)。<br>26)LCD[DIR]：将本地工作目录切换至dir。<br>27)LS[remote-DIR][LOCAL-FILE]：显示远程目录remote-dir，并存入本地文local-fileo<br>28)macdefmacro-name：定义一个宏，遇到macdef下的空行时，宏定义结束。<br>29)mdelete[remote-file]：删除远程主机文件。<br>30)mdirremote-fileslocal-file：与dlr类似，但可指定多个远程文件。 列如mdir*．O．*．zipoutfiLe。<br>31)mgetremote-files：传输多个远程文件。<br>32)mkdirdirname：在远程主机中建一目录。<br>33)misremote-filelocal-file．同nlist，但可指定多个文件名。<br>34)mode[modename]：将文件传输方式设置为modename，缺省为stream方式。<br>35)modtimefile-name．．显示远程主机文件的最后修改时间。 &#183;<br>36)mputlocal-file：将多个文件传输至远程主机，<br>37)newerfile-name： 如果远程机中file-name的修改时间比本地硬盘同名文件的时间巨近，则重新传输该文件。 &#183;<br>38)nlist正remote&#183;di41local-file3：显示远程主机目录的文件清单，并存入本地硬盘的local-fileo<br>39)nmap[npattem outpattem]设置文件名映射机制，使得文件传输时，文件中的某些字符相互转换，如：nmapSl．S2．S3[，][，]，则传输文件a1．a2．a3时，文件名变为a1，a20该命令特别适用于远程主机为非UNIX机的情况o<br>40)ntrans[Inchars[outchars]]设置文件名字符的翻译机制，如ntranslR，则文件名LLI将变为RRR。<br>41)openhost[port]：建立指定FTP服务器连接，可指定连接端口。<br>42)passive：进入被动传输方式。<br>43)prompt：设置多个文件传输时的交互提示。<br>44)proxy FTP-cmd：在次要控制连接中，执行一条FTP命令，该命令允许连接两个FTP服务器，以在两个服务器间传输文件。第一条FTP命令必须为open，以首先建立两个服务器间的连接。<br>45)putlocal-file[remote-file]：将本地文件local-file传送至远程主机。<br>46)vwd：显示远程主机的当前工作目录。<br>47)qmt-．同bye，退出FTP会话。<br>48)quote argl，arg2。。。：将参数逐字发至远程卸服务器，如：quote， syst。<br>49)recvremote-file[Local-file)：同get。<br>50)reget remote-file[Local-file]：类似于get，但若local-file存在，则从上次传输中断处继续传输。<br>51)rhelp[cmd-name]：请求获得远程主机的帮助。<br>52)rstatus[FILe-name]：若未指定文件名，则显示远程主机的状态，否则显示文件状态，<br>53)rename[FRom)[to]：更改远程主机文件名。<br>54)reset：清除回答队列。<br>55)restart marker：从指定的标志marker处，重新开始get或put，如：restartl30。<br>56)rmdirdir-name：删除远程主机目录。<br>57)mnique：设置文件名惟一性存储，若文件存在，则在原文件后加后缀．1，．2等<br>58)send local-file[remote-file)：同put<br>59)sendport：设置PORT命令的使用。<br>60)siteargl，arg2。。。：将参数作为SITE命令逐字发送至远程卸主机。<br>61)sizefile-name：显示远程主机文件大小，如：Slteidle7200。<br>62)stares：。显示当前FTP状态。 &#183;<br>63)struct[struct-name]：将文件传输结构设置为struct-name，缺省时使用stream结构。<br>64)suniclue：将远程主机文件名存储设置为惟一(与mnique对应)。<br>65)system：显示远程主机的操作系统类型。<br>66)tenex：将文件：传输类型设置为TENEX机的所需的类型<br>67)tick：设置传输时的字节计数器<br>68)trace：设置包跟踪。<br>69)type[type-name)：设置文件传输类型为type-name，缺省为ascii，<br>例如：typebinary，设置二进制传输方式。<br>70)umask[newmask)：将远程服务器的缺省umask设置为newmask。 例如：umask 3。<br>71)user user-name [passwordⅡaccount]：向远程主机表明自己的身份，需要口令时，必须输入口令，如：useranonymousmy@emaiL。<br>72)verbose：同命令行的-v参数，即设置详尽报告方式，FTP服务器的所有响应都将显示给用户，缺省为on。<br>73)?[cmd]：同help。
<div></div>
</div>
</div>
</div>
<img src ="http://www.cnitblog.com/wangyaqin2006/aggbug/46901.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.cnitblog.com/wangyaqin2006/" target="_blank">wangyaqin</a> 2008-07-18 20:57 <a href="http://www.cnitblog.com/wangyaqin2006/archive/2008/07/18/46901.html#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Linux修改IP地址</title><link>http://www.cnitblog.com/wangyaqin2006/archive/2008/07/18/46900.html</link><dc:creator>wangyaqin</dc:creator><author>wangyaqin</author><pubDate>Fri, 18 Jul 2008 12:56:00 GMT</pubDate><guid>http://www.cnitblog.com/wangyaqin2006/archive/2008/07/18/46900.html</guid><wfw:comment>http://www.cnitblog.com/wangyaqin2006/comments/46900.html</wfw:comment><comments>http://www.cnitblog.com/wangyaqin2006/archive/2008/07/18/46900.html#Feedback</comments><slash:comments>0</slash:comments><wfw:commentRss>http://www.cnitblog.com/wangyaqin2006/comments/commentRss/46900.html</wfw:commentRss><trackback:ping>http://www.cnitblog.com/wangyaqin2006/services/trackbacks/46900.html</trackback:ping><description><![CDATA[<table cellSpacing=0 cellPadding=0 width=660 align=center border=0>
    <tbody>
        <tr>
            <td class=Ftext1 height=30>Linux修改IP地址</td>
        </tr>
        <tr>
            <td>
            <table cellSpacing=0 cellPadding=0 width="80%" align=center border=0>
                <tbody>
                    <tr>
                        <td bgColor=#cccccc height=1></td>
                    </tr>
                </tbody>
            </table>
            </td>
        </tr>
        <tr>
            <td align=middle height=40></td>
        </tr>
        <tr>
            <td>&nbsp;</td>
        </tr>
        <tr>
            <td class=F14><br>LINUX--修改IP地址<br>A、修改ip地址<br>即时生效:<br># ifconfig eth0 192.168.0.20 netmask 255.255.255.0<br>启动生效:<br>修改/etc/sysconfig/network-scripts/ifcfg-eth0<br>B、修改default gateway<br>即时生效:<br># route add default gw 192.168.0.254<br>启动生效:<br>修改/etc/sysconfig/network-scripts/ifcfg-eth0<br>C、修改dns<br>修改/etc/resolv.conf<br>修改后可即时生效，启动同样有效<br>D、修改host name<br>即时生效:<br># hostname fc2<br>启动生效:<br>修改/etc/sysconfig/network<br></td>
        </tr>
    </tbody>
</table>
<img src ="http://www.cnitblog.com/wangyaqin2006/aggbug/46900.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.cnitblog.com/wangyaqin2006/" target="_blank">wangyaqin</a> 2008-07-18 20:56 <a href="http://www.cnitblog.com/wangyaqin2006/archive/2008/07/18/46900.html#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>oracle 存储过程的基本语法</title><link>http://www.cnitblog.com/wangyaqin2006/archive/2008/07/09/46476.html</link><dc:creator>wangyaqin</dc:creator><author>wangyaqin</author><pubDate>Wed, 09 Jul 2008 03:48:00 GMT</pubDate><guid>http://www.cnitblog.com/wangyaqin2006/archive/2008/07/09/46476.html</guid><wfw:comment>http://www.cnitblog.com/wangyaqin2006/comments/46476.html</wfw:comment><comments>http://www.cnitblog.com/wangyaqin2006/archive/2008/07/09/46476.html#Feedback</comments><slash:comments>0</slash:comments><wfw:commentRss>http://www.cnitblog.com/wangyaqin2006/comments/commentRss/46476.html</wfw:commentRss><trackback:ping>http://www.cnitblog.com/wangyaqin2006/services/trackbacks/46476.html</trackback:ping><description><![CDATA[&nbsp;
<h1><span>oracle </span><span>存储过程的基本语法</span></h1>
<p><strong><span>1.</span></strong><strong><span>基本结构</span></strong><span> <br>CREATE OR REPLACE PROCEDURE <a href="http://www.pcdog.com/edu/storage/index.html" target=_blank><span><span>存储过程</span></span></a></span><span>名字</span><span><br>(<br>&nbsp;&nbsp;&nbsp; </span><span>参数</span><st1:chmetcnv w:st="on" TCSC="0" NumberType="1" Negative="False" HasSpace="True" SourceValue="1" UnitName="in"><span>1 IN</span></st1:chmetcnv><span> NUMBER,<br>&nbsp;&nbsp;&nbsp; </span><span>参数</span><st1:chmetcnv w:st="on" TCSC="0" NumberType="1" Negative="False" HasSpace="True" SourceValue="2" UnitName="in"><span>2 IN</span></st1:chmetcnv><span> NUMBER<br>) IS<br></span><span>变量</span><span>1 INTEGER :=0;<br></span><span>变量</span><span>2 DATE;<br>BEGIN </span></p>
<p><span>END </span><span>存储过程名字</span></p>
<p><strong><span>2.SELECT INTO STATEMENT</span></strong><span><br>&nbsp; </span><span>将</span><span>select</span><span>查询的结果存入到变量中，可以同时将多个列存储多个变量中，必须有一条</span><span><br>&nbsp; </span><span>记录，否则抛出异常</span><span>(</span><span>如果没有记录抛出</span><span>NO_DATA_FOUND)<br>&nbsp; </span><span>例子：</span><span> <br>&nbsp; BEGIN<br>&nbsp; SELECT col1,col2 into </span><span>变量</span><span>1,</span><span>变量</span><span>2 FROM typestruct where xxx;<br>&nbsp; EXCEPTION<br>&nbsp; WHEN NO_DATA_FOUND THEN<br>&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;xxxx;<br>&nbsp; END;<br>&nbsp; ...<br><br><strong><span>3.IF </span></strong></span><strong><span>判断</span></strong><span><br>&nbsp; IF V_TEST=1 THEN<br>&nbsp;&nbsp;&nbsp; BEGIN <br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; do something<br>&nbsp;&nbsp;&nbsp; END;<br>&nbsp; END IF;<br><br><strong><span>4.while </span></strong></span><strong><span>循环</span></strong><span><br>&nbsp; WHILE V_TEST=1 LOOP<br>&nbsp; BEGIN<br>&nbsp;XXXX<br>&nbsp; END;<br>&nbsp; END LOOP;<br><strong><br><strong><span>5.</span></strong></strong></span><strong><span>变量赋值</span></strong><strong><span><br></span></strong><span>&nbsp; V_TEST := 123;<br><strong><br><strong><span>6.</span></strong></strong></span><strong><span>用</span></strong><strong><span>for in </span></strong><strong><span>使用</span></strong><strong><span>cursor</span></strong><span><br>&nbsp; ...<br>&nbsp; IS<br>&nbsp; CURSOR cur IS SELECT * FROM xxx;<br>&nbsp; BEGIN<br>&nbsp;FOR cur_result in cur LOOP<br>&nbsp;&nbsp;BEGIN<br>&nbsp;&nbsp;&nbsp;V_SUM :=cur_result.</span><span>列名</span><span>1+cur_result.</span><span>列名</span><span>2<br>&nbsp;&nbsp;END;<br>&nbsp;END LOOP;<br>&nbsp; END;<br><br><strong><span>7.</span></strong></span><strong><span>带参数的</span></strong><strong><span>cursor</span></strong><span><br>&nbsp; CURSOR C_USER(C_ID NUMBER) IS SELECT NAME FROM USER WHERE TYPEID=C_ID;<br>&nbsp; OPEN C_USER(</span><span>变量值</span><span>);<br>&nbsp; LOOP<br>&nbsp;FETCH C_USER INTO V_NAME;<br>&nbsp;EXIT FETCH C_USER%NOTFOUND;<br>&nbsp;&nbsp;&nbsp; do something<br>&nbsp; END LOOP;<br>&nbsp; CLOSE C_USER;</span></p>
<p><strong><span>8.</span></strong><strong><span>用</span></strong><strong><span>pl/sql developer debug</span></strong><span><br>&nbsp; </span><span>连接数据库后建立一个</span><span>Test WINDOW<br>&nbsp; </span><span>在窗口输入调用</span><span>SP</span><span>的代码</span><span>,F9</span><span>开始</span><span>debug,CTRL+N</span><span>单步调试</span></p>
<ol type=1>
    <li><span>存储过程 包含三部分： 声明，执行部分，异常。<span> &nbsp;&nbsp; </span></span></li>
    <li><span>可以有无参数程序和带参数存储过程。<span> &nbsp;&nbsp; </span></span></li>
    <li><span>无参程序语法<span> &nbsp;&nbsp; </span></span></li>
    <li><span>1</span><span> create or replace procedure NoParPro &nbsp;&nbsp; </span></li>
    <li><span>2</span><span> as&nbsp;&nbsp;&nbsp; ; &nbsp;&nbsp; </span></li>
    <li><span>3</span><span> begin &nbsp;&nbsp; </span></li>
    <li><span>4</span><span>&nbsp;&nbsp; ; &nbsp;&nbsp; </span></li>
    <li><span>5</span><span> exception &nbsp;&nbsp; </span></li>
    <li><span>6</span><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ; &nbsp;&nbsp; </span></li>
    <li><span>7</span><span> end; &nbsp;&nbsp; </span></li>
    <li><span>8</span><span> &nbsp;&nbsp; </span></li>
    <li><span>&nbsp;&nbsp; </span></li>
    <li><span>&nbsp;&nbsp;&nbsp; </span><span>带参存储过程实例<span> &nbsp;&nbsp; </span></span></li>
    <li><span>1</span><span> create or replace procedure queryempname(sfindno emp.empno%type) as &nbsp;&nbsp; </span></li>
    <li><span>2</span><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sName emp.ename%type; &nbsp;&nbsp; </span></li>
    <li><span>3</span><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sjob emp.job%type; &nbsp;&nbsp; </span></li>
    <li><span>4</span><span> begin &nbsp;&nbsp; </span></li>
    <li><span>5</span><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .... &nbsp;&nbsp; </span></li>
    <li><span>7</span><span> exception &nbsp;&nbsp; </span></li>
    <li><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .... &nbsp;&nbsp; </span></li>
    <li><span>14</span><span> end; &nbsp;&nbsp; </span></li>
    <li><span>15</span><span> &nbsp;&nbsp; </span></li>
    <li><span>&nbsp;&nbsp; </span></li>
    <li><span>&nbsp;&nbsp;&nbsp; </span><span>带参数存储过程含赋值方式<span> &nbsp;&nbsp; </span></span></li>
    <li><span>1</span><span> create or replace procedure runbyparmeters&nbsp;&nbsp; (isal in emp.sal%type, &nbsp;&nbsp; </span></li>
    <li><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sname out varchar,sjob in out varchar) &nbsp;&nbsp; </span></li>
    <li><span>2</span><span>&nbsp;&nbsp; as icount number; &nbsp;&nbsp; </span></li>
    <li><span>3</span><span>&nbsp;&nbsp; begin &nbsp;&nbsp; </span></li>
    <li><span>4</span><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; select count(*) into icount from emp where sal&gt;isal and job=sjob; &nbsp;&nbsp; </span></li>
    <li><span>5</span><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<strong><span>if</span></strong> icount=<span>1</span> then &nbsp;&nbsp; </span></li>
    <li><span>6</span><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .... &nbsp;&nbsp; </span></li>
    <li><span>9</span><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<strong><span>else</span></strong>&nbsp;&nbsp; </span></li>
    <li><span>10</span><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .... &nbsp;&nbsp; </span></li>
    <li><span>12</span><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; end <strong><span>if</span></strong>; &nbsp;&nbsp; </span></li>
    <li><span>13</span><span>&nbsp;&nbsp; exception &nbsp;&nbsp; </span></li>
    <li><span>14</span><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; when too_many_rows then &nbsp;&nbsp; </span></li>
    <li><span>15</span><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DBMS_OUTPUT.PUT_LINE(<span>'</span></span><span>返回值多于<span>1</span>行<span>'</span></span><span>); &nbsp;&nbsp; </span></li>
    <li><span>16</span><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; when others then &nbsp;&nbsp; </span></li>
    <li><span>17</span><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DBMS_OUTPUT.PUT_LINE(<span>'</span></span><span>在<span>RUNBYPARMETERS</span>过程中出错！<span>'</span></span><span>); &nbsp;&nbsp; </span></li>
    <li><span>18</span><span>&nbsp;&nbsp; end; &nbsp;&nbsp; </span></li>
    <li><span>19</span><span> &nbsp;&nbsp; </span></li>
    <li><span>&nbsp;&nbsp; </span></li>
    <li><span>&nbsp;&nbsp; </span><span>过程调用<span> &nbsp;&nbsp; </span></span></li>
    <li><span>&nbsp;&nbsp; </span><span>方式一<span> &nbsp;&nbsp; </span></span></li>
    <li><span>1</span><span> declare &nbsp;&nbsp; </span></li>
    <li><span>2</span><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; realsal emp.sal%type; &nbsp;&nbsp; </span></li>
    <li><span>3</span><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; realname varchar(<span>40</span>); &nbsp;&nbsp; </span></li>
    <li><span>4</span><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; realjob varchar(<span>40</span>); &nbsp;&nbsp; </span></li>
    <li><span>5</span><span>&nbsp;&nbsp; begin &nbsp;&nbsp; </span></li>
    <li><span>6</span><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; realsal:=<span>1100</span>; &nbsp;&nbsp; </span></li>
    <li><span>7</span><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; realname:=<span>''</span>; &nbsp;&nbsp; </span></li>
    <li><span>8</span><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; realjob:=<span>'CLERK'</span>; &nbsp;&nbsp; </span></li>
    <li><span>9</span><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; runbyparmeters(realsal,realname,realjob);&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span>－－必须按顺序<span> &nbsp;&nbsp; </span></span></li>
    <li><span>10</span><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DBMS_OUTPUT.PUT_LINE(REALNAME||<span>'&nbsp;&nbsp;&nbsp; '</span>||REALJOB); &nbsp;&nbsp; </span></li>
    <li><span>11</span><span>&nbsp;&nbsp; END; &nbsp;&nbsp; </span></li>
    <li><span>12</span><span> &nbsp;&nbsp; </span></li>
    <li><span>&nbsp;&nbsp; </span></li>
    <li><span>&nbsp;&nbsp; </span><span>方式二<span> &nbsp;&nbsp; </span></span></li>
    <li><span>1</span><span> declare &nbsp;&nbsp; </span></li>
    <li><span>2</span><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; realsal emp.sal%type; &nbsp;&nbsp; </span></li>
    <li><span>3</span><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; realname varchar(<span>40</span>); &nbsp;&nbsp; </span></li>
    <li><span>4</span><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; realjob varchar(<span>40</span>); &nbsp;&nbsp; </span></li>
    <li><span>5</span><span> begin &nbsp;&nbsp; </span></li>
    <li><span>6</span><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; realsal:=<span>1100</span>; &nbsp;&nbsp; </span></li>
    <li><span>7</span><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; realname:=<span>''</span>; &nbsp;&nbsp; </span></li>
    <li><span>8</span><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; realjob:=<span>'CLERK'</span>; &nbsp;&nbsp; </span></li>
    <li><span>9</span><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; runbyparmeters(sname=&gt;realname,isal=&gt;realsal,sjob=&gt;realjob);&nbsp;&nbsp; </span><span>－－指定值对应变量顺序可变<span> &nbsp;&nbsp; </span></span></li>
    <li><span>10</span><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DBMS_OUTPUT.PUT_LINE(REALNAME||<span>'&nbsp;&nbsp;&nbsp; '</span>||REALJOB); &nbsp;&nbsp; </span></li>
    <li><span>11</span><span> END; &nbsp;&nbsp; </span></li>
    <li><span>12</span><span>&nbsp;&nbsp;&nbsp; </span></li>
</ol>
<p align=left>&nbsp;</p>
<img src ="http://www.cnitblog.com/wangyaqin2006/aggbug/46476.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.cnitblog.com/wangyaqin2006/" target="_blank">wangyaqin</a> 2008-07-09 11:48 <a href="http://www.cnitblog.com/wangyaqin2006/archive/2008/07/09/46476.html#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Unix命令。</title><link>http://www.cnitblog.com/wangyaqin2006/archive/2008/07/09/46474.html</link><dc:creator>wangyaqin</dc:creator><author>wangyaqin</author><pubDate>Wed, 09 Jul 2008 03:43:00 GMT</pubDate><guid>http://www.cnitblog.com/wangyaqin2006/archive/2008/07/09/46474.html</guid><wfw:comment>http://www.cnitblog.com/wangyaqin2006/comments/46474.html</wfw:comment><comments>http://www.cnitblog.com/wangyaqin2006/archive/2008/07/09/46474.html#Feedback</comments><slash:comments>0</slash:comments><wfw:commentRss>http://www.cnitblog.com/wangyaqin2006/comments/commentRss/46474.html</wfw:commentRss><trackback:ping>http://www.cnitblog.com/wangyaqin2006/services/trackbacks/46474.html</trackback:ping><description><![CDATA[&nbsp;
<div align=center>
<table cellSpacing=0 cellPadding=0 width="100%" border=0>
    <tbody>
        <tr>
            <td>
            <p align=center><span>Unix</span><span>命令。</span></p>
            </td>
        </tr>
        <tr>
            <td>
            <p align=left><span>以下只说明各指令的基本用法</span><span>, </span><span>若需详细说明</span><span>, </span><span>请用</span><span> man </span><span>去读详细的</span><span> manual.</span><span><br><br></span><span>a. </span><span>关於档案</span><span>/</span><span>目录处理的指令</span><span>:</span><span><br><br></span><span>1. ls</span><span><br></span><span>这是最基本的档案指令。</span><span> ls </span><span>的意义为</span><span> "list"</span><span>，也就是将某一个目录或是</span><span><br></span><span>某一个档案的内容显示出来。</span><span><br><br></span><span>如果你在下</span><span> ls </span><span>指令後头没有跟著任何的档名，它将会显示出目前目录中所</span><span><br></span><span>有档案。</span><span><br><br></span><span>也可以在</span><span> ls </span><span>後面加上所要察看的目录名称或档案的名称，如</span><span><br><br></span><span>% ls /home2/X11R5</span><span><br><br></span><span>% ls first</span><span><br><br></span><span>ls </span><span>有一些特别的参数，可以给予使用者更多有关的资讯，如下</span><span>:</span><span><br><br></span><span>-a : </span><span>在</span><span> UNIX </span><span>中若一个目录或档案名字的第一个字元为</span><span> "." , </span><span>则使用</span><span> ls</span><span><br></span><span>将不会显示出这个档案的名字，我们称此类档案为隐藏档。如</span><span> tcsh</span><span><br></span><span>的初设档</span><span> .tcshrc</span><span>；如果我们要察看这类档案，则必须加上参数</span><span> -a </span><span>。</span><span><br><br></span><span>-l : </span><span>这个参数代表使用</span><span> ls </span><span>的长</span><span>( long )</span><span>格式，可以显示更多的资讯，</span><span><br></span><span>如档案存取权，档案拥有者</span><span>( owner )</span><span>，档案大小，档案最後更新</span><span><br></span><span>日期，甚而</span><span> symbolic link </span><span>的档案是</span><span> link </span><span>那一个档等等。如下</span><span><br><br></span><span>% ls -l</span><span><br><br></span><span>drwx--x--x 2 jjtseng 512 Aug 8 058 18</span><span><br></span><span>drwx--x--x 2 jjtseng 512 Aug 8 220 19</span><span><br></span><span>-rw------- 1 jjtseng 566 Aug 8 05:28 makefile</span><span><br><br></span><span>2. cp</span><span><br></span><span>cp </span><span>这个指令的意义是复制</span><span>("COPY") , </span><span>也就是将一个或多个档案复制成另</span><span><br></span><span>一个档案或者是将其复制到另一个目录去。</span><span><br><br></span><span>cp </span><span>的用法如下</span><span>:</span><span><br><br></span><span>cp f<st1:chmetcnv w:st="on" TCSC="0" NumberType="1" Negative="False" HasSpace="True" SourceValue="1" UnitName="F">1 f</st1:chmetcnv>2 : </span><span>将档名为</span><span> f1 </span><span>的档案复制一份为档名为</span><span> f2 </span><span>的档案。</span><span><br></span><span>cp f<st1:chmetcnv w:st="on" TCSC="0" NumberType="1" Negative="False" HasSpace="True" SourceValue="1" UnitName="F">1 f</st1:chmetcnv><st1:chmetcnv w:st="on" TCSC="0" NumberType="1" Negative="False" HasSpace="True" SourceValue="2" UnitName="F">2 f</st1:chmetcnv>3 ... dir : </span><span>将档案</span><span> f<st1:chmetcnv w:st="on" TCSC="0" NumberType="1" Negative="False" HasSpace="True" SourceValue="1" UnitName="F">1 f</st1:chmetcnv><st1:chmetcnv w:st="on" TCSC="0" NumberType="1" Negative="False" HasSpace="True" SourceValue="2" UnitName="F">2 f</st1:chmetcnv>3 ... </span><span>都以相同的档名复制一</span><span><br></span><span>份放到目录</span><span> dir </span><span>里面。</span><span><br></span><span>cp -r dir1 dir2 : </span><span>将</span><span> dir1 </span><span>的全部内容全部复制到</span><span> dir2 </span><span>里面。</span><span><br><br></span><span>cp </span><span>也有一些参数，如下</span><span>:</span><span><br><br></span><span>-i : </span><span>此参数是当已有档名为</span><span> f2 </span><span>的档案时，若迳自使用</span><span> cp </span><span>将会将原来</span><span> f2</span><span><br></span><span>的内容掩盖过去，因此在要盖过之前必须先询问使用者一下。如使用者</span><span><br></span><span>的回答是</span><span>y(yes)</span><span>才执行复制的动作。</span><span><br><br></span><span>-r : </span><span>此参数是用来做递回复制用，可将一整颗子树都复制到另一个</span><span><br></span><span>目录中。</span><span><br><br></span><span>3. mv</span><span><br></span><span>mv </span><span>的意义为</span><span> move , </span><span>主要是将一档案改名或换至另一个目录。如同</span><span> cp </span><span>，它也有</span><span><br></span><span>三种格式</span><span>:</span><span><br><br></span><span>mv f<st1:chmetcnv w:st="on" TCSC="0" NumberType="1" Negative="False" HasSpace="True" SourceValue="1" UnitName="F">1 f</st1:chmetcnv>2 : </span><span>将档名为</span><span> f1 </span><span>的档案变更成档名为</span><span> f2 </span><span>的档案。</span><span><br></span><span>mv dir1 dir2 : </span><span>将档名为</span><span> dir1 </span><span>的目录变更成档名为</span><span> dir2 </span><span>的目录。</span><span><br></span><span>mv f<st1:chmetcnv w:st="on" TCSC="0" NumberType="1" Negative="False" HasSpace="True" SourceValue="1" UnitName="F">1 f</st1:chmetcnv><st1:chmetcnv w:st="on" TCSC="0" NumberType="1" Negative="False" HasSpace="True" SourceValue="2" UnitName="F">2 f</st1:chmetcnv>3 ... dir : </span><span>将档案</span><span> f<st1:chmetcnv w:st="on" TCSC="0" NumberType="1" Negative="False" HasSpace="True" SourceValue="1" UnitName="F">1 f</st1:chmetcnv><st1:chmetcnv w:st="on" TCSC="0" NumberType="1" Negative="False" HasSpace="True" SourceValue="2" UnitName="F">2 f</st1:chmetcnv>3 ... </span><span>都移至目录</span><span> dir </span><span>里面。</span><span><br><br></span><span>mv </span><span>的参数有两个，</span><span>-f </span><span>和</span><span> -i , </span><span>其中</span><span> -i </span><span>的意义与</span><span> cp </span><span>中的相同，均是</span><span> interactive</span><span><br></span><span>询问之意。而</span><span> -f </span><span>为强迫</span><span>( force ) , </span><span>就是不管有没有同名的档案，反正我就是要</span><span><br></span><span>搬过去，所有其他的参数遇到</span><span> -f </span><span>均会失效。</span><span><br><br></span><span>4. rm</span><span><br></span><span>rm </span><span>的意义是</span><span> remove </span><span>，也就是用来杀掉一个档案的指令。在</span><span> UNIX </span><span>中一</span><span><br></span><span>个被杀掉的档案除非是系统恰好有做备份，否则是无法像</span><span> DOS </span><span>里面一样还能够救回</span><span><br></span><span>来的。所以在做</span><span> rm </span><span>动作的时候使用者应该要特别小心。</span><span><br><br></span><span>rm </span><span>的格式如下</span><span>:</span><span><br><br></span><span>rm f<st1:chmetcnv w:st="on" TCSC="0" NumberType="1" Negative="False" HasSpace="True" SourceValue="1" UnitName="F">1 f</st1:chmetcnv><st1:chmetcnv w:st="on" TCSC="0" NumberType="1" Negative="False" HasSpace="True" SourceValue="2" UnitName="F">2 f</st1:chmetcnv>3 .....</span><span><br><br></span><span>而</span><span> rm </span><span>的参数比较常用的有几个</span><span>: -f , -i , </span><span>与</span><span> -r</span><span><br><br></span><span>-f : </span><span>将会使得系统在删除时，不提出任何警告讯息。</span><span><br></span><span>-i : </span><span>在除去档案之前均会询问是否真要除去。</span><span><br></span><span>-r : </span><span>递回式的删除。</span><span><br><br></span><span>小心不要随便使用</span><span> rm -rf , </span><span>否则有一天你会</span><span>"</span><span>欲哭无泪</span><span>"......</span><span><br><br></span><span>5. mkdir</span><span><br></span><span>mkdir </span><span>是一个让使用者建立一个目录的指令。你可以在一个目录底下使用</span><span><br></span><span>midir </span><span>建立一个子目录，使用的方法如下</span><span>:</span><span><br><br></span><span>mkdir dirname1 [ dirname2 ... ]</span><span><br><br></span><span>如此你就可以建立一个或多个目录。</span><span><br><br></span><span>6. chdir ( cd )</span><span><br></span><span>这是让使用者用来转移工作目录用的。</span><span><br></span><span>chdir </span><span>的用法如下</span><span>:</span><span><br><br></span><span>chdir dirname</span><span><br><br></span><span>如此你就可以将目前的目录转移到</span><span> dirname </span><span>这一个目录去。</span><span><br></span><span>或使用</span><span> "chdir .." </span><span>来转移到上一层目录。</span><span><br><br></span><span>7. rmdir</span><span><br></span><span>相对於</span><span> mkdir </span><span>，</span><span>rmdir </span><span>是用来将一个</span><span>"</span><span>空的</span><span>"</span><span>目录杀掉的。如果一个目录下面</span><span><br></span><span>没有任何档案，你就可以用</span><span> rmdir </span><span>指令将其除去。</span><span>rmdir </span><span>的使用法如下</span><span>:</span><span><br><br></span><span>rmdir dirname1 [ dirname2 .... ]</span><span><br><br></span><span>如果一个目录底下有其他的档案，</span><span> rmdir </span><span>将无法将这个目录杀掉，除非使用</span><span><br></span><span>rm </span><span>指令的</span><span> -r </span><span>选项。</span><span><br><br></span><span>8. pwd</span><span><br></span><span>pwd </span><span>会将目前目录的路径</span><span>( path )</span><span>显示出来，例如</span><span>:</span><span><br><br></span><span>9. cat/more/less</span><span><br></span><span>以上三个指令均为察看档案内容的指令。</span><span>cat </span><span>的意义是猫</span><span>....</span><span>不不不，是</span><span><br></span><span>concatenate </span><span>，在字典上的意思是</span><span>"</span><span>连结</span><span>,</span><span>将</span><span>&#8230;</span><span>串成锁状</span><span>"( </span><span>语出资工电子</span><span><br></span><span>词典</span><span> cdict )</span><span>，其实就是把档案的内容显示出来的意思。</span><span> cat </span><span>有许多奇怪</span><span><br></span><span>的参数，较常为人所使用的是</span><span> -n </span><span>参数，也就是把显示出来的内容加上行</span><span><br></span><span>号。</span><span> cat </span><span>的用法如下</span><span>:</span><span><br><br></span><span>cat [-n] :</span><span>自标准输入读进内容，你可以用</span><span> pipe </span><span>将别的程式的输出转向</span><span><br></span><span>给</span><span> <span>cat .</span></span><span><br></span><span>cat [-n] filename : </span><span>将</span><span> filename </span><span>的内容读进来，显示在标准输出上。</span><span><br><br></span><span>问题在於</span><span> cat </span><span>它是不会停下来的，因此并不好用</span><span>( </span><span>试想如果一个萤幕二十</span><span><br></span><span>四行，而一个档案四百行，</span><span>cat </span><span>一出来将会劈哩啪啦不断的卷上去，使用者</span><span><br></span><span>很难据此得到他们所需的资讯。</span><span>) </span><span>所以才有人又写了</span><span> more </span><span>出来。</span><span><br><br></span><span>more , </span><span>跟据<st1:personname w:st="on" ProductID="蔡文能">蔡文能</st1:personname>老师的说法是</span><span>"</span><span>再多一点就好</span><span>"</span><span>，</span><span>more </span><span>可以将所观察的档案</span><span><br></span><span>跟据终端机的形态一页页的显示出来，再根据使用者的要求换页或卷行。如果</span><span><br></span><span>使用者要在某一个档案中搜寻一个特定的字串，则按</span><span> / </span><span>然後跟著打所要搜寻</span><span><br></span><span>的单字即可进行搜寻。</span><span>more </span><span>也可以找得到。</span><span>more </span><span>的使用法如下</span><span>:</span><span><br><br></span><span>more filename</span><span><br><br></span><span>如果你在使用中觉得已经看到了所要看的部份，可以按</span><span>'q'</span><span>离开</span><span> more </span><span>的使用。</span><span><br></span><span>在使用中按</span><span>'v' </span><span>亦可以使用编辑器来编辑所观看的档案。</span><span><br><br></span><span>less </span><span>的用法与</span><span> more </span><span>极类似，原先它就是为了弥补</span><span> more </span><span>只能往前方卷页的缺</span><span><br></span><span>点而设计。</span><span> less </span><span>的用法如下</span><span>:</span><span><br><br></span><span>less filename</span><span><br><br></span><span>其与</span><span> more </span><span>不同的是它可以按</span><span> y </span><span>来往上卷一行，并且可以用</span><span>"?"</span><span>来往回搜寻你所</span><span><br></span><span>要找的单字。</span><span><br><br></span><span>10. chmod</span><span><br></span><span>chmod </span><span>为变更档案模式用</span><span>( change mode ) . </span><span>这个指令是用来更改档案的存取模</span><span><br></span><span>式</span><span>( access mode )</span><span>。在</span><span> UNIX </span><span>一个档案上有可读</span><span>(r)</span><span>可写</span><span>(w)</span><span>可执行</span><span>(x)</span><span>三种模式</span><span>,</span><span><br></span><span>分别针对该档案的拥有者</span><span>( onwer )</span><span>、同群者</span><span>( group member )( </span><span>你可以</span><span> ls -lg</span><span><br></span><span>来观看某一档案的所属的</span><span> group )</span><span>，以及其他人</span><span>( other )</span><span>。一个档案如果改成可</span><span><br></span><span>执行模式则系统就将其视为一个可执行档，而一个目录的可执行模式代表使用者</span><span><br></span><span>有进入该目录之权利。</span><span>chmod </span><span>就是用来变更一些档案的模式，其使用方式如下</span><span>:</span><span><br><br></span><span>chmod [ -fR ] mode filename ...</span><span><br><br></span><span>其参数的意义如下</span><span>:</span><span><br><br></span><span>-f Force. chmod </span><span>不会理会失败的动作。</span><span><br></span><span>-R Recurive. </span><span>会将所有子树下的所有子目录及档案改为你所要改成的模式。</span><span><br><br></span><span>mode </span><span>可以为一个三位或四位的八进位数字，来表示对某些对象的存取权。详情</span><span><br></span><span>可参阅</span><span> chmod(1) </span><span>的</span><span> manual page </span><span>中有关</span><span> Absolute Modes </span><span>的说明。</span><span><br><br></span><span>或是用一个字串来表示，请参考</span><span> chmod(1) </span><span>的说明。</span><span><br></span><span>b. </span><span>关於</span><span> Process </span><span>处理的指令</span><span>:</span><span><br><br></span><span>1. ps</span><span><br></span><span>ps </span><span>是用来显示目前你的</span><span> process </span><span>或系统</span><span> processes </span><span>的状况。</span><span><br></span><span>以下列出比较常用的参数</span><span>:</span><span><br><br></span><span>其选项说明如下</span><span>:</span><span><br></span><span>-a </span><span>列出包括其他</span><span> users </span><span>的</span><span> process </span><span>状况。</span><span><br></span><span>-u </span><span>显示</span><span> user - oriented </span><span>的</span><span> process </span><span>状况</span><span> </span><span>。</span><span><br></span><span>-x </span><span>显示包括没有</span><span> terminal </span><span>控制的</span><span> process </span><span>状况</span><span> </span><span>。</span><span><br></span><span>-w </span><span>使用较宽的显示模式来显示</span><span> process </span><span>状况</span><span> </span><span>。</span><span><br><br></span><span>我们可以经由</span><span> ps </span><span>取得目前</span><span> processes </span><span>的状况，如</span><span> pid , running state </span><span>等。</span><span><br><br></span><span>2. kill</span><span><br></span><span>kill </span><span>指令的用途是送一个</span><span> signal </span><span>给某一个</span><span> process </span><span>。因为大部份送的都是</span><span><br></span><span>用来杀掉</span><span> process </span><span>的</span><span> SIGKILL </span><span>或</span><span> SIGHUP </span><span>，因此称为</span><span> kill </span><span>。</span><span>kill </span><span>的用法</span><span><br></span><span>为</span><span>:</span><span><br><br></span><span>kill [ -SIGNAL ] pid ...</span><span><br></span><span>kill -l</span><span><br><br></span><span>SIGNAL </span><span>为一个</span><span> singal </span><span>的数字，从</span><span> 0 </span><span>到</span><span> 31 </span><span>，其中</span><span> 9 </span><span>是</span><span> SIGKILL </span><span>，也就是一</span><span><br></span><span>般用来杀掉一些无法正常</span><span> terminate </span><span>的讯号。其馀讯号的用途可参考</span><span> sigvec(2)</span><span><br></span><span>中对</span><span> signal </span><span>的说明。</span><span><br><br></span><span>你也可以用</span><span> kill -l </span><span>来察看可代替</span><span> signal </span><span>号码的数目字。</span><span>kill </span><span>的详细情形</span><span><br></span><span>请参阅</span><span> man kill</span><span>。</span><span><br><br></span><span>c. </span><span>关於字串处理的指令</span><span>:</span><span><br><br></span><span>1. echo</span><span><br></span><span>echo </span><span>是用来显示一字串在终端机上。</span><span>□ echo -n </span><span>则是当显示完之後不会有跳行的动作。</span><span><br><br><br></span><span>2. grep/fgrep</span><span><br></span><span>grep </span><span>为一过滤器，它可自一个或多个档案中过滤出具有某个字串的行，或是</span><span><br></span><span>自标准输入过滤出具有某个字串的行。</span><span><br><br></span><span>fgrep </span><span>可将欲过滤的一群字串放在某一个档案中，然後使用</span><span> fgrep </span><span>将包含有</span><span><br></span><span>属於这一群字串的行过滤出来。</span><span><br><br></span><span>grep </span><span>与</span><span> fgrep </span><span>的用法如下</span><span>:</span><span><br><br></span><span>grep [-nv] match_pattern file1 file2 ....</span><span><br></span><span>fgrep [-nv] -f pattern_file file1 file2 ....</span><span><br><br></span><span>-n </span><span>把所找到的行在行前加上行号列出</span><span><br></span><span>-v </span><span>把不包含</span><span> match_pattern </span><span>的行列出</span><span><br></span><span>match_pattern </span><span>所要搜寻的字串</span><span><br></span><span>-f </span><span>以</span><span> pattern_file </span><span>存放所要搜寻的字串</span><span><br><br></span><span>d. </span><span>网路上查询状况的指令</span><span>:</span><span><br><br></span><span>1. man</span><span><br></span><span>man </span><span>是手册</span><span> ( manual ) </span><span>的意思。</span><span> UNIX </span><span>提供线上辅助</span><span>( on-line help )</span><span>的功能，</span><span><br></span><span>man </span><span>就是用来让使用者在使用时查询指令、系统呼叫、标准程式库函式、各种表</span><span><br></span><span>格等的使用所用的。</span><span>man </span><span>的用法如下</span><span>:</span><span><br><br></span><span>man [-M path] [[section] title ] .....</span><span><br></span><span>man [-M path] -k keyword ...</span><span><br><br></span><span>-M path man </span><span>所需要的</span><span> manual database </span><span>的路径。</span><span><br></span><span>我们也可以用设定环境变数</span><span> <span>MANPATH </span></span><span>的方式来取代</span><span> -M </span><span>选项。</span><span><br></span><span>title </span><span>这是所要查询的目的物。</span><span><br></span><span>section </span><span>为一个数字表示</span><span> manual </span><span>的分类，通常</span><span> 1 </span><span>代表可执行指令，</span><span><br></span><span>2 </span><span>代表系统呼叫</span><span>( system call ) </span><span>，</span><span>3 </span><span>代表标准函数，等等。</span><span><br><br></span><span>像下面</span><span> man </span><span>查询的片段</span><span>:</span><span><br><br></span><span>SEE ALSO</span><span><br></span><span>apropos(1), cat(1V), col(1V), eqn(1), lpr(1), more(1),</span><span><br></span><span>nroff(1), refer(1), tbl(1), troff(1), vgrind(1), vtroff(1),</span><span><br></span><span>whatis(1), eqnchar(7), man(7), catman(8)</span><span><br><br></span><span>我们如要参考</span><span> eqnchar(7) </span><span>的资料，则我们就输入</span><span> man 7 eqnchar </span><span>，</span><span><br></span><span>便能取得我们所要的辅助讯息。</span><span><br></span><span>-k keyword</span><span><br></span><span>用来将含有这项</span><span> keyword </span><span>的</span><span> title </span><span>列出来。</span><span><br><br></span><span>man </span><span>在</span><span> UNIX </span><span>上是一项非常重要的指令，我们在本讲义中所述之用法均仅只是一</span><span><br></span><span>个大家比较常用的用法以及简单的说明，真正详细的用法与说明还是要请你使用</span><span><br></span><span>man </span><span>来得到。</span><span><br><br></span><span>2. who</span><span><br></span><span>who </span><span>指令是用来查询目前有那些人在线上。</span><span><br><br></span><span>3. w</span><span><br><br></span><span>w </span><span>指令是用来查询目前有那些人在线上，同时显示出那些人目前的工作。</span><span><br><br></span><span>4. ku</span><span><br></span><span>ku </span><span>可以用来搜寻整个网路上的</span><span> user </span><span>，不像</span><span> w </span><span>跟</span><span> who </span><span>只是针对</span><span> local host </span><span>的</span><span><br></span><span>查询</span><span>. </span><span>而且</span><span> ku </span><span>提供让使用者建立搜寻特定使用者名单的功能。你可以建立一个档</span><span><br></span><span>案</span><span> information-file </span><span>以条列的方式存放你的朋友的资料，再建立一个档案</span><span><br></span><span>hosts-file </span><span>来指定搜寻的机器名称。</span><span> ku </span><span>的指令格式可由</span><span> ku -h </span><span>得到。</span><span><br><br></span><span>E. </span><span>网路指令</span><span>:</span><span><br><br></span><span>UNIX </span><span>提供网路的连接，使得你可以在各个不同的机器上做一些特殊的事情，如</span><span><br></span><span>你可以在系上的</span><span> iris </span><span>图形工作站上做图形的处理，在系上的</span><span> Sun </span><span>上读</span><span> News </span><span>，</span><span><br></span><span>甚至到学校的计中去找别系的同学</span><span> talk </span><span>。这些工作可以利用</span><span> UNIX </span><span>的网路指</span><span><br></span><span>令，在你的位子上连到各个不同的机器上工作。如此一来，即使你在寝室，也能</span><span><br></span><span>轻易的连至系上或计中来工作，不用像以前的人必须泡在冷冰冰的机房面。</span><span><br><br></span><span>这些网路的指令如下所述</span><span>:</span><span><br><br></span><span>1. rlogin </span><span>与</span><span> rsh</span><span><br></span><span>rlogin </span><span>的意义是</span><span> remote login , </span><span>也就是经由网路到另外一部机器</span><span> login </span><span>。</span><span><br></span><span>rlogin </span><span>的格式是</span><span>:</span><span><br><br></span><span>rlogin host [ -l username ]</span><span><br><br></span><span>选项</span><span> -l username </span><span>是当你在远方的机器上的</span><span> username </span><span>和</span><span> local host </span><span>不同的</span><span><br></span><span>时後，必须输入的选项，否则</span><span> rlogin </span><span>将会假设你在那边的</span><span> username </span><span>与</span><span> local</span><span><br></span><span>host </span><span>相同，然後在第一次</span><span> login </span><span>时必然会发生错误。</span><span><br><br></span><span>rsh </span><span>是在远方的机器上执行某些指令，而把结果传回</span><span> local host </span><span>。</span><span>rsh </span><span>的格式</span><span><br></span><span>如下</span><span>:</span><span><br><br></span><span>rsh host [ -l username ] [ command ]</span><span><br><br></span><span>如同</span><span> rlogin </span><span>的参数</span><span> -l username , rsh </span><span>的</span><span> -l username </span><span>也是指定</span><span> remote host</span><span><br></span><span>的</span><span> username </span><span>。而</span><span> command </span><span>则是要在</span><span> remote host </span><span>上执行的指令。如果没有</span><span><br></span><span>指定</span><span> command </span><span>，则</span><span> rsh </span><span>会去执行</span><span> rlogin </span><span>，如同直接执行</span><span> rlogin </span><span>。</span><span><br><br></span><span>不过</span><span> rsh </span><span>在执行的时候并不会像一般的</span><span> login </span><span>程序一样还会问你</span><span> password , </span><span>而</span><span><br></span><span>是如果你没有设定</span><span> trust table , </span><span>则</span><span> remote host </span><span>将不会接受你的</span><span> request </span><span>。</span><span><br><br></span><span>rsh </span><span>须要在每个可能会做为</span><span> remote host </span><span>的机器上设定一个档案，称为</span><span> .rhosts</span><span>。</span><span><br></span><span>这个档案每一行分为两个部份，第一个是允许</span><span> login </span><span>的</span><span> hostname , </span><span>第二个部份</span><span><br></span><span>则是允许</span><span> login </span><span>的</span><span> username </span><span>。例如，在</span><span> ccsun7.csie.nctu.edu.tw </span><span>上头你的</span><span><br></span><span>username </span><span>为</span><span> ysjuang , </span><span>而你的</span><span> home </span><span>下面的</span><span> .rhost </span><span>有以下的一行</span><span>:</span><span><br><br></span><span>ccsun6.cc.nctu.edu.tw u8217529</span><span><br><br></span><span>则在</span><span> ccsun6.cc.nctu.edu.tw </span><span>机器上的</span><span> user u8217529 </span><span>就可以用以下的方法来</span><span><br></span><span>执行</span><span> rsh </span><span>程式</span><span>:</span><span><br><br></span><span>% rsh ccsun7.csie.nctu.edu.tw -l ysjuang cat mbox</span><span><br><br></span><span>将</span><span> ysjuang </span><span>在</span><span> ccsun7.csie.nctu.edu.tw </span><span>上的</span><span> mbox </span><span>档案内容显示在</span><span> local host</span><span><br></span><span>ccsun6.cc.nctu.edu.tw </span><span>上。</span><span><br><br></span><span>而如果</span><span> .rhost </span><span>有这样的一行，则</span><span> ccsun6.cc.nctu.edu.tw </span><span>上的</span><span> user u8217529</span><span><br></span><span>将可以不用输入</span><span> password </span><span>而直接经由</span><span> rsh </span><span>或</span><span> rlogin login </span><span>到</span><span><br></span><span>ccsun7.csie.nctu.edu.tw </span><span>来。</span><span><br><br></span><span>注意</span><span>:</span><span><br><br></span><span>.rhost </span><span>是一个设定可以信任的人</span><span> login </span><span>的表格，因此如果设定不当将会让</span><span><br></span><span>不法之徒有可以乘机侵入系统的机会。</span><span> </span><span>如果你阅读</span><span> man 5 rhosts </span><span>，将会</span><span><br></span><span>发现你可以在第一栏用</span><span> + </span><span>来取代任何</span><span> hostname </span><span>，第二栏用</span><span> + </span><span>来取代任何</span><span><br></span><span>username </span><span>。</span><span><br><br></span><span>如一般</span><span> user </span><span>喜欢偷懒利用</span><span> " + username " </span><span>来代替列一长串</span><span> hostname </span><span>，</span><span><br></span><span>但是这样将会使得即使有一台</span><span> PC </span><span>上跑</span><span> UNIX </span><span>的</span><span> user </span><span>有与你相同的</span><span><br></span><span>username , </span><span>也可以得到你的</span><span> trust </span><span>而侵入你的系统。这样容易造成系统</span><span><br></span><span>安全上的危险。因此本系禁止使用这样子的方式写你的</span><span> .rhost </span><span>档，如果</span><span><br></span><span>发现将予以停机直到你找中心的工作人员将其改正为止。</span><span> </span><span>同理，如果你的</span><span><br></span><span>第二个栏位为</span><span> + </span><span>，如</span><span>" hostname + " ,</span><span>则你是允许在某一部机器上的</span><span>"</span><span>所有</span><span>"</span><span><br></span><span>user </span><span>可以不用经由输入</span><span> password </span><span>来进入你的帐号，是壹种更危险的行为。</span><span><br></span><span>所以请自行小心。</span><span><br><br></span><span>2. telnet</span><span><br></span><span>telnet </span><span>是一个提供</span><span> user </span><span>经由网路连到</span><span> remote host</span><span>。</span><span><br></span><span>telnet </span><span>的</span><span> </span><span>格式如下</span><span>:</span><span><br><br></span><span>telnet [ hostname | ip-address ] [ port ]</span><span><br><br></span><span>hostname </span><span>为一个像</span><span> ccsun1 </span><span>或是</span><span> ccsun1.cc.nctu.edu.tw </span><span>的</span><span> name address</span><span>，</span><span><br></span><span>ip-address </span><span>则为一个由四个小於</span><span> 255 </span><span>的数字组成的</span><span> ip address </span><span>，如</span><span> ccsun1</span><span><br></span><span>的</span><span> ip-address </span><span>为</span><span> 140.113.17.173 </span><span>，</span><span>ccsun1.cc.nctu.edu.tw </span><span>的</span><span> ip-address</span><span><br></span><span>为</span><span> 140.113.4.11 </span><span>。你可以利用</span><span> telnet ccsun1 </span><span>或</span><span> telnet 140.113.17.173 </span><span>来</span><span><br></span><span>连到</span><span> ccsun1</span><span>。</span><span><br><br></span><span>port </span><span>为一些特殊的程式所提供给外界的沟通点，如资工系的</span><span> MUD </span><span>其</span><span> server </span><span>便</span><span><br></span><span>提供一些</span><span> port </span><span>让</span><span> user </span><span>由这些</span><span> port </span><span>进入</span><span> MUD </span><span>程式。详情请参阅</span><span> telnet(1)</span><span><br></span><span>的说明。</span><span><br><br><br></span><span>3. ftp</span><span><br></span><span>ftp </span><span>的意义是</span><span> File Transfer Program </span><span>，是一个很常应用在网路档案传输的</span><span><br></span><span>程式。</span><span>ftp </span><span>的格式如下</span><span>:</span><span><br><br></span><span>ftp [ hostname | ip-address ]</span><span><br><br></span><span>其中</span><span> hostname | ip-address </span><span>的意义跟</span><span> telnet </span><span>中的相同。</span><span><br><br></span><span>在进入</span><span> ftp </span><span>之後，如果与</span><span> remote host </span><span>连接上了，它将会询问你</span><span> username</span><span><br></span><span>与密码，如果输入对了就可以开始进行档案传输。</span><span><br><br></span><span>在</span><span> ftp </span><span>中有许多的命令，详细的使用方式请参考</span><span> ftp(1) </span><span>，这里仅列出较常</span><span><br></span><span>用的</span><span> cd , lcd , mkdir , put , mput , get , mget , binary , ascii ,</span><span><br></span><span>prompt , help </span><span>与</span><span> quit </span><span>的使用方式。</span><span><br><br></span><span>ascii </span><span>将传输模式设为</span><span> ascii </span><span>模式。通常用於传送文字档。</span><span><br><br></span><span>binary </span><span>将传输模式设为</span><span> binary </span><span>模式，通常用於传送执行档，压缩档与影像</span><span><br></span><span>档等。</span><span><br></span><span>cd remote-directory </span><span>将</span><span> remote host </span><span>上的工作目录改变。</span><span><br><br></span><span>lcd [ directory ] </span><span>更改</span><span> local host </span><span>的工作目录。</span><span><br><br></span><span>ls [ remote-directory ] [ local-file ] </span><span>列出</span><span> remote host </span><span>上的档案。</span><span><br><br></span><span>get remote-file [ local-file ] </span><span>取得远方的档案。</span><span><br><br></span><span>mget remote-files </span><span>可使用通用字元一次取得多个档案。</span><span><br><br></span><span>put local-file [ remote-file] </span><span>将</span><span> local host </span><span>的档案送到</span><span> remote host</span><span>。</span><span><br><br></span><span>mput local-files </span><span>可使用通用字元一次将多个档案放到</span><span> remote host </span><span>上。</span><span><br><br></span><span>help [ command ] </span><span>线上辅助指令。</span><span><br><br></span><span>mkdir directory-name </span><span>在</span><span> remote host </span><span>造一个目录。</span><span><br><br></span><span>prompt </span><span>更改交谈模式，若为</span><span> on </span><span>则在</span><span> mput </span><span>与</span><span> mget </span><span>时每作一个档案之传</span><span><br></span><span>输时均会询问。</span><span><br><br></span><span>quit/bye </span><span>离开</span><span>ftp .</span><span><br><br></span><span>利用</span><span> ftp </span><span>，我们便可以在不同的机器上将所需要的资料做转移，某些特别的</span><span><br></span><span>机器更存放大量的资料以供各地的使用者抓取，本校较著名的</span><span> ftp server</span><span><br></span><span>有</span><span> NCTUCCCA </span><span>与系上的</span><span> ftp.csie.nctu.edu.tw </span><span>。这些</span><span> ftp server </span><span>均有提</span><span><br></span><span>供一个</span><span> user </span><span>称为</span><span> <span>anonymous </span></span><span>，一般的</span><span>"</span><span>外来客</span><span>"</span><span>可以利用这个</span><span> username </span><span>取</span><span><br></span><span>得该</span><span> server </span><span>的公共资料。不过</span><span> anonymous </span><span>在询问</span><span> password </span><span>时是要求使用</span><span><br></span><span>anonymous </span><span>的使用者输入其</span><span> email address</span><span>，以往有许多台湾的使用者在使用</span><span><br></span><span>国外的</span><span> ftp server </span><span>时并没有按照人家的要求输入其</span><span> email address</span><span>，而仅是</span><span><br></span><span>随便打一些字串，引起许多</span><span> internet user </span><span>和管理者的不满，对台湾的使用</span><span><br></span><span>者的风评变得很差，因此遵循各</span><span> ftp server </span><span>的使用规则也是一件相当重要的事。</span><span><br><br></span><span>f. </span><span>关於通讯用的指令</span><span>:</span><span><br><br></span><span>1. write</span><span><br></span><span>这个指令是提供使用者传送讯息给另一个使用者，使用方式</span><span>:</span><span><br></span><span>write username [tty]</span><span><br><br></span><span>2. talk/ytalk/cytalk/ctalk</span><span><br></span><span>UNIX </span><span>专用的交谈程式。会将萤幕分隔开为你的区域和交谈对象的区域，</span><span><br></span><span>同时也可和不同机器的使用者交谈。使用方式</span><span>:</span><span><br><br></span><span>talk username[@host] [tty]</span><span><br><br></span><span>3. mesg</span><span><br></span><span>选择是否接受他人的</span><span> messege , </span><span>若为</span><span> messege no </span><span>则他人的</span><span> messege </span><span>将无法</span><span><br></span><span>传送给你，同时他也无法干扰你的工作。使用方法</span><span>:</span><span><br><br></span><span>mesg [-n|-y]</span><span><br><br></span><span>4. mail/elm</span><span><br></span><span>在网路上的</span><span> email </span><span>程式，可经由此程式将信件</span><span> mail </span><span>给他人。</span><span> </span><span>使用方式</span><span>:</span><span><br><br></span><span>mail [username]</span><span><br></span><span>mail -f mailboxfile</span><span><br><br></span><span>如有信件，则直接键入</span><span> mail </span><span>可以读取你的</span><span> mail .</span><span><br><br></span><span>elm </span><span>提供较</span><span> mail </span><span>更为方便的介面，而且可做线上的</span><span> alias . </span><span>你可以进入</span><span> elm</span><span><br></span><span>使用上下左右键来选读取的信件，并可按</span><span> h </span><span>取得线上的</span><span> help </span><span>文件。</span><span><br><br></span><span>使用方式</span><span>:</span><span><br><br></span><span>elm [usernmae]</span><span><br></span><span>elm -f mailboxfile</span><span><br><br></span><span>g. </span><span>编译器</span><span>( Compiler ):</span><span><br></span><span>Compiler </span><span>的用处在於将你所撰写的程式翻译成一个可执行档案。在资工系常</span><span><br></span><span>用的程式语言是</span><span> C , pascal , FORTRAN </span><span>等。你可以先写好一个</span><span> C </span><span>或</span><span> Pascal</span><span><br></span><span>或</span><span> FORTRAN </span><span>的原始程式档，再用这些</span><span> compiler </span><span>将其翻成可执行档。你可以</span><span><br></span><span>用这个方法来制造你自己的特殊指令。</span><span><br><br></span><span>1. cc/gcc (C Compiler)</span><span><br></span><span>/usr/bin/cc</span><span><br></span><span>/usr/local/bin/gcc</span><span><br><br></span><span>语法</span><span>: cc [ -o execfile ] source</span><span><br></span><span>gcc [ -o execfile ] source</span><span><br><br></span><span>execfile </span><span>是你所希望的执行档的名称，如果没有加上</span><span> -o </span><span>选项编译出来的可</span><span><br></span><span>执行档会以</span><span> a.out </span><span>做为档名。</span><span> source </span><span>为一个以</span><span> .c </span><span>做为结尾的</span><span> C </span><span>程式档。</span><span><br></span><span>请参阅</span><span> cc(1) </span><span>的说明。</span><span><br><br></span><span>2. pc (Pascal Compiler)</span><span><br></span><span>/usr/local/bin/pc</span><span><br><br></span><span>语法</span><span>: pc [ -o execfile ] source</span><span><br><br></span><span>execfile </span><span>是你所希望的执行档的名称，如果没有加上</span><span> -o </span><span>选项编译出来的可</span><span><br></span><span>执行档会以</span><span> a.out </span><span>做为档名。</span><span> source </span><span>为一个以</span><span> .p </span><span>做为结尾的</span><span> Pascal </span><span>程</span><span><br></span><span>式档。</span><span> </span><span>请参阅</span><span> /net/home5/lang/man </span><span>中</span><span> pc(1) </span><span>的说明。</span><span><br><br></span><span>3. f77 (Fortran Compiler)</span><span><br></span><span>/net/home5/lang/f77</span><span><br><br></span><span>语法</span><span>: f77 [ -o execfile ] source</span><span><br><br></span><span>execfile </span><span>是你所希望的执行档的名称，如果没有加上</span><span> -o </span><span>选项编译出来的可</span><span><br></span><span>执行档会以</span><span> a.out </span><span>做为档名。</span><span> source </span><span>为一个以</span><span> .p </span><span>做为结尾的</span><span> FORTRAN </span><span>程</span><span><br></span><span>式档。</span><span><br><br></span><span>h. </span><span>有关列印的指令</span><span>:</span><span><br></span><span>以下为印表所会用到的指令，在本系的印表机有</span><span> lp1 , lp2 ( </span><span>点矩阵印表机</span><span> )</span><span>，</span><span><br></span><span>lw , sp , ps , compaq ( </span><span>雷射印表机</span><span> )</span><span>，供使用者使用。</span><span><br><br></span><span>1. lpr</span><span><br></span><span>lpr </span><span>为用来将一个档案印至列表机的指令。</span><span><br><br></span><span>用法</span><span>:</span><span><br></span><span>lpr -P[ printer ] file1 file2 file3 ....</span><span><br><br></span><span>或</span><span><br></span><span>lpr -P[ printer ] &lt; file1</span><span><br><br></span><span>例子</span><span>:</span><span><br></span><span>lpr -Plp1 hello.c hello.lst hello.map</span><span><br></span><span>lpr -Plp1 &lt; hello.c</span><span><br><br></span><span>前者以参数输入所要印出的档案内容，後者列印标准输入档案</span><span>( standard input )</span><span><br></span><span>的内容，因已将</span><span> hello.c </span><span>转向到标准输入，故会印出</span><span> hello.c </span><span>的档案内容。</span><span><br><br></span><span>2. lpq</span><span><br></span><span>lpq </span><span>是用来观察</span><span> printer queue </span><span>上的</span><span> Jobs </span><span>。</span><span><br><br></span><span>用法</span><span>:</span><span><br></span><span>lpq -P[ printer ]</span><span><br><br><br></span><span>3. lprm</span><span><br></span><span>lprm </span><span>是用来取消列印要求的指令。</span><span> </span><span>通常我们有时会印错，或是误送非文字档</span><span><br></span><span>资料至</span><span> printer , </span><span>此时就必须利用</span><span> lprm </span><span>取消列印</span><span> request </span><span>，以免造成资源</span><span><br></span><span>的浪费。</span><span><br><br></span><span>用法</span><span>:</span><span><br></span><span>lprm -P[ printer ] [ Jobs id | username ]</span><span><br><br></span><span>lprm </span><span>用来清除</span><span> printer queue </span><span>中的</span><span> Jobs , </span><span>如果你使用</span><span> Job Id </span><span>作为参数，则</span><span><br></span><span>它将此</span><span> Job </span><span>自</span><span>printer queue </span><span>清除，如果你用</span><span> username</span><span>作为参数，则它将此</span><span> queue</span><span><br></span><span>中所有</span><span> Owner </span><span>为此</span><span> username </span><span>的</span><span> Jobs </span><span>清除。</span><span><br><br></span><span>i. </span><span>更改个人使用资料</span><span>:</span><span><br><br></span><span>1. passwd</span><span><br></span><span>passwd </span><span>是用来更改你的使用密码，用法为</span><span>:</span><span><br><br></span><span>passwd [ username ]</span><span><br><br></span><span>在使用</span><span> passwd </span><span>的时候，它会先问你的旧密码，然後询问两次要更改的密码，确定</span><span><br></span><span>无误後才将你的密码改掉。</span><span><br><br></span><span>2. chsh</span><span><br></span><span>chsh </span><span>是提供使用者更换</span><span> login shell </span><span>的指令，你可经由此更换自己使用的</span><span> shell </span><span>。</span></p>
            </td>
        </tr>
    </tbody>
</table>
</div>
<p align=left>&nbsp;</p>
<img src ="http://www.cnitblog.com/wangyaqin2006/aggbug/46474.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.cnitblog.com/wangyaqin2006/" target="_blank">wangyaqin</a> 2008-07-09 11:43 <a href="http://www.cnitblog.com/wangyaqin2006/archive/2008/07/09/46474.html#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item></channel></rss>