I got a problem with RecordStore when I fetch it and put it into array I got multiple results.
I mean when I have 3 records and fetch it by enumerateRecords then put it into array[][] and then fetch it again, I know that is wrong way to fetch again, but how can I add resultset of recordstore into array[][] and then fetch resultset of array[][]?
My Code:
public Table showRs(){
String sID = null,sName = null,sTOE = null;
hrs.openRecordStore(hrs.getRecordnameBasic());
//hrs.listofRecord();
RecordEnumeration re;
try {
re = hrs.getRcs().enumerateRecords(null, null, true);
while(re.hasNextElement()){
byte[] recordBuffer = re.nextRecord();
String record = new String(recordBuffer);
//ID
int iID = record.indexOf(";");
sID = record.substring(0,iID);
//Name
int iName = record.indexOf(";", iID+1);
sName = record.substring(iID + 1,iName);
//Type of Est
int iTOE = record.indexOf(";", iName + 1);
sTOE = record.substring(iName + 1, iTOE);
int rc = hrs.getRcs().getNumRecords();
tb = new Table(mf, this, "List of record");
TableCell cells[][] = new TableCell[rc][3];
for(int i = 0; i< rc ; i++){
System.out.println("-------" + sID);
cells[i][0] = new TableCell(CellType.STRING, sID, true);
cells[i][1] = new TableCell(CellType.STRING, sName, true);
cells[i][2] = new TableCell(CellType.STRING, sTOE, true);
}
String header[] = new String[]{"ID", "Name", "TypeOfEst"};
tb.setData(new int[]{40,97,98}, header, cells);
}
} catch (Exception e) {
e.printStackTrace();
}
return tb;
}
Table
import java.util.Vector;
import javax.microedition.lcdui.*;
import javax.microedition.midlet.MIDlet;
public class Table extends Canvas implements CommandListener {
private MIDlet midlet;
private Displayable preScreen;
private String tableName;
private int oneRowHeight;
private int Countrow = 2;
private int Countcol = 2;
protected int focusRow = 0;// cursor focus on row
protected int focusCol = 0;// cursor focus on col
private int pad = 0;// pad between row
private int scrollBarWidth = 4;// SCroll bar for table
private int headerHeight;
private String header[] = {" ", " "};//Table header
private int colWidth[] = {118, 118};// total width screen
public TableCell cells[][] = {{new TableCell(CellType.STRING, "Name", false), new TableCell(CellType.STRING, "Bush", true)}, {new TableCell(CellType.STRING, "Sex", false), new TableCell(CellType.ITEM, "Male", new String[]{"Male", "Female"}, true)}};
private Font font = Font.getDefaultFont();// table font
private Command editCommand;
private Command backCommand;
private CellEditor cellEditor;//cell can be edit
public Table(MIDlet midlet, Displayable preScreen, String tableName) {
this.midlet = midlet;
this.preScreen = preScreen;
this.tableName = tableName;
init();
repaint();
}
private void init() {
setTitle(tableName);
editCommand = new Command("Edit", Command.ITEM, 1);
backCommand = new Command("Back", Command.BACK, 1);
addCommand(editCommand);
addCommand(backCommand);
setCommandListener(this);
calculateTableHeight();
repaint();
}
/*
*This method allow me set data into table
*and set total width for table and table header
*/
public void setData(int colWidth[], String header[], TableCell[][] cells) {
if (colWidth.length != cells[0].length || (header != null && colWidth.length != header.length)) {
System.out.println("Invalid Argument.");
return;
}
this.colWidth = colWidth;
this.cells = cells;
this.header = header;
Countrow = cells.length;
Countcol = cells[0].length;
calculateTableHeight();
repaint();
}
/*
* Set table's font
*/
public void setFont(Font font) {
this.font = font;
calculateTableHeight();
repaint();
}
/*
*This method calculate all cells' height.
*Long cell text will be splited into several segments(several lines).
*/
protected void calculateTableHeight() {
oneRowHeight = font.getHeight() + 1;//depends on height of font
if(header==null){
headerHeight=0;
}else{
headerHeight = oneRowHeight;
}
int xTemp = 0;
int yTemp = headerHeight;
int rowHeight=oneRowHeight;
StringBuffer sb = new StringBuffer();
for (int i = 0; i < Countrow; i++) {
rowHeight = oneRowHeight;
xTemp = 0;
for (int j = 0; j < Countcol; j++) {
cells[i][j].x = xTemp;
xTemp += colWidth[j];
cells[i][j].y = yTemp;
cells[i][j].width = colWidth[j];
if (cells[i][j].cellText == null || font.stringWidth(cells[i][j].cellText) < colWidth[j]) {
cells[i][j].height = oneRowHeight;
cells[i][j].multiLine = false;
} else {
cells[i][j].multiLine = true;
cells[i][j].cellString = new Vector();// create vector to store String in that cell
sb.setLength(0);
for (int k = 0; k < cells[i][j].cellText.length(); k++) {
sb.append(cells[i][j].cellText.charAt(k));//append string into sb until the end of string
if (font.stringWidth(sb.toString()) > colWidth[j]) {
sb.deleteCharAt(sb.length() - 1);
cells[i][j].cellString.addElement(sb.toString());
sb.setLength(0);
sb.append(cells[i][j].cellText.charAt(k));
}
}
if (sb.length() > 0) {
cells[i][j].cellString.addElement(sb.toString());
}
cells[i][j].height = oneRowHeight * cells[i][j].cellString.size();
}
if (rowHeight < cells[i][j].height) {
rowHeight= cells[i][j].height;
}
}
for (int j = 0; j < Countcol; j++) {
cells[i][j].height = rowHeight;
}
yTemp += cells[i][0].height;
}
}
protected void paint(Graphics g) {
g.setFont(font);
//draw table background
g.setColor(0xffffff);
g.fillRect(0, 0, this.getWidth(), this.getHeight());
//draw table border line
g.setColor(0x000000);
g.drawLine(0, 0, cells[0][Countcol-1].x+cells[0][Countcol-1].width, 0);
g.drawLine(0, 0, 0, cells[Countrow-1][0].y+cells[Countrow-1][0].height);
g.drawLine(cells[0][Countcol-1].x+cells[0][Countcol-1].width, 0, cells[0][Countcol-1].x+cells[0][Countcol-1].width, cells[Countrow-1][0].y+cells[Countrow-1][0].height);
g.drawLine(0, cells[Countrow-1][0].y+cells[Countrow-1][0].height, cells[0][Countcol-1].x+cells[0][Countcol-1].width, cells[Countrow-1][0].y+cells[Countrow-1][0].height);
//draw cells
for (int i = 0; i < Countrow; i++) {
//draw cell background
if (i % 2 == 0) {
g.setColor(0xe7f3f8);
g.fillRect(1, cells[i][0].y - pad + 1, cells[i][Countcol - 1].x + cells[i][Countcol - 1].width, cells[i][0].height - 2);
}
g.setColor(0x000000);
g.drawLine(0, cells[i][0].y - pad + cells[i][0].height, cells[i][Countcol - 1].x + cells[i][Countcol - 1].width, cells[i][0].y + cells[i][0].height - pad);
//draw cell text
for (int j = 0; j < Countcol; j++) {
//draw single-line text
if (!cells[i][j].multiLine) {
if (cells[i][j].cellText != null) {
g.drawString(cells[i][j].cellText, cells[i][j].x + 1, cells[i][j].y - pad + 1, 0);
}
} else {
//draw multi-line text
for (int a = 0; a < cells[i][j].cellString.size(); a++) {
g.drawString(cells[i][j].cellString.elementAt(a).toString(), cells[i][j].x + 1, cells[i][j].y + oneRowHeight * a - pad + 1, 0);
}
}
}
}
//draw table header
if (header != null) {
g.setColor(0xA0A0A0);
g.fillRect(1, 1, cells[0][Countcol - 1].x + cells[0][Countcol - 1].width, headerHeight);
g.setColor(0x000000);
g.drawLine(0, 0, cells[0][Countcol - 1].x + cells[0][Countcol - 1].width, 0);
g.drawLine(0, headerHeight, cells[0][Countcol - 1].x + cells[0][Countcol - 1].width, headerHeight);
for (int i = 0; i < header.length; i++) {
g.drawString(header[i], cells[0][i].x + 1, 0, 0);
}
}
//draw vertical line
int temp = 0;
for (int i = 0; i < colWidth.length; i++) {
temp += colWidth[i];
g.drawLine(temp, 0, temp, cells[Countrow - 1][0].y + cells[Countrow - 1][0].height);
}
//draw scrollbar
g.drawLine(this.getWidth() - scrollBarWidth, 0, this.getWidth() - scrollBarWidth, this.getHeight() - 1);
g.fillRect(this.getWidth() - scrollBarWidth, 0, scrollBarWidth, ((int) (this.getHeight() * (focusRow + 1) / Countrow)));
//draw focus cell
g.setColor(0x3a9ff7);
g.fillRect(cells[focusRow][focusCol].x + 1, cells[focusRow][focusCol].y - pad + 1, cells[focusRow][focusCol].width - 1, cells[focusRow][focusCol].height - 1);
g.setColor(0x000000);
if (!cells[focusRow][focusCol].multiLine) {
if (cells[focusRow][focusCol].cellText != null) {
g.drawString(cells[focusRow][focusCol].cellText, cells[focusRow][focusCol].x + 1, cells[focusRow][focusCol].y - pad + 1, 0);
}
} else {
for (int i = 0; i < cells[focusRow][focusCol].cellString.size(); i++) {
g.drawString(cells[focusRow][focusCol].cellString.elementAt(i).toString(), cells[focusRow][focusCol].x + 1, cells[focusRow][focusCol].y + oneRowHeight * i - pad + 1, 0);
}
}
}
public void commandAction(Command com, Displayable display) {
if (com == backCommand) {
Display.getDisplay(midlet).setCurrent(preScreen);
} else if (com == editCommand) {
if (cells[focusRow][focusCol].editable) {
editCell(cells[focusRow][focusCol]);
}
}
}
private void editCell(TableCell cell) {
if (cellEditor == null) {
cellEditor = new CellEditor(midlet, this, "");
}
cellEditor.setCell(cell);
Display.getDisplay(midlet).setCurrent(cellEditor);
}
public void keyPressed(int keyCode) {
switch (keyCode) {
case -3: //left
focusCol--;
if (focusCol <= 0) {
focusCol = 0;
}
break;
case -4: //right
focusCol++;
if (focusCol >= Countcol - 1) {
focusCol = Countcol - 1;
}
break;
case -1: //up
focusRow--;
if (focusRow <= 0) {
focusRow = 0;
}
if (cells[focusRow][0].y < pad+headerHeight) {
pad = cells[focusRow][0].y-headerHeight;
}
break;
case -2: //down
focusRow++;
if (focusRow >= Countrow - 1) {
focusRow = Countrow - 1;
}
if (cells[focusRow][0].y + cells[focusRow][0].height-pad> this.getHeight()) {
pad = cells[focusRow][0].y + cells[focusRow][0].height - this.getHeight();
}
break;
case 13:
if (cells[focusRow][focusCol].editable) {
editCell(cells[focusRow][focusCol]);
}
break;
}
repaint();
}
}
Table Cell
import java.util.Vector;
public class TableCell {
int x, y, width, height;
int cellType;// types of cell - String , int or other type.
boolean editable = false;// cell can be edit or not.
boolean multiLine = false;// long text can be split into several lines.
public Vector cellString;
public String[] itemOptions;// itemOptions used when cell type is Item.
public String cellText;
public TableCell(){
this(CellType.STRING, "", true);
}
public TableCell(int cellType, String cellText, boolean editable) {
this.cellType = cellType;
this.cellText = cellText;
this.editable = editable;
}
public TableCell(int cellType, String cellText, String[] itemOptions, boolean editable){
this.cellType = cellType;
this.cellText = cellText;
this.itemOptions = itemOptions;
this.editable = editable;
}
/*
*all objects need to be represent by string
*
*/
public String toString(){
return "TableCell: x=" + x + ",y=" + y + ",width=" + width + ",height=" + height+",cellText="+cellText;
}
}
Cell Type
/* * To change this template, choose Tools | Templates * and open the template in the editor. */
package ui.table;
public class CellType {
public static final int STRING = 0;
public static final int NUMBER = 1;
public static final int ITEM = 2;
}
Cell Editor
import javax.microedition.lcdui.ChoiceGroup;
import javax.microedition.lcdui.Command;
import javax.microedition.lcdui.CommandListener;
import javax.microedition.lcdui.Display;
import javax.microedition.lcdui.Displayable;
import javax.microedition.lcdui.Form;
import javax.microedition.lcdui.TextField;
import javax.microedition.midlet.MIDlet;
public class CellEditor extends Form implements CommandListener {
private MIDlet midlet = null;
private Table previousScreen = null;
private Command backCommand = null;
private Command OKCommand = null;
private TextField textField;
private ChoiceGroup choiceGroup;
private TableCell cell;
public CellEditor(MIDlet midlet, Table previousScreen, String title) {
super(title);
this.midlet = midlet;
this.previousScreen = previousScreen;
initialize();
}
private void initialize() {
backCommand = new Command("Back", Command.BACK, 1);
OKCommand = new Command("OK", Command.OK, 1);
addCommand(backCommand);
addCommand(OKCommand);
setCommandListener(this);
}
public void setCell(TableCell cell) {
this.cell = cell;
deleteAll();
if (cell.cellType == CellType.STRING) {
textField = getTextField();
textField.setConstraints(TextField.ANY);
textField.setString(cell.cellText);
append(textField);
} else if (cell.cellType == CellType.NUMBER) {
textField = getTextField();
textField.setConstraints(TextField.NUMERIC);
textField.setString(cell.cellText);
append(textField);
} else {
choiceGroup=getChoiceGroup();
choiceGroup.deleteAll();
for (int i = 0; i < cell.itemOptions.length; i++) {
choiceGroup.append(cell.itemOptions[i], null);
if (cell.cellText.equals(cell.itemOptions[i])) {
choiceGroup.setSelectedIndex(i, true);
}
}
append(choiceGroup);
}
}
public TextField getTextField() {
if (textField == null) {
textField = new TextField("", "", 300, TextField.ANY);
}
return textField;
}
public ChoiceGroup getChoiceGroup() {
if (choiceGroup == null) {
choiceGroup = new ChoiceGroup("", ChoiceGroup.EXCLUSIVE);
}
return choiceGroup;
}
public void commandAction(Command com, Displayable display) {
if (com == backCommand) {
Display.getDisplay(midlet).setCurrent(previousScreen);
} else if (com == OKCommand) {
if (cell.cellType == CellType.ITEM) {
previousScreen.cells[previousScreen.focusRow][previousScreen.focusCol].cellText = choiceGroup.getString(choiceGroup.getSelectedIndex());
} else {
previousScreen.cells[previousScreen.focusRow][previousScreen.focusCol].cellText = textField.getString();
}
previousScreen.calculateTableHeight();
Display.getDisplay(midlet).setCurrent(previousScreen);
}
}
}
And I want to output data from ResultSet
It's still not quite clear what exactly is the problem, but it feels like you better try dropping internal for loop and moving table / cells declaration outside of while:
//...
String sID = null, sName = null, sTOE = null;
hrs.openRecordStore(hrs.getRecordnameBasic());
//hrs.listofRecord();
RecordEnumeration re;
try {
// move table / cells declaration outside of while:
int rc = hrs.getRcs().getNumRecords();
tb = new Table(mf, this, "List of record");
TableCell cells[][] = new TableCell[rc][3];
int i = 0;
re = hrs.getRcs().enumerateRecords(null, null, true);
while(re.hasNextElement()){
byte[] recordBuffer = re.nextRecord();
//... stuff that was there
sTOE = record.substring(iName + 1, iTOE);
// drop that loop - for(int i = 0; i< rc ; i++){
System.out.println("-------" + sID);
cells[i][0] = new TableCell(CellType.STRING, sID, true);
cells[i][1] = new TableCell(CellType.STRING, sName, true);
cells[i][2] = new TableCell(CellType.STRING, sTOE, true);
i++;
}
String header[] = new String[]{"ID", "Name", "TypeOfEst"};
tb.setData(new int[]{40,97,98}, header, cells);
} catch (Exception e) {
e.printStackTrace();
}
//...