Search operation, By Address .
Return


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();
}
}