1 1 00:00:05,210 --> 00:00:06,043 line:15% Hello everybody, 2 2 00:00:06,043 --> 00:00:07,270 line:15% in this section we are going to create 3 3 00:00:07,270 --> 00:00:10,621 line:15% very, very nice and an advanced project. 4 4 00:00:10,621 --> 00:00:11,454 What's our project? 5 5 00:00:11,454 --> 00:00:12,490 Let me introduce it. 6 6 00:00:12,490 --> 00:00:15,240 Our project is a library management system. 7 7 00:00:15,240 --> 00:00:16,650 What we have here, 8 8 00:00:16,650 --> 00:00:20,920 here at top we have here, a toolbar, 9 9 00:00:20,920 --> 00:00:23,260 and we have three boxes for our toolbar, okay. 10 10 00:00:23,260 --> 00:00:26,330 And on the toolbar, we have here tabs, two different tabs. 11 11 00:00:26,330 --> 00:00:28,820 The first one is our library management tab. 12 12 00:00:28,820 --> 00:00:30,477 The second one is our statistics. 13 13 00:00:30,477 --> 00:00:32,090 Let me click this one. 14 14 00:00:32,090 --> 00:00:33,659 As you see now we have in the space here 15 15 00:00:33,659 --> 00:00:37,290 statistics for our library, 16 16 00:00:37,290 --> 00:00:40,570 and after that here let me click this one. 17 17 00:00:40,570 --> 00:00:44,210 Here on the left side we list all our books 18 18 00:00:44,210 --> 00:00:46,020 from our library, okay. 19 19 00:00:46,020 --> 00:00:49,500 You will get all the books from our database, of course. 20 20 00:00:49,500 --> 00:00:52,500 And here if I click that one, the Origin, 21 21 00:00:52,500 --> 00:00:54,120 as you see now on the right side, 22 22 00:00:54,120 --> 00:00:57,860 I see all the details of this book. 23 23 00:00:57,860 --> 00:01:02,027 Book name is Origin, author is Dan Brown, pages is 463, 24 24 00:01:03,132 --> 00:01:06,450 language is English, and status is taken. 25 25 00:01:06,450 --> 00:01:08,840 And for example, if I make double-click 26 26 00:01:09,846 --> 00:01:13,130 for, let's click this one, CyberStorm, okay. 27 27 00:01:13,130 --> 00:01:16,070 Now, it says this status is not taken, alright, 28 28 00:01:16,070 --> 00:01:19,090 and that means, this book is in my library, 29 29 00:01:19,090 --> 00:01:20,660 okay, not taken. 30 30 00:01:20,660 --> 00:01:23,680 If I make double-click here, you see, 31 31 00:01:23,680 --> 00:01:26,260 we will also click double and single-click even, 32 32 00:01:26,260 --> 00:01:28,190 so, okay, this was very important. 33 33 00:01:28,190 --> 00:01:30,360 Now CyberStorm is here, 34 34 00:01:30,360 --> 00:01:35,360 and now I can give this book to a member. 35 35 00:01:37,400 --> 00:01:39,080 Okay, this very important. 36 36 00:01:39,080 --> 00:01:43,040 Now, if I hit give book we will give this book to a member. 37 37 00:01:43,040 --> 00:01:45,920 Okay, and after that, what I will show you, 38 38 00:01:45,920 --> 00:01:48,590 I want to show you our search bar. 39 39 00:01:48,590 --> 00:01:49,640 What's our Search Bar? 40 40 00:01:49,640 --> 00:01:51,683 For example here, you want to list. 41 41 00:01:53,200 --> 00:01:56,520 Sorry, first you can list anything you want 42 42 00:01:56,520 --> 00:01:57,790 by using Search Bar. 43 43 00:01:57,790 --> 00:02:02,790 I only need to type here the keyword for your book, right, 44 44 00:02:03,780 --> 00:02:07,610 but for example, if you want to search for the keyword, 45 45 00:02:07,610 --> 00:02:12,610 okay, and here, as you see now, if you hit the button, 46 46 00:02:13,260 --> 00:02:16,990 our application will display all the books from database 47 47 00:02:18,160 --> 00:02:21,140 which has the keyword. 48 48 00:02:21,140 --> 00:02:22,540 Okay, this very important. 49 49 00:02:22,540 --> 00:02:25,410 And after here, of course, you can click one of them. 50 50 00:02:25,410 --> 00:02:29,214 You see The Da Vinci Code, and the details of this book 51 51 00:02:29,214 --> 00:02:31,350 it will be appear on the right side. 52 52 00:02:31,350 --> 00:02:34,210 For other one is, for example, The Critical Mind, 53 53 00:02:34,210 --> 00:02:38,160 as you see now for The Critical Mind our details is here. 54 54 00:02:38,160 --> 00:02:42,631 Of course, also, this one is not taken, right. 55 55 00:02:42,631 --> 00:02:46,980 Now, imagine coincidentally you have 3,000, 5,000, 56 56 00:02:46,980 --> 00:02:49,440 or 10,000 books in your library. 57 57 00:02:49,440 --> 00:02:52,140 Now we have, I think it's almost 50, 60, 58 58 00:02:52,140 --> 00:02:53,210 something like that, 59 59 00:02:53,210 --> 00:02:57,940 but the normal library should have more than 1,000, right? 60 60 00:02:57,940 --> 00:03:00,270 And how you can give a book, 61 61 00:03:00,270 --> 00:03:04,973 or how you can make search for your book is very important. 62 62 00:03:05,990 --> 00:03:08,180 For example, you have a member, 63 63 00:03:08,180 --> 00:03:10,510 and that member wants to get a book, okay. 64 64 00:03:10,510 --> 00:03:15,170 Its name is, for example, let's list all our books, firstly. 65 65 00:03:15,170 --> 00:03:19,350 This books, and it says, give me the book Think Fast. 66 66 00:03:19,350 --> 00:03:20,183 That one, okay. 67 67 00:03:20,183 --> 00:03:21,540 This is only example. 68 68 00:03:21,540 --> 00:03:25,410 You need to come here and say Think Fast, okay. 69 69 00:03:25,410 --> 00:03:28,820 And after search, and now you see our Think Fast is here. 70 70 00:03:28,820 --> 00:03:32,100 After you can make double-click on Think Fast, 71 71 00:03:32,100 --> 00:03:33,880 and after choose your member, 72 72 00:03:33,880 --> 00:03:37,300 and give your member this book. 73 73 00:03:37,300 --> 00:03:39,537 Okay, this is also very, very nice feature 74 74 00:03:42,390 --> 00:03:45,290 for this application, and after that here, 75 75 00:03:45,290 --> 00:03:48,510 what I want to show you, I want to show you sort by. 76 76 00:03:48,510 --> 00:03:50,390 Here, what we will do, 77 77 00:03:50,390 --> 00:03:53,100 for example, if you want to list all your books, 78 78 00:03:53,100 --> 00:03:55,630 and this is our radio button, and we will say, 79 79 00:03:55,630 --> 00:03:57,840 hit the list books, okay? 80 80 00:03:57,840 --> 00:04:01,440 As you see now, all our books is here, on the left side. 81 81 00:04:01,440 --> 00:04:05,120 Of course, if I click one of them, The Critical Mind, 82 82 00:04:05,120 --> 00:04:07,500 details of this book is will be shown here 83 83 00:04:08,620 --> 00:04:09,650 on the right side. 84 84 00:04:09,650 --> 00:04:10,920 If I want to show, 85 85 00:04:10,920 --> 00:04:15,920 or if I want the list only books in my library, okay, 86 86 00:04:16,000 --> 00:04:18,860 and here what I will say, I will come to here 87 87 00:04:18,860 --> 00:04:20,467 and list right here books in library, 88 88 00:04:20,467 --> 00:04:22,920 and these books, as you see now here, 89 89 00:04:22,920 --> 00:04:27,650 the books in library, they display them, okay. 90 90 00:04:27,650 --> 00:04:29,490 And the other one is borrowed books. 91 91 00:04:29,490 --> 00:04:32,500 If I want to list borrowed books I will come here, 92 92 00:04:32,500 --> 00:04:35,290 make my choice, okay, borrowed books, 93 93 00:04:35,290 --> 00:04:37,230 and I will say these books, as you see now, 94 94 00:04:37,230 --> 00:04:40,900 we have here one, two, three, four different books, 95 95 00:04:40,900 --> 00:04:42,130 and they are taken. 96 96 00:04:42,130 --> 00:04:46,410 Okay, and also, let's here check our statistics. 97 97 00:04:46,410 --> 00:04:48,260 You see now, taken books is four, 98 98 00:04:48,260 --> 00:04:50,960 and now here we see all the taken books is here, 99 99 00:04:50,960 --> 00:04:54,120 and one, two, three, four taken books, okay. 100 100 00:04:54,120 --> 00:04:56,030 As I said, this the application, 101 101 00:04:56,030 --> 00:04:59,080 it will be really, really useful, okay, 102 102 00:04:59,080 --> 00:05:01,170 and you will learn many things 103 103 00:05:01,170 --> 00:05:02,340 when we create this application 104 104 00:05:02,340 --> 00:05:04,780 because why I'm saying that, 105 105 00:05:04,780 --> 00:05:07,720 we are going to use really advanced SQL queries, okay, 106 106 00:05:07,720 --> 00:05:09,830 and also we are going to use different things 107 107 00:05:09,830 --> 00:05:11,173 for new things also. 108 108 00:05:11,173 --> 00:05:14,170 That's why I hope you will learn many, many things, 109 109 00:05:14,170 --> 00:05:16,290 line:15% and for now, that's all. 110 110 00:05:16,290 --> 00:05:17,957 line:15% See you in the next.