Simple BSP application to Create.docx
- 文档编号:3662610
- 上传时间:2022-11-24
- 格式:DOCX
- 页数:9
- 大小:312.28KB
Simple BSP application to Create.docx
《Simple BSP application to Create.docx》由会员分享,可在线阅读,更多相关《Simple BSP application to Create.docx(9页珍藏版)》请在冰豆网上搜索。
SimpleBSPapplicationtoCreate
SimpleBSPapplicationtoCreate,ModifyandDeletethedatabaseentries
BeforebuildingaBSPapplication,you’llhavetohavedatabasetable.
STEP1:
CalltransactionSE11;createadatabasetableusingpredefinedtypes.
STEP2:
Pushsomeentriesinthetable;
Enterabunchofemployee-ids,correspondingdate-of-birth,date-of-joiningandsalary.
STEP3:
CalltransactionSE80;createaBSPapplication.
STEP4:
Right-clicktheobjectnameandcreateapagewithflow-logic.
STEP5:
ChoosetheTypeDefinitionstabandcreateatype-definition.
STEP6:
ChoosethetabPageAttributesanddefinetheworkvariables,whichyouaregoingtouseinyourapplication.Besidesdefiningwork-variables,youhavetodefineaninternaltableandafieldstring.
Todefineafield-string,usetypes:
ff_progmr.Andtodefineaninternaltable,usetable-typeof‘ZART_PROGRAMMER’table.OpentableusingSE11,pressCtrl+Shift+F3(Where-Used-List),orclicktheicon
deselectothercheckboxesandselectTable-Types,pursedownthetable-typenameforthetableZART_PROGRAMMER.
Orcreateanewtable-type,ifthereexistsnotable-type.CalltransactionSE11->Datatype->Create->TableType->LineType:
ZART_PROGRAMMER->SaveandActivate.
fl_flagTYPEINT4
fs_progmrTYPEFF_PROGMR
t_progmrTYPEZART_TT
w_dobTYPEDATS
w_dojTYPEDATS
w_emnoTYPEZART_PROGRAMMER-EMNO
w_ext_dobTYPECHAR10
w_ext_dojTYPECHAR10
w_indexTYPEINT4
w_salaryTYPEZART_PROGRAMMER-SALARY
STEP7:
ChoosethetabLayoutanddesignaweb-pagethatshouldcontainatable-viewandtable-view-columns.Table-Viewchoosestheinternaltablefromwhichthedatahastobefetchedanddisplaysitinformattedmanner.Table-View-Column.
Togetatable-view,chooseTag-Browserfromtheleft-handpane;pulldownBSPExtensions->Transportable->HTMLB.Hereyougetalotofhtmlbcontrols,dragTable-Viewcontrolanddropitinthelayout(Foradditionaldetailsaboutit,right-clickthetagandgothroughdocumentation).
Whenyouactivatethispageandchoicetoviewtheoutput,itcan’thappensinceinternaltablecontainsnodata.
STEP8:
Topopulatedataininternaltable,chooseEventHandlertabandselectOnInitialization,thiseventistriggerednosoonerthepagegetsrefreshedorcalledforthefirsttime.
OnInitialization:
SELECT * FROM zart_programmer INTO TABLE t_progmr.
Save,activateandtestthepage:
Selection-Modeforthetable-viewhasbeendefinedas‘SINGLESELECT’,thisselectsdesiredrow.Now,weneedSelected-Row-Index,whicheasesourtasktoplayaroundwithanykindofmanipulationwedesire.
STEP8:
ChoosetabEventHandlerandselectOnInputProcessing.
OnInputProcessinghandles theeventsfor checking and processing user input andfor defining navigation.
CodethefollowinginOnInputProcessingevent;
DATA:
w_event TYPE REF TO cl_htmlb_event,
w_eventid TYPE string,
w_object TYPE REF TO object,
w_fieldid TYPE string,
w_in_field TYPE REF TO cl_htmlb_inputfield,
w_in_value TYPE string,
w_employee TYPE zart_programmer-emno,
w_dofb TYPE char10,
w_dofj TYPE char10,
w_esalary TYPE zart_programmer-salary.
CALL METHOD cl_htmlb_manager=>get_event
EXPORTING
request = runtime->server->request
* fast_exit_event_id =
* fast_exit_event_class =
RECEIVING
event = w_event.
w_eventid = w_event->id.
IF w_eventid EQ 'Programmer_Data'.
CLASS cl_htmlb_manager DEFINITION LOAD.
CASE event_id.
WHEN cl_htmlb_manager=>event_id.
DATA:
event TYPE REF TO if_htmlb_data,
selrow TYPE REF TO cl_htmlb_tableview.
event = cl_htmlb_manager=>get_event_ex( request ).
selrow ?
= cl_htmlb_manager=>get_data( request = request
name = 'tableView'
id = 'Programmer_Data).
DATA:
tv_data TYPE REF TO cl_htmlb_event_tableview.
tv_data = selrow->data.
w_index = tv_data->selectedrowindex.
ENDCASE.
w_eventidcontainstheidofbutton,table-view,etc.
w_indexcontainsselected-row-indexvalue.
Tocatchtheevent,wemakeuseofClasscl_htmlb_managerandmethodget_event.
Similarly,tocatchdatafrominput-fields,get_datamethodisused.
STEP10:
Ontheclickofcreatebutton,wesetthefl_flagas2,thatcanbeusedtodisplaycreatelayoutwithaninsertbuttononthesamepage.Further,onclickofinsertbutton,valuesofallinputfieldsareprocessedandinsertedintodatabaseusingasimpleINSERTquery.
AddthefollowingcodeinOnInputProcessing;
ELSEIF w_eventid EQ 'create'.
fl_flag = 2.
Now,addthispieceofcodeinthelayout;
<%
elseif fl_flag eq 2.
%>
label for = "ip_emno" labelType = "MEDIUM" text = "Employee Number" /> | inputField id = "ip_emno” disabled = "FALSE" /> |
label for = "ip_dob" labelType = "MEDIUM" text = "Date of Birth" /> | inputField id = "ip_dob"/> |
label for = "ip_doj" labelType = "MEDIUM" text = "Date of Joining" /> | inputField id = "ip_doj"/> |
label for = "ip_salary" labelType = "MEDIUM" text = "Salary" /> | inputField id = "ip_salary"/> |
button id = "insert" tooltip = "Create a New Record" text = "INSERT" onClick = "OnInputProcessing()" />
|
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- Simple BSP application to Create