Java-Business-Application/C2/Database-and-validation/Khasi

Time	Narration
00:01	Pdiang sngewbha sha spoken-tutorial halor Database and validation.
00:06	Ha kane ka tutorial, ngin pule ban:
00:08	ïatrei lang bad ka database bad
00:10	Validate ïaki fields.
00:12	Hangne ngi pyndonkam ka :Ubuntu Version 12.04
00:15	Netbeans IDE 7.3
00:19	JDK 1.7
00:21	Firefox web-browser 21.0
00:24	Phi lah ban pyndonkam uno uno u web-browser uba phi kwah.
00:28	Ban bud ïa kane ka tutorial, phi dei ban don ka jingtip ïaka:
00:31	Ki Basics jong Java Servlets bad JSPs
00:35	Ban connect sha ka MySQL Database naka Netbeans IDE
00:39	Shna ïaka database bad tables
00:42	Lada em, naka bynta ki tutorial ba kum kane leit shaka website jong ngi.
00:47	Mynta, to ngin leit sha Netbeans IDE.
00:52	Nga la sdang ïaka MySQL server.
00:55	Nga lahdep shna ïaka database ka ba kyrteng library.
01:00	Nga lahdep shna ïaka table ka ba kyrteng ka Users.
01:04	Nga lahdep thep lypa katto katne ki value ha kane ka table.
01:08	Ngan pyni ïaki mynta.
01:10	Na bynta kata, right click ha Users bad click ha View Data.
01:15	Click u jingshon Output uba ha trai.
01:19	Ngi lah ban iohi hangne baki don 15 users .
01:23	Ngi lah ban iohi ïaka FirstName, Surname, Age, Gender, email, Username bad Password.
01:31	Mynta, to ngin load ïaka JDBC driver kata Java Database Connectivity Driver.
01:39	Na bynta kata, click ha u Projects tab.
01:42	Right-click ha Libraries bad click ha Add Library.
01:46	Nangta click ha u MySQL JDBC Driver.
01:50	Bad click ha Add Library.
01:53	Kane kan load ïa u JDBC Driver.
01:56	To ngin run iaka Project kumba ngi lah leh hashwa.
02:00	Mynta, type iaka User Name kum "arya" bad Password kum "arya123*".
02:06	Nangta click ha Sign In.
02:08	Ngi lah ban ioh ïaka Success Greeting Page.
02:12	Click ha here ban logout.
02:15	Mynta, to ngin leit phai pat sha ka IDE.
02:17	NGin leit sha ka GreetingServlet dot java.
02:21	Wan sha ka doPost method.
02:23	Hakaba nyngkong, ngi ioh ïaka username bad password naka request pyndonkam ka getParameter() method.
02:31	KaBa bud, Ngin peit ia u code naka bynta ka JDBC connection.
02:35	Nyngkong, ngi la buhdak sdang ïaka Connection object, PreparedStatement object bad ResultSet object sha null.
02:44	Nangta ngi register ïa u driver haka program jong ngi.
02:48	Nangta ngi shna ïaka connection sha ka database.
02:52	Nangta, ngi execute ïaka prepareStatement method haka Connection object.
02:58	Ngi ai ïaka query ban ioh ïa ki user detail naka Users table.
03:03	Ngi peit la ka username bad password ki long ne em katkum kiba la pyndap ha ka form.
03:09	Hangne, U dak jingkylli u thew ïa kawei pa kawei ka field haka database.
03:15	Ban thep ki value haka jaka u dak jingkylli, ngi pyntreikam ïaka setString() method.
03:22	Ngi leh ïa kane dakaba pyndonkam ka PreparedStatement object.
03:26	Nangta ngi pyntreikam ïaka executeQuery method ha ka object Prepared statement.
03:33	NGi buh ïa kaba mih ha ka object ResultSet.
03:37	Na bynta ka jing login bajop, ngi pyni ïaka successGreeting page.
03:43	Na bynta kane, ngi pyndonkam ka RequestDispatcher interface.
03:48	Ngi pyndonkam ka method getRequestDispatcher() haka request ban ioh ïaka object RequestDispatcher.
03:56	Nangta ngi pynmih ïaka method forward() haka object RequestDispatcher.
04:02	Ha kane ka rukom, ngi forward sha ka successGreeting dot jsp.
04:07	Mynta leit phai biang sha ki slides.
04:10	To ngin pule khyndiat shaphang u RequestDispatcher interface.
04:15	une u interface u ai ïa ka jingpynlah ban phah ïaka request sha kawei pat ka resource.
04:22	Ka resource ka lah ban long ka html, servlet lane jsp.
04:26	Mynta, to ngin phai pat sha ka IDE.
04:29	To ngin wan sha successGreeting dot'jsp.'
04:33	Hangne, ngi la pyni ïa ka success message You have successfully logged in.
04:38	Mynta, phai biang sha u browser.
04:41	Type ka username bad password kaba ngi khlem shym la kynthup haka database.
04:47	Te, to ngan type abc kum ka username bad abc123* kum ka password.
04:56	Nangta click ha Sign In.
04:59	Ngi lah ban iohi ba ngi ioh ïaka error message ha kajuh hi ka page.
05:03	"Please correct the following errors!!! Invalid username or password" .
05:09	Mynta, to ngin peit ïa u code Na bynta kane.
05:12	TE, phai biang sha ka IDE.
05:14	leit sha GreetingServlet dot java.
05:17	lada ka validation ka bakla te ngin sa iohi ïaka error message.
05:22	Nyngkong, ngi lahdep ban buhdak sdang ïa ka List jong ki errorMsgs.
05:27	Ngi ai ïaki variable ka errorMsgs hapoh ka request scope pyndonkam ka setAttribute method.
05:35	Hangne, ka errorMsgs kadei ka kyrteng jong ka attribute.
05:39	NGi lah buhdak sdang ïa u String variable id sha null.
05:44	Nangta, ngi peit lada u user lah don ne em haka database.
05:48	lada hooid, ngi thep ïa ki value ha u variable id.
05:53	Lymda kumta, ngi thep ïa ka error "Invalid username or password" sha ka errorMsgs list.
06:00	Lada ka errorMsgs list kam long thylli te ngi pyni ïaka error messages haka index dot jsp.
06:09	te, ngi donkam ban pynphai pat sha ka index dot jsp.
06:13	Ngi lahdep iohi lypa kumno ban pynphai pat sha kawei ka page pyndonkam ka RequestDispatcher.
06:20	Peit thuh ba ngi la kynthup lang ïa une u code hapoh ka try catch block ban pynbiang ïaka exception scenario.
06:27	Mynta, ngin peit kumno ban ioh ïaki variable errorMsgs ha ka index dot jsp.
06:34	Nyngkong, ngi ioh shwa ïa ka value jong ka attribute "errorMsgs".
06:38	La leh ïa kane dakaba pyndonkam ka getAttribute method haka request.
06:44	Peit thuh ba ngi la thep lang ïaka Java code hapoh ki tag basdang kaba long less than sign percentage sign bad u tag ba kut percentage sign and greater than sign.
06:57	Kane ka block ïa u code ba tip kum scriptlet.
07:02	U kynthup ïa u Java code uba pyntreikam manla ka por ba la pyntreikam ïa u JSP .
07:08	Lada ka value jong ki errorMsgs kim dei null te ngi pyni ïa kane ka message.
07:15	"Please correct the following errors".
07:18	Nangta ngi bthah ba kan ïaid biang ïaka list jong ki errorMsgs baroh.
07:23	Nangta, ngi pynpaw ïaka error messages kum ka list.
07:27	Hakane ka rukom ngi pynpaw ïaki error messages haka index dot jsp.
07:32	Mynta, to ngin peit kumno ban pynrung u user sha ka database.
07:37	Shwa ban pynrung ïa u user sha ka database, ngi donkam ban shna ïa ka model na bynta ka User table.
07:44	Mynta, to ngin peit kaei ka model.
07:48	KA model : Ka thew ïaki rukom shong ki logical structure jong ki data haka software application.
07:55	KA Java class ryngkat attributes bad setters bad getters na bynta jong ki.
08:00	Ha kane ka rukom, ngi lah ban shim ïaka model kum kawei haka jaka jong ki attributes ba marwei marwei.
08:07	Mynta, Phai biang sha ka Netbeans IDE.
08:11	Nga lahdep shna lypa ïaka model User dot java.
08:16	Peit thuh ba ngi la shna ïa kane ka Java class hapoh ka package org dot spokentutorial dot model.
08:24	Ngi don ïaki attribute harum - firstName, surname, age, gender, email, username bad password.
08:33	Ngi lah buhdak sdang ïaki ha ki value ba thylli.
08:37	Nangta ngi don ka parameterized constructor.
08:41	NGi don ruh ïa u default constructor.
08:44	Ngi batai ïaka getFirstName method.
08:47	Ngi la batai ruh ïaka setFirstName method.
08:51	Kumjuh ruh, ngi la batai ïaka set bad get methods ha kawei pa kawei ka attributes.
08:57	Wanphai sha u browser.
08:59	Mynta, to ngin click ha u link here ban register.
09:03	Type ha baroh ki fields haka Registration page.
09:07	Nangta click ha Add User.
09:10	Ngi ïoh ïaka Add User Success page.
09:14	Ngi ioh ïaka message: "Your request to add harshita was successful".
09:20	Hangne harshita Kadei ka username kaba ngi lah ai.
09:24	Mynta, to ngin peit kumno la leh ïa kane.
09:28	te, phaibiang sha ka IDE.
09:30	Leit sha AddUserServlet dot java.
09:35	Ki synjam ki ïasyriem bad kito kiba ngi la leh ha ka GreetingServlet dot java.
09:40	Nyngkong, ngi ioh ïaka form parameters pyndonkam ka getParameter method.
09:46	Ngi buhdak sdang ïaki variable user kum instance jong u User model with individual attributes.
09:53	Ngi buh ïaki variable user hapoh ka request scope pyndonkam ka setAttribute method.
10:01	Lada kam don ka jingbakla haka por ba pyndap ïaka form, ngi execute ïaka query ban thep ïaki values shapoh ka Users table.
10:10	Nangta ngi phah pat sha ka successUser page.
10:15	Mynta, to ngin wan shaka successUser dot jsp.
10:19	Nyngkong, ngi la import ka User dot java.
10:24	Kane ka lain jong ki codes la khot directive haka JSP.
10:28	KA JSP directive ka sdang da ki tag ba sdang - 'less than sign percentage sign and at the rate sign' bad ka kut daki tag ba khang - 'percentage sign and greater than sign'.
10:42	Kane kadei ka page directive.
10:45	Ka page directive ka kynthup ïaka list jong baroh ki packages bala import.
10:50	NGi ioh ïaka value attribute jong ki user bad buh ïaki kum ki User object.
10:57	Nangta, ngi don ïaka success message hangne.
11:00	Hangne, ngi lah sei ïaka Username.
11:04	Ngi la pyndonkam ïa ka getUsername() method ha ka request object.
11:09	Ngi la leh ïa kane dakaba pyndonkam ki scriptlet tags.
11:12	Mynta , to ngin wanphai biang sha u browser.
11:15	Ngin pyrshang ban pynrung ïa u user uba la don lypa haka database.
11:20	Te, ngan pyrshang ban pynrung biang harshita.
11:24	Ngi lah ban iohi ba ngi ioh ïaka error message "Please correct the following errors!!!! Duplicate entry 'harshita' for key 'UserName'.
11:33	Mynta, to ngin register na bynta u user sa shisien.
11:37	Hangne, nga pyndap ïaka form mynta.
11:40	Nga la shna iaka Age field kaba bakla.
11:44	Nga la type ab haka jaka jong u number uba dei.
11:48	Mynta, click ha Add User.
11:51	Ngi iohi, ba ngi ioh ia ka error message- "The age must be a positive integer".
11:57	Mynta, to ngin peit kumno la leh ïakane.
12:00	Phai pat sha ka IDE.
12:03	Plie ïaka AddUserServlet dot java.
12:08	Hangne ruh, ngi la shna ïaka list na bynta ki errorMsgs.
12:11	Nangta ngi buh ki variable errorMsgs shapoh jong ka request scope pyndonkam ka setAttribute method.
12:18	Nangta, ngi la pynbna ïaka ageUser jong ka type integer bad ngi la buh ïaka dak sdang sha -1 (minus one).
12:26	Hapoh jong u try catch block, ngi la pyndonkam ka parseInt method.
12:31	Kane kan pynphai ïa u integer, bala ai ïa u string representation jong ki number kum ka input.
12:37	Te, hangne ngi lah ban pynshisha ba ka age field ka kynthup ïa u dak jingkheiñ badei.
12:44	Lada ka jingpynshisha ka bakla te ngi thep ïaka error message sha ka errorMsgs list.
12:51	The age Must be a positive integer.
12:54	Kumjuh ruh, ngi dei ban pynshisha ïa baroh ki fields ba kin don ïaki data ba dei.
13:01	Lada ka errorMsgs kam long thylli the ngin pyni ïaka errorMsgs ha ka addUser dot jsp hi.
13:09	Ngi lahdep peit kumno ban leh ïa kane dakaba pyndonkam u RequestDispatcher.
13:15	Mynta, to ngin wan sha ka addUser dot jsp.
13:19	Hangne ruh, nyngkong ngi dei ban import shwa ïa u User dot java.
13:24	Hapoh ka scriptlet tags, ngi la shna ïaka object ka rukom jong User.
13:31	Nangta ngi ioh ïa ka value jong ka attribute errorMsgs pyndonkam ka getAttribute method.
13:38	ngi peit lada kane ka value ka ïa ryngkat ne em bad u null.
13:43	Lada kam ïa ryngkat bad u null te ngi pyni ïaka error message kumba ngi la leh na bynta ka index dot jsp.
13:51	Lada em, ngin ioh ïaka value jong ka attribute user na ka request pyndonkam ka 'User' model.
13:59	Te ngi ioh ïaka form.
14:01	Ka form tag ka don ka action kum AddUserServlet bad method kum POST.
14:07	Ka Jaka ba nyngkong kadei ka First Name jong input type kum text , name kum firstName bad value kum user dot getFirstName.
14:18	Hangne, ngi la buh dak sdang ïaka value jong ka firstName sha empty string.
14:24	kumjuh ruh, phi dei ban leh naka bynta kiwei ruh ki fields.
14:28	Ngi don ruh u jingshon submit bad value kum Add User.
14:33	Kumne ngi leh ban pynshisha ïa ki fields hakaaddUser.jsp.
14:38	Phi lah ban pyrshang ïaki errors bapher bapher haka "addUser" page.
14:42	Mynta to ngin peit lada lah thep ne em ïaka user harshita sha ka database.
14:49	Te, wan biang sha ka Users table. Ngi lah ban iohi ba ïaka harshita la thep sha ka database.
14:56	Ha kane ka tutorial, ngi la pule ban:
14:58	Database connectivity bad
15:00	Field validation.
15:02	Ban tip shuh shaphang ka spoken tutorial project, Peit ïaka video ba don haka link harum.
15:07	Ka batai lyngkot ïaka Spoken Tutorial project.
15:11	Lada phim don ka bandwidth ba biang, phi lah ban download bad peit ïaka.
15:15	Ka Spoken Tutorial Project team:
15:17	Ka pynlong workshops dakaba pyndonkam ki spoken tutorials.
15:20	Ka ai certificates sha kito kiba pass ïaka on-line test.
15:23	Ban tip kham bniah, sngewbha thoh sha: contact@spoken-tutorial.org
15:29	Spoken Tutorial project kadei shi bynta jong ka ‘‘‘Talk to a Teacher project.
15:32	La kyrshan ïaka daka National Mission on Education Lyngba ka ICT, MHRD, Sorkar India.
15:38	Khambun ka jingtip halor kane ka mission kadon ha ka :http://spoken-tutorial.org/NMEICT-Intro
15:48	ïaka Library Management System la noh synniang da ka software MNC ba pawkhmat lyngba ka programme "Corporate Social Responsibility" jong ki.
15:57	Ki la pynkhamti ruh ïaka content naka bynta kane ka spoken tutorial.
16:02	ïa kane ka script la pynkylla sha ka ktien Khasi da I Hezekiah Lyngdoh na Shillong. Khublei ba phi la ïasnohlang.

Contributors and Content Editors

Hezekiah2016