Difference between revisions of "Java-Business-Application/C2/Database-and-validation/Khasi"
From Script | Spoken-Tutorial
Hezekiah2016 (Talk | contribs) (Created page with "{| border = 1 | Time | Narration |- | 00:01 | Pdiang sngewbha sha '''spoken-tutorial''' halor ''' Database and validation.''' |- | 00:06 | Ha kane ka tutorial, ngin pule...") |
Hezekiah2016 (Talk | contribs) |
||
Line 41: | Line 41: | ||
|- | |- | ||
| 00:28 | | 00:28 | ||
− | | Ban bud | + | | Ban bud ïa kane ka tutorial, phi dei ban don ka jingtip ïaka: |
|- | |- | ||
Line 57: | Line 57: | ||
|- | |- | ||
| 00:42 | | 00:42 | ||
− | | Lada em, | + | | Lada em, naka bynta ki tutorial ba kum kane leit shaka website jong ngi. |
|- | |- | ||
|00:47 | |00:47 | ||
− | |Mynta, to ngin leit sha '''Netbeans IDE.''' | + | | Mynta, to ngin leit sha '''Netbeans IDE.''' |
|- | |- | ||
Line 158: | Line 158: | ||
|- | |- | ||
| 02:31 | | 02:31 | ||
− | | KaBa bud, Ngin peit ia u code | + | | KaBa bud, Ngin peit ia u code naka bynta ka '''JDBC connection.''' |
|- | |- | ||
Line 234: | Line 234: | ||
|- | |- | ||
| 04:15 | | 04:15 | ||
− | | | + | | une u '''interface''' u ai ïa ka jingpynlah ban phah ïaka '''request''' sha kawei pat ka resource. |
|- | |- | ||
Line 256: | Line 256: | ||
|- | |- | ||
− | | | + | | 04:41 |
| Type ka '''username ''' bad '''password ''' kaba ngi khlem shym la kynthup haka '''database.''' | | 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.''' | | Te, to ngan type '''abc ''' kum ka '''username '''bad '''abc123* ''' kum ka '''password.''' | ||
Line 295: | Line 295: | ||
|- | |- | ||
| 05:27 | | 05:27 | ||
− | | Ngi ai ïaki variable '''errorMsgs ''' hapoh ka '''request scope''' pyndonkam ka '''setAttribute''' '''method'''. | + | | Ngi ai ïaki variable ka '''errorMsgs ''' hapoh ka '''request scope''' pyndonkam ka '''setAttribute''' '''method'''. |
|- | |- | ||
Line 442: | Line 442: | ||
|- | |- | ||
| 08:57 | | 08:57 | ||
− | | Wanphai | + | | Wanphai sha u '''browser'''. |
|- | |- | ||
Line 513: | Line 513: | ||
|- | |- | ||
| 10:24 | | 10:24 | ||
− | | Kane ka lain jong ki | + | | Kane ka lain jong ki codes la khot '''directive ''' haka '''JSP.''' |
|- | |- | ||
Line 653: | Line 653: | ||
|- | |- | ||
| 13:24 | | 13:24 | ||
− | | Hapoh | + | | Hapoh ka '''scriptlet tags,''' ngi la shna ïaka '''object ''' ka rukom jong '''User.''' |
|- | |- | ||
Line 724: | Line 724: | ||
|- | |- | ||
| 15:02 | | 15:02 | ||
− | | Ban tip shuh shaphang ka spoken tutorial project, Peit ïaka video | + | | Ban tip shuh shaphang ka spoken tutorial project, Peit ïaka video ba don haka link harum. |
|- | |- | ||
| 15:07 | | 15:07 |
Latest revision as of 22:51, 29 May 2017
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. |