Java-Business-Application/C2/Creating-and-viewing-inventories/Khasi
From Script | Spoken-Tutorial
Revision as of 17:37, 24 May 2017 by Hezekiah2016 (Talk | contribs)
Time | Narration |
00:01 | Pdiang sngewbha sha ka spoken-tutorial halor Creating and viewing inventories. |
00:07 | Ha kane ka tutorial, ngin pule ban: |
00:09 | Ban pynpher ïaka login page ban redirect sha admin page |
00:14 | Ban sei ïa baroh ki jingbniah jong ki kot, |
00:17 | Ban sei ïa ki jingbniah jong ki kot bala shim kylliang. |
00:20 | Ban pyni ïaki kot bala shim kylliang da ki user bala logged in. |
00:25 | Hangne ngi pyndonkam ka: |
00:27 | Ubuntu Version 12.04 |
00:29 | Netbeans IDE 7.3 |
00:32 | JDK 1.7 |
00:34 | Firefox web-browser 21.0 |
00:38 | Phi lah ban pyndonkam uno uno u web-browser uba phi kwah. |
00:42 | Ban bud ïakane ka tutorial, phi dei ban don ka jingtip ïa: |
00:45 | Ki Basics jong Java Servlets bad JSPs |
00:50 | Database bad validation ïaki fields. |
00:53 | Lada em, na bynta ki tutorial ba kum kane leit shaka website jong ngi. |
00:57 | Mynta, to ngin leit sha Netbeans IDE. |
01:01 | Nga lahdep shna ïaka Books table. |
01:04 | Phi lah ban ïohi ïa ki fields bapher bapher haka table. |
01:08 | Nga lah thep ruh 10 books hapoh kane ka table. |
01:12 | Nga lah shna ïaka Checkout table ban buh ïaki kot bala shim kylliang. |
01:18 | Nga la thep 5 tylli ki entries hapoh ka Checkout table. |
01:24 | Nga lahdep shna ruh ïaka model na bynta kaBook bad Checkout. |
01:29 | Ka Book.java kadei ka book model. |
01:32 | Bad ka Checkout.java kadei ka checkout model. |
01:37 | Mynta, wan sha u browser. |
01:40 | To ngin login kum u admin. |
01:43 | Te, ngan type ïaka username bad password kum admin. Nangta click ha Sign In. |
01:51 | Ngi lah ban iohi ba ngi la wan sha ka Admin Section Page. |
01:55 | Ngin sa wan biang sha kane ka page. Mynta to ngin leit biang sha ka Netbeans IDE. |
02:02 | Ngin peit, Kumno ngi pynpher ïaka GreetingServlet ban redirect sha ka Admin Page. |
02:08 | To ngin peit ïaka GreetingServlet.java. |
02:13 | Hangne ngi check la ka username bad password ka ïaryngkat bad u admin. |
02:19 | Lada hooid, te ngi redirect sha ka adminsection.jsp. |
02:25 | Ngi lahdep peit kymno ban phah sha kawei ka page dakaba pyndonkam u RequestDispatcher. |
02:32 | Mynta, phai biang sha u browser. |
02:35 | Ngi don ar tylli ki jingjied hangne. |
02:37 | Ngin click ha u radio button na bynta ka List Books. |
02:41 | Te click ha u Submit button. |
02:44 | Hangne, ngi lah ban iohi ba ngi don ka list jong baroh ki Books. |
02:49 | Ka don ïa baroh ki jingbatai bniah kum - Book Id, Book Name, Author Name, ISBN, Publisher, Total Copies and Available copies. |
02:59 | Mynta, Ngan pyni ïaphi kumno la leh ïa kane. |
03:03 | Phai biang sha ka IDE. |
03:05 | Mynta, to ngin wan sha ka adminsection dot jsp. |
03:10 | Hangne ngi don ar tylli ki radio buttons. |
03:14 | U ba nyngkong u dei ban list ïa baroh ki books. |
03:19 | Ngi lah ban iohi ba haka adminsection dot jsp, ngi don ka form action ba ïaryngkat AdminSection. |
03:28 | Mynta, Plie ïaka AdminSection dot java. |
03:32 | Hangne, kane ka checks ïa ki jingjied ba ngi click haki. |
03:36 | Ngi click ha List Books. |
03:39 | Te, kane ka bynta jong ka query yn sa pyntreikam. |
03:44 | Ngi pyntreikam ïaka query ban ioh ïaki kot naka Books table. |
03:49 | Ba bud, ngi shna ïaka ArrayList ban buh ïaki detail jong ki kot. |
03:55 | Nangta ngi bthah lyngba ka result set. |
03:59 | Ngi shna ïaka Book object. |
04:03 | Ngi buh ïaka BookId hapoh jong ka Book object. |
04:08 | Kumjuh ruh, ngi buh ia kiwei ki attribute jong ki kot hapoh jong ka Book object. |
04:16 | Nangta ngi thep ïaka book object hapoh ka books list. |
04:21 | Nangta ngi buh ïaka ArrayList books hapoh ka request. |
04:26 | Nangta ngi phah ïa ka request sha ka listBooks.jsp pyndonkam ka RequestDispatcher. |
04:33 | Mynta, ngi wan sha ka listBooks.jsp. |
04:38 | Ha kane ka page, u admin u lah ban peit ïaka list jong ki kot. |
04:43 | Hangne, ngi shim shwa ïaki books naka request. |
04:48 | Kane ka HTML table kan pyni ïaki detail jong ki kot. |
04:54 | Te, ngin bthah lyngba ka book list. |
04:58 | Hangne, ngi pyni ïaka BookId jong ki kot. |
05:02 | Kumjuh ruh, ngi pyni ïa kiwei pat ki attribute jong ki kot. |
05:07 | Ha kane ka rukom ngi pyni ïaka list jong ki kot. |
05:11 | Mynta, phai biang sha u browser. |
05:14 | Click ha ka List Borrowed Books. |
05:17 | Bad click ha u Submit button. |
05:20 | Ngi iohi ïaka list jong baroh ki Books issued. |
05:24 | Ka don ki detail kum Transaction Id, Book Id bad Username. |
05:29 | Mynta, Ngan phai biang sha ka IDE |
05:32 | bad pyni ïaphi ïa u code naka bynta kane. |
05:35 | Leit sha AdminSection.java. |
05:38 | Ngi lahdep click ha List Borrowed Books. |
05:42 | Te ka menuSelection ka ïa ryngkat ïaka List Borrowed books. |
05:47 | KI synjam ki long ïasyriem bad kiba ngi lah iohi na bynta ka List Books. |
05:53 | NGi pyntreikam ïaka query ban ioh ïaki detail jong ki kot bala shim kylliang na ka Checkout table. |
05:59 | Nangta ngi bthah lyngba ka borrowed books |
06:02 | bad buh ïaka hapoh ka request kum ka checkout attribute. |
06:07 | Mynta, ngi wan sha ka listBorrowedBooks.jsp. |
06:12 | Hangne ngi ioh ïaka checkout naka request. |
06:17 | Ngi bthah ïaka lyngba ka Checkout list |
06:20 | bad ngi pyni hangne ïaki attributes jong ka Checkout. |
06:25 | Ha kane ka rukom ngi pyni ïa ki Borrowed Books. |
06:28 | Mynta, phai biang sha u browser. |
06:30 | Ha ka borrowed books page, ngi don sa kawei ka list. |
06:36 | Ka list jong ki books issued hakaba kacurrent date ka lah tam ïaka return date. |
06:43 | Phai biang sha ka IDE ban iohi ïa u code. |
06:46 | ïa Kane la leh ha kajuh ka rukom kum ba ngi leh ïaka Borrowed Books. |
06:50 | Ka jingïapher ka long tang ha ka SQL query. |
06:56 | haka query, ngi ai ïaka condition: return_date less than now() order by transaction_Id. |
07:05 | Mynta, Ngan pyni ïaphi u interface naka bynta ki normal user. |
07:10 | Phai biang sha u browser. |
07:12 | Wan biang sha ka login page. |
07:15 | Ngan login kum mdhusein. |
07:20 | Type ïaka password kum welcome |
07:22 | bad click ha Sign In. |
07:25 | Ngi ioh ïaka Success Greeting Page. |
07:28 | Ka don ïa ki kot ba dang shim kylliang da u user. |
07:32 | Ka don ïaki detail kum Transaction Id, User Name, Book Id bad Return Date. |
07:39 | Mynta, to ngin wan biang sha ka IDE. |
07:43 | Mynta ngi leit sha ka GreetingServlet.java. |
07:47 | Ngi pyni ïaki kot bala ai ha kajuh ka rukom kumba ngi leh ïa u admin. |
07:53 | Hangne ka jingïapher kan long ba ngi dei ban pyni ïaki kot na bynta ki user bala log in. |
08:02 | Te, nga ioh iaka username na une u laiñ. |
08:05 | Nangta ngi shim ïa ki detail jong ki kot bala shim kylliang. |
08:10 | daka username ka ïa ryngkat bad u logged-in user. |
08:14 | Te, ngi ioh ïaka list jong ki kot bala ai naka bynta uta u user. |
08:20 | Nangta, haka successGreeting dot jsp ngin pyni ïaka list. |
08:27 | Kumne ka successGreeting dot jsp kan long. |
08:32 | Ha kane ka tutorial, ngi la pule ban: |
08:35 | Pynpher ïaka login page ban redirect sha ka admin page |
08:39 | Ban ioh ïaki detail jong ki kot. |
08:42 | Ban ioh ïaki detail jong ki kot bala shim kylliang bad |
08:45 | Ban pyni ïa ki kot bala shim kylliang da u user bala log in. |
08:50 | Ban tip shuh shaphang ka spoken tutorial project, Peit ïaka video badon haka link harum. |
08:56 | Ka batai lyngkot ïaka Spoken Tutorial project. |
08:59 | Lada phim don ka bandwidth kaba biang, phi lah ban download bad peit ïaka. |
09:04 | Ka Spoken Tutorial Project team: |
09:06 | Ka pynlong workshops dakaba pyndonkam ki spoken tutorials. |
09:09 | Ka ai certificates sha kito kiba pass ïaka on-line test. |
09:13 | Ban tip kham bniah, sngewbha thoh sha: contact@spoken-tutorial.org |
09:20 | Spoken Tutorial project kadei shi bynta jong ka ‘‘‘Talk to a Teacher project. |
09:24 | La kyrshan ïaka daka National Mission on Education Lyngba ka ICT, MHRD, Sorkar India. |
09:30 | Khambun ka jingtip halor kane ka mission kadon ha ka :http://spoken-tutorial.org/NMEICT-Intro |
09:40 | ïaka Library Management System la noh synniang da ka software MNC ba pawkhmat lyngba ka programme "Corporate Social Responsibility" jong ki. |
09:49 | Ki la pynkhamti ruh ïaka content naka bynta kane ka spoken tutorial. |
09:53 | ïa kane ka script la pynkylla sha ka ktien Khasi da I Hezekiah Lyngdoh na Shillong. |
09:57 | Khublei ba phi la ïasnohlang. |