Search operation, By Address . |
Search operation, By Address
- the new text Code to be add is red.
// 3- Search Operations by
address.... public void tabControl1_mouseUp(Object source, MouseEvent e) { // Tabpage no 0, by Word if (String.valueOf(tabControl1.getSelectedIndex()).toString().equals( "0")) { lbInfo.setText("Search operation available ..."); } else { // Tabpage no 1, By Address if (String.valueOf(tabControl1.getSelectedIndex()).toString().equals( "1")) { lbInfo1.setText("One moment ..."); //Clear the comboboxes comboBook.removeAll(); comboTitle.removeAll(); comboChapter.removeAll(); comboVerse.removeAll(); // Recordset declaration vrecordset = "select Book, BookTitle, Chapter, Verse from BibleTable where (BibleTable.Chapter = '001' and BibleTable.Verse = '001') or ( BibleTable.Book = '" + editBook.getText().toString() + "' and ( BibleTable.Chapter = '" + editChapter.getText().toString() + "' or BibleTable.Verse = '001'))"; openRecordset_search_address(vrecordset.toString()); //Comboboxes values Searchbyaddress(); // Message lbInfo1.setText("Search operation ..."); } } } //Comboboxes values void Searchbyaddress() { // Varaiables String vtextdata, vbook, vtitle, vchapter, vverse; //Clear the comboboxes comboBook.removeAll(); comboTitle.removeAll(); comboChapter.removeAll(); comboVerse.removeAll(); // Search Operation m_rs_address.moveFirst(); while (!m_rs_address.getEOF()) { //Values of Book, Title, Chapter and Verse fields vbook = m_rs_address.getField("Book").getString().toString(); vtitle = m_rs_address.getField("BookTitle").getString().toString(); vchapter = m_rs_address.getField("Chapter").getString().toString(); vverse = m_rs_address.getField("Verse").getString().toString(); if (!vbook.toString().equals(editBook.getText().toString())) { if ((vchapter.toString().equals("001")) && (vverse.toString().equals("001"))) { //Add item to combobook and combotitle comboboxes comboBook.addItem(vbook.toString()); comboTitle.addItem(vtitle.toString()); } } else { if ((vchapter.toString().equals("001")) && (vverse.toString().equals("001"))) { //Add item to combobook and combotitle comboboxes comboBook.addItem(vbook.toString()); comboTitle.addItem(vtitle.toString()); } if (!vchapter.toString().equals(editChapter.getText().toString())) { if (vverse.toString().equals("001")) { //Add item to combochapter and combochapterrecno comboboxes comboChapter.addItem(vchapter.toString()); } } else { if (vverse.toString().equals("001")) { //Add item to combochapter and comboverse comboboxes comboChapter.addItem(vchapter.toString()); comboVerse.addItem(vverse.toString()); } else { //Add item to comboverse and comboverserecno comboboxes comboVerse.addItem(vverse.toString()); } } } m_rs_address.moveNext(); } //Current string Values display at the Comboboxes int varcount = comboBook.getItemCount(); for( int i = 0; i < varcount; ++i ) { if (comboBook.getItem(i).toString().equals(editBook.getText().toString())) { comboBook.setSelectedIndex(i); comboTitle.setSelectedIndex(i); } } varcount = comboChapter.getItemCount(); for(int i = 0; i < varcount; ++i ) { if (comboChapter.getItem(i).toString().equals(editChapter.getText().toString())) comboChapter.setSelectedIndex(i); } varcount = comboVerse.getItemCount(); for( int i = 0; i < varcount; ++i ) { if (comboVerse.getItem(i).toString().equals(editVerse.getText().toString())) comboVerse.setSelectedIndex(i); } } public void comboTitle_selectedIndexChanged(Object source, Event e) { // Variables String vcombtitle = new String(); int recordno = 0; // selected item Value of the combotitle vcombtitle = comboTitle.getSelectedItem().toString(); // Record data boxes, data corresponding m_rs_word.moveFirst(); while (!m_rs_word.getEOF()) { if (m_rs_word.getField("BookTitle").getString().toString().equals(vcombtitle.toString()) && m_rs_word.getField("Chapter").getString().toString().equals("001") && m_rs_word.getField("Verse").getString().toString().equals("001")) { recordno = m_rs_word.getAbsolutePosition()-1; // Modify, Record data boxes m_rs.moveFirst(); m_rs.move(recordno); CalculValue(); // Navigation control if (recordno == 31103) SetButtons(false); else { if (recordno == 2) SetButtons(true); else SetButtonsAll(true); } break; } m_rs_word.moveNext(); } // Search (Title), data corresponding // Recordset declaration vrecordset = "select Book, BookTitle, Chapter, Verse from BibleTable where (BibleTable.Chapter = '001' and BibleTable.Verse = '001') or ( BibleTable.BookTitle = '" + vcombtitle.toString() + "' and ( BibleTable.Chapter = '001' or BibleTable.Verse = '001'))"; openRecordset_search_address(vrecordset.toString()); //Comboboxes values Searchbyaddress(); } public void comboBook_selectedIndexChanged(Object source, Event e) { // Variables String vcombbook = new String(); int recordno = 0; // selected item Value of the combobook vcombbook = comboBook.getSelectedItem().toString(); // Record data boxes, data corresponding m_rs_word.moveFirst(); while (!m_rs_word.getEOF()) { if (m_rs_word.getField("Book").getString().toString().equals(vcombbook.toString()) && m_rs_word.getField("Chapter").getString().toString().equals("001") && m_rs_word.getField("Verse").getString().toString().equals("001")) { recordno = m_rs_word.getAbsolutePosition()-1; // Modify, Record data boxes m_rs.moveFirst(); m_rs.move(recordno); CalculValue(); // Navigation control if (recordno == 31103) SetButtons(false); else { if (recordno == 2) SetButtons(true); else SetButtonsAll(true); } break; } m_rs_word.moveNext(); } // Search (Book), data corresponding // Recordset declaration vrecordset = "select Book, BookTitle, Chapter, Verse from BibleTable where (BibleTable.Chapter = '001' and BibleTable.Verse = '001') or ( BibleTable.Book = '" + vcombbook.toString() + "' and ( BibleTable.Chapter = '001' or BibleTable.Verse = '001'))"; openRecordset_search_address(vrecordset.toString()); //Comboboxes values Searchbyaddress(); } public void comboChapter_selectedIndexChanged(Object source, Event e) { // Variables String vcombbook = new String(); String vcombchapter = new String(); String vtextdata, vbook, vchapter, vverse; int recordno = 0; // selected item Value of the combobook vcombbook = comboBook.getText().toString(); vcombchapter = comboChapter.getSelectedItem().toString(); // Record data boxes, data corresponding m_rs_word.moveFirst(); while (!m_rs_word.getEOF()) { if (m_rs_word.getField("Book").getString().toString().equals(vcombbook.toString()) && m_rs_word.getField("Chapter").getString().toString().equals(vcombchapter.toString()) && m_rs_word.getField("Verse").getString().toString().equals("001")) { recordno = m_rs_word.getAbsolutePosition()-1; // Modify, Record data boxes m_rs.moveFirst(); m_rs.move(recordno); CalculValue(); // Navigation control if (recordno == 31103) SetButtons(false); else { if (recordno == 2) SetButtons(true); else SetButtonsAll(true); } break; } m_rs_word.moveNext(); } // Search by address (Chapter), data corresponding // Recordset declaration vrecordset = "select Book, BookTitle, Chapter, Verse from BibleTable where (BibleTable.Chapter = '001' and BibleTable.Verse = '001') or ( BibleTable.Book = '" + vcombbook.toString() + "' and ( BibleTable.Chapter = '" + vcombchapter + "' or BibleTable.Verse = '001'))"; openRecordset_search_address(vrecordset.toString()); //Clear the combobox comboVerse.removeAll(); // Search Operation, chapter m_rs_address.moveFirst(); while (!m_rs_address.getEOF()) { //Values of Book, Chapter and Verse fields vbook = m_rs_address.getField("Book").getString().toString(); vchapter = m_rs_address.getField("Chapter").getString().toString(); vverse = m_rs_address.getField("Verse").getString().toString(); if (vbook.toString().equals(vcombbook.toString()) && vchapter.toString().equals(vcombchapter.toString())) { comboVerse.addItem(vverse.toString()); } m_rs_address.moveNext(); } comboVerse.setSelectedIndex(0); } public void comboVerse_selectedIndexChanged(Object source, Event e) { // Variables String vcombbook = new String(); String vcombchapter = new String(); String vcombverse = new String(); int recordno = 0; // selected item Value of the combobook vcombbook = comboBook.getText().toString(); vcombchapter = comboChapter.getText().toString(); vcombverse = comboVerse.getSelectedItem().toString(); // Record data boxes, data corresponding m_rs_word.moveFirst(); while (!m_rs_word.getEOF()) { if (m_rs_word.getField("Book").getString().toString().equals(vcombbook.toString()) && m_rs_word.getField("Chapter").getString().toString().equals(vcombchapter.toString()) && m_rs_word.getField("Verse").getString().toString().equals(vcombverse.toString())) { recordno = m_rs_word.getAbsolutePosition()-1; // Modify, Record data boxes m_rs.moveFirst(); m_rs.move(recordno); CalculValue(); // Navigation control if (recordno == 31103) SetButtons(false); else { if (recordno == 2) SetButtons(true); else SetButtonsAll(true); } break; } m_rs_word.moveNext(); } } |