Warning: date(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected the timezone 'UTC' for now, but please set date.timezone to select your timezone. in /home/webadm/public_html/w20120921/lf/class/action/blogaction.class.php on line 306

Warning: date(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected the timezone 'UTC' for now, but please set date.timezone to select your timezone. in /home/webadm/public_html/w20120921/lf/class/action/blogaction.class.php on line 308

Warning: date(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected the timezone 'UTC' for now, but please set date.timezone to select your timezone. in /home/webadm/public_html/w20120921/lf/class/action/blogaction.class.php on line 310

Warning: Cannot modify header information - headers already sent by (output started at /home/webadm/public_html/w20120921/lf/class/action/blogaction.class.php:306) in /home/webadm/public_html/w20120921/lf/class/view/view.class.php on line 328

Warning: Cannot modify header information - headers already sent by (output started at /home/webadm/public_html/w20120921/lf/class/action/blogaction.class.php:306) in /home/webadm/public_html/w20120921/lf/class/view/view.class.php on line 175
2019商經一而上 http://oldwww.kmvs.km.edu.tw/lf/index.php?blogId=71 2019bm123 2020-03-31T20:49:22Z 20200406數位科技上機實作:安裝並使用Appserv伺服器的MYSQL資料庫系統 http://oldwww.kmvs.km.edu.tw/lf/index.php?op=ViewArticle&articleId=578&blogId=71 <p>(一) 在你的WIN10電腦下載並安裝Appserv<span style="color: #000080;"><span class="headd"><strong><big>9.3.0</big></strong></span></span>應用程式伺服程式(最新版)</p> <p>(<a href="https://www.appserv.org/en/">https://www.appserv.org/en/</a>),詳參:<a href="http://oldwww.kmvs.km.edu.tw/lf/index.php?op=ViewArticle&amp;articleId=568&amp;blogId=71">20200302在win10安裝並使用Appserv應用程式伺服程式</a></p> <p>&nbsp;</p> <p>(1-1)在cmd命令執行ipconfig可查得你的IP (如<span style="background-color: #ffff00;">192.168.176.9)</span></p> <p>&nbsp;</p> <p>(1-2)修改設定檔C:\AppServ\Apache24\conf\httpd.conf的一行文字如下(表示在IP為192.168.176.9的電腦的801埠號聆聽) 並重啟apache httpd</p> <p>:</p> <p><span style="background-color: #ffff00;">Listen 192.168.176.9:801&nbsp;&nbsp; <br /></span></p> <p>:</p> <p>(1-3)執行C:\AppServ\Apache24\bin\ApacheMonitor.exe可啟動網頁伺服器啟動控制</p> <p>&nbsp;</p> <p>(二)參考如下文章<a class="external text" rel="nofollow" href="http://oldwww.kmvs.km.edu.tw/lf/index.php?op=ViewArticle&amp;articleId=574&amp;blogId=71">20200316使用Appserv的phpMyAdmin在MYSQL資料庫新增一個selldb資料庫並建立一個custs資料表並加入3筆資料錄</a></p> <p><span style="background-color: #ffff00;">(2-0) 用firefox 連 http://192.168.176.9:801</span></p> <p>(2-1)登入phpMyAdmin點選左上角的「新增」/再點選上方的「SQL」/</p> <p>並在剛裝妥的伺服器的MYSQL資料庫系統用SQL指令建一個你英文名資料庫(如「BigDogdb」)。</p> <p>&nbsp;</p> <p><span style="color: #000080;"><span class="headd"><strong><span class="app"><span style="background-color: #ccffcc;">參考SQL指令:CREATE DATABASE selldb default character set utf8;</span></span></strong></span></span></p> <p><span style="color: #000080;"><span class="headd"><strong><span class="app"><span style="background-color: #ccffcc;"><br /></span></span></strong></span></span></p> <p>(2-2) 並在(2-1)所建的資料庫中建立一個有如下四個欄位的custs資料表。</p> <p>參考SQL指令:<span style="color: #000080;"><span class="headd"><strong><span class="app"><span style="background-color: #ccffcc;"><span style="background-color: #ccffcc;">CREATE TABLE custs (id char(10),name char(20),amount float,tel char(20));</span></span></span></strong></span></span></p> <p><span style="color: #000080;"><span class="headd"><strong><span class="app"><span style="background-color: #ccffcc;"><span style="background-color: #ccffcc;">id char(10)</span></span></span></strong></span></span></p> <p><span style="color: #000080;"><span class="headd"><strong><span class="app"><span style="background-color: #ccffcc;"><span style="background-color: #ccffcc;">name char(20)</span></span></span></strong></span></span></p> <p><span style="color: #000080;"><span class="headd"><strong><span class="app"><span style="background-color: #ccffcc;"><span style="background-color: #ccffcc;">amount float</span></span></span></strong></span></span></p> <p><span style="color: #000080;"><span class="headd"><strong><span class="app"><span style="background-color: #ccffcc;"><span style="background-color: #ccffcc;">tel char(20)</span></span></span></strong></span></span></p> <p>&nbsp;</p> <p>(2-3)<span style="color: #000080;"><span class="headd"><strong><span class="app"><span style="background-color: #ccffcc;"><span style="background-color: #ccffcc;"><span style="color: #000080;"><span class="headd"><strong><span class="app"><span style="background-color: #ccffcc;"><span style="color: #000080;"><span class="headd"><strong><span class="app"><span style="background-color: #ccffcc;"><span style="color: #000080;"><span class="headd"><strong><span class="app"><span style="background-color: #ccffcc;"><span style="color: #000080;"><span class="headd"><strong><span class="app"><span style="background-color: #ccffcc;"><span style="color: #000080;"><span class="headd"><strong><span class="app"><span style="background-color: #ccffcc;">並在(2-2)所建的custs資料表中新增三筆資料錄到<span style="color: #000080;"><span class="headd"><strong><span class="app"><span style="background-color: #ccffcc;">custs資料表中</span></span></strong></span></span></span></span></strong></span></span></span></span></strong></span></span></span></span></strong></span></span></span></span></strong></span></span></span></span></strong></span></span></span></span></span></strong></span></span></p> <p><span style="color: #000080;"><span class="headd"><strong><span class="app"><span style="background-color: #ccffcc;"><span style="background-color: #ccffcc;"><span style="color: #000080;"><span class="headd"><strong><span class="app"><span style="background-color: #ccffcc;"><span style="color: #000080;"><span class="headd"><strong><span class="app"><span style="background-color: #ccffcc;"><span style="color: #000080;"><span class="headd"><strong><span class="app"><span style="background-color: #ccffcc;"><span style="color: #000080;"><span class="headd"><strong><span class="app"><span style="background-color: #ccffcc;"><span style="color: #000080;"><span class="headd"><strong><span class="app"><span style="background-color: #ccffcc;"><span style="color: #000080;"><span class="headd"><strong><span class="app"><span style="background-color: #ccffcc;"><span style="background-color: #ccffcc;">'901','大狗',100,'111222'</span></span></span></strong></span></span></span></span></strong></span></span></span></span></strong></span></span></span></span></strong></span></span></span></span></strong></span></span></span></span></strong></span></span></span></span></span></strong></span></span></p> <p><span style="background-color: #ccffcc;">'902','大貓',200,'333444'</span></p> <p><span style="background-color: #ccffcc;">'903','大牛',300,'555666'</span></p> <p>參考SQL指令:<span style="color: #000080;"><span class="headd"><strong><span class="app"><span style="background-color: #ccffcc;"><span style="background-color: #ccffcc;"><span style="background-color: #ccffcc;">insert into custs(id,name,amount,tel) values ('20002','小貓',200,'233444');</span></span></span></span></strong></span></span></p> <p><strong>(2-4)用SQL指令將以上的custs資料表刪除掉。</strong></p> <p><strong>drop table custs;</strong></p> <p><strong>&nbsp;</strong></p> <div> <p><strong>(2-5)用SQL指令將以上的你建的資料庫刪除掉。</strong></p> <div><strong>drop database selldb;</strong></div> <p><strong>(2-6)一次執行<strong>(2-1)~(2-3)中</strong>SQL指令來完成對應的所有操作。</strong></p> </div> <p>&nbsp;</p> <p>參考SQL指令:</p> <p><span style="color: #000000; background-color: #ffff99;"><span class="headd"><strong><span class="app">CREATE DATABASE selldb default character set utf8;</span></strong></span></span></p> <p><span style="color: #000000; background-color: #ffff99;"><span class="headd"><strong><span class="app">use selldb;<br /></span></strong></span></span></p> <p><span style="color: #000000; background-color: #ffff99;"><span class="headd"><strong><span class="app">CREATE TABLE custs (id char(10),name char(20),amount float,tel char(20));</span></strong></span></span></p> <p><span style="background-color: #ffff99; color: #000000;">insert into custs(id,name,amount,tel) values ('10001','小狗',100,'233111');</span></p> <p><span style="background-color: #ffff99; color: #000000;">insert into custs(id,name,amount,tel) values ('20002','小貓',200,'233444');</span></p> <p><span style="background-color: #ffff99; color: #000000;">insert into custs(id,name,amount,tel) values ('30003','小牛',300,'233777');</span></p> <p><span style="color: #000000; background-color: #ffff99;"><span class="headd"><strong><span class="app"><span class="headd"><strong><span class="app"><span class="headd"><strong><span class="app"><span class="headd"><strong><span class="app"><span class="headd"><strong><span class="app">select * from custs;</span></strong></span></span></strong></span></span></strong></span></span></strong></span></span></strong></span></span></p> <p><span style="color: #000000; background-color: #ffff99;"><span class="headd"><strong><span class="app"><span class="headd"><strong><span class="app"><span class="headd"><strong><span class="app"><span class="headd"><strong><span class="app"><span class="headd"><strong><span class="app"><br /></span></strong></span></span></strong></span></span></strong></span></span></strong></span></span></strong></span></span></p> <p>(三)請將以上的(2-1)~(2-6)的操作結果畫面截圖(如下)貼入<span style="font-size: small;">操作畫面用<span style="background-color: #ffff99;">ALT+PrtScr</span>鍵抓入LibreOffice 的writer中並於<span style="background-color: #ffff99;">「格式功能表/頁面」處設定顯示頁首</span> 並於<span style="background-color: #ffff99;">頁首的左上角顯示「商一+你號+你名」文字</span>。</span></p> <p><span style="font-size: small;">再存檔為「20200406商一你號你名.odt」,並再&nbsp;匯出為PDF檔(檔名為「<span style="font-size: small;">20200406</span>商一你號你名.pdf」,自動取用odt檔的主檔名)。</span></p> <p><span style="font-size: small;">請參考範例pdf檔如下:</span> 20200406商一55吳小花.pdf<a href="http://oldwww.kmvs.km.edu.tw/lf/gallery/71/20200406%E5%95%86%E4%B8%8055%E5%90%B3%E5%B0%8F%E8%8A%B1.pdf">下載</a> (825 KB) | created 30 三月, 2020</p> <p>&nbsp;</p> <p>(圖1)</p> <p><img src="http://oldwww.kmvs.km.edu.tw/lf/gallery/71/selldbSQL01.jpg" alt="alt" width="600" height="358" /></p> <p>&nbsp;</p> <p>(圖2)</p> <p><img src="http://oldwww.kmvs.km.edu.tw/lf/gallery/71/selldbSQL02.jpg" alt="alt" width="600" height="358" /></p> <p>&nbsp;</p> <p>(圖3)</p> <p><img src="http://oldwww.kmvs.km.edu.tw/lf/gallery/71/selldbSQL03.jpg" alt="alt" width="600" height="358" /></p> <p>(圖4)</p> <p><img src="http://oldwww.kmvs.km.edu.tw/lf/gallery/71/selldbSQL04.jpg" alt="alt" width="600" height="358" /></p> <p><span style="font-size: small;">圖5</span></p> <p><img src="http://oldwww.kmvs.km.edu.tw/lf/gallery/71/selldbSQL05.jpg" alt="alt" width="600" height="358" /></p> <p><span style="font-size: small;">圖6<br /></span></p> <p><span style="color: #000080;"><span class="headd"><strong><span class="app"><span style="background-color: #ccffcc;"><img src="http://oldwww.kmvs.km.edu.tw/lf/gallery/71/selldbSQL06.jpg" alt="alt" width="600" height="358" /><br /></span></span></strong></span></span></p> 一般 2020-03-27T07:17:42Z tree 20200323在WIN10裝維基百科採用的mediawiki共同協作平台並使用之 http://oldwww.kmvs.km.edu.tw/lf/index.php?op=ViewArticle&articleId=575&blogId=71 <p>(0) 確定已有裝妥Appserv<span style="color: #000080;"><span class="headd"><strong><big>9.3.0</big></strong></span></span>應用程式伺服程式(<a href="https://www.appserv.org/en/">https://www.appserv.org/en/</a>),安裝可參考:<a href="http://oldwww.kmvs.km.edu.tw/lf/index.php?op=ViewArticle&amp;articleId=568&amp;blogId=71">20200302在win10安裝並使用Appserv應用程式伺服程式</a></p> <p>&nbsp;</p> <p>(1)下載mediawiki-1.34.0.tar.gz (約39MB) : MediaWiki 1.34.0 (<a class="external text" href="https://releases.wikimedia.org/mediawiki/1.34/mediawiki-1.34.0.tar.gz">download</a>) - stable</p> <p>&nbsp;</p> <p>(2)下載<a class="extiw" title="w:7-Zip" href="https://en.wikipedia.org/wiki/7-Zip">並安裝7-Zip</a> 解壓縮軟體(7z1900-x64.exe):</p> <table border="0" cellpadding="6" cellspacing="1"> <tbody> <tr> <td class="Item" align="center"><a href="https://www.7-zip.org/a/7z1900-x64.exe">Download</a></td> <td class="Item" align="center">.exe</td> <td class="Item" align="center">64-bit x64</td> <td class="Item">7-Zip for 64-bit Windows x64 (Intel 64 or AMD64)</td> </tr> </tbody> </table> <p>&nbsp;</p> <p>(3)將用7z解開的mediawiki-1.34.0.tar.gz的結果資料夾(mediawiki-1.34.0)改名為wiki並移動到本機網站的網頁主資料夾 C:\AppServ\www下。</p> <p>&nbsp;</p> <p>(4-1)用firefox連http://localhost/wiki/出現要有<span style="background-color: #ffff99;"><strong>fileinfo&nbsp;</strong></span> <span style="background-color: #ffff99;">PHP extensions 的</span>錯誤訊息。</p> <ul> </ul> <p>(4-2)用記事本將在C:\AppServ\php7\php.ini設定檔中的fileinfo模組註解分號拿掉,並重啟apache httpd 本機網站服務</p> <p><span style="background-color: #ffff99;">;extension=fileinfo</span></p> <p><span style="background-color: #ffff99;">(4-3)連http://localhost/phpinfo.php可發現fileinfo已啟用。(<strong>)</strong></span></p> <p>&nbsp;</p> <p>(5)用firefox再連<span style="background-color: #ffff00;">http://localhost/wiki/</span> 出現如下訊息:</p> <p>MediaWiki 1.34.0</p> <div class="error"> <p>LocalSettings.php not found.</p> <p>Please <a href="http://localhost/mediawiki-1.34.0/mw-config/index.php">set up the wiki</a> first.</p> <p>&nbsp;</p> <p>(6)點選第(5)點的<a href="http://10.1.1.13/wiki/mw-config/index.php"> set up the wiki</a></p> <p>&nbsp;</p> <p>(7)進入mediawiki網頁安裝過程:</p> <p>&nbsp;</p> <p>(7-1)語言:接受zh-tw 中文(台灣)</p> <p>&nbsp;</p> <p>(7-2)<span id=".E7.92.B0.E5.A2.83.E6.AA.A2.E6.9F.A5" class="mw-headline">環境檢查:結果如下</span></p> <div class="error"><strong>:</strong></div> <div class="error"><span style="background-color: #ccffff;"><strong>警告:</strong>找不到<a class="external text" rel="nofollow noreferrer noopener" href="https://www.php.net/apcu" target="_blank">APCu</a>或<a class="external text" rel="nofollow noreferrer noopener" href="https://www.iis.net/downloads/microsoft/wincache-extension" target="_blank">WinCache</a>。未開啟物件快取。 </span></div> <div class="config-message"><span style="background-color: #ccffff;">找不到 GNU diff3 文字比對工具程式,而您現在可忽略它,但可能會更頻繁地遇到編輯衝突。</span></div> <div class="config-message"> <p><span style="background-color: #ccffff;">找到內建 GD 圖形程式庫。</span></p> <p><span style="background-color: #ccffff;">若您開啟了檔案上傳功能,將可啟用縮圖功能。</span></p> </div> <div class="config-message"><span style="background-color: #ccffff;">查無 Git 版本控制軟體,而您現在可忽略它,另外請注意 Special:Version 不會顯示出提交的雜湊。</span></div> <div class="config-message"><span style="background-color: #ccffff;">使用伺服器名稱 "http://10.1.1.13"。</span></div> <div class="config-message"><span style="background-color: #ccffff;">使用伺服器 URL "http://10.1.1.13/wiki"。</span></div> <div class="config-message"> <p><span style="background-color: #ccffff;"><strong>警告:</strong>您預設的上傳目錄 <code>C:\AppServ\www\wiki/images/</code> 有可被任意執行 Script 的漏洞。</span></p> <p><span style="background-color: #ccffff;">雖然 MediaWiki 會對所有上傳的檔案進行安全檢查,但我們仍強烈建議您在開啟上傳功能前了解如何 <a class="external text" rel="noreferrer noopener" href="https://www.mediawiki.org/wiki/Special:MyLanguage/Manual:Security#Upload_security" target="_blank">關閉此安全漏洞</a>。</span></p> </div> <div class="config-message"><span style="background-color: #ccffff;">使用 <a class="external text" rel="nofollow noreferrer noopener" href="https://php.net/manual/en/book.intl.php" target="_blank">PHP intl 擴充套件</a>做 Unicode 正規化。</span></div> <div class="error"><span class="success-message" style="background-color: #ccffff;"> 環境檢查已完成。 您可以安裝 MediaWiki。</span></div> <div class="error"><span class="success-message" style="background-color: #ccffff;"><br /></span></div> <div class="error"><span class="success-message">(7-3)<span class="success-message">輸入如下</span>連線到資料庫所需的資料:</span></div> <div class="error"><span class="success-message" style="background-color: #ccffff;">資料庫類型:MySQL<br />資料庫主機:localhost<br />資料庫名稱:bmwikidb<br />資料庫資料表名稱的字首:bmwiki<br />資料庫使用者名稱:root<br />資料庫密碼:abc123abc123</span></div> <div class="error"><span class="success-message" style="background-color: #ccffff;"><br /></span></div> <div class="error"><span class="success-message">(7-4)資料庫設定:</span></div> <div class="error"><span class="success-message"><span style="background-color: #ccffff;">供網頁存取使用的資料庫帳號(使用與安裝程序相同的帳號)</span></span></div> <div class="error"><span class="success-message">(7-5) </span></div> <div class="error"><span class="success-message" style="background-color: #ccffff;">wiki的名稱:商經一而上維基<br />專案命名空間:與 wiki 名稱一致(商經一而上維基)<br />管理員帳號<br />您的使用者名稱:bm123<br />密碼:bm10023bm10023<br />電子郵件地址:bm123@gmail.com</span></div> <div class="error"> <div class="error"><span class="success-message"><br /></span></div> <div class="error"><span class="success-message">(7-6)選項:<br /><span style="background-color: #ccffff;">使用者權限基本資料:&nbsp;&nbsp;&nbsp;&nbsp; 開放式 wiki</span><br /><span style="background-color: #ccffff;">版權聲明與授權條款:&nbsp;&nbsp;&nbsp; 創用 CC 姓名標示</span></span></div> </div> <span style="background-color: #ccffff;">餘皆採預設值。 </span> <div class="error"></div> <div class="error"><span class="success-message">勾選「開啟檔案上傳」</span></div> <div class="error"><span class="success-message"><br /></span></div> <div class="error"><span class="success-message">(7-7)安裝中&hellip;</span></div> <div class="error"><span class="success-message"> <ul> <li>正在設定資料庫&hellip;完成</li> <li>正在建立資料表&hellip;完成</li> <li>正在建立資料庫使用者&hellip;完成</li> <li>正在匯入預設的 interwiki 資料表&hellip;完成</li> <li>初始化統計資訊&hellip;完成</li> <li>產生秘密金鑰中&hellip;完成</li> <li>略過執行不需要的更新&hellip;完成</li> <li>正在建立管理員使用者帳號&hellip;完成</li> <li>正在使用預設的內容建立首頁&hellip;完成</li> <div class="config-message">資料庫設定成功</div> </ul> <div class="mw-infobox-right"> <p><strong>(7-8)恭喜!</strong> 您已經成功安裝MediaWiki。</p> <p>安裝程式已自動產生<code>LocalSettings.php</code>檔案, 該檔案中包含了您所有的設定項目。</p> <p>您需要下載該檔案,並將其放置在您的Wiki的根目錄(index.php所在的目錄)中,下載應已自動開始。</p> <p>若瀏覽器沒有提示您下載,或者您取消了下載,您可以點選下方連結重新下載:</p> <div class="config-download-link"><a href="http://10.1.1.13/wiki/mw-config/index.php?localsettings=1">下載 <code>LocalSettings.php</code></a></div> <p><strong>注意:</strong>如果您現在不下載此檔案,稍後結束安裝程式之後將無法再下載設定檔。</p> <p>當您完成本步驟後,您可以<strong><a class="external text" rel="nofollow noreferrer noopener" href="http://10.1.1.13/wiki/index.php" target="_blank">進入您的Wiki</a></strong>。</p> </div> </span></div> </div> <div class="error"><span class="success-message">(8)將下載的LocalSettings.php拷入wiki資料夾中並點<strong><a class="external text" rel="nofollow noreferrer noopener" href="http://10.1.1.13/wiki/index.php" target="_blank">進入您的Wiki</a></strong>。</span></div> <div class="error"><span class="success-message"><br /></span></div> <div class="error"><span class="success-message">(9)成功出現本機的mediawiki首頁。</span></div> <div class="error"><span class="success-message"><br /></span></div> 一般 2020-03-18T19:19:13Z tree 20200316使用Appserv的phpMyAdmin在MYSQL資料庫新增一個selldb資料庫並建立一個custs資料表並加入3筆資料錄 http://oldwww.kmvs.km.edu.tw/lf/index.php?op=ViewArticle&articleId=574&blogId=71 <p>&nbsp;</p> <p>(1)用firefox 連 http://localhost,於系統預設首頁選取<span style="color: #000080;"><span class="headd"><strong><span class="app"><a href="http://localhost/phpMyAdmin/">phpMyAdmin Database Manager Version 4.6.4</a></span></strong></span></span></p> <p>&nbsp;</p> <p>(2)輸入root帳密登入MYSQL資料庫管理畫面</p> <p>&nbsp;</p> <p>(3)在MYSQL資料庫管理畫面的SQL指令區輸入如下五個SQL指令:</p> <p>&nbsp;</p> <p><span style="color: #000080;"><span class="headd"><strong><span class="app"><span style="background-color: #ccffcc;">(3-1)建立selldb資料庫(字元集採UTF8)</span></span></strong></span></span></p> <p><span style="color: #000080;"><span class="headd"><strong><span class="app"><span style="background-color: #ccffcc;">CREATE DATABASE selldb default character set utf8;</span></span></strong></span></span></p> <p>&nbsp;</p> <p><span style="color: #000080;"><span class="headd"><strong><span class="app"><span style="background-color: #ccffcc;">(3-2)<span style="color: #000080;"><span class="headd"><strong><span class="app"><span style="background-color: #ccffcc;"><span style="color: #000080;"><span class="headd"><strong><span class="app"><span style="background-color: #ccffcc;">點選<span style="color: #000080;"><span class="headd"><strong><span class="app"><span style="background-color: #ccffcc;">selldb資料庫並輸入如下SQL指令來</span></span></strong></span></span></span></span></strong></span></span></span></span></strong></span></span><span style="color: #000080;"><span class="headd"><strong><span class="app"><span style="background-color: #ccffcc;">&nbsp;</span></span></strong></span></span>建立custs資料表</span></span></strong></span></span></p> <p><span style="color: #000080;"><span class="headd"><strong><span class="app"><span style="background-color: #ccffcc;"><span style="background-color: #ccffcc;">CREATE TABLE custs (id char(10),name char(20),amount float,tel char(20));</span></span></span></strong></span></span></p> <p>&nbsp;</p> <p><span style="color: #000080;"><span class="headd"><strong><span class="app"><span style="background-color: #ccffcc;">(3-3)<span style="color: #000080;"><span class="headd"><strong><span class="app"><span style="background-color: #ccffcc;"><span style="color: #000080;"><span class="headd"><strong><span class="app"><span style="background-color: #ccffcc;"><span style="color: #000080;"><span class="headd"><strong><span class="app"><span style="background-color: #ccffcc;"><span style="color: #000080;"><span class="headd"><strong><span class="app"><span style="background-color: #ccffcc;">輸入如下三個SQL指令來新增三筆資料錄到<span style="color: #000080;"><span class="headd"><strong><span class="app"><span style="background-color: #ccffcc;">custs資料表中。</span></span></strong></span></span></span></span></strong></span></span></span></span></strong></span></span></span></span></strong></span></span><span style="color: #000080;"><span class="headd"><strong><span class="app">&nbsp;</span></strong></span></span></span></span></strong></span></span></span></span></strong></span></span></p> <p><span style="background-color: #ccffcc;">insert into custs(id,name,amount,tel) values ('10001','小狗',100,'233111');</span></p> <p><span style="background-color: #ccffcc;">insert into custs(id,name,amount,tel) values ('20002','小貓',200,'233444');</span></p> <p><span style="background-color: #ccffcc;">insert into custs(id,name,amount,tel) values ('30003','小牛',300,'233777');</span></p> <p>(3-4)<span style="color: #000080;"><span class="headd"><strong><span class="app"><span style="background-color: #ccffcc;"><span style="color: #000080;"><span class="headd"><strong><span class="app"><span style="background-color: #ccffcc;"><span style="color: #000080;"><span class="headd"><strong><span class="app"><span style="background-color: #ccffcc;"><span style="color: #000080;"><span class="headd"><strong><span class="app"><span style="background-color: #ccffcc;"><span style="color: #000080;"><span class="headd"><strong><span class="app"><span style="background-color: #ccffcc;">輸入如下SQL指令來查詢custs資料表</span></span></strong></span></span></span></span></strong></span></span></span></span></strong></span></span></span></span></strong></span></span></span></span></strong></span></span></p> <p><span style="color: #000080;"><span class="headd"><strong><span class="app"><span style="background-color: #ccffcc;"><span style="color: #000080;"><span class="headd"><strong><span class="app"><span style="background-color: #ccffcc;"><span style="color: #000080;"><span class="headd"><strong><span class="app"><span style="background-color: #ccffcc;"><span style="color: #000080;"><span class="headd"><strong><span class="app"><span style="background-color: #ccffcc;"><span style="color: #000080;"><span class="headd"><strong><span class="app"><span style="background-color: #ccffcc;">select * from custs;</span></span></strong></span></span></span></span></strong></span></span></span></span></strong></span></span></span></span></strong></span></span></span></span></strong></span></span></p> <p>&nbsp;</p> <p><strong>(4)用管理介面的操作來將以上的selldb資料庫及custs資料表刪除掉。</strong></p> <p><strong>(5)用管理介面的操作來將以上的selldb資料庫及custs資料表的三筆資料錄內容在建立出來。</strong></p> <p><strong>(6)用SQL指令將以上的selldb資料庫及custs資料表刪除掉。</strong></p> <p><strong>drop table custs;</strong></p> <div> <p><strong>drop database selldb;</strong></p> <p>&nbsp;</p> <p><strong>(7-1)執行如下七個SQL指令來完成第3點的所有操作:</strong></p> <p><span style="color: #000000; background-color: #ffff99;"><span class="headd"><strong><span class="app">CREATE DATABASE selldb default character set utf8;</span></strong></span></span></p> <p><span style="color: #000000; background-color: #ffff99;"><span class="headd"><strong><span class="app">use selldb;<br /></span></strong></span></span></p> <p><span style="color: #000000; background-color: #ffff99;"><span class="headd"><strong><span class="app">CREATE TABLE custs (id char(10),name char(20),amount float,tel char(20));</span></strong></span></span></p> <p><span style="background-color: #ffff99; color: #000000;">insert into custs(id,name,amount,tel) values ('10001','小狗',100,'233111');</span></p> <p><span style="background-color: #ffff99; color: #000000;">insert into custs(id,name,amount,tel) values ('20002','小貓',200,'233444');</span></p> <p><span style="background-color: #ffff99; color: #000000;">insert into custs(id,name,amount,tel) values ('30003','小牛',300,'233777');</span></p> <p><span style="color: #000000; background-color: #ffff99;"><span class="headd"><strong><span class="app"><span class="headd"><strong><span class="app"><span class="headd"><strong><span class="app"><span class="headd"><strong><span class="app"><span class="headd"><strong><span class="app">select * from custs;</span></strong></span></span></strong></span></span></strong></span></span></strong></span></span></strong></span></span></p> <p>&nbsp;</p> <p>(7-2)以上執行結果如下:</p> <div class="result_query" style="text-align: left;"> <div class="success"><span style="background-color: #ffff99;"><img class="icon ic_s_success" src="http://localhost/phpMyAdmin/themes/dot.gif" alt="alt" /> MySQL 回傳空的查詢結果 (即零資料列)。 (查詢花費 0.0156 秒。)</span></div> <div class="sqlOuter"><span style="background-color: #ffff99;"><code class="sql"> <div class="sql-highlight cm-s-default"><span class="cm-keyword"><a class="cm-sql-doc" href="http://localhost/phpMyAdmin/url.php?url=https://dev.mysql.com/doc/refman/5.5/en/create-database.html" target="mysql_doc">CREATE</a></span> <span class="cm-keyword"><a class="cm-sql-doc" href="http://localhost/phpMyAdmin/url.php?url=https://dev.mysql.com/doc/refman/5.5/en/create-database.html" target="mysql_doc">DATABASE</a></span> selldb <span class="cm-keyword"><a class="cm-sql-doc" href="http://localhost/phpMyAdmin/url.php?url=https://dev.mysql.com/doc/refman/5.5/en/miscellaneous-functions.html#function_default" target="mysql_doc">default</a></span> <span class="cm-keyword"><a class="cm-sql-doc" href="http://localhost/phpMyAdmin/url.php?url=https://dev.mysql.com/doc/refman/5.5/en/charset.html" target="mysql_doc">character</a></span> <span class="cm-keyword"><a class="cm-sql-doc" href="http://localhost/phpMyAdmin/url.php?url=https://dev.mysql.com/doc/refman/5.5/en/charset.html" target="mysql_doc">set</a></span> utf8</div> </code></span></div> <div class="tools print_ignore"><form method="post"><input name="CsrfToken" type="hidden" value="34cd8603b8b601067a3172ff08073d06" /><input name="CsrfToken" type="hidden" value="34cd8603b8b601067a3172ff08073d06" /></form><span style="background-color: #ffff99;"> [ <a class="inline_edit_sql" href="http://localhost/phpMyAdmin/server_sql.php?db=&amp;token=aa78e26d7570f6b7cac6ee8cd85d2f19">行內編輯</a> ] [ <a href="http://localhost/phpMyAdmin/server_sql.php?sql_query=CREATE+DATABASE+selldb+default+character+set+utf8&amp;show_query=1&amp;token=aa78e26d7570f6b7cac6ee8cd85d2f19#querybox">編輯</a> ] [ <a href="http://localhost/phpMyAdmin/import.php?sql_query=CREATE+DATABASE+selldb+default+character+set+utf8&amp;show_query=1&amp;show_as_php=1&amp;token=aa78e26d7570f6b7cac6ee8cd85d2f19">產生 PHP 程式碼</a> ]</span></div> </div> <div class="result_query" style="text-align: left;"> <div class="success"><span style="background-color: #ffff99;"><img class="icon ic_s_success" src="http://localhost/phpMyAdmin/themes/dot.gif" alt="alt" /> MySQL 回傳空的查詢結果 (即零資料列)。 (查詢花費 0.0000 秒。)</span></div> <div class="sqlOuter"><span style="background-color: #ffff99;"><code class="sql"> <div class="sql-highlight cm-s-default"><span class="cm-keyword">use</span> selldb</div> </code></span></div> <div class="tools print_ignore"><form method="post"><input name="CsrfToken" type="hidden" value="34cd8603b8b601067a3172ff08073d06" /><input name="CsrfToken" type="hidden" value="34cd8603b8b601067a3172ff08073d06" /></form><span style="background-color: #ffff99;"> [ <a class="inline_edit_sql" href="http://localhost/phpMyAdmin/server_sql.php?db=&amp;token=aa78e26d7570f6b7cac6ee8cd85d2f19">行內編輯</a> ] [ <a href="http://localhost/phpMyAdmin/server_sql.php?sql_query=use+selldb&amp;show_query=1&amp;token=aa78e26d7570f6b7cac6ee8cd85d2f19#querybox">編輯</a> ] [ <a href="http://localhost/phpMyAdmin/import.php?sql_query=use+selldb&amp;show_query=1&amp;show_as_php=1&amp;token=aa78e26d7570f6b7cac6ee8cd85d2f19">產生 PHP 程式碼</a> ]</span></div> </div> <div class="result_query" style="text-align: left;"> <div class="success"><span style="background-color: #ffff99;"><img class="icon ic_s_success" src="http://localhost/phpMyAdmin/themes/dot.gif" alt="alt" /> MySQL 回傳空的查詢結果 (即零資料列)。 (查詢花費 0.2496 秒。)</span></div> <div class="sqlOuter"><span style="background-color: #ffff99;"><code class="sql"> <div class="sql-highlight cm-s-default"><span class="cm-keyword"><a class="cm-sql-doc" href="http://localhost/phpMyAdmin/url.php?url=https://dev.mysql.com/doc/refman/5.5/en/create-table.html" target="mysql_doc">CREATE</a></span> <span class="cm-keyword"><a class="cm-sql-doc" href="http://localhost/phpMyAdmin/url.php?url=https://dev.mysql.com/doc/refman/5.5/en/create-table.html" target="mysql_doc">TABLE</a></span> custs (id <span class="cm-builtin"><a class="cm-sql-doc" href="http://localhost/phpMyAdmin/url.php?url=https://dev.mysql.com/doc/refman/5.5/en/string-types.html" target="mysql_doc">char</a></span>(<span class="cm-number">10</span>),name <span class="cm-builtin"><a class="cm-sql-doc" href="http://localhost/phpMyAdmin/url.php?url=https://dev.mysql.com/doc/refman/5.5/en/string-types.html" target="mysql_doc">char</a></span>(<span class="cm-number">20</span>),amount <span class="cm-builtin"><a class="cm-sql-doc" href="http://localhost/phpMyAdmin/url.php?url=https://dev.mysql.com/doc/refman/5.5/en/numeric-types.html" target="mysql_doc">float</a></span>,tel <span class="cm-builtin"><a class="cm-sql-doc" href="http://localhost/phpMyAdmin/url.php?url=https://dev.mysql.com/doc/refman/5.5/en/string-types.html" target="mysql_doc">char</a></span>(<span class="cm-number">20</span>))</div> </code></span></div> <div class="tools print_ignore"><form method="post"><input name="CsrfToken" type="hidden" value="34cd8603b8b601067a3172ff08073d06" /><input name="CsrfToken" type="hidden" value="34cd8603b8b601067a3172ff08073d06" /></form><span style="background-color: #ffff99;"> [ <a class="inline_edit_sql" href="http://localhost/phpMyAdmin/server_sql.php?db=&amp;token=aa78e26d7570f6b7cac6ee8cd85d2f19">行內編輯</a> ] [ <a href="http://localhost/phpMyAdmin/server_sql.php?sql_query=CREATE+TABLE+custs+%28id+char%2810%29%2Cname+char%2820%29%2Camount+float%2Ctel+char%2820%29%29&amp;show_query=1&amp;token=aa78e26d7570f6b7cac6ee8cd85d2f19#querybox">編輯</a> ] [ <a href="http://localhost/phpMyAdmin/import.php?sql_query=CREATE+TABLE+custs+%28id+char%2810%29%2Cname+char%2820%29%2Camount+float%2Ctel+char%2820%29%29&amp;show_query=1&amp;show_as_php=1&amp;token=aa78e26d7570f6b7cac6ee8cd85d2f19">產生 PHP 程式碼</a> ]</span></div> </div> <div class="result_query" style="text-align: left;"> <div class="success"><span style="background-color: #ffff99;"><img class="icon ic_s_success" src="http://localhost/phpMyAdmin/themes/dot.gif" alt="alt" /> 新增了 1 列。 (查詢花費 0.0468 秒。)</span></div> <div class="sqlOuter"><span style="background-color: #ffff99;"><code class="sql"> <div class="sql-highlight cm-s-default"><span class="cm-keyword"><a class="cm-sql-doc" href="http://localhost/phpMyAdmin/url.php?url=https://dev.mysql.com/doc/refman/5.5/en/insert.html" target="mysql_doc">insert</a></span> <span class="cm-keyword">into</span> custs(id,name,amount,tel) <span class="cm-keyword"><a class="cm-sql-doc" href="http://localhost/phpMyAdmin/url.php?url=https://dev.mysql.com/doc/refman/5.5/en/miscellaneous-functions.html#function_values" target="mysql_doc">values</a></span> (<span class="cm-string">'10001'</span>,<span class="cm-string">'小狗'</span>,<span class="cm-number">100</span>,<span class="cm-string">'233111'</span>)</div> </code></span></div> <div class="tools print_ignore"><form method="post"><input name="CsrfToken" type="hidden" value="34cd8603b8b601067a3172ff08073d06" /><input name="CsrfToken" type="hidden" value="34cd8603b8b601067a3172ff08073d06" /></form><span style="background-color: #ffff99;"> [ <a class="inline_edit_sql" href="http://localhost/phpMyAdmin/server_sql.php?db=&amp;token=aa78e26d7570f6b7cac6ee8cd85d2f19">行內編輯</a> ] [ <a href="http://localhost/phpMyAdmin/server_sql.php?sql_query=insert+into+custs%28id%2Cname%2Camount%2Ctel%29+values+%28%2710001%27%2C%27%E5%B0%8F%E7%8B%97%27%2C100%2C%27233111%27%29&amp;show_query=1&amp;token=aa78e26d7570f6b7cac6ee8cd85d2f19#querybox">編輯</a> ] [ <a href="http://localhost/phpMyAdmin/import.php?sql_query=insert+into+custs%28id%2Cname%2Camount%2Ctel%29+values+%28%2710001%27%2C%27%E5%B0%8F%E7%8B%97%27%2C100%2C%27233111%27%29&amp;show_query=1&amp;show_as_php=1&amp;token=aa78e26d7570f6b7cac6ee8cd85d2f19">產生 PHP 程式碼</a> ]</span></div> </div> <div class="result_query" style="text-align: left;"> <div class="success"><span style="background-color: #ffff99;"><img class="icon ic_s_success" src="http://localhost/phpMyAdmin/themes/dot.gif" alt="alt" /> 新增了 1 列。 (查詢花費 0.0312 秒。)</span></div> <div class="sqlOuter"><span style="background-color: #ffff99;"><code class="sql"> <div class="sql-highlight cm-s-default"><span class="cm-keyword"><a class="cm-sql-doc" href="http://localhost/phpMyAdmin/url.php?url=https://dev.mysql.com/doc/refman/5.5/en/insert.html" target="mysql_doc">insert</a></span> <span class="cm-keyword">into</span> custs(id,name,amount,tel) <span class="cm-keyword"><a class="cm-sql-doc" href="http://localhost/phpMyAdmin/url.php?url=https://dev.mysql.com/doc/refman/5.5/en/miscellaneous-functions.html#function_values" target="mysql_doc">values</a></span> (<span class="cm-string">'20002'</span>,<span class="cm-string">'小貓'</span>,<span class="cm-number">200</span>,<span class="cm-string">'233444'</span>)</div> </code></span></div> <div class="tools print_ignore"><form method="post"><input name="CsrfToken" type="hidden" value="34cd8603b8b601067a3172ff08073d06" /><input name="CsrfToken" type="hidden" value="34cd8603b8b601067a3172ff08073d06" /></form><span style="background-color: #ffff99;"> [ <a class="inline_edit_sql" href="http://localhost/phpMyAdmin/server_sql.php?db=&amp;token=aa78e26d7570f6b7cac6ee8cd85d2f19">行內編輯</a> ] [ <a href="http://localhost/phpMyAdmin/server_sql.php?sql_query=insert+into+custs%28id%2Cname%2Camount%2Ctel%29+values+%28%2720002%27%2C%27%E5%B0%8F%E8%B2%93%27%2C200%2C%27233444%27%29&amp;show_query=1&amp;token=aa78e26d7570f6b7cac6ee8cd85d2f19#querybox">編輯</a> ] [ <a href="http://localhost/phpMyAdmin/import.php?sql_query=insert+into+custs%28id%2Cname%2Camount%2Ctel%29+values+%28%2720002%27%2C%27%E5%B0%8F%E8%B2%93%27%2C200%2C%27233444%27%29&amp;show_query=1&amp;show_as_php=1&amp;token=aa78e26d7570f6b7cac6ee8cd85d2f19">產生 PHP 程式碼</a> ]</span></div> </div> <div class="result_query" style="text-align: left;"> <div class="success"><span style="background-color: #ffff99;"><img class="icon ic_s_success" src="http://localhost/phpMyAdmin/themes/dot.gif" alt="alt" /> 新增了 1 列。 (查詢花費 0.0468 秒。)</span></div> <div class="sqlOuter"><span style="background-color: #ffff99;"><code class="sql"> <div class="sql-highlight cm-s-default"><span class="cm-keyword"><a class="cm-sql-doc" href="http://localhost/phpMyAdmin/url.php?url=https://dev.mysql.com/doc/refman/5.5/en/insert.html" target="mysql_doc">insert</a></span> <span class="cm-keyword">into</span> custs(id,name,amount,tel) <span class="cm-keyword"><a class="cm-sql-doc" href="http://localhost/phpMyAdmin/url.php?url=https://dev.mysql.com/doc/refman/5.5/en/miscellaneous-functions.html#function_values" target="mysql_doc">values</a></span> (<span class="cm-string">'30003'</span>,<span class="cm-string">'小牛'</span>,<span class="cm-number">300</span>,<span class="cm-string">'233777'</span>)</div> </code></span></div> <div class="tools print_ignore"><form method="post"><input name="CsrfToken" type="hidden" value="34cd8603b8b601067a3172ff08073d06" /><input name="CsrfToken" type="hidden" value="34cd8603b8b601067a3172ff08073d06" /></form><span style="background-color: #ffff99;"> [ <a class="inline_edit_sql" href="http://localhost/phpMyAdmin/server_sql.php?db=&amp;token=aa78e26d7570f6b7cac6ee8cd85d2f19">行內編輯</a> ] [ <a href="http://localhost/phpMyAdmin/server_sql.php?sql_query=insert+into+custs%28id%2Cname%2Camount%2Ctel%29+values+%28%2730003%27%2C%27%E5%B0%8F%E7%89%9B%27%2C300%2C%27233777%27%29&amp;show_query=1&amp;token=aa78e26d7570f6b7cac6ee8cd85d2f19#querybox">編輯</a> ] [ <a href="http://localhost/phpMyAdmin/import.php?sql_query=insert+into+custs%28id%2Cname%2Camount%2Ctel%29+values+%28%2730003%27%2C%27%E5%B0%8F%E7%89%9B%27%2C300%2C%27233777%27%29&amp;show_query=1&amp;show_as_php=1&amp;token=aa78e26d7570f6b7cac6ee8cd85d2f19">產生 PHP 程式碼</a> ]</span></div> </div> <div class="notice"><span style="background-color: #ffff99;"><img class="icon ic_s_notice" src="http://localhost/phpMyAdmin/themes/dot.gif" alt="alt" /> 目前選擇的項目不含唯一(Unique)的資料欄位,將無法執行表格的編輯/核選、編輯、複製、刪除等相關的功能。<a href="http://localhost/phpMyAdmin/doc/html/config.html#cfg_RowActionLinksWithoutUnique" target="documentation"><img class="icon ic_b_help" title="說明文件" src="http://localhost/phpMyAdmin/themes/dot.gif" alt="說明文件" /></a></span></div> <div class="success"><span style="background-color: #ffff99;"><img class="icon ic_s_success" src="http://localhost/phpMyAdmin/themes/dot.gif" alt="alt" /> 顯示第 0 - 2 列 (總計 3 筆, 查詢花費 0.0000 秒。)</span></div> <div class="sqlOuter"><span style="background-color: #ffff99;"><code class="sql"> <div class="sql-highlight cm-s-default"><span class="cm-keyword"><a class="cm-sql-doc" href="http://localhost/phpMyAdmin/url.php?url=https://dev.mysql.com/doc/refman/5.5/en/select.html" target="mysql_doc">select</a></span> * <span class="cm-keyword">from</span> custs</div> </code></span></div> <div class="sqlOuter">:</div> <div class="sqlOuter"> <table class="table_results ajax pma_table"> <thead> <tr> <th class="draggable column_heading pointer marker" style="cursor: move;"><span> <a href="http://localhost/phpMyAdmin/sql.php?db=&amp;table=custs&amp;sql_query=select+%2A+from+custs++%0AORDER+BY+%60custs%60.%60id%60+ASC&amp;session_max_rows=25&amp;is_browse_distinct=0&amp;token=aa78e26d7570f6b7cac6ee8cd85d2f19">id</a> </span></th><th class="draggable column_heading pointer marker"><span> <a href="http://localhost/phpMyAdmin/sql.php?db=&amp;table=custs&amp;sql_query=select+%2A+from+custs++%0AORDER+BY+%60custs%60.%60name%60+ASC&amp;session_max_rows=25&amp;is_browse_distinct=0&amp;token=aa78e26d7570f6b7cac6ee8cd85d2f19">name</a> </span></th><th class="draggable right column_heading pointer marker"><span> <a href="http://localhost/phpMyAdmin/sql.php?db=&amp;table=custs&amp;sql_query=select+%2A+from+custs++%0AORDER+BY+%60custs%60.%60amount%60+ASC&amp;session_max_rows=25&amp;is_browse_distinct=0&amp;token=aa78e26d7570f6b7cac6ee8cd85d2f19">amount</a> </span></th><th class="draggable column_heading pointer marker" style="cursor: move;"><span> <a href="http://localhost/phpMyAdmin/sql.php?db=&amp;table=custs&amp;sql_query=select+%2A+from+custs++%0AORDER+BY+%60custs%60.%60tel%60+ASC&amp;session_max_rows=25&amp;is_browse_distinct=0&amp;token=aa78e26d7570f6b7cac6ee8cd85d2f19">tel</a> </span></th> <td class="print_ignore"><br /></td> </tr> </thead> <tbody> <tr class="odd"> <td class="data text"><span>10001</span></td> <td class="data text "><span>小狗</span></td> <td class="right data nowrap"><span>100</span></td> <td class="data text"><span>233111</span></td> </tr> <tr class="even"> <td class="data text"><span>20002</span></td> <td class="data text "><span>小貓</span></td> <td class="right data nowrap"><span>200</span></td> <td class="data text"><span>233444</span></td> </tr> <tr class="odd"> <td class="data text"><span>30003</span></td> <td class="data text "><span>小牛</span></td> <td class="right data nowrap"><span>300</span></td> <td class="data text"><span>233777</span></td> </tr> </tbody> </table> </div> </div> <p>REF1:<a href="http://oldwww.kmvs.km.edu.tw/lf/index.php?op=ViewArticle&amp;articleId=568&amp;blogId=71">20200302在win10安裝並使用Appserv應用程式伺服程式</a></p> <p><span style="color: #000080;"><span class="headd"><strong><span class="app"><span style="background-color: #ccffcc;">REF2:<a title="Next post: 20200120設計可連線LAMP-MYSQL資料庫伺服器並新增資料庫、資料表、資料錄的PHP程式(c1.php)" href="http://oldwww.kmvs.km.edu.tw/lf/index.php?op=ViewArticle&amp;articleId=558&amp;blogId=70">20200120設計可連線LAMP-MYSQL資料庫伺服器並新增資料庫、資料表、資料錄的PHP程式(c1.php) &raquo;</a></span></span></strong></span></span></p> <p>&nbsp;</p> <p><span style="color: #000080;"><span class="headd"><strong><span class="app"><span style="background-color: #ccffcc;">REF 3:</span></span></strong></span></span><span id="Linux.E6.94.B6.E9.8A.80.E6.A9.9F.E7.B3.BB.E7.B5.B1.E8.A8.AD.E8.A8.88" class="mw-headline">Linux C語言 收銀機系統設計</span></p> <ul> <li><a class="external text" rel="nofollow" href="http://oldwww.kmvs.km.edu.tw/lf/index.php?op=ViewArticle&amp;articleId=436&amp;blogId=70">20181111將貨品資料csv檔轉入ilvssell資料庫的new_goods資料表(程式t19.c)</a> </li> <li><a class="external text" rel="nofollow" href="http://oldwww.kmvs.km.edu.tw/lf/index.php?op=ViewArticle&amp;articleId=435&amp;blogId=70">20181110new_goods貨品基本資料編修程式(t18.c)</a> </li> <li><a class="external text" rel="nofollow" href="http://oldwww.kmvs.km.edu.tw/lf/index.php?op=ViewArticle&amp;articleId=434&amp;blogId=70">20181109顧客csv資料轉入ilvssell資料庫的new_cust資料表程式(t17.c)</a> </li> <li><a class="external text" rel="nofollow" href="http://oldwww.kmvs.km.edu.tw/lf/index.php?op=ViewArticle&amp;articleId=433&amp;blogId=70">20181107new_cust顧客基本資料編修程式(t16.c)</a> </li> <li><a class="external text" rel="nofollow" href="http://oldwww.kmvs.km.edu.tw/lf/index.php?op=ViewArticle&amp;articleId=432&amp;blogId=70">20181105調減new_goods資料表中指定貨品編號(gdsno)的貨品庫存量(stock_qty) t15.c</a> </li> <li><a class="external text" rel="nofollow" href="http://oldwww.kmvs.km.edu.tw/lf/index.php?op=ViewArticle&amp;articleId=431&amp;blogId=70">20181104修改new_cust資料表中某一客戶(custno)的儲值金額(remain) t14.c</a> </li> <li><a class="external text" rel="nofollow" href="http://oldwww.kmvs.km.edu.tw/lf/index.php?op=ViewArticle&amp;articleId=430&amp;blogId=70">20181101在伺服端建立mysql連線用戶並在用戶端用C程式碼連線</a> </li> <li><a class="external text" rel="nofollow" href="http://oldwww.kmvs.km.edu.tw/lf/index.php?op=ViewArticle&amp;articleId=429&amp;blogId=70">20181030在ubuntu用c在mysql ilvssell資料庫建立new_outcome_detail資料表並加入一筆資料(t13.c)</a> </li> <li><a class="external text" rel="nofollow" href="http://oldwww.kmvs.km.edu.tw/lf/index.php?op=ViewArticle&amp;articleId=427&amp;blogId=70">20181026POS1收銀機系統第1步(pos1.c)</a> </li> <li><a class="external text" rel="nofollow" href="http://oldwww.kmvs.km.edu.tw/lf/index.php?op=ViewArticle&amp;articleId=428&amp;blogId=70">20181029在ubuntu用c在mysql ilvssell資料庫建立new_outcome資料表並加入一筆資料(t12.c)</a> </li> <li><a class="external text" rel="nofollow" href="http://oldwww.kmvs.km.edu.tw/lf/index.php?op=ViewArticle&amp;articleId=425&amp;blogId=70">20181010在ubuntu用c在mysql ilvssell資料庫new_id_reg資料表加入一筆資料(t11.c)</a> </li> <li><a class="external text" rel="nofollow" href="http://oldwww.kmvs.km.edu.tw/lf/index.php?op=ViewArticle&amp;articleId=410&amp;blogId=70">20180610在ubuntu用c在mysql ilvssell資料庫建立資料表new_id_reg(t10.c)</a> </li> <li><a class="external text" rel="nofollow" href="http://oldwww.kmvs.km.edu.tw/lf/index.php?op=ViewArticle&amp;articleId=409&amp;blogId=70">20180609在ubuntu用c列出mysql ilvssell資料庫三個資料表的內容(t9.c)</a> </li> <li><a class="external text" rel="nofollow" href="http://oldwww.kmvs.km.edu.tw/lf/index.php?op=ViewArticle&amp;articleId=407&amp;blogId=70">20180608在ubuntu用c在mysql ilvssell資料庫新增一個資料表new_factory並新增一筆資料(t8.c,t7.c)</a> </li> <li><a class="external text" rel="nofollow" href="http://oldwww.kmvs.km.edu.tw/lf/index.php?op=ViewArticle&amp;articleId=406&amp;blogId=70">20180605在ubuntu用c在mysql ilvssell資料庫新增一個資料表new_goods並加入一筆資料(t6.c,t5.c)</a> </li> <li><a class="external text" rel="nofollow" href="http://oldwww.kmvs.km.edu.tw/lf/index.php?op=ViewArticle&amp;articleId=399&amp;blogId=70">20180519在ubuntu建ilvssell資料庫及連線用戶treehrt並新增一個資料表new_cust及二筆資料(t4.c,t3.c,t2.c)</a> </li> <li><a class="external text" rel="nofollow" href="http://oldwww.kmvs.km.edu.tw/lf/index.php?op=ViewArticle&amp;articleId=396&amp;blogId=70">20180517安裝ubuntu mysql c connector並設計一個顯示mysql版本的程式(t1.c)</a> </li> </ul> 一般 2020-03-16T13:26:57Z tree 20200316讓WIN10變成WiFI基地台(行動熱點) http://oldwww.kmvs.km.edu.tw/lf/index.php?op=ViewArticle&articleId=573&blogId=71 <p>(1)工作列/網路圖示/網路和網際網路/行動熱點/開啟/網路名稱用TreeWifi/密碼用<span style="background-color: #ffff99;">12344321</span></p> <p><img src="http://oldwww.kmvs.km.edu.tw/lf/gallery/71/TreeWiFi2.jpg" alt="alt" width="600" height="337" /></p> <p>(2<span style="font-family: 微軟正黑體; font-size: 12pt;">)<span style="font-family: 微軟正黑體; font-size: 12pt;">變更介面卡設定/乙太網路/右鍵內容/共用/<span style="font-family: 微軟正黑體; font-size: 12pt;">勾選「<span style="background-color: #ffff99;">允許其他網路使用者透過這台電腦的網際網路連線來連線</span>」/<span style="font-family: 微軟正黑體; font-size: 12pt;">再勾選「家用網路連線」為新的「<span style="font-family: 微軟正黑體; font-size: 12pt; background-color: #ffff99;"><span style="font-family: 微軟正黑體; font-size: 12pt;"><span style="font-family: 微軟正黑體; font-size: 12pt;"><span style="font-family: 微軟正黑體; font-size: 12pt;">區域連線*n</span></span></span></span>」</span></span></span></span></p> <p><span style="font-family: 微軟正黑體; font-size: 12pt;"><span style="font-family: 微軟正黑體; font-size: 12pt;"><span style="font-family: 微軟正黑體; font-size: 12pt;"><span style="font-family: 微軟正黑體; font-size: 12pt;"><img src="http://oldwww.kmvs.km.edu.tw/lf/gallery/71/TreeWiFi3.jpg" alt="alt" width="423" height="538" /></span></span></span></span></p> <p><span style="font-family: 微軟正黑體; font-size: 12pt;"><span style="font-family: 微軟正黑體; font-size: 12pt;"><span style="font-family: 微軟正黑體; font-size: 12pt;"><span style="font-family: 微軟正黑體; font-size: 12pt;"><br /></span></span></span></span></p> <p><img src="http://oldwww.kmvs.km.edu.tw/lf/gallery/71/TreeWiFi1.jpg" alt="alt" width="600" height="177" /></p> <p>&nbsp;</p> <p><img src="http://oldwww.kmvs.km.edu.tw/lf/gallery/71/TreeWiFi6.jpg" alt="alt" width="476" height="182" /></p> <p>(3)在cmd命令提示字元執行i<span style="background-color: #ffff99;">pconfig</span></p> <p>D:\&gt;ipconfig<br /><br /><span style="background-color: #ffff99;">Windows IP 設定</span><br /><span style="background-color: #ffff99;">無線區域網路介面卡 sTreeWifi:</span><br /><span style="background-color: #ffff99;">&nbsp;&nbsp; 媒體狀態 . . . . . . . . . . . . .: 媒體已中斷連線</span><br /><span style="background-color: #ffff99;">&nbsp;&nbsp; 連線特定 DNS 尾碼 . . . . . . . . :</span><br /><span style="background-color: #ffff99;">:</span></p> <p><span style="background-color: #ffff99;">乙太網路卡 乙太網路:</span><br /><br /><span style="background-color: #ffff99;">&nbsp;&nbsp; 連線特定 DNS 尾碼 . . . . . . . . :</span><br /><span style="background-color: #ffff99;">&nbsp;&nbsp; 連結-本機 IPv6 位址 . . . . . . . : fe80::3995:8785:1041:9888%7</span><br /><span style="background-color: #ffff99;">&nbsp;&nbsp; IPv4 位址 . . . . . . . . . . . . : 192.168.2.111</span><br /><span style="background-color: #ffff99;">&nbsp;&nbsp; 子網路遮罩 . . . . . . . . . . . .: 255.255.255.0</span><br /><span style="background-color: #ffff99;">&nbsp;&nbsp; 預設閘道 . . . . . . . . . . . . .: 192.168.2.1</span><br /><br /><span style="background-color: #ffff99;">無線區域網路介面卡 區域連線* 11:</span><br /><br /><span style="background-color: #ffff99;">&nbsp;&nbsp; 連線特定 DNS 尾碼 . . . . . . . . :</span><br /><span style="background-color: #ffff99;">&nbsp;&nbsp; 連結-本機 IPv6 位址 . . . . . . . : fe80::d8ef:4df2:4128:3a21%41</span><br /><span style="background-color: #ffff99;">&nbsp;&nbsp; IPv4 位址 . . . . . . . . . . . . : 192.168.137.1</span><br /><span style="background-color: #ffff99;">&nbsp;&nbsp; 子網路遮罩 . . . . . . . . . . . .: 255.255.255.0</span><br /><span style="background-color: #ffff99;">&nbsp;&nbsp; 預設閘道 . . . . . . . . . . . . .:</span><br /><br /><span style="background-color: #ffff99;">:</span></p> <p><span style="background-color: #ffff99;"><img src="http://oldwww.kmvs.km.edu.tw/lf/gallery/71/TreeWiFi4.jpg" alt="alt" width="426" height="504" /><br /></span></p> <p><span style="font-size: 18px;">(4-1)防毒軟體的 防火牆 要開啟允許網路連線共享。</span></p> <p><span style="font-size: 18px;">(4-2)</span></p> <p><span style="font-size: 18px;"><img src="http://oldwww.kmvs.km.edu.tw/lf/gallery/71/TreeWiFi7.jpg" alt="alt" width="418" height="520" /><br /></span></p> <p><span style="font-family: 微軟正黑體; font-size: 12pt;"><span style="font-family: 微軟正黑體; font-size: 12pt;"><span style="font-family: 微軟正黑體; font-size: 12pt;"><span style="font-family: 微軟正黑體; font-size: 12pt;"><span style="font-family: 微軟正黑體; font-size: 12pt;"><span style="font-family: 微軟正黑體; font-size: 12pt;"><span style="font-family: 微軟正黑體; font-size: 12pt;"><span style="font-family: 微軟正黑體; font-size: 12pt;">(5-1)在ANDROID手機<span style="font-family: 微軟正黑體; font-size: 12pt;"><span style="font-family: 微軟正黑體; font-size: 12pt;"><span style="font-family: 微軟正黑體; font-size: 12pt;"><span style="font-family: 微軟正黑體; font-size: 12pt;"><span style="font-family: 微軟正黑體; font-size: 12pt;"><span style="font-family: 微軟正黑體; font-size: 12pt;"><span style="font-family: 微軟正黑體; font-size: 12pt;"><span style="font-family: 微軟正黑體; font-size: 12pt;">設定</span></span></span></span></span></span></span></span>TreeWifi採靜態IP(192.168.137.222)如下圖:</span></span></span></span></span></span></span></span></p> <p><span style="font-family: 微軟正黑體; font-size: 12pt;"><span style="font-family: 微軟正黑體; font-size: 12pt;"><span style="font-family: 微軟正黑體; font-size: 12pt;"><span style="font-family: 微軟正黑體; font-size: 12pt;"><span style="font-family: 微軟正黑體; font-size: 12pt;"><span style="font-family: 微軟正黑體; font-size: 12pt;"><span style="font-family: 微軟正黑體; font-size: 12pt;"><span style="font-family: 微軟正黑體; font-size: 12pt;"><img src="http://oldwww.kmvs.km.edu.tw/lf/gallery/71/Screenshot_20200317-200056.png" alt="alt" width="400" height="822" /></span></span></span></span></span></span></span></span></p> <p>(5-2)ios<span style="font-family: 微軟正黑體; font-size: 12pt;"><span style="font-family: 微軟正黑體; font-size: 12pt;"><span style="font-family: 微軟正黑體; font-size: 12pt;"><span style="font-family: 微軟正黑體; font-size: 12pt;"><span style="font-family: 微軟正黑體; font-size: 12pt;"><span style="font-family: 微軟正黑體; font-size: 12pt;"><span style="font-family: 微軟正黑體; font-size: 12pt;"><span style="font-family: 微軟正黑體; font-size: 12pt;">手機<span style="font-family: 微軟正黑體; font-size: 12pt;"><span style="font-family: 微軟正黑體; font-size: 12pt;"><span style="font-family: 微軟正黑體; font-size: 12pt;"><span style="font-family: 微軟正黑體; font-size: 12pt;"><span style="font-family: 微軟正黑體; font-size: 12pt;"><span style="font-family: 微軟正黑體; font-size: 12pt;"><span style="font-family: 微軟正黑體; font-size: 12pt;"><span style="font-family: 微軟正黑體; font-size: 12pt;">設定</span></span></span></span></span></span></span></span>TreeWifi採靜態IP(192.168.137.23)如下圖:</span></span></span></span></span></span></span></span></p> <p><img src="http://oldwww.kmvs.km.edu.tw/lf/gallery/71/1584508011755.jpg" alt="alt" width="400" height="711" /></p> <p><span style="font-family: 微軟正黑體; font-size: 12pt;"><span style="font-family: 微軟正黑體; font-size: 12pt;"><span style="font-family: 微軟正黑體; font-size: 12pt;"><span style="font-family: 微軟正黑體; font-size: 12pt;"><span style="font-family: 微軟正黑體; font-size: 12pt;"><span style="font-family: 微軟正黑體; font-size: 12pt;"><span style="font-family: 微軟正黑體; font-size: 12pt;"><span style="font-family: 微軟正黑體; font-size: 12pt;">(5-3)用手機連TreeWiFi皆上網成功。<br /></span></span></span></span></span></span></span></span></p> <p>&nbsp;</p> <p>參考文章:</p> <p>ref6:<a href="https://www.itread01.com/content/1550256509.html">https://www.itread01.com/content/1550256509.html</a></p> <p>ref5 :<a href="https://a7432186.pixnet.net/blog/post/349363006-%5B%E6%95%99%E5%AD%B8%5D-windows-10-%E7%9A%84%E9%81%A0%E7%AB%AFad-%E4%BC%BA%E6%9C%8D%E5%99%A8%E7%AE%A1%E7%90%86%E5%B7%A5%E5%85%B7%E5%8F%AF%E8%AE%93-">https://a7432186.pixnet.net/blog/post/349363006-%5B%E6%95%99%E5%AD%B8%5D-windows-10-%E7%9A%84%E9%81%A0%E7%AB%AFad-%E4%BC%BA%E6%9C%8D%E5%99%A8%E7%AE%A1%E7%90%86%E5%B7%A5%E5%85%B7%E5%8F%AF%E8%AE%93-</a></p> <p><span style="font-family: 微軟正黑體; font-size: 12pt;">ref4:</span><a href="https://www.google.com/url?sa=t&amp;rct=j&amp;q=&amp;esrc=s&amp;source=web&amp;cd=4&amp;ved=2ahUKEwiYz-n-tpToAhWkI6YKHY-tAtEQFjADegQIAhAB&amp;url=https%3A%2F%2Fblog.xuite.net%2Fyh96301%2Fblog%2F354928369-Windows%2B10%25E7%25AD%2586%25E8%25A8%2598%25E5%259E%258B%25E9%259B%25BB%25E8%2585%25A6%25E8%25A8%25AD%25E5%25AE%259A%25E7%2582%25BA%25E7%2584%25A1%25E7%25B7%259A%25E5%259F%25BA%25E5%259C%25B0%25E5%258F%25B0&amp;usg=AOvVaw3kqU7K-8QOBLZxTTITtF9i">Windows 10筆記型電腦設定為無線基地台@ 軟體使用教學 ...</a></p> <p><span style="font-family: 微軟正黑體; font-size: 12pt;">ref3:</span><a href="https://dodo2001777.pixnet.net/blog/post/321991128-%e8%ae%93%e4%bd%a0%e7%9a%84-win-10%ef%bc%8c%e7%9e%ac%e9%96%93%e8%ae%8a%e6%88%90%e7%84%a1%e7%b7%9a%e7%b6%b2%e8%b7%af%e5%88%86%e4%ba%ab%e5%99%a8">讓你的 win 10,瞬間變成無線網路分享器</a></p> <p>ref2:<a href="https://www.mobile01.com/topicdetail.php?f=504&amp;t=5327471">桌上型電腦如何變成無線WIFI接收</a></p> <p>ref1:<span style="font-family: 微軟正黑體; font-size: 12pt;"><span lang="EN-US"><a href="http://blog.xuite.net/yh96301/blog/227035300" target="_blank">Windows 8<span lang="EN-US"><span lang="EN-US">筆記型電腦自動啟用無線虛擬基地台</span></span></a></span>。</span></p> <p><span style="font-family: 微軟正黑體; font-size: 12pt;">ref7: </span><a href="https://support.hp.com/tw-zh/document/c03547598#AbT0">建立無線家用網路 (Windows 10、8)</a></p> <p>ref8:<a class="title may-blank " style="color: #0078d7; font-family: &amp;quot;Segoe UI&amp;quot;,Helvetica,sans-serif; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; margin-bottom: 1px; margin-right: 0.4em; orphans: 2; outline-color: invert; outline-style: none; outline-width: medium; overflow: hidden; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; padding: 0px;" rel="nofollow" tabindex="1" href="https://www.reddit.com/r/windows/comments/3h266q/windows_cant_set_up_a_homegroup_on_this_computer/">Windows can't set up a homegroup on this computer (Windows 10)</a></p> <p>ref9: <a href="http://www.fox-saying.com/blog/post/43766296">Windows 10 變更 網路類型設定</a></p> 一般 2020-03-12T15:36:06Z tree 20200309在WINDOWS架設檔案傳輸伺服器(採File Transfer Proctocal,FTP通訊協定) http://oldwww.kmvs.km.edu.tw/lf/index.php?op=ViewArticle&articleId=569&blogId=71 <p>在WINDOWS安裝並使用FileZilla Server</p> <p>(1)自<span style="font-family: 微軟正黑體; font-size: 12pt;"><span lang="EN-US"><a href="http://filezilla-project.org/" target="_blank"><span lang="EN-US"><span lang="EN-US">官方網站</span></span></a></span></span>下載<a href="https://filezilla-project.org/download.php?type=server"><span class="external text">FileZilla Server(約2.1MB)</span></a>&nbsp; &nbsp;&nbsp; FileZilla_Server-0_9_60_2.exe 並執行之。</p> <p>&nbsp;</p> <p>(2) 選取全部的安裝組件:</p> <p>&nbsp;&nbsp; FileZilla Server(Service)、Administrator interface、Source Code、&nbsp;&nbsp; Start Menu Shortcuts、Desktop Icon</p> <p>&nbsp;</p> <p>(3)接受預設安裝資料夾為<span style="background-color: #ffff00;">C:\Program Files\FileZilla Server</span></p> <p>&nbsp;</p> <p>(4)接受「Install as service,started with Windows(default)」及管理者埠號:14147並</p> <p>&nbsp;&nbsp;&nbsp;&nbsp; 勾選「Start server after setup completes」</p> <p>&nbsp;</p> <p>(5)接受「Start manually」的SERVER介面&nbsp; 並勾選「Start Interface after setup completes」</p> <p>&nbsp;</p> <p>(6)安裝成功出現 server Interface(伺服器管理介面)</p> <p>&nbsp;</p> <p>(7)接受localhost及14147埠號 出現如下失敗訊息</p> <p>:</p> <p><span style="background-color: #ffff00;">Connecting to server localhost:14147...</span><br /><span style="background-color: #ffff00;">Error, could not connect to server</span></p> <p>&nbsp;</p> <p>(8) 控制台/系統及安全性/允許程式通過防火牆/允許其他程式/瀏覽/挑選C:\Program Files\FileZilla Server\FileZilla Server.exe</p> <p>&nbsp;</p> <p>(9)登入server Interface成功,出現如下訊息及下圖的伺服器管理介面視窗:</p> <p>FileZilla Server 0.9.60 beta</p> <p>:</p> <p>Connecting to server localhost:14147...<br />Connected, waiting for authentication<br />Logged on<br /><span style="background-color: #ffcc00;">You appear to be behind a NAT router. Please configure the passive mode settings and forward a range of ports in your router.</span><br /><span style="background-color: #ffcc00;">Warning: FTP over TLS is not enabled, users cannot securely log in.</span></p> <p>:</p> <p><img src="http://oldwww.kmvs.km.edu.tw/lf/gallery/71/ftpServerInterface.png" alt="alt" width="600" height="586" /></p> <p>&nbsp;</p> <p>(10)伺服器管理介面/Edit/Setting/FTP over TLS settings/勾FTP over TLS support/Generate new certificate...</p> <p><img src="http://oldwww.kmvs.km.edu.tw/lf/gallery/71/setFTPoverTLS.png" alt="alt" width="600" height="416" /></p> <p>(11-1)輸入如下欄位後/[Generate certificate]鈕</p> <p><img src="http://oldwww.kmvs.km.edu.tw/lf/gallery/71/mkftpcrt.png" alt="alt" width="406" height="441" /></p> <p>(11-2)執行cmd/輸入指令&nbsp; <span style="background-color: #ffff00;">type c:\certificate.crt </span>結果如下:</p> <p>C:\&gt;<span style="background-color: #ffff99;">type c:\certificate.crt</span><br /><span style="background-color: #ffff99;">-----BEGIN RSA PRIVATE KEY-----</span><br /><span style="background-color: #ffff99;">MIIC7AIBAAKBoQC+WE/W+Txh2/m+lpglCZT/cWWhM90q2LLTCjgWopTACUIXgsE+</span><br /><span style="background-color: #ffff99;">oR3SOp2TE18vWMDmCB37FKqIQEz4sD1Cv+VpVdDXxocZTKw/eFU8i6lmjVw698T+</span><br /><span style="background-color: #ffff99;">4eiST1nrbMY7Lh0lufFSnteSPt8xcLZ6ClZKWfwEvf7/Prlsa4jF8uPR/wsVl4+m</span><br /><span style="background-color: #ffff99;">T9igAa6jSFu9qgQYe1Hja8BIyF3/1O89nxodAgMBAAECgaEApjuUBoeGL2SgeM0m</span><br /><span style="background-color: #ffff99;">NHpo0Kmk+yLDTY8QpXRwRXxZcljjiorb36lv1NDyGqc5Yq0dUgfWvxduUy3syueH</span><br /><span style="background-color: #ffff99;">qMrUPKkAieFMzVCDwa6CqizCldbvGI9484mZaa8422OxLhMCMHOin2EhQIPuDYy2</span><br /><span style="background-color: #ffff99;">ht74wj1A1e7cuZc6dj3FZRkheGs1h1jkRXan5YA1iRBzk0p9qtxY1pZyR+Vh/sJT</span><br /><span style="background-color: #ffff99;">1XjylQJRAN4wBtJLxJ+lLUe1mUyMO295ic1T71FN1dWVsmwcmVVfhd5pQcNMCJtE</span><br /><span style="background-color: #ffff99;">A2A80vwHELFfFWarD3fmqFX9yg5IUwEJ/XdhdAQ8dk2qTm3zCBs3AlEA20/C7gH2</span><br /><span style="background-color: #ffff99;">c80Zwh4nVB85GMfIDdUG9vOmGhoUCJJ5GLUFWOgguv5Zl1v9kIK558tyZXS60GoI</span><br /><span style="background-color: #ffff99;">p3uaCTn2kGPrB7PHaO40E9jwTXVkgBEUZ0sCUGsGF0MU3BFKLxVrk/wbUEXR9V7C</span><br /><span style="background-color: #ffff99;">H3S6WVYYVWleHT3SVVlcuiCobzza9gVVRwu/G3tUoapim4DVyiAhr0JR9Cl79mua</span><br /><span style="background-color: #ffff99;">tZeUyCeA8WZkunLhAlBjuNkCMJJIBbL4uY1YivoDcpRc9ci88f1NUR5a53945JcR</span><br /><span style="background-color: #ffff99;">3jtDy/QhBws9crPl2nSh/XoU2qIkxec82sZq0YRFdFHwPKAhhjt+fSq9sQZ+EQJQ</span><br /><span style="background-color: #ffff99;">N5inYuSHwC/QhsksSZ0JD1vzSBwBn50y0AUcZ33VeT1BZAlfWF2DW1s6HBPMvgtV</span><br /><span style="background-color: #ffff99;">6jDHEE4T1PWcnqC8joEDQQFSvja25owvuSr9VlNpfi8=</span><br /><span style="background-color: #ffff99;">-----END RSA PRIVATE KEY-----</span><br /><span style="background-color: #ffff99;">-----BEGIN CERTIFICATE-----</span><br /><span style="background-color: #ffff99;">MIICxzCCAhCgAwIBAgIEVlaifTANBgkqhkiG9w0BAQsFADCBhzESMBAGA1UEAwwJ</span><br /><span style="background-color: #ffff99;">bG9jYWxob3N0MQswCQYDVQQGEwJUVzEPMA0GA1UECAwGVGFpd2FuMQ8wDQYDVQQH</span><br /><span style="background-color: #ffff99;">DAZraW5tZW4xDTALBgNVBAoMBEtNVlMxETAPBgNVBAsMCHJlc2VhcmNoMSAwHgYJ</span><br /><span style="background-color: #ffff99;">KoZIhvcNAQkBFhF0cmVlaHJ0QGdtYWlsLmNvbTAeFw0yMDAzMDkxMzMyNTlaFw0y</span><br /><span style="background-color: #ffff99;">MTAzMDkxMzMyNTlaMIGHMRIwEAYDVQQDDAlsb2NhbGhvc3QxCzAJBgNVBAYTAlRX</span><br /><span style="background-color: #ffff99;">MQ8wDQYDVQQIDAZUYWl3YW4xDzANBgNVBAcMBmtpbm1lbjENMAsGA1UECgwES01W</span><br /><span style="background-color: #ffff99;">UzERMA8GA1UECwwIcmVzZWFyY2gxIDAeBgkqhkiG9w0BCQEWEXRyZWVocnRAZ21h</span><br /><span style="background-color: #ffff99;">aWwuY29tMIG/MA0GCSqGSIb3DQEBAQUAA4GtADCBqQKBoQC+WE/W+Txh2/m+lpgl</span><br /><span style="background-color: #ffff99;">CZT/cWWhM90q2LLTCjgWopTACUIXgsE+oR3SOp2TE18vWMDmCB37FKqIQEz4sD1C</span><br /><span style="background-color: #ffff99;">v+VpVdDXxocZTKw/eFU8i6lmjVw698T+4eiST1nrbMY7Lh0lufFSnteSPt8xcLZ6</span><br /><span style="background-color: #ffff99;">ClZKWfwEvf7/Prlsa4jF8uPR/wsVl4+mT9igAa6jSFu9qgQYe1Hja8BIyF3/1O89</span><br /><span style="background-color: #ffff99;">nxodAgMBAAEwDQYJKoZIhvcNAQELBQADgaEAG+4Noxs+97datn60lR5ai4Hek329</span><br /><span style="background-color: #ffff99;">cqPYpeO9HTQufTjoRSYw0uFbuHdnHkHz2QX64JN5ArYC1x5MuGIfve/cz9T2SxVh</span><br /><span style="background-color: #ffff99;">OyPHDqXwGdjZD7e6IO+USrjIeIqMvBYSBU9aN8FP2lrJFE0g3C7vIJhpmUp0ajJT</span><br /><span style="background-color: #ffff99;">5dkUSURgISlHSaDt/7ZqTy/NkYdFoh/OWBRTrbCbzfQ9jc6dO4IJuosbpg==</span><br /><span style="background-color: #ffff99;">-----END CERTIFICATE-----</span></p> <p>(11-3)如上啟動支援TLS加密後,就不再有如下警告訊息 「<span style="background-color: #ffcc00;">Warning: FTP over TLS is not enabled, users cannot securely log in.」</span></p> <p>(12)在伺服器管理介面建立一個用戶帳號bear如下: 伺服器管理介面/edit/user/ADD/建立帳號 bear, 密碼給abc123abc123,家目錄給d:\,權限全給</p> <p><img src="http://oldwww.kmvs.km.edu.tw/lf/gallery/71/ftpUserAdd.png" alt="alt" width="600" height="403" /></p> <p>&nbsp;</p> <p>(13-1)執行cmd/輸入ftp localhost/以帳密bear、abc123abc123登入ftp命令模式成功,詳如下圖。</p> <p>(13-2)輸入dir命令查詢遠端主機的檔案列表,詳如下圖。</p> <p>(13-3)輸入quit 離開ftp命令模式,詳如下圖。</p> <p><img src="http://oldwww.kmvs.km.edu.tw/lf/gallery/71/cmdftpclient.png" alt="alt" width="663" height="730" /></p> <p>(14)用伺服器管理介面修改bear帳號的用戶目錄為c:\appserv\www</p> <p>(15)用小畫家畫一隻台灣黑熊並存在桌面為bear.jpg</p> <p>(16)下載並安裝<a href="https://filezilla-project.org/download.php?platform=win64">fiilezilla client</a></p> <p>(17)用filezilla client 連線本機ftp伺服器,並用bear帳號登入,將桌面的bear.jpg上傳到bear帳號中。</p> <p>(18)連http://localhost/bear.jpg成功。</p> <p>REF:</p> <p><a href="http://dotnetmis91.blogspot.com/2010/06/windows-7-filezilla-server-ftp.html">http://dotnetmis91.blogspot.com/2010/06/windows-7-filezilla-server-ftp.html</a></p> <ul> <li><a class="external text" rel="nofollow" href="https://blog.xuite.net/yh96301/blog/62868611-%E5%85%8D%E8%B2%BB%E7%9A%84FTP%E4%BC%BA%E6%9C%8D%E5%99%A8FileZilla+Server">安裝並使用FileZilla Server</a> </li> <li><span style="font-family: 微軟正黑體; font-size: 12pt;"><span lang="EN-US"><a href="http://blog.xuite.net/yh96301/blog/62869022" target="_blank">FileZilla Server<span lang="EN-US"><span lang="EN-US">設定</span></span>Windows<span lang="EN-US"><span lang="EN-US">的防火牆</span></span></a></span>。</span></li> </ul> 一般 2020-03-03T07:38:27Z tree 20200302在win10安裝並使用Appserv應用程式伺服程式 http://oldwww.kmvs.km.edu.tw/lf/index.php?op=ViewArticle&articleId=568&blogId=71 <p><strong>(1)下載並安裝<a href="http://prdownloads.sourceforge.net/appserv/appserv-win32-8.5.0.exe?download">appserv-win32-8.5.0.exe</a> 32位元版(約104MB,WIN7適用)</strong></p> <p><strong>Download :&nbsp;</strong><a href="http://prdownloads.sourceforge.net/appserv/appserv-win32-8.5.0.exe?download">http://prdownloads.sourceforge.net/appserv/appserv-win32-8.5.0.exe?download</a></p> <p>(2)執行<span style="background-color: #ffff00;"><strong><a href="http://prdownloads.sourceforge.net/appserv/appserv-win32-8.5.0.exe?download">appserv-win32-8.5.0.exe</a>&nbsp; </strong><span style="background-color: #ffffff;">來安裝應用程式伺服程式:</span></span></p> <p>(3)選c:\APPSERV</p> <p>(4)接受如下安裝組件「Apache HTTP Server,My SQL Database,PHP HyperText Preprocessor ,phpMyAdmin 」</p> <p>(5)裝VC-11 RUNTIME DLL</p> <p>(6)裝VC-14 RUNTIME DLL</p> <p>(7)接受「localhost」為伺服器名稱,管理者EMAIL給 ox@mail.edu.tw</p> <p>http PORT :80&nbsp;&nbsp; https 埠號:443</p> <p>(8)MYSQL root密碼給<span style="background-color: #ffff99;">abc123abc123</span>,</p> <p>&nbsp; &nbsp;Character Sets接受<span style="background-color: #ffff99;">UTF-8 UNICODE</span></p> <p>(9)安裝完成並啟用<span style="background-color: #ffff99;">apache</span>及<span style="background-color: #ffff99;">mysql server <br /></span></p> <p>(10)<span style="background-color: #ffff99;">允許</span>windows防火牆「<span style="background-color: #ffff99;">存取</span>Apache HTTP Server」</p> <p>&nbsp;&nbsp;&nbsp;&nbsp; 程式路徑:c:\appserv\apache24\bin\httpd.exe</p> <p>(11)放一小狗圖檔dog.png 在C:\AppServ\www</p> <p>(12)用firefox 連 http://localhost/dog.png成功看到小狗圖檔</p> <p>(13)用firefox 連 http://localhost,於系統預設首頁</p> <p>選取<span style="color: #000080;"><span class="headd"><strong><span class="app"><a href="http://localhost/phpMyAdmin/">phpMyAdmin Database Manager Version 4.6.4</a></span></strong></span></span></p> <p>(14)輸入root帳密之後,登入後出現的MYSQL資料庫管理畫面如下:</p> <p><img src="http://oldwww.kmvs.km.edu.tw/lf/gallery/71/20200302phpMyAdmin.png" alt="alt" width="600" height="450" /></p> <p>(w-1)製作如下背景透明的動物圖案並存在桌面為wild.png</p> <p>(w-2)啟動GIMP/按CTRL+N/圖片尺寸寬600、高800/進階「填上/透明」。</p> <p>(w-3)左上工具區選「鉛筆工具」</p> <p>(w-4)左上工具區/「前景」挑「紫色」</p> <p>(w-5)右上「筆刷」挑「最大的實心圓」</p> <p>(w-6)用滑鼠在工作區繪出一隻紫色線的動物</p> <p>(w-7)按CTRL+E將工作區匯出到C:\AppServ\www,檔名為wild.png。</p> <p>(w-8)用記事本編寫如下「六行HTML文字」並存檔在C:\AppServ\www為wild.htm</p> <p>(w-9)用firefox瀏覽http://localhost/wild.htm的結果如下:</p> <p><img src="http://oldwww.kmvs.km.edu.tw/lf/gallery/70/20200106wild.png" alt="alt" width="600" height="351" /></p> <p>&nbsp;</p> <p>REF 1: <a class="external text" rel="nofollow" href="http://oldwww.kmvs.km.edu.tw/lf/index.php?op=ViewArticle&amp;articleId=553&amp;blogId=70">20191224在win10下載、安裝並使用Appserv9.3.0應用程式伺服程式</a></p> 一般 2020-03-02T11:35:54Z tree 20200106數位科技概論期末上機考「電腦繪圖與網頁設計」軟體操作 http://oldwww.kmvs.km.edu.tw/lf/index.php?op=ViewArticle&articleId=556&blogId=71 <p>(1)請參考如下文章「<a href="http://oldwww.kmvs.km.edu.tw/lf/index.php?op=ViewArticle&amp;articleId=552&amp;blogId=71">20191223數位科技概論作業-安裝並使用GIMP,PhotoImpactX3,Notepad</a>」,製作三個指定的<span style="font-size: small;">檔案(c1.xcf,c2.uf0,c3.htm)</span>。</p> <p>&nbsp;</p> <p><span style="font-family: Liberation Serif, serif;"><span style="font-size: small;"><span lang="en-US">(2) </span></span></span><span style="font-size: small;">將以上三個<span style="font-size: small;">檔案</span>的操作畫面用</span><span style="font-family: Liberation Serif, serif;"><span style="font-size: small;"><span lang="en-US"><span style="font-size: small;"><span style="background: #ffff99;">PrtScr</span></span></span></span></span><span style="font-size: small;">鍵 抓入</span><span style="font-family: Liberation Serif, serif;"><span style="font-size: small;"><span lang="en-US"><span style="font-size: small;">LibreOffice </span></span></span></span><span style="font-size: small;">的</span><span style="font-family: Liberation Serif, serif;"><span style="font-size: small;"><span lang="en-US"><span style="font-size: small;">writer</span></span></span></span><span style="font-size: small;">中並存檔為「</span><span style="font-family: Liberation Serif, serif;"><span style="font-size: small;"><span lang="en-US"><span style="font-size: small;">20200106</span></span></span></span><span style="font-size: small;">商一你號你名</span><span style="font-family: Liberation Serif, serif;"><span style="font-size: small;"><span lang="en-US"><span style="font-size: small;">.odt</span></span></span></span><span style="font-size: small;">」,並再&nbsp;匯出為</span><span style="font-family: Liberation Serif, serif;"><span style="font-size: small;"><span lang="en-US"><span style="font-size: small;">PDF</span></span></span></span><span style="font-size: small;">檔</span><span style="font-family: Liberation Serif, serif;"><span style="font-size: small;"><span lang="en-US"><span style="font-size: small;">(</span></span></span></span><span style="font-size: small;">檔名會</span><span style="font-size: small;">自動取用</span><span style="font-family: Liberation Serif, serif;"><span style="font-size: small;"><span lang="en-US"><span style="font-size: small;">odt</span></span></span></span><span style="font-size: small;">檔的主檔名</span><span style="font-family: Liberation Serif, serif;"><span style="font-size: small;"><span lang="en-US"><span style="font-size: small;">)</span></span></span></span><span style="font-size: small;">,詳細內容格式請參如下二範例檔:</span><span style="font-family: Liberation Serif, serif;"><span style="font-size: small;"><span lang="en-US"><span style="font-size: small;">(</span></span></span></span><span style="font-family: Liberation Serif, serif;"><span style="font-size: small;"><span lang="en-US"><span style="font-size: small;"><span style="background: #ffff99;">PrtScr</span></span></span></span></span><span style="font-size: small;">鍵在</span><span style="font-family: Liberation Serif, serif;"><span style="font-size: small;"><span lang="en-US"><span style="font-size: small;">F12</span></span></span></span><span style="font-size: small;">鍵的右邊</span><span style="font-family: Liberation Serif, serif;"><span style="font-size: small;"><span lang="en-US"><span style="font-size: small;">)</span></span></span></span></p> <p>20200106商經一49號吳小花Gimp與PhotoImpact電腦繪圖及Notepad網頁表格.odt<a href="http://oldwww.kmvs.km.edu.tw/lf/gallery/71/20200106%E5%95%86%E7%B6%93%E4%B8%8049%E8%99%9F%E5%90%B3%E5%B0%8F%E8%8A%B1Gimp%E8%88%87PhotoImpact%E9%9B%BB%E8%85%A6%E7%B9%AA%E5%9C%96%E5%8F%8ANotepad%E7%B6%B2%E9%A0%81%E8%A1%A8%E6%A0%BC.odt"> 下載</a></p> <div id="album">20200106商經一49號吳小花Gimp與PhotoImpact電腦繪圖及Notepad網頁表格.pdf<a href="http://oldwww.kmvs.km.edu.tw/lf/gallery/71/20200106%E5%95%86%E7%B6%93%E4%B8%8049%E8%99%9F%E5%90%B3%E5%B0%8F%E8%8A%B1Gimp%E8%88%87PhotoImpact%E9%9B%BB%E8%85%A6%E7%B9%AA%E5%9C%96%E5%8F%8ANotepad%E7%B6%B2%E9%A0%81%E8%A1%A8%E6%A0%BC.pdf">下載</a></div> <p><br /> <br /></p> 一般 2019-12-31T16:00:44Z tree 20191223數位科技概論作業-安裝並使用GIMP,PhotoImpactX3,Notepad http://oldwww.kmvs.km.edu.tw/lf/index.php?op=ViewArticle&articleId=552&blogId=71 <div> <p>(1a)參考如下文章安裝新酷音及蝦米輸入法:</p> <p><a class="external text" rel="nofollow" href="http://oldwww.kmvs.km.edu.tw/lf/index.php?op=ViewArticle&amp;articleId=535&amp;blogId=70">20191119在WINDOWS安裝PIME新酷音輸入程式並使用蝦米輸入法</a></p> <p><span style="font-size: 13px;">(1b)PIME新酷音輸入程式<span style="font-size: 13px;"> 下載</span>&nbsp; <a class="d-flex flex-items-center min-width-0" rel="nofollow" href="https://github.com/EasyIME/PIME/releases/download/v1.1.0/PIME-1.1.0-setup.exe"><span class="pl-2 flex-auto min-width-0 text-bold">PIME-1.1.0-setup.exe</span></a>&nbsp; (約24MB)</span></p> <p>(1c)<a href="https://www.csie.ntu.edu.tw/~b92025/liu/liu-uni.tab"><span style="font-size: 13px;"><span style="font-size: 13px;">&nbsp;</span></span>liu-uni.tab&nbsp; </a><a href="https://www.csie.ntu.edu.tw/~b92025/liu/liu-uni.tab"><span style="font-size: 13px;"><span style="font-size: 13px;">下載 (</span></span></a><a href="https://www.csie.ntu.edu.tw/~b92025/liu/liu-uni.tab">136K)</a></p> <p>&nbsp;</p> <p>(1d)用GIMP輸入如下文字並存檔為d:\c1.xcf(如沒有GIMP請下載<a href="https://download.gimp.org/mirror/pub/gimp/v2.10/windows/gimp-2.10.14-setup.exe">GIMP</a>並安裝之)。</p> <p><img src="http://oldwww.kmvs.km.edu.tw/lf/gallery/70/A10.png" alt="alt" width="600" height="450" /></p> <p>(2)用PhotoImpact 輸入如下內容並存檔為d:\c2.ufo</p> </div> <div><img src="http://oldwww.kmvs.km.edu.tw/lf/gallery/70/A4.png" alt="alt" width="600" height="450" /></div> <div>(3)用notepad記事本 輸入如下內容並存檔為d:\c3.htm(存檔類型要選所有檔案)並用firefox打開c3.htm</div> <div><img src="http://oldwww.kmvs.km.edu.tw/lf/gallery/70/A5.png" alt="alt" width="600" height="450" /></div> <p>&nbsp;</p> 一般 2019-12-23T13:20:21Z tree 20191216數位科技概論第4次上機作業-安裝並使用LibreOffice並將結果抓入writer再轉存為pdf再上傳至「金門農工學生學習歷程系統」 http://oldwww.kmvs.km.edu.tw/lf/index.php?op=ViewArticle&articleId=546&blogId=71 <p>(1a)參考如下文章安裝新酷音及蝦米輸入法:<a class="external text" rel="nofollow" href="http://oldwww.kmvs.km.edu.tw/lf/index.php?op=ViewArticle&amp;articleId=535&amp;blogId=70">20191119在WINDOWS安裝PIME新酷音輸入程式並使用蝦米輸入法</a></p> <p><span style="font-size: 13px;">(1b)PIME新酷音輸入程式<span style="font-size: 13px;"> 下載</span>&nbsp; <a class="d-flex flex-items-center min-width-0" rel="nofollow" href="https://github.com/EasyIME/PIME/releases/download/v1.1.0/PIME-1.1.0-setup.exe"><span class="pl-2 flex-auto min-width-0 text-bold">PIME-1.1.0-setup.exe</span></a>&nbsp; (約24MB)</span>&nbsp;</p> <p>(1c)<a href="https://www.csie.ntu.edu.tw/~b92025/liu/liu-uni.tab"><span style="font-size: 13px;"><span style="font-size: 13px;">&nbsp;</span></span>liu-uni.tab&nbsp; </a><a href="https://www.csie.ntu.edu.tw/~b92025/liu/liu-uni.tab"><span style="font-size: 13px;"><span style="font-size: 13px;">下載 (</span></span></a><a href="https://www.csie.ntu.edu.tw/~b92025/liu/liu-uni.tab">136K)</a></p> <p>&nbsp;</p> <p>(2)自 https://zh-tw.libreoffice.org/download/<a href="https://www.libreoffice.org/download/download/">下載LibreOffice 6.3.3安裝程式</a>(LibreOffice_6.3.3_Win_x64.msi, 303MB)並安裝之.</p> <p>&nbsp;</p> <p>(3)用LibreOffice Writer 輸入如下內容並存檔為d:\a6.odt(參考20191120安裝並使用LibreOfficeWriter.odt<a href="http://web.kmvs.km.edu.tw/lf/gallery/70/20191120%E5%AE%89%E8%A3%9D%E4%B8%A6%E4%BD%BF%E7%94%A8LibreOfficeWriter.odt"> 下載</a> (200 KB))</p> <p>(註:按WIN鍵再輸入writer即可點選執行writer)</p> <div><img src="http://oldwww.kmvs.km.edu.tw/lf/gallery/70/A6.png" alt="alt" width="600" height="431" /></div> <div> <p>(4)用LibreOffice CALC 輸入如下內容並存檔為d:\a7.ods(參考20191120安裝並使用LibreOfficeCALC.ods<a href="http://web.kmvs.km.edu.tw/lf/gallery/70/20191120%E5%AE%89%E8%A3%9D%E4%B8%A6%E4%BD%BF%E7%94%A8LibreOfficeCALC.ods">下載</a> (118 KB))</p> <p>(註:按WIN鍵再輸入calc即可點選執行calc)</p> <p><img src="http://oldwww.kmvs.km.edu.tw/lf/gallery/70/A7.png" alt="alt" width="400" height="301" /></p> <div>(5)用LibreOffice Impress 輸入如下內容並存檔為d:\a8.odp</div> <div>(註:按WIN鍵再輸入impress即可點選執行impress)</div> <p><img src="http://oldwww.kmvs.km.edu.tw/lf/gallery/70/A8.png" alt="alt" width="600" height="431" /></p> <p>&nbsp;</p> <p>(5) <span style="font-size: small;">將以上三個文件檔的操作畫面用<span style="background-color: #ffff99;">ALT+PrtScr</span>鍵抓入LibreOffice 的writer中並存檔為「20191216商一你號你名.odt」,並再&nbsp;匯出為PDF檔(檔名為「20191216商一你號你名.pdf」,自動取用odt檔的主檔名),詳細內容格式請參如下二範例檔:(<span style="font-size: small;"><span style="font-size: small;"><span style="background-color: #ffff99;"><span style="font-size: small;"><span style="font-size: small;"><span style="background-color: #ffff99;">ALT</span>鍵在空白鍵的二邊,</span></span>PrtScr</span>鍵在F12鍵的右邊)</span></span></span></p> <p><span style="font-size: small;">「<a href="http://oldwww.kmvs.km.edu.tw/lf/gallery/71/20191212%E5%95%86%E7%B6%93%E4%B8%8049%E8%99%9F%E5%90%B3%E5%B0%8F%E8%8A%B1%E5%98%B8%E8%9D%A6%E7%B1%B3%E4%B8%AD%E6%96%87%E8%BC%B8%E5%85%A5%E8%88%87LibreOffice%E6%93%8D%E4%BD%9C%E7%B5%90%E6%9E%9C.odt">20191212商經一49號吳小花嘸蝦米中文輸入與LibreOffice操作結果.odt</a>(438 KB)」</span></p> <p><span style="font-size: small;">「<a href="http://oldwww.kmvs.km.edu.tw/lf/gallery/71/20191212%E5%95%86%E7%B6%93%E4%B8%8049%E8%99%9F%E5%90%B3%E5%B0%8F%E8%8A%B1%E5%98%B8%E8%9D%A6%E7%B1%B3%E4%B8%AD%E6%96%87%E8%BC%B8%E5%85%A5%E8%88%87LibreOffice%E6%93%8D%E4%BD%9C%E7%B5%90%E6%9E%9C.pdf">20191212商經一49號吳小花嘸蝦米中文輸入與LibreOffice操作結果.pdf(274 KB)</a>」。</span></p> <p>&nbsp;</p> <p>(6)請把(5)所產生的PDF檔上傳至<a id="C-1226" class="tab-ctl-x" title="學生學習歷程系統(另開啟新視窗)" tabindex="0" href="http://stu.kmvs.km.edu.tw/Ncnu_EPortfolio" target="_blank"><span>「金門農工學生學習歷程系統</span></a>」成為你的數位科技學習檔案。</p> <p>&nbsp;</p> <p>(7)ODF 開放文件格式(Open Document Format):</p> <p>(7-1)<a id="who-should-read-section" href="http://www.oasis-open.org/committees/download.php/12572/OpenDocument-v1.0-os.pdf"><tt class="systemitem">http://www.oasis-open.org/committees/download.php/12572/OpenDocument-v1.0-os.pdf</tt></a></p> <p>(7-2)<a href="http://books.evc-cit.info/books/odbook/book.html">http://books.evc-cit.info/books/odbook/book.html</a></p> <p>&nbsp;</p> <p>(8)請勤練如下「嘸蝦米中文輸入法」拆碼CAI程式(常用字測驗速度要10個字/分)</p> <p>下載點:<a href="http://boshiamy.com/dl/LiuEasyLearn.exe">http://boshiamy.com/dl/LiuEasyLearn.exe</a></p> </div> 一般 2019-12-09T20:48:39Z tree 20191209數位科技概論第3次上機作業-在MS-word,excel,powerpoint中使用新酷音蝦米中文輸入法。 http://oldwww.kmvs.km.edu.tw/lf/index.php?op=ViewArticle&articleId=545&blogId=71 <p>(1)參考如下文章安裝新酷音及蝦米輸入法:</p> <p><a class="external text" rel="nofollow" href="http://oldwww.kmvs.km.edu.tw/lf/index.php?op=ViewArticle&amp;articleId=535&amp;blogId=70">20191119在WINDOWS安裝PIME新酷音輸入程式並使用蝦米輸入法 <br /></a></p> <p>&nbsp;</p> <p>(2)請執行ms-office word並輸入如下內容並存檔為d:\a1.docx</p> <p><img src="http://oldwww.kmvs.km.edu.tw/lf/gallery/70/A1.png" alt="alt" width="600" height="431" /></p> <p>&nbsp;</p> <p>&nbsp;(3)請執行ms-office excel並輸入如下內容並存檔為d:\a2.xlsx</p> <p><img src="http://oldwww.kmvs.km.edu.tw/lf/gallery/70/A2.png" alt="alt" width="600" height="450" /></p> <p>&nbsp;</p> <p>&nbsp;(4)請執行ms-office powerpoint並輸入如下內容並存檔為d:\a3.pptx</p> <p><img src="http://oldwww.kmvs.km.edu.tw/lf/gallery/70/A3.png" alt="alt" width="600" height="431" /></p> <p>&nbsp;</p> <p>&nbsp;</p> 一般 2019-12-07T16:08:32Z tree