2013年6月19日 星期三
日記 2013/6/19 10:19
最近這幾天都在忙著學校的期末考科目，在前幾天的考試中已經將比較重要的科目解決了，而在這周的四、五所要考的科目則較為簡單，只要再稍微複習就能獲得高分，在這幾個理應忙碌的日子裡卻顯得十分空閒，幸好早在幾個禮拜前就對所有考試科目有所準備，真正要忙碌的是接下來暑假開始的幾件事項，首先是舉辦最後一次的ITSA競賽，還有幫助學校主任建置一個環境，能讓九組專題生能夠互相交流及分享的網頁，希望由我自己去撰寫並給老師指導，緊接著七月三號要去長庚大學比賽程式，在這之後就是暑假的空閒時期，我可以自己安排自己的行程，來為將來忙碌的三年級做準備，可以的話希望能多考幾張證照，以及事先準備專題的各種專業技術。
2013年6月16日 星期日
日記 2013/6/16 11:28
經過這幾天的英文寫作日記，不得不承認對於文章的結構和組織幫助有限，僅有的好處只在於英文單字的找尋以及使用，對於英文文法的成長也毫無幫助，看來對於英文方面的增進目前只能著手於閱讀和聽力了，在鋪浪上有一位同學很喜歡寫關於甜不辣的腐女小說，重點不再小說內容而是在於文字描述方式以及鋪陳，閱讀下來讓人有身歷其境的感覺，這興許就是文章寫作的神奇之處，希望以後我也能夠培養成這樣的能力，在事件的細節與描述著手、慢慢鋪陳摹寫狀態，發揮出語言最大的力量就是文章的魅力吧，見微知著則是更高的作文境界了，希望在放假的時候能夠更加培養關於中文與英文的語言能力，最好是在說與寫方面能夠更加進步，對於以後工作以及專題企畫案的製作更有幫助。
2013年6月15日 星期六
Diary 2013/6/15 10:55
It's very rare that someone ask me questions in college, but in the last two times that really angry me. The first thing is one girl want to ask me for programming problem, but she had bad attitude in the words. The question is about a function in the C language, she wanted to know what is the function principle. And I said just to use by the format, don't try to know everything about it. Then she answer "Ok! Ok! Ok! genius senior." immediately, the sentence stimulate my temper. the other thing occurrence in today, also a girl want to know the problem of database manage's final exam's content. The girl's logic is very strange and take wrong answer to ask, not anyone questions is really an problem worth to solve. She only want the result of subject, keep waste my time in odd problem.
2013年6月14日 星期五
Diary 2013/6/14 10:49
It's a leisure day that only multimedia production in one day and don't study after class. After relax for a long time, I start to install eclipse JDK to linux ubuntu. The detail of install all follow by the web and only have some bug in it. And the other thins is about my girlfriend, she is in a very exciting mood just want to chat with me. She is crazy in the recent days, I feel a little puzzle by the situation. What can I do to alter the condition? Should I give her some protest about my feeling, or just let it go. Only she happy is all don't matter what I feel. That's the total detail in today.
2013年6月13日 星期四
Diary 2013/6/13 9:55
My Sony's notebook has double system of Windows 7 and Linux Ubuntu in finally. It take me much time to partition the the 500 GB disk, set the three section use by Win 7 and the others for the Ubuntu, swap disk and data store. In yesterday, I made a mistake in change the 80 GB section to swap that make system overhead. Today I reset the hard disk by win 7's application, and start to install Linux Ubuntu in the new partition. When the time after install, I use the terminal to key some instruction but don't have enough privilege to execute. Therefore I found the sudoers.txt and attempt to overwrite the administrate member by add my name and privilege, but the text property is read-only so I am fault to overwrite final. However, shutdown the system and restart it after I take a nap, the sudo instruction become ordinary situation. After all, I update of Linux Ubuntu and download series of software that I use to in win 7,and I press the shut down button to close system. The amazing things happen is nothing happen at all, I think the function of shut down may damage, Hope it can recover by the next time I open it.
2013年6月12日 星期三
Diary 2013/6/12 9:29
Today my final exam's three major subject is already in entirely preparing. the database manage, operation system and English are all in ready, and object-oriented, worldwide civilization and cultural relic could be open book in the examine reduce the most time in study those subject. The lease two subject information manage and multimedia production are in the recent two days, and I will wait the order of teacher and do my best at it. Today's top point is the SQL highlight that I fount in the blogger's javascript can use the code of sql language in beauty layout. The tip let my database manage's key points could show in the best view. That's the total special thing beside study in this day, and thanks god for the early ending in reading.
資料庫管理上機(3)
檔名store_select01_999.sql
相關教學文件: http://db.tt/rOsoYFqv
使用上一次建立的資料庫..
use bookstore_062
SELECT * FROM dbo.Author_062
SELECT * FROM dbo.Browse_062
SELECT * FROM dbo.Cart_062
SELECT * FROM dbo.Member_062
SELECT * FROM dbo.Order_062
SELECT * FROM dbo.Product_062
SELECT * FROM dbo.Record_062
SELECT * FROM dbo.Transaction_062
--滿足條件
/* 1. 單價等於 500的商品*/
Select * from Product_062 where unitPrice = 500
/* 2. 會員 su 的會員編號*/
Select mid from Member_062 where name='su'
/* 3. 交易方式(method)透過傳真fax購買的資料*/
Select * from Transaction_062 where method = 'fax'
/* 4. cardType以 visa 付款的的交易資料*/
Select * from Transaction_062 where cardType = 'visa'
--比較大小條件
/* 5. 單價大於 500的商品*/
Select * from Product_062 where unitPrice > 500
--多個條件 AND
/* 6. 價格介於 500 與 650 元之間的商品 */
Select * from Product_062 where unitPrice >= 500 and unitPrice <= 650
/* 7. 價格低於600元的書*/
Select * from Product_062 where catelog = 'book' and unitPrice < 600
--多個條件 OR
/*8. 交易方式透過fax 或 email 的交易資料*/
Select * from Transaction_062 where method = 'fax' or method = 'email'
--否定 Not
/* 9. 不是透過購物車的交易資料*/
Select * from Transaction_062 where not method = 'cart'
--空值 IS NULL /非空值 IS NOT NULL
/* 10. 沒有透過介紹人(introducer)的會員id, name */
Select pId, name from Member_062 where introducer is null
/* 11. 經由介紹進來的會員id, name (即introducer 不是空值 )*/
Select pId,name from Member_062 where introducer is not null
/* 12. 沒有聯絡方式的會員(即沒有email, 也沒有聯絡電話)*/
Select * from Member_062 where email is null and phone is null
--模糊相似條件 LIKE ,
/* 13. 所有的女會員…pid like '_2%'*/
Select * from Member_062 where pId like '_2%'
/* 14. 住台北市的會員姓名及地址*/
Select name, address from Member_062 where address like '台北市%'
--IN 集合條件 / Not IN 集合條件
/* 15. 透過fax ,及 email 的交易資料 請使用(in (‘fax’,’email’)*/
Select * from Transaction_062 where method in('fax','email')
/* 16. 不是透過fax ,及 email 的交易資料 (請使用not in (‘fax’,’email’)*/
Select * from Transaction_062 where method not in ('fax','email')
-- 範圍條件 BETWEEN .. AND
/* 17. 價格介於 500 與 650 元之間的商品)*/
Select * from Product_062 where unitPrice between 500 and 650
--排序(由高到低ORDER BY DESC)及排名次(TOP N, TOP N PERCENT)
/* 18. 價格由高至低列出商品資料*/
Select * from Product_062 order by unitPrice desc
/* 19. 列出價格最高的3樣商品之商品名稱及商品價格*/
Select top 3 pName,unitPrice from Product_062 order by unitPrice desc
/* 20. 列出價格在前百分之10的商品資料*/
select top 10 percent * from Product_062 order by unitPrice desc
- 使用distinct 查詢不重覆的資料
/* 21. 有購買記錄的會員 id (一個人如果有多次購買,只出現一次名字, distinct)*/
select distinct transMid from Transaction_062
/* 22. 列出有被購買過的商品編號 (同一商品只要出現一次) */
select distinct pNo from Product_062
--日期函數
/* 23. 本月份生日的會員id, name,生日 -- month(birthday)=month(getdate())*/
select mid,name,birthday from Member_062 where month(birthday)=month(getdate())
/* 24. 2003年的交易…… year函數*/
select * from dbo.Transaction_062 where year(transTime) = 2003檔名store_select02_999.sql
相關教學文件: http://db.tt/pUIdNIVs
使用上一次建立的資料庫..
/* 1. 列出商品編號,名稱與創作人姓名(product, author) */
/* 2. 列出你所出版的商品編號,商品名稱 (product, author) */
/* 3. 列出交易編號，會員id 及會員姓名 (transaction, member) */
/* 4. 列出會員id, 姓名及介紹人id,姓名 (沒有介紹人的不必列出) (member, member) P204, * /
/* 5. 列出會員id, 姓名及介紹人 id,姓名 (所有人都要列出,不管有沒有介紹人) P204, LEFT OUTER JOIN */
/* 6. 列出有被購買過的商品編號, 商品名稱 (同一商品只要出現一次) (DISTINCT) */
/* 7. 列出沒有被購買過的商品編號與名稱 (record, product, not in ) P199 In 運算子 */
use bookstore_062 SELECT * FROM dbo.Author_062; SELECT * FROM dbo.Browse_062 SELECT * FROM dbo.Cart_062 SELECT * FROM dbo.Member_062 SELECT * FROM dbo.Order_062 SELECT * FROM dbo.Product_062 SELECT * FROM dbo.Record_062 SELECT * FROM dbo.Transaction_062 /* 1. 列出商品編號,名稱與創作人姓名(product, author)*/ SELECT dbo.Product_062.pNo , pName , name FROM dbo.Product_062, dbo.Author_062 WHERE dbo.Product_062.pNo = dbo.Author_062.pNo /* 2. 列出你所出版的商品編號,商品名稱 (product, author)*/ SELECT Product_062.pNo , pName FROM dbo.Product_062 , dbo.Author_062 WHERE Product_062.pNo = Author_062.pNo and name = '張崴凱' /* 3. 列出交易編號，會員id 及會員姓名 (transaction, member)*/ SELECT tNo , Member_062.mId , name FROM Transaction_062 , Member_062 WHERE Member_062.mId = Transaction_062.transMid /* 4. 列出會員id, 姓名及介紹人id,姓名 (沒有介紹人的不必列出) (member, member) P204, */ SELECT m1.mid , m1.name , m1.introducer , m2.name FROM Member_062 as m1 , Member_062 as m2 WHERE m1.introducer = m2.mId /* 5. 列出會員id, 姓名及介紹人 id,姓名 (所有人都要列出,不管有沒有介紹人) P204, LEFT OUTER JOIN */ SELECT m1.mid , m1.name , m1.introducer , m2.name FROM Member_062 as m1 left outer join Member_062 as m2 on m1.introducer = m2.mId /* 6. 列出有被購買過的商品編號, 商品名稱 (同一商品只要出現一次) (DISTINCT)*/ select distinct Product_062.pNo , pName from Product_062 , Record_062 WHERE Product_062.pNo = Record_062.pNo /* 7. 列出沒有被購買過的商品編號與名稱 (record, product, not in ) P199 In 運算子*/ Select pNo, pName from Product_062 where pNo not in (select pNo from Record_062)
seclect03 (group分群)
相關教學文件: http://db.tt/QB4NMr7O
相關教學文件: http://db.tt/rOsoYFqv
use bookstore_062 SELECT * FROM dbo.Author_062; SELECT * FROM dbo.Browse_062 SELECT * FROM dbo.Cart_062 SELECT * FROM dbo.Member_062 SELECT * FROM dbo.Order_062 SELECT * FROM dbo.Product_062 SELECT * FROM dbo.Record_062 SELECT * FROM dbo.Transaction_062 /* (01)列出所有商品數、平均價、最高價，和最低價 (P.208 Q14)*/ SELECT COUNT(*) AS 商品數 , AVG(unitPrice) AS平均價, MAX(unitPrice) AS最高價, MIN(unitPrice) AS最低價 FROM Product_062 /* (02A)透過介紹人進來的會員人數*/ SELECT COUNT(introducer) as 透過介紹人進來的會員人數 FROM dbo.Member_062 /* (02A)住台北市的會員數*/ SELECT COUNT(*) as 住台北市的會員數 FROM Member_062 WHERE address = '台北市%' /* (02B) 2003年完成的交易數 */ select COUNT(*) as 二零零三年完成的交易數 from dbo.Transaction_062 where year(transTime)=2003 /* (02C)單價 >500元的商品數 */ select COUNT(*) as 單價高於五百元 from dbo.Product_062 where unitPrice > 500 /*(02D)12月份生日的會員數*/ select COUNT(*) as 十二月份生日 from dbo.Member_062 where MONTH(birthday) = 12 /* (03)列出類別，商品樣數*/ SELECT catalog , COUNT(*) as 列出類別商品樣數 FROM Product_062 GROUP BY catalog /* (03A) 商品樣數> 2的,請列出商品類別及商品樣數*/ SELECT catalog , COUNT(*) as 商品樣數大於二 FROM Product_062 GROUP BY catalog HAVING COUNT(*) > 2 /*(04)列出每一筆交易的交易編號和交易總金額 P208-Q15*/ SELECT tNo , SUM(salePrice) as 交易總金額 FROM Record_062 GROUP BY tNo /*(04A)列出每筆交易總金額超過???錢的交易編號及其交易總金額 (Having)*/ SELECT tNo , sum(salePrice) as 交易總金額 FROM dbo.Record_062 GROUP BY tNo Having SUM(salePrice) >2000 /* (04B)：列出每一筆上網 (method=’cart’)達成的交易之交易編號和購買商品總樣數 P208-Q16 */ SELECT Record_062.tNo , COUNT(*) as 交易編號和購買商品總樣數 FROM Record_062, dbo.Transaction_062 WHERE Record_062.tNo=dbo.Transaction_062.tNo AND method='cart' GROUP BY Record_062.tNo select tNo , COUNT(*) as 交易編號和購買商品總樣數 from Record_062 where tNo in (select tNo from Transaction_062 where method='cart') group by tNo /*(05)列出每一位會員的會員編號和交易總金額 (沒有交易的會員不必列出 P209-Q18*/ SELECT transMid , SUM(salePrice) as 會員編號和交易總金額 FROM dbo.Transaction_062 , dbo.Record_062 WHERE dbo.Transaction_062.tNo = dbo.Record_062.tNo GROUP BY transMid /*(05A)列出每一位會員的會員編號和交易總金額 (沒有交易的會員也要列出*/ SELECT mId , SUM(salPrice) as 交易總金額 FROM dbo.Member_062 LEFT OUTER JOIN dbo.Record_062 ON WHERE dbo.Transaction_062.tNo = dbo.Record_062.tNo GROUP BY mId /*(06)對每一個商品，列出其商品編號，總銷售數量及總銷售金額P208-Q16*/ SELECT pNo , SUM(amount)as 總銷售數量 , SUM(salePrice) as 總銷售金額 FROM Record_062 GROUP BY pNo /* (07)列出商品編號及作者人數 )*/ SELECT pNo , COUNT(*)as 作者人數 FROM Author_062 GROUP BY pNo /* (07A) 列出每商品的商品編號及作者人數(沒有作者的商品也要列出*/ SELECT Product_062.pNo ,COUNT(Author_062.name) as 作者人數 FROM Product_062 LEFT OUTER JOIN Author_062 ON Product_062.pNo=Author_062.pNo GROUP BY Product_062.pNo /* (08)每個月份的生日人數*/ SELECT MONTH(birthday) as 月份, COUNT(*) as 人數 FROM dbo.Member_062 GROUP BY MONTH(birthday) having month(birthday) is not null --Subquery子查詢 /* 沒有交易的會員id,姓名 */ SELECT mId, name FROM Member_062 WHERE mId NOT IN (SELECT Transmid FROM Transaction_062) /* 沒有被購買的商品 */ select * from Product_062 where pNo not in (select pNo from Record_062)store_update999.sql
6.5.1 SQL的修改語法
UPDATE table_name
SET column1=value1,column2=value2,...
WHERE some_column=some_value;
1.刪除會員 c0927777 所有的瀏覽記錄
2.把所有書類商品定價提高1成
3 設定你的介紹人是 jenny (請查一下 jenny 的員工代號
6.3.3 更改資料表(Alter Table)
**改變欄位
4. 在「會員」資料表新增一個sex 欄位, 固定長度1個字元的文字
**新增欄位
ALTER TABLE table_name
ADD column_name datatype
5. 將「商品」資料表的pName欄位 的寬度改為變動長度40
ALTER TABLE table_name
ALTER COLUMN column_name datatype
-- 6.將「商品」v00111 改為"A123456789B123456789C123456789D123456789"
**刪除欄位
ALTER TABLE table_name
DROP COLUMN column_name
6.5.1 SQL的修改語法 select * from dbo.Browse_062 select * from dbo.Product_062 select * from dbo.Member_062 --1.刪除會員 c0927777 所有的瀏覽記錄 select * from dbo.Browse_062 where mId='c0927777' delete dbo.Browse_062 where mId='c0927777' --2.把所有書類商品定價提高1成 select * from dbo.Product_062 where catalog='book' update dbo.Product_062 set unitPrice = unitPrice*1.1 where catalog='book' --3 設定你的介紹人是 jenny (請查一下 jenny 的員工代號 select mId from dbo.Member_062 where name='jenny' update dbo.Member_062 set introducer = (select mId from dbo.Member_062 where name='jenny') where name='陳奕安' --6.3.3 更改資料表(Alter Table) --**改變欄位 --4. 在「會員」資料表新增一個sex 欄位, 固定長度1個字元的文字 --**新增欄位 ALTER TABLE dbo.Member_062 ADD sex char(1) --5. 將「商品」資料表的pName欄位 的寬度改為變動長度40 ALTER TABLE dbo.Product_062 ALTER COLUMN pName varchar(40) -- 6.將「商品」v00111 改為"A123456789B123456789C123456789D123456789" --**刪除欄位 update dbo.Product_062 set pName = 'A123456789B123456789C123456789D123456789' where pNo = 'v00111'
資料庫管理上機(2)
繼續上一個實作
請新增以下資料
使用上次的資料庫
建一個新的查詢檔 , store_myinsert_999
(1)昨天也加入了會員(會員編號為你的學號)-- (暫不打介紹人)
(2)假設你與你的組同學合出版了一本書,請
(a)新增一個商品，類別為"Book", 商品編號第一個字元為B，書名及價格自訂。
(b新增這本書的2個作者，一個是你，一個是你專題內同組的同學，請打中文姓名
(3)你5月 1日透過 fax 完成了一筆交易(交易編號自己設)。信用卡資料可以不必輸入,此筆交易買了1本你的書
(4)你5月10日在門市又完成了一筆交易(交易編號自己設)。.這次你買了4本你的書及1個DVD 商品 (這請自己設)
(四)輸入查詢以上資料表內容的指令--
use bookstore_062
SELECT * FROM dbo.Author_062
SELECT * FROM dbo.Browse_062
SELECT * FROM dbo.Cart_062
SELECT * FROM dbo.Member_062
SELECT * FROM dbo.Order_062
SELECT * FROM dbo.Product_062
SELECT * FROM dbo.Record_062
SELECT * FROM dbo.Transaction_062
Insert into MEMBER_062 (MID, PID, NAME) Values ('b0922499', 'R100200399', '陳奕安');
Insert into PRODUCT_062 Values ('b40062', '甜不辣歷險記', 200 , 'Book');
Insert into AUTHOR_062 (PNO, NAME) Values ('b40062', '陳煒博');
Insert into AUTHOR_062 (PNO, NAME) Values ('b40062', '張崴凱');
Insert into Transaction_062 (TNO, TRANSMID, TRANSTIME, METHOD, BANKID) Values ('92777', 'b0922462', '2003/5/1 11:30:00', 'fax' , '010');
Insert into RECORD_062(TNO, PNO, SALEPRICE, AMOUNT) Values ('92777','b40062',200.00,1);
Insert into Transaction_062 (TNO, TRANSMID, TRANSTIME, METHOD, BANKID) Values ('92888', 'b0922462', '2003/5/10 11:30:00', 'fax', '010');
Insert into RECORD_062(TNO, PNO, SALEPRICE, AMOUNT) Values ('92888','b40062',800,4);
Insert into RECORD_062(TNO, PNO, SALEPRICE, AMOUNT) Values ('92888','v00111',450,1);
go
資料庫管理上機(1)
建立書上範例資料庫— store_999
將store_schema_999.sql及 store_data_999.sql檔名中的 999改為你學號後3碼
(一)建立資料庫
create database store_999 -- 建立資料庫,只能執行一次
use database store_999 -- 使用資料庫
(二)建立(CREATE TABLE)資料表( 請開啟store_schema_999.sql )
1. 將每個資料表名稱後的_999，也改為你學號後 3 碼
2. 建立所有 table, 內容有少許錯誤，執行時如有錯，請把錯找出來修正
/* 請將下面的databas 名字062改為你的學號後3碼後按執行*/ create database bookstore_062; go use bookstore_062; go CREATE TABLE Member_062 (mId CHAR(8) NOT NULL, pId CHAR(10) NOT NULL, name VARCHAR(8) NOT NULL, birthday DATETIME, phone VARCHAR(10), address VARCHAR(40), email VARCHAR(40), introducer CHAR(8), PRIMARY KEY (mId), UNIQUE (pId), FOREIGN KEY (introducer) REFERENCES Member_062(mId)); CREATE TABLE Product_062 (pNo CHAR(6) NOT NULL, pName VARCHAR(30), unitPrice DECIMAL(10,2), catalog VARCHAR(20), PRIMARY KEY (pNo ), CONSTRAINT UnitPrice_Check CHECK (unitPrice > 100)); CREATE TABLE Author_062 (pNo CHAR(6) NOT NULL, name VARCHAR(8), PRIMARY KEY (pNo, name ), FOREIGN KEY (pNo) REFERENCES Product_062(pNo)); CREATE TABLE Transaction_062 (tNo CHAR(5) NOT NULL, transMid CHAR(8) NOT NULL, transTime DATETIME NOT NULL, method VARCHAR(5) NOT NULL, bankId VARCHAR(14) NOT NULL, bankName VARCHAR(20), cardType VARCHAR(10), cardId VARCHAR(10), dueDate DATETIME, PRIMARY KEY (tNo), FOREIGN KEY (transMid) REFERENCES Member_062(mId)); CREATE TABLE Cart_062 (mId CHAR(8) NOT NULL, cartTime DATETIME NOT NULL, tNo CHAR(5) NOT NULL, PRIMARY KEY (mId, cartTime), FOREIGN KEY (tNo) REFERENCES Transaction_062(tNo) ON UPDATE CASCADE, FOREIGN KEY (mId) REFERENCES Member_062(mId) ON DELETE CASCADE ON UPDATE CASCADE); CREATE TABLE Browse_062 (mId CHAR(8) NOT NULL DEFAULT 'a0910001', pNo CHAR(6) NOT NULL, browseTime DATETIME, PRIMARY KEY (mId, pNo, browseTime), FOREIGN KEY (mId) REFERENCES Member_062(mId) ON UPDATE CASCADE, FOREIGN KEY (pNo) REFERENCES Product_062(pNo)); CREATE TABLE Order_062 (pNo CHAR(6) NOT NULL, mId CHAR(8) NOT NULL, cartTime DATETIME NOT NULL, amount INT DEFAULT 0, PRIMARY KEY (pNo ,mId, cartTime ), FOREIGN KEY (pNo) REFERENCES Product_062(pNo), FOREIGN KEY (mId, cartTime) REFERENCES Cart_062(mId, cartTime)); CREATE TABLE Record_062 (tNo CHAR(5) NOT NULL, pNo CHAR(6) NOT NULL, salePrice DECIMAL(10,2), amount INT, PRIMARY KEY (tNo,pNo), FOREIGN KEY (tNo) REFERENCES Transaction_062(tNo), FOREIGN KEY (pNo) REFERENCES Product_062(pNo)); go
(三)新增各資料表內的記錄(請開啟store_data_999.sql)
執行所有的 insert 指令(有錯,則修改)，把各資料表內記錄成功的新增進去。
/* 請將下面的databas 名字062改為你的學號後3碼後按執行*/
use bookstore_062
go
Insert into MEMBER_062
(MID, PID, NAME, BIRTHDAY, PHONE, ADDRESS, EMAIL)
Values
('b0922468', 'R100200300', 'Jackson', '1980-03-30', '06-3210321', '台南縣中華路號', 'jack99@ms9.hinet.net');
Insert into MEMBER_062
(MID, PID, NAME, BIRTHDAY, PHONE, ADDRESS, EMAIL)
Values
('b0905555', 'C200456789', 'Jennifer', '1974-03-04', '07-2221111', '高雄市五福三路號', 'jen33@ms3.hinet.net');
Insert into MEMBER_062
(MID, PID, NAME, BIRTHDAY, PHONE, ADDRESS, EMAIL, INTRODUCER)
Values
('a0910001', 'A220123456', 'Jenny', '1979-01-01', '02-2222001', '台北市中山北路號', 'jenny@ms1.hinet.net', 'b0905555');
Insert into MEMBER_062
(MID, PID, NAME, BIRTHDAY, PHONE, ADDRESS, EMAIL, INTRODUCER)
Values
('c0927777', 'B123123123', 'Su', '1982-06-06', '07-2345678', '高雄市蓮海路號', 'su88@ms2.hinet.net', 'b0905555');
Insert into MEMBER_062
(MID, PID, NAME, BIRTHDAY, PHONE, ADDRESS, EMAIL, INTRODUCER)
Values
('a0911234', 'A12255888', 'Tony', '1980-12-12', '02-2288009', '台北市羅斯福路號', 'tony@ms1.hinet.net', 'a0910001');
Insert into MEMBER_062
(MID, PID, NAME, BIRTHDAY, PHONE, ADDRESS, EMAIL, INTRODUCER)
Values
('a0921111', 'A100062777', 'David', '1975-11-22', '04-2468888', '台中市中港路號', 'david@ms1.hinet.net', 'a0911234');
GO
Insert into PRODUCT_062
(PNO, PNAME, UNITPRICE, CATALOG)
Values
('b30062', '資料庫理論與實務', 500, 'Book');
Insert into PRODUCT_062
(PNO, PNAME, UNITPRICE, CATALOG)
Values
('d11222', '任賢齊專輯三', 300, 'CD');
Insert into PRODUCT_062
(PNO, PNAME, UNITPRICE, CATALOG)
Values
('b20666', 'OLAP進階', 500, 'Book');
Insert into PRODUCT_062
(PNO, PNAME, UNITPRICE, CATALOG)
Values
('b10234', '管理資訊系統概論', 600, 'Book');
Insert into PRODUCT_062
(PNO, PNAME, UNITPRICE, CATALOG)
Values
('b40555', '系統分析理論與實務', 550, 'Book');
Insert into PRODUCT_062
(PNO, PNAME, UNITPRICE, CATALOG)
Values
('d20777', '蔡依林專輯二', 350, 'CD');
Insert into PRODUCT_062
(PNO, PNAME, UNITPRICE, CATALOG)
Values
('v01888', '哈利波特-混血王子的背叛', 450, 'DVD');
Insert into PRODUCT_062
(PNO, PNAME, UNITPRICE, CATALOG)
Values
('d03333', '5566專輯', 450, 'CD');
Insert into PRODUCT_062
(PNO, PNAME, UNITPRICE, CATALOG)
Values
('b51111', '電子商務理論與實務', 700, 'Book');
Insert into PRODUCT_062
(PNO, PNAME, UNITPRICE, CATALOG)
Values
('v00111', '英雄', 400, 'DVD');
GO
Insert into AUTHOR_062 (PNO, NAME) Values ('b30062', 'Huang');
Insert into AUTHOR_062
(PNO, NAME)
Values
('b10234', 'Lin');
Insert into AUTHOR_062
(PNO, NAME)
Values
('d11222', 'William');
Insert into AUTHOR_062
(PNO, NAME)
Values
('b20666', 'Sandra');
Insert into AUTHOR_062
(PNO, NAME)
Values
('b40555', 'Wu');
Insert into AUTHOR_062
(PNO, NAME)
Values
('d20777', 'Jolin');
Insert into AUTHOR_062
(PNO, NAME)
Values
('v01888', 'J.K.');
Insert into AUTHOR_062
(PNO, NAME)
Values
('b51111', 'Lai');
Insert into AUTHOR_062
(PNO, NAME)
Values
('b51111', 'Huang');
Insert into AUTHOR_062
(PNO, NAME)
Values
('b51111', 'Lin');
Insert into AUTHOR_062
(PNO, NAME)
Values
('d03333', 'Jackey');
Insert into AUTHOR_062
(PNO, NAME)
Values
('d03333', 'David');
Insert into AUTHOR_062
(PNO, NAME)
Values
('d03333', 'Tom');
GO
Insert into Transaction_062
(TNO, TRANSMID, TRANSTIME, METHOD, BANKID, BANKNAME, CARDTYPE, CARDID, DUEDATE)
Values
('92222', 'a0911234', '2003/1/1 11:30:00', 'cart', '010', 'tb', 'visa', '987654321', '2005-01-01');
Insert into Transaction_062
(TNO, TRANSMID, TRANSTIME, METHOD, BANKID, BANKNAME, CARDTYPE, CARDID, DUEDATE)
Values
('92555', 'b0922468', '2003/11/11 09:10:00', 'cart', '010', 'tb', 'visa', '333300000', '2004-01-01');
Insert into Transaction_062
(TNO, TRANSMID, TRANSTIME, METHOD, BANKID, BANKNAME, CARDTYPE, CARDID, DUEDATE)
Values
('90111', 'b0905555', '2002/5/5 12:30:30', 'cart', '020', 'fb', 'master', '444455555', '2003-01-01');
Insert into Transaction_062
(TNO, TRANSMID, TRANSTIME, METHOD, BANKID, BANKNAME, CARDTYPE, CARDID, DUEDATE)
Values
('92333', 'c0927777', '2003/10/15 09:00:00', 'email', '070', 'sb', 'visa', '111122222', '2004-12-31');
Insert into Transaction_062
(TNO, TRANSMID, TRANSTIME, METHOD, BANKID, BANKNAME, CARDTYPE, CARDID, DUEDATE)
Values
('91888', 'a0910001', '2002/9/10 10:10:00', 'fax', '040', 'cb', 'master', '777788888', '2004-10-10');
Insert into Transaction_062
(TNO, TRANSMID, TRANSTIME, METHOD, BANKID, BANKNAME, CARDTYPE, CARDID, DUEDATE)
Values
('92666', 'c0927777', '2003/10/10 22:10:30', 'cart', '020', 'fb', 'visa', '123456789', '2003-12-31');
Insert into Transaction_062
(TNO, TRANSMID, TRANSTIME, METHOD, BANKID, BANKNAME, CARDTYPE, CARDID, DUEDATE)
Values
('91100', 'a0911234', '2004/7/27 18:30:00', 'cart', '010', 'tb', 'visa', '987654321', '2005-01-01');
GO
Insert into CART_062
(MID, CARTTIME, TNO)
Values
('a0911234', '2003/1/1 10:00:00', '92222');
Insert into CART_062
(MID, CARTTIME, TNO)
Values
('a0910001', '2002/9/9 10:00:10', '91888');
Insert into CART_062
(MID, CARTTIME, TNO)
Values
('b0922468', '2003/11/11 09:00:30', '92555');
Insert into CART_062
(MID, CARTTIME, TNO)
Values
('a0911234', '2002/2/2 18:00:30', '91100');
Insert into CART_062
(MID, CARTTIME, TNO)
Values
('b0905555', '2002/5/5 12:00:00', '90111');
Insert into CART_062
(MID, CARTTIME, TNO)
Values
('c0927777', '2003/10/10 22:00:00', '92666');
GO
Insert into browse_062
(MID, PNO, BROWSETIME)
Values
('a0910001', 'b40555', '2002/9/9 10:00:00');
Insert into browse_062
(MID, PNO, BROWSETIME)
Values
('b0922468', 'b40555', '2003/11/10 12:00:30');
Insert into browse_062
(MID, PNO, BROWSETIME)
Values
('b0922468', 'b10234', '2003/11/1 22:00:00');
Insert into browse_062
(MID, PNO, BROWSETIME)
Values
('c0927777', 'v00111', '2003/10/10 21:50:00');
Insert into browse_062
(MID, PNO, BROWSETIME)
Values
('c0927777', 'd20777', '2003/10/10 21:40:00');
Insert into browse_062
(MID, PNO, BROWSETIME)
Values
('c0927777', 'd11222', '2003/10/10 21:30:30');
Insert into browse_062
(MID, PNO, BROWSETIME)
Values
('b0905555', 'v01888', '2002/5/5 11:40:30');
Insert into browse_062
(MID, PNO, BROWSETIME)
Values
('a0911234', 'b20666', '2002/2/2 17:50:00');
Insert into browse_062
(MID, PNO, BROWSETIME)
Values
('a0911234', 'b30062', '2002/2/2 17:30:00');
GO
Insert into Order_062
(PNO, MID, CARTTIME, AMOUNT)
Values
('d11222', 'a0911234', '2003/1/1 10:00:00', 1);
Insert into Order_062
(PNO, MID, CARTTIME, AMOUNT)
Values
('b40555', 'b0922468', '2003/11/11 09:00:30', 10);
Insert into Order_062
(PNO, MID, CARTTIME, AMOUNT)
Values
('b10234', 'b0922468', '2003/11/11 09:00:30', 5);
Insert into Order_062
(PNO, MID, CARTTIME, AMOUNT)
Values
('v00111', 'c0927777', '2003/10/10 22:00:00', 2);
Insert into Order_062
(PNO, MID, CARTTIME, AMOUNT)
Values
('d20777', 'c0927777', '2003/10/10 22:00:00', 1);
Insert into Order_062
(PNO, MID, CARTTIME, AMOUNT)
Values
('d11222', 'c0927777', '2003/10/10 22:00:00', 1);
Insert into Order_062
(PNO, MID, CARTTIME, AMOUNT)
Values
('v01888', 'b0905555', '2002/5/5 12:00:00', 3);
Insert into Order_062
(PNO, MID, CARTTIME, AMOUNT)
Values
('b30062', 'a0911234', '2002/2/2 18:00:30', 1);
GO
Insert into RECORD_062
(TNO, PNO, SALEPRICE, AMOUNT)
Values
('91100', 'b30062', 450, 1);
Insert into RECORD_062
(TNO, PNO, SALEPRICE, AMOUNT)
Values
('90111', 'v01888', 1350, 3);
Insert into RECORD_062
(TNO, PNO, SALEPRICE, AMOUNT)
Values
('92555', 'b10234', 3000, 5);
Insert into RECORD_062
(TNO, PNO, SALEPRICE, AMOUNT)
Values
('92555', 'b40555', 5000, 10);
Insert into RECORD_062
(TNO, PNO, SALEPRICE, AMOUNT)
Values
('91888', 'b40555', 1650, 3);
Insert into RECORD_062
(TNO, PNO, SALEPRICE, AMOUNT)
Values
('91888', 'd03333', 850, 2);
Insert into RECORD_062
(TNO, PNO, SALEPRICE, AMOUNT)
Values
('92666', 'd11222', 300, 1);
Insert into RECORD_062
(TNO, PNO, SALEPRICE, AMOUNT)
Values
('92666', 'd20777', 350, 1);
Insert into RECORD_062
(TNO, PNO, SALEPRICE, AMOUNT)
Values
('92666', 'v00111', 800, 2);
Insert into RECORD_062
(TNO, PNO, SALEPRICE, AMOUNT)
Values
('92333', 'b51111', 700, 1);
go
SELECT * FROM 資料表名稱
(四)建立一個新的查詢檔 store_select01_999,sql
1.查詢所有的table 資料
use bookstore_062 SELECT * FROM dbo.Author_062 SELECT * FROM dbo.Browse_062 SELECT * FROM dbo.Cart_062 SELECT * FROM dbo.Member_062 SELECT * FROM dbo.Order_062 SELECT * FROM dbo.Product_062 SELECT * FROM dbo.Record_062 SELECT * FROM dbo.Transaction_062
(五)繳交SQL第一個作業 --- 共 5 個檔含
store_schema_999.sql, store_data_999.sql ,store_select01_999.sql
及store_999.mdf 及 store_999.ldf
備註:備份(上傳)資料庫 --- 下次上課要用的，沒存起來，下次上課又要把前面重作一次
1. disconnet 所有的connection (關閉所有的查詢檔)
2. detach database(卸離資料庫)
3. 把store_999.mdf 及 store_999.ldf 拷貝出來，下次上課要用
客戶訂購商品
order_schema_A0061062.sql
create database order_A0061062; go use order_A0061062; go CREATE TABLE Client_062 (cId CHAR(8) NOT NULL, cName NVARCHAR(30) NOT NULL, cPhone VARCHAR(10), fax VARCHAR(10), PRIMARY KEY (cId)); CREATE TABLE Product_062 (pNo CHAR(4) NOT NULL, pName VARCHAR(30), pUprice INT, PRIMARY KEY (pNo)); CREATE TABLE Order_062 (oNo CHAR(3) NOT NULL, cId CHAR(8), oDate DATETIME, PRIMARY KEY (oNo), FOREIGN KEY (cId) REFERENCES Client_062(cId)); CREATE TABLE OrderDetail_062 (oNo CHAR(3) NOT NULL, pNo CHAR(4) NOT NULL, num INT, PRIMARY KEY (oNo,pNo), FOREIGN KEY (oNo) REFERENCES Order_062(oNo), FOREIGN KEY (pNo) REFERENCES Product_062(pNo)); goorder_data_A0061062.sql
use order_A0061062
go
--客戶資料表:
--cid : 至少 5 位,其中一個是你, 客戶代號為你的學號
--cName :你的名字必需是中文
Insert into Client_062
(cId, cName, cPhone, fax)
Values
('A0061062', '陳奕安', '06-3210321', '06-3210330');
Insert into Client_062
(cId, cName, cPhone, fax)
Values
('A0061063', '陳二安', '07-3210321', '07-3210330');
Insert into Client_062
(cId, cName, cPhone, fax)
Values
('A0061064', '陳三安', '08-3210321', '08-3210330');
Insert into Client_062
(cId, cName, cPhone, fax)
Values
('A0061065', '陳四安', '09-3210321', '09-3210330');
Insert into Client_062
(cId, cName, cPhone, fax)
Values
('A0061066', '陳五安', '10-3210321', '10-3210330');
go
--產品資料表
--至少輸入 5 種商品
Insert into Product_062
(pNo, pName, pUprice)
Values
('0101', '經綸歷險記', 50);
Insert into Product_062
(pNo, pName, pUprice)
Values
('0102', '汪汪歷險記', 60);
Insert into Product_062
(pNo, pName, pUprice)
Values
('0103', '喵喵歷險記', 70);
Insert into Product_062
(pNo, pName, pUprice)
Values
('0104', '哞哞歷險記', 80);
Insert into Product_062
(pNo, pName, pUprice)
Values
('0105', '啾啾歷險記', 90);
go
--訂單檔:
--至少5 筆,且能反映出 ERD 的參與度與基數比
Insert into Order_062
(oNo, cId, oDate)
Values
('011', 'A0061062', '2005');
Insert into Order_062
(oNo, cId, oDate)
Values
('012', 'A0061062', '2005');
Insert into Order_062
(oNo, cId, oDate)
Values
('013', 'A0061062', '2005');
Insert into Order_062
(oNo, cId, oDate)
Values
('014', 'A0061063', '2005');
Insert into Order_062
(oNo, cId, oDate)
Values
('015', 'A0061064', '2005');
Insert into Order_062
(oNo, cId, oDate)
Values
('016', 'A0061064', '2005');
go
--訂單明細
--至少輸入10 筆,且要能表達出 ERD 的參與度與基數比
Insert into OrderDetail_062
(oNo, pNo, num)
Values
('011', '0101', 50);
Insert into OrderDetail_062
(oNo, pNo, num)
Values
('011', '0101', 20);
Insert into OrderDetail_062
(oNo, pNo, num)
Values
('012', '0101', 40);
Insert into OrderDetail_062
(oNo, pNo, num)
Values
('011', '0102', 50);
Insert into OrderDetail_062
(oNo, pNo, num)
Values
('011', '0103', 50);
Insert into OrderDetail_062
(oNo, pNo, num)
Values
('013', '0104', 50);
Insert into OrderDetail_062
(oNo, pNo, num)
Values
('014', '0104', 50);
Insert into OrderDetail_062
(oNo, pNo, num)
Values
('014', '0101', 20);
Insert into OrderDetail_062
(oNo, pNo, num)
Values
('015', '0102', 60);
Insert into OrderDetail_062
(oNo, pNo, num)
Values
('016', '0101', 10);
go
order_query_A0061062.sqluse order_A0061062
--1. 4個slect * , 列出 4 個 table 的內容.
SELECT * FROM dbo.Client_062
SELECT * FROM dbo.Order_062
SELECT * FROM dbo.OrderDetail_062
SELECT * FROM dbo.Product_062
--2. 另至少 6 個查詢,能滿足以下的要求
--每個查詢需先有題目說明 ---
--(1)有文字條件的設定,有數值欄位條件的設定,有日期條件的設定
--(1)訂單中2005年的所有資料
select * from dbo.Order_062 where year(oDate) = 2005
--(2)有 2 個以上的條件
--(2)訂單明細中數量大於20、小於50的所有資料
Select * from dbo.OrderDetail_062 where num >= 20 and num <= 50
--(3)會用到 order by ,
--(3)前三高價格商品的所有資料
select top 3 * from Product_062 order by pUprice desc
--(4)會用的 Between .. and,
--(4)商品價格介於60-80之間的所有資料
Select * from Product_062 where pUprice between 60 and 80
--(5)會用到 in
--(5)訂單明細中編號為011的所有商品資料
Select * from dbo.OrderDetail_062 where oNo in('011')
--(3)查詢會join 一個以上的table
--(3)客戶姓名及訂單編號在訂單和客戶裡
SELECT dbo.Client_062.cName, dbo.Order_062.oNo
FROM dbo.Client_062
INNER JOIN dbo.Order_062
ON dbo.Client_062.cId=dbo.Order_062.cId
--(4)會用到至少2個彙總函數(SUM, AVERAGE,MAX, MIN )
--(4)訂單明細中最大單筆數量及訂單總和
SELECT MAX(num) as 最大數量,SUM(num)as 訂單總和 FROM dbo.OrderDetail_062;
2013年6月11日 星期二
Diary
The recent days I always feel so tired but don't know why. My body suffer in unhealthy disease, so I have to keep taking medicine to control the situation of emotion. For the reason to avoid behavioral disorders, I live with the secondary action in final. The main symptom of secondary action is tired quickly, and then easy to thirsty. They are all big trouble for me, but I still have no method to solve any problem of them. Should I stop the medicine or comment to doctor again? And I also take a task about administrative assistant, I have to executes the command of very important person. The direct of university Shih Chien department of information technology and management advice me to let nine special subjects in a location, it may course a good environment to learn and also can cooperation with other team. When I talk to toy Cheng with the former sentences, he know the situation right now and has the view to construction website. The next week is final exam week, so we plan to realize the job after it. Those events give me more duty and pressure, I should try to release some of them or I will get mad.
6/11 物件導向小考
物件導向設計原理期末考 102/6/11
1. 輸入二元檔(binary file)： pdata2.txt
(a) pdata2.txt 的存放格式：(共有9筆資料)
· 會員代號(6個字元)
· 性別(1個字元) ，性別M:男生，性別F:女生
· 姓名(10個字元)
· 年齡(integer)
· 身高(double)，單位為(英)吋
· 體重(double)，單位為磅
(b) 輸入pdata.txt 檔的9筆資料，且從螢幕輸出
(c) 輸出格式：會員代號後為「性別」；M è「*」，Fè「」
會員代號* 姓名 年齡 身高(公尺) 體重(公斤) BMI值 體重狀態
………
體重1磅 = 0.454公斤 poundà KG
身高1(英)吋 = 2.54公分 inch à CM * CM/100à M
class BMI {
double toKg(double pound); // pound à kg
double toM(double inch); // feet à m
double getBMI(double m, double kg); // input height(m) & weight(kg) return BMI value
}
bmi < 18.5 體重過輕
18.5 £ bmi< 24 體重正常
24 £bmi< 27 體重過重
27 £bmi< 30 輕度肥胖
30 £bmi< 35 中度肥胖
bmi ³ 35 重度肥胖
import java.io.*;
class ex0611i{
public static void main(String[] args) throws IOException
{
DataInputStream din= new DataInputStream (
new BufferedInputStream(
new FileInputStream("pdata2.txt")));
char[] id= new char[6];
char[] name=new char[10];
int age;
double hei,wei, bmi;
char gender, star;
for(int ii=0;ii<9;ii++){
for(int i=0;i<6;i++) id[i]=din.readChar();
String sid=new String(id);
gender=din.readChar();
for(int i=0;i<10;i++) name[i]=din.readChar();
String sname=new String(name);
age=din.readInt(); // age
hei=din.readDouble(); // height
wei=din.readDouble(); // weight
if(gender=='M') star='*';
else star=' ';
BMI obj=new BMI();
double m=obj.toM(hei);
double kg=obj.toKg(wei);
bmi=obj.getBMI(m,kg);
String status;
if(bmi<18.5) status="體重過輕";
else if(bmi<24) status="體重正常";
else if(bmi<27) status="體重過重";
else if(bmi<30) status="輕度肥胖";
else if(bmi<35) status="中度肥胖";
else status="重度肥胖";
System.out.println(" "+sid+star+" "+sname+" "+age+" "+m+" "+
kg+" "+bmi+" "+status);
}
din.close();
}
}
二進位檔案
bio
binary.txt
pH?腲I?毨 !D-
text.txt
12345678901234512345678903.141592653589793
binary.txt
pH?腲I?毨 !D-
import java.io.*;
class bio{
public static void main(String[] args) throws IOException
{
DataInputStream din= new DataInputStream (
new BufferedInputStream(
new FileInputStream("binary.txt")));
long n1=din.readLong();
int n2=din.readInt();
double n3=din.readDouble();
System.out.println(" n1: "+n1+" n2: "+n2+" n3: "+n3);
din.close();
}
}
tiotext.txt
12345678901234512345678903.141592653589793
import java.io.*;
class tio{
public static void main(String[] args) throws IOException
{
FileReader fr1=new FileReader("text.txt");
BufferedReader bfr1= new BufferedReader(fr1);
String str;
while ((str=bfr1.readLine())!=null) //
{
long n1=Long.parseLong(str.substring(0,15));
int n2=Integer.parseInt(str.substring(15,25));
double n3=Double.parseDouble(str.substring(25));
System.out.println(" n1: "+n1+" n2: "+n2+" n3: "+n3);
}
fr1.close();
}
}
2013年6月9日 星期日
Diary 2013/6/9 10:52
Today has one strange thing upset my life, the thing is e-mail address problem. When Microsoft hotmail change to outlook, my hotmail has some bug in specify web site. The same steam support's e-mail send in the identical moment, my gmail receive as soon as I confirm the button in send message, but my hotmail delay about four or five hours. It's so horrible, how can I use the code in mail to change the setting in steam. Finally
the next day, the outlook is normal , so I can setting steam in the end. Thanks to the Microsoft, it still have a little work for me.
the next day, the outlook is normal , so I can setting steam in the end. Thanks to the Microsoft, it still have a little work for me.
2013年6月8日 星期六
Diary 2013/6/8 11:12
In the recent days, lots of thing disturb my simple live so that I have to transform the content of diary. Abandon the Chinese version to let English version could have good time to fill the space of my blogs. Here is the several advantages in it, for example total time can short to half and the struct of article also can present in English essay. It's still the beginning in writing so it could be some difficult world or the method to perform my though in my mind. I should more try and do it every day to extend the knowledge and experience in it.
2013年6月6日 星期四
日記 2013/6/6 10:45
中文:
今日課程在中午就結束了，在與同學吃完午餐後緊接的就是帳單代繳的辦理，在烈陽高照的中午，循著蜿蜒的小街巷弄慢慢地朝著郵局邁進，抵達郵局時已汗流浹背，循著樓梯緩慢地朝著地下室走去並享用著冷氣的沁涼，依循慣例抽著號碼牌等候叫號，與此同時在隨身背包裡拿取可能用到的存摺與繳費資料，不料當詢問櫃檯如何填寫資料時，才發現原來郵局只提供公家機關的代繳服務，而我的遠傳電信帳單需要自行到他的服務處辦理，在其他三個代繳服務都辦理妥當後被告知四十五天之後才生效，公家機關的工作天數是不是都會比較長呢!?
回家之後幫筆電的VirtualBox裝好ubuntu再把英文課本熟讀一遍，一天的時間這樣就過去了，果真在無聊的時候才會覺得時間很多，在需要時間的又覺得永遠不夠用，套一句英文演講裡的話a mind is an expensive thing to wast，必須要好好善用時間不用白白浪費你的腦力。
English:
Time manage is the most important thing in the collage live. Although I am in the private universities so that my courses are not heavy than public universities. That's mean time manage maybe not necessary for me, but I always try to learn new things what I interesting in so I need to afford about the time consume. Since the long time ago, I usually do many things at one time to control every matter in the right step. Gradually, I am good at time manage, I can arrange multiple affairs in a period and solve them in the deadline at all. Eventually, the skill of time manage is the tip to make thing quick and well.
今日課程在中午就結束了，在與同學吃完午餐後緊接的就是帳單代繳的辦理，在烈陽高照的中午，循著蜿蜒的小街巷弄慢慢地朝著郵局邁進，抵達郵局時已汗流浹背，循著樓梯緩慢地朝著地下室走去並享用著冷氣的沁涼，依循慣例抽著號碼牌等候叫號，與此同時在隨身背包裡拿取可能用到的存摺與繳費資料，不料當詢問櫃檯如何填寫資料時，才發現原來郵局只提供公家機關的代繳服務，而我的遠傳電信帳單需要自行到他的服務處辦理，在其他三個代繳服務都辦理妥當後被告知四十五天之後才生效，公家機關的工作天數是不是都會比較長呢!?
回家之後幫筆電的VirtualBox裝好ubuntu再把英文課本熟讀一遍，一天的時間這樣就過去了，果真在無聊的時候才會覺得時間很多，在需要時間的又覺得永遠不夠用，套一句英文演講裡的話a mind is an expensive thing to wast，必須要好好善用時間不用白白浪費你的腦力。
English:
Time manage is the most important thing in the collage live. Although I am in the private universities so that my courses are not heavy than public universities. That's mean time manage maybe not necessary for me, but I always try to learn new things what I interesting in so I need to afford about the time consume. Since the long time ago, I usually do many things at one time to control every matter in the right step. Gradually, I am good at time manage, I can arrange multiple affairs in a period and solve them in the deadline at all. Eventually, the skill of time manage is the tip to make thing quick and well.
2013年6月5日 星期三
日記 2013/6/5 11:18
中文:
在今天這一整天中，從地獄獵手4、資訊管理題庫、多媒體製作實作到VirtualBox linux ubuntu，一連串的事情可以摸索，在學校非營利事業的上課中和阿宅一起玩地域列手的平板APP遊戲，遊戲製作良好難度適中十分耐玩，足夠打發多餘的時間，唯一的遺憾就是耗電量很大，而回家之後的第一件事情就是查找資料管理題庫的答案，有許多題目在網路上搜尋不到，而題目的內容跨足好多科目的資料，大多都只能靠少數學過的商類科目來猜測答案，如果明日上課老師不講解的話，考試的時候分數可能會不太好看，而說到最棘手的事情莫過於多媒體製作，所有的軟體的環境安裝就花了許多時間，而實際操作出來又有許多執行上的問題，幸好這禮拜還可以去詢問老師是否是WIN7作業系統無法操作還是課本內容需要稍作更改，最後在無聊的時候打開慣壞的ubuntu似乎安裝步驟錯誤，導致guest additions檔案毀損，以至於螢幕無法隨視窗伸展，就連滑鼠指標都無法顯示，可能最佳的解決方法就是全部重新安裝才是上上之策。
English:
STOP today.
在今天這一整天中，從地獄獵手4、資訊管理題庫、多媒體製作實作到VirtualBox linux ubuntu，一連串的事情可以摸索，在學校非營利事業的上課中和阿宅一起玩地域列手的平板APP遊戲，遊戲製作良好難度適中十分耐玩，足夠打發多餘的時間，唯一的遺憾就是耗電量很大，而回家之後的第一件事情就是查找資料管理題庫的答案，有許多題目在網路上搜尋不到，而題目的內容跨足好多科目的資料，大多都只能靠少數學過的商類科目來猜測答案，如果明日上課老師不講解的話，考試的時候分數可能會不太好看，而說到最棘手的事情莫過於多媒體製作，所有的軟體的環境安裝就花了許多時間，而實際操作出來又有許多執行上的問題，幸好這禮拜還可以去詢問老師是否是WIN7作業系統無法操作還是課本內容需要稍作更改，最後在無聊的時候打開慣壞的ubuntu似乎安裝步驟錯誤，導致guest additions檔案毀損，以至於螢幕無法隨視窗伸展，就連滑鼠指標都無法顯示，可能最佳的解決方法就是全部重新安裝才是上上之策。
English:
STOP today.
2013年6月4日 星期二
日記 2013/6/4 11:09
中文:
學校近來有幾件事情適合論述，第一件事情就是英文畢業門檻成績已公布，考試難度比想像中還要簡單，就連英文科目可以用糟糕來形容的同學也通過了，可能是學校內部的畢業門檻降低難度，而不參照全民英檢中級初試一樣的難度，反正對我來說通過了英文畢業門檻就達成目的了。第二件事情就是學校的教學評量已可以填寫，可以充分反映你學習了一整學期中，對老師的教導方式與課程內容的評語與改進方法，大部分科目都給予較好的分數與反應，只有少數教學不恰當的老師有給予評語和建言，雖然沒有十全十美的老師，但是只要學生反映給老師知道，而老師也聽了建議有所改善的話，相信在老師以後的教學上面能夠更加精進，不要當個混吃等死的老師，永遠怠惰不前、誤人子弟。
English:
I would like to search some tip in English grammar, but the tittle of grammars is so many. So I change the method to write English essay. I have been contact with English for a long time since I was in senior high school. In those days, I just repeat the grammar ,but not understand the true meaning in the words. However nowadays,the change of me that in write essay is no matter what I try to recognize the differences think about the real meaning in the grammar. Learning by Intuition, It is the new way to do.
學校近來有幾件事情適合論述，第一件事情就是英文畢業門檻成績已公布，考試難度比想像中還要簡單，就連英文科目可以用糟糕來形容的同學也通過了，可能是學校內部的畢業門檻降低難度，而不參照全民英檢中級初試一樣的難度，反正對我來說通過了英文畢業門檻就達成目的了。第二件事情就是學校的教學評量已可以填寫，可以充分反映你學習了一整學期中，對老師的教導方式與課程內容的評語與改進方法，大部分科目都給予較好的分數與反應，只有少數教學不恰當的老師有給予評語和建言，雖然沒有十全十美的老師，但是只要學生反映給老師知道，而老師也聽了建議有所改善的話，相信在老師以後的教學上面能夠更加精進，不要當個混吃等死的老師，永遠怠惰不前、誤人子弟。
English:
I would like to search some tip in English grammar, but the tittle of grammars is so many. So I change the method to write English essay. I have been contact with English for a long time since I was in senior high school. In those days, I just repeat the grammar ,but not understand the true meaning in the words. However nowadays,the change of me that in write essay is no matter what I try to recognize the differences think about the real meaning in the grammar. Learning by Intuition, It is the new way to do.
二進位檔案讀寫實作
bio0604將資料輸入到2進位檔案pdata.txt裡面
import java.io.*;
class bio0604{
public static void main(String[] args) throws IOException
{
DataOutputStream dout= new DataOutputStream (
new BufferedOutputStream(
new FileOutputStream("pdata.txt"))); // set filename
dout.writeChars("M00031"); // output id (String)
dout.writeChar('M'); // output gender (char)
dout.writeInt(85); // output score1 (int)
dout.writeDouble(0.27); // output weight1 (double)
dout.writeInt(76); // output score2 (int)
dout.writeDouble(0.33); // output weight2 (double)
dout.writeInt(81); // output score3 (int)
dout.writeDouble(0.4); // output weight3 (double)
dout.writeChars("M00037"); // output id (String)
dout.writeChar('F'); // output gender (char)
dout.writeInt(62); // output score1 (int)
dout.writeDouble(0.27); // output weight1 (double)
dout.writeInt(54); // output score2 (int)
dout.writeDouble(0.33); // output weight2 (double)
dout.writeInt(50); // output score3 (int)
dout.writeDouble(0.4); // output weight3 (double)
dout.flush();
dout.close();
}
}
bout0604從pdata.txt將2進位檔案解析並印出import java.io.*;
class bout0604{
public static void main(String[] args) throws IOException
{
DataInputStream din= new DataInputStream (
new BufferedInputStream(
new FileInputStream("pdata.txt"))); // set filename
char[] in=new char[6];
char gen,star;
int sc1,sc2,sc3;
double w1,w2,w3,fin;
String ss;
for(int i=0;i<6;i++) in[i]=din.readChar(); // output id (String)
gen=din.readChar(); // output gender (char)
sc1=din.readInt(); // output score1 (int)
w1=din.readDouble(); // output weight1 (double)
sc2=din.readInt(); // output score2 (int)
w2=din.readDouble(); // output weight2 (double)
sc3=din.readInt(); // output score3 (int)
w3=din.readDouble(); // output weight3 (double)
ss= new String(in);
if(gen=='M') star='*';
else star=' ';
fin=(int)((sc1*w1+sc2*w2+sc3*w3)*100)/100.0;
System.out.println(ss+star+" "+sc1+" "+sc2+" "+sc3+" "+fin);
for(int i=0;i<6;i++) in[i]=din.readChar(); // output id (String)
gen=din.readChar(); // output gender (char)
sc1=din.readInt(); // output score1 (int)
w1=din.readDouble(); // output weight1 (double)
sc2=din.readInt(); // output score2 (int)
w2=din.readDouble(); // output weight2 (double)
sc3=din.readInt(); // output score3 (int)
w3=din.readDouble(); // output weight3 (double)
ss= new String(in);
if(gen=='M') star='*';
else star=' ';
fin=(int)((sc1*w1+sc2*w2+sc3*w3)*100)/100.0;
System.out.println(ss+star+" "+sc1+" "+sc2+" "+sc3+" "+fin);
din.close();
}
}
以上為兩比資料分為同時寫入pdata.txt以及同時讀出，以下合併成一個程式碼import java.io.*;
class bfix0604{
public static void main(String[] args) throws IOException
{
DataOutputStream dout= new DataOutputStream (
new BufferedOutputStream(
new FileOutputStream("pdata.txt"))); // set filename
dout.writeChars("M00031"); // output id (String)
dout.writeChar('M'); // output gender (char)
dout.writeInt(85); // output score1 (int)
dout.writeDouble(0.27); // output weight1 (double)
dout.writeInt(76); // output score2 (int)
dout.writeDouble(0.33); // output weight2 (double)
dout.writeInt(81); // output score3 (int)
dout.writeDouble(0.4); // output weight3 (double)
dout.writeChars("M00037"); // output id (String)
dout.writeChar('F'); // output gender (char)
dout.writeInt(62); // output score1 (int)
dout.writeDouble(0.27); // output weight1 (double)
dout.writeInt(54); // output score2 (int)
dout.writeDouble(0.33); // output weight2 (double)
dout.writeInt(50); // output score3 (int)
dout.writeDouble(0.4); // output weight3 (double)
dout.flush();
dout.close();
DataInputStream din= new DataInputStream (
new BufferedInputStream(
new FileInputStream("pdata.txt"))); // set filename
char[] in=new char[6];
char gen,star;
int sc1,sc2,sc3;
double w1,w2,w3,fin;
String ss;
for(int i=0;i<6;i++) in[i]=din.readChar(); // output id (String)
gen=din.readChar(); // output gender (char)
sc1=din.readInt(); // output score1 (int)
w1=din.readDouble(); // output weight1 (double)
sc2=din.readInt(); // output score2 (int)
w2=din.readDouble(); // output weight2 (double)
sc3=din.readInt(); // output score3 (int)
w3=din.readDouble(); // output weight3 (double)
ss= new String(in);
if(gen=='M') star='*';
else star=' ';
fin=(int)((sc1*w1+sc2*w2+sc3*w3)*100)/100.0;
System.out.println(ss+star+" "+sc1+" "+sc2+" "+sc3+" "+fin);
for(int i=0;i<6;i++) in[i]=din.readChar(); // output id (String)
gen=din.readChar(); // output gender (char)
sc1=din.readInt(); // output score1 (int)
w1=din.readDouble(); // output weight1 (double)
sc2=din.readInt(); // output score2 (int)
w2=din.readDouble(); // output weight2 (double)
sc3=din.readInt(); // output score3 (int)
w3=din.readDouble(); // output weight3 (double)
ss= new String(in);
if(gen=='M') star='*';
else star=' ';
fin=(int)((sc1*w1+sc2*w2+sc3*w3)*100)/100.0;
System.out.println(ss+star+" "+sc1+" "+sc2+" "+sc3+" "+fin);
din.close();
}
}
執行序Thread實例
題目使用多執行序一起執行在執行的時候印出現在時間，利用不同的開頭字串區別開來，只利用for迴圈i的記數來緩衝無限迴圈，當把記數次數調低而出現次數會變多。
import java.util.Date;
class TimerThread extends Thread{
String s;
TimerThread(String ss){
s=ss;
}
public void run(){
while(true){
for(int i=0;i<1000000000;i++);
Date now=new Date();
System.out.println(s+" thread >>>" + now);
}
}
}
public class ex0604a2{
public static void main(String[] argv){
TimerThread Thread1=new TimerThread("+++++");
Thread1.start();
TimerThread Thread2=new TimerThread("-----");
Thread2.start();
TimerThread Thread3=new TimerThread("******");
Thread3.start();
while (true) {
for(int i=0;i<500000000;i++);
Date now=new Date();
System.out.println(" main >>>" + now);
}
}
}
物件導向期末小考5/28
物件導向設計原理期末考(II)A 102/5/28
1. class TLprice 繼承抽象類別 time 且實作介面 rating，用以計算電話通話費。
(a) abstract 類別 time 定義四個成員變數，及三個抽象方法：
• public int hh=0,mm=0,ss=0,seconds=0;
• toTime(String timeString); // 將時間字串轉成整數，分別存入
// hh (時)，mm (分)，ss(秒) 三個整數變數中
• toSeconds(); // hh*3600+mm*60+ss seconds
• getSeconds(); // 傳回轉成秒數的時間
(b) 介面 rating定義兩個抽象方法：
• callSec(); // 傳回通話秒數 (終話時間 - 始話時間)
• callPrice(char type, int callSec); // 傳回通話費用
(c) class TLprice繼承抽象類別 time 且實作介面 rating，且增加三個方法：
• getCallNo(); // 傳回發話號碼
• getCallType() // 傳回通話類別
• setLprice() // 設定區域通話費(以秒計價)
• setGprice() // 設定長途通話費(以秒計價)
• setMprice() // 設定行動通話費(以秒計價)
每筆通話記錄存放格式說明：
(a) 發話號碼Calling No.：0~7 字元
(b) 通話類別Call Type：8~8 字元 // L：區域通話, G：長途通話, M：行動通話
(c) 始話時間：9~14字元
(d) 終話時間：15~20字元
(a) (b) (c) (d)
25380000 L 110325 111007
2. 印出每筆通話記錄之 Calling No. Call Type Call Sec. Call Price
參考答案
編譯java檔案TLprice之後執行class的 prob10528印出結果
abstract class time{
public int hh=0,mm=0,ss=0,seconds=0;
abstract void toTime(String timeString);
abstract void toSeconds();
abstract int getSeconds();
}
interface rating{
abstract int callSec();
abstract double callPrice(char type, int callSec);
}
public class TLprice extends time implements rating{
String callRec;
public double Lprice=0, Gprice=0, Mprice=0;
TLprice(String ss){
callRec=ss;
}
public void toTime(String tt){
hh=Integer.parseInt(tt.substring(0,2));
mm=Integer.parseInt(tt.substring(2,4));
ss=Integer.parseInt(tt.substring(4));
}
public void toSeconds(){
seconds=hh*3600+mm*60+ss;
}
public int getSeconds(){
return seconds;
}
public String getCallNo(){
return callRec.substring(0,8);
}
public String getCallType(){
return callRec.substring(8);
}
public int callSec(){ // (終話時間 - 始話時間)
int sec1, sec2;
toTime(callRec.substring(9,15)); // 始話時間
toSeconds();
sec1=getSeconds();
toTime(callRec.substring(15)); // 終話時間
toSeconds();
sec2=getSeconds();
return sec2-sec1;
}
void setLprice(double pp){
Lprice=pp;
}
void setGprice(double pp){
Gprice=pp;
}
void setMprice(double pp){
Mprice=pp;
}
public double callPrice(char locate, int p){
switch(locate){
case 'L':
return Lprice*p;
case 'G':
return Gprice*p;
case 'M':
return Mprice*p;
default:
return 0.0;
}
}
}
class prob10528{
public static void main(String[] args){
double upL=0.05, upG=0.1, upM=0.15; // unit price of 3 call type
String[] callRec={"25380000L110325111007","25380011G122503123710","25381100M145912151559",
"25382222M151111151616","25383311L155555161616","25385566G162022163559",
"25386116M163333164316","25387123G170000172310","25388412L145912151559"};
System.out.println(" Calling No.\t Call Type \t Call Sec. \t Call Price");
for(String ss:callRec){
TLprice tl=new TLprice(ss);
tl.setLprice(upL);
tl.setGprice(upG);
tl.setMprice(upM);
System.out.println(" "+tl.getCallNo()+"\t "+tl.getCallType()+" \t"+tl.callSec()+" \t"+
tl.callPrice(ss.charAt(8), tl.callSec()));
}
}
}
物件導向設計原理期末考(II)B 102/5/28
1. 輸入兩班的成績資料檔： clsA.txt & clsB.txt
(a) clsA.txt 的存放格式：學號/性別/姓名/成績1/成績2/成績3/成績4
• 學期成績=成績1*0.15+成績2*0.25+成績3*0.3+成績4*0.3
• 性別M:男生，性別F:女生
(b) clsB.txt 的存放格式：學號(0~7) 性別(8~8)姓名(9~23)
成績1(24~26)成績2(27~29)成績3(30~32)成績4(33~35)
• 學期成績=成績1*0.15+成績2*0.25+成績3*0.3+成績4*0.3
• 性別M:男生，性別F:女生
(c) 先輸入clsA.txt，再輸入clsB.txt
* (可以 Skip step 2) 30%
2. 輸出前，先將「學期成績」及格的學生資料依成績由高至低順序排序。
輸出前，先將「學期成績」不及格的學生資料依成績由高至低順序排序。
3. 將「學期成績」及格的學生資料寫入 pass.txt 檔，
將「學期成績」不及格的學生資料寫入 fail.txt 檔，
輸出的格式為：學號(*) 姓名 成績1 成績2 成績3 成績4 學期成績
男生於學號後加上「*」，女生於學號後加上「 」
prob20528無排序
import java.io.*;
class prob20528{
public static void main(String[] args) throws IOException
{
FileReader fr1=new FileReader("clsA.txt"); // input file1: clsA.txt ==> A班學生成績資料檔
BufferedReader bfr1= new BufferedReader(fr1);
FileReader fr2=new FileReader("clsB.txt"); // input file2: clsB.txt ==> B班學生成績資料檔
BufferedReader bfr2= new BufferedReader(fr2);
//
// 將學號、姓名、成績1(15%), 成績2(25%), 成績3(30%), 成績4(30%)及學期成績輸出
//
FileWriter fw1 = new FileWriter("pass.txt"); // output file1:pass.txt 學期成績及格資料檔
BufferedWriter bfw1 = new BufferedWriter(fw1);
FileWriter fw2 = new FileWriter("fail.txt"); // output file2:fail.txt 學期成績不及格資料檔
BufferedWriter bfw2 = new BufferedWriter(fw2);
//
//
String name,id,str,gender,sc1,sc2,sc3,outstring="";
int recno=0,isc1,isc2,isc3, isc4, pno=0, fno=0;
double fin;
char star='*';
while ((str=bfr1.readLine())!=null) // read a record from input file1
{
String[] token=str.split("[/]");
id=token[0];
gender=token[1];
name=token[2];
isc1=Integer.parseInt(token[3]);
isc2=Integer.parseInt(token[4]);
isc3=Integer.parseInt(token[5]);
isc4=Integer.parseInt(token[6]);
fin=finScore(isc1,isc2,isc3,isc4);
if(gender.compareTo("M")==0) star='*';
else star=' ';
System.out.println(id+star+" "+name+" "+gender+" "+isc1+" "+isc2+" "+isc3+" "+isc4+" "+fin);
if(fin >= 60){
bfw1.write(id+star+" "+name+" "+gender+" "+isc1+" "+isc2+" "+isc3+" "+isc4+" "+fin);
bfw1.newLine();
}// output to pass.txt
else{
bfw2.write(id+star+" "+name+" "+gender+" "+isc1+" "+isc2+" "+isc3+" "+isc4+" "+fin);
bfw2.newLine();
}// output to fail.txt
}
while ((str=bfr2.readLine())!=null) // read a record from input file2
{
id=str.substring(0,8);
gender=str.substring(8,9);
name=str.substring(9,24);
isc1=Integer.parseInt(str.substring(24,27));
isc2=Integer.parseInt(str.substring(27,30));
isc3=Integer.parseInt(str.substring(30,33));
isc4=Integer.parseInt(str.substring(33));
fin=finScore(isc1,isc2,isc3,isc4);
if(gender.compareTo("M")==0) star='*';
else star=' ';
System.out.println(id+star+" "+name+" "+gender+" "+isc1+" "+isc2+" "+isc3+" "+isc4+" "+fin);
if(fin >= 60){
bfw1.write(id+star+" "+name+" "+gender+" "+isc1+" "+isc2+" "+isc3+" "+isc4+" "+fin);
bfw1.newLine();
}// output to pass.txt
else{
bfw2.write(id+star+" "+name+" "+gender+" "+isc1+" "+isc2+" "+isc3+" "+isc4+" "+fin);
bfw2.newLine();
}// output to fail.txt
}
bfw1.flush();
bfw2.flush();
fr1.close();
fw1.close();
fr2.close();
fw2.close();
}
static double finScore(int a, int b, int c, int d){
return (int)((a*0.15+b*0.25+c*0.3+d*0.3)*100)/100.0;
}
}
prob20528sort排序版本import java.io.*;
class score{
String[] data;
int no;
score(String[] ss, int num){
data=ss;
no=num;
}
void sort(){
String tmp;
for(int i=0;i<no-1;i++){
for(int j=i+1;j<no;j++){
if(data[i].compareTo(data[j]) < 0){
tmp=data[i];
data[i]=data[j];
data[j]=tmp;
}
}
}
}
}
class prob20528sort{
public static void main(String[] args) throws IOException
{
FileReader fr1=new FileReader("clsA.txt"); // input file1: clsA.txt ==> A班學生成績資料檔
BufferedReader bfr1= new BufferedReader(fr1);
FileReader fr2=new FileReader("clsB.txt"); // input file2: clsB.txt ==> B班學生成績資料檔
BufferedReader bfr2= new BufferedReader(fr2);
//
// 將學號、姓名、成績1(15%), 成績2(25%), 成績3(30%), 成績4(30%)及學期成績輸出
//
FileWriter fw1 = new FileWriter("pass.txt"); // output file1:pass.txt 學期成績及格資料檔
BufferedWriter bfw1 = new BufferedWriter(fw1);
FileWriter fw2 = new FileWriter("fail.txt"); // output file2:fail.txt 學期成績不及格資料檔
BufferedWriter bfw2 = new BufferedWriter(fw2);
//
//
String name,id,str,gender,sc1,sc2,sc3,outstring="";
int recno=0,isc1,isc2,isc3, isc4, pno=0, fno=0;
double fin;
String[] pass=new String[20]; // for sorting
String[] fail=new String[20]; // for sorting
char star='*';
while ((str=bfr1.readLine())!=null) // read a record from input file1
{
String[] token=str.split("[/]");
id=token[0];
gender=token[1];
name=token[2];
isc1=Integer.parseInt(token[3]);
isc2=Integer.parseInt(token[4]);
isc3=Integer.parseInt(token[5]);
isc4=Integer.parseInt(token[6]);
fin=finScore(isc1,isc2,isc3,isc4);
if(gender.compareTo("M")==0) star='*';
else star=' ';
System.out.println(id+star+" "+gender+" "+name+" "+isc1+" "+isc2+" "+isc3+" "+isc4+" "+fin);
outstring=fin+","+id+star+","+gender+","+name+","+isc1+","+isc2+","+isc3+","+isc4;
if(fin >= 60) pass[pno++]=outstring;
else fail[fno++]=outstring;
}
while ((str=bfr2.readLine())!=null) // read a record from input file2
{
id=str.substring(0,8);
gender=str.substring(8,9);
name=str.substring(9,24);
isc1=Integer.parseInt(str.substring(24,27));
isc2=Integer.parseInt(str.substring(27,30));
isc3=Integer.parseInt(str.substring(30,33));
isc4=Integer.parseInt(str.substring(33));
fin=finScore(isc1,isc2,isc3,isc4);
if(gender.compareTo("M")==0) star='*';
else star=' ';
System.out.println(id+star+" "+gender+" "+name+" "+isc1+" "+isc2+" "+isc3+" "+isc4+" "+fin);
outstring=fin+","+id+star+","+gender+","+name+","+isc1+","+isc2+","+isc3+","+isc4;
if(fin >= 60) pass[pno++]=outstring;
else fail[fno++]=outstring;
}
score score1 =new score(pass, pno);
score1.sort();
for(int i=0;i< pno;i++){
String[] tk=pass[i].split("[,]");
bfw1.write(tk[1]+" "+tk[2]+" "+tk[3]+" "+tk[4]+" "+tk[5]+" "+tk[6]+" "+tk[0]);
bfw1.newLine();
}
score score2=new score(fail, fno);
score2.sort();
for(int i=0;i< fno;i++){
String[] tk=fail[i].split("[,]");
bfw2.write(tk[1]+" "+tk[2]+" "+tk[3]+" "+tk[4]+" "+tk[5]+" "+tk[6]+" "+tk[0]);
bfw2.newLine();
}
bfw1.flush();
bfw2.flush();
fr1.close();
fw1.close();
fr2.close();
fw2.close();
}
static double finScore(int a, int b, int c, int d){
return (int)((a*0.15+b*0.25+c*0.3+d*0.3)*100)/100.0;
}
}
clsA
A9528003/F/Mary Chen/75/82/65/73
A9528005/M/Roney Liu/86/62/75/66
A9528006/M/CoCo Wu/43/62/45/50
A9528011/F/Jeny Kuo/95/88/93/92
A9528012/M/Johny Hu/72/66/65/73
A9528013/F/Colud Lu/53/42/35/47
A9528017/M/Beer Lee/77/66/88/54
A9528025/M/Cool Hung/43/62/45/65
A9528028/F/Fly Wang/93/82/98/85
A9528031/F/Rose Chung/82/76/67/70
clsB
A9528002MBruce Wang 075076065093
A9528008MRoney Chen 086072075057
A9528010FEdwin Liao 082086067050
A9528014FMilly Shai 095085093072
A9528018MAndy Chen 082063065073
A9528022FWoody Lu 063052035037
A9528026MBlue Cheng 071057093057
A9528030MDenny Hung 048063045045
A9528038FCandy Lin 093082088085
A9528042MAdam Wu 082088067074
A9528050FKitty Lee 042056041065
2013年6月3日 星期一
日記 2013/6/3 11:32
中文:
今天上最後一節的體育課，滿滿一整學期的羽球也快接近尾聲了，本想說羽球可能也和排球一樣輕鬆，能夠在體育館三樓吹冷氣、就算運動也不太會流汗，但在一開始打了整整兩節課的羽球之後才發現，其實羽球的運動量可能還不輸給很多運動，上課照的洪大程老師所教的一些羽球標準動作練習，羽球也是蠻有趣的運動，最後在羽球發球項目終於考到期望的分數了，希望各個科目也能夠更加精進，如果這篇文章也能夠更加有結構有順序那就更好了。
English:
In the beginning, today is a casual day like before, but when I hearing the news that my friend's cellphone
's mirror broken is so fun for me. He is the most unlucky man that I ever saw, before the broken of the mirror the cellphone also has some bug send to HTC company to fix it. But, in the few days the cellphone mar again. It's so surprise for me, the tragedy human being.
今天上最後一節的體育課，滿滿一整學期的羽球也快接近尾聲了，本想說羽球可能也和排球一樣輕鬆，能夠在體育館三樓吹冷氣、就算運動也不太會流汗，但在一開始打了整整兩節課的羽球之後才發現，其實羽球的運動量可能還不輸給很多運動，上課照的洪大程老師所教的一些羽球標準動作練習，羽球也是蠻有趣的運動，最後在羽球發球項目終於考到期望的分數了，希望各個科目也能夠更加精進，如果這篇文章也能夠更加有結構有順序那就更好了。
English:
In the beginning, today is a casual day like before, but when I hearing the news that my friend's cellphone
's mirror broken is so fun for me. He is the most unlucky man that I ever saw, before the broken of the mirror the cellphone also has some bug send to HTC company to fix it. But, in the few days the cellphone mar again. It's so surprise for me, the tragedy human being.
2013年6月2日 星期日
日記2013/6/2 10:02
中文:
最近發覺增進語文能力是很重要的一件事，在與人溝通或是文字上的交流也有莫大功效，三年級再進行專題研究的公文寫作等等，都需要在增進自己的中文寫作能力，希望能讓言語更有力量，先在個人部落格中增進語文寫作的技巧，希望以後能跟各網路部落格寫手一樣，能夠滔滔不絕地介紹或是陳述某些事情，能夠有結構邏輯的寫法、讓文章更引人入勝值得去閱讀。
English:
The things began with a idea occasionally, I want to practice my English literature. First , it's the best way to learn English, try to write something you think at your brain. Your thought exchange to other logic and that is also useful at earn new knowledge. Second, I also try to write at Chinese language, so why don't let them stick together easy to solve the problem. finally, I will do my best to do. Hope I can get so rewards and skills in it.
最近發覺增進語文能力是很重要的一件事，在與人溝通或是文字上的交流也有莫大功效，三年級再進行專題研究的公文寫作等等，都需要在增進自己的中文寫作能力，希望能讓言語更有力量，先在個人部落格中增進語文寫作的技巧，希望以後能跟各網路部落格寫手一樣，能夠滔滔不絕地介紹或是陳述某些事情，能夠有結構邏輯的寫法、讓文章更引人入勝值得去閱讀。
English:
The things began with a idea occasionally, I want to practice my English literature. First , it's the best way to learn English, try to write something you think at your brain. Your thought exchange to other logic and that is also useful at earn new knowledge. Second, I also try to write at Chinese language, so why don't let them stick together easy to solve the problem. finally, I will do my best to do. Hope I can get so rewards and skills in it.
訂閱：
文章 (Atom)