Java-Business-Application/C2/Creating-and-viewing-inventories/Khasi

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 sha ka 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	Ki 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 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 kyndon ka 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.

Contributors and Content Editors

Hezekiah2016