Java source code from Tushar Kapila
o
center a frame in the middle of the screen, adjusting for the task bar.
JApplet that writes to file system Dj Data Capture runs on windows and mac
try {
htcon = (HttpConnection)Connector.open(url);
htcon .setRequestProperty("User-Agent",
"Profile/MIDP-2.0 Configuration/CLDC-1.0");
os = c.openOutputStream();
os.write("patientId(13).getFile(1)\n".getBytes());
os.flush();
rc = c.getResponseCode();
u.sl("opened url c.getResponseCode() " + c.getResponseCode());
if (rc != HttpConnection.HTTP_OK) {
//throw new IOException("HTTP response code: " + rc);
return false;
}
is = new BufferedInputStream(c.openInputStream());
HSSFWorkbook hssfWorkbook = new HSSFWorkbook(fs);
HSSFSheet hssfSheet = hssfWorkbook.getSheet(oSheetPro.sSheetName1 );
Utl.soup("\n\noSheetPro.sSheetName1 :" + oSheetPro.sSheetName1 + "|\t hssfSheet " + hssfSheet);
final int iNoSqlCols = Integer.parseInt( oPropsSql.getProperty("noSqlCols")) ;
final int iXlsCols = Integer.parseInt( oPropsSql.getProperty("m_nofXlsCols")) ;
Object []oRsltStRowDat = new Object[ iNoSqlCols];
i=-1;
int iIndxRow= -1;
HSSFRow hssfRow =null;
HSSFCell hssfCell =null;
Utl.soup("iXlsCols " + iXlsCols + "\t iNoSqlCols :" + iNoSqlCols);
while(oSqlDat.next()){
iIndxRow++;
for(i = 1; i <= iNoSqlCols ;i++){
oRsltStRowDat [i -1] = oSqlDat.getObject(i);
}
hssfRow = hssfSheet.getRow(oSheetPro.iS1FrmRow + iIndxRow);
if (hssfRow == null){
hssfRow =hssfSheet.createRow((short) (oSheetPro.iS1FrmRow + iIndxRow) );
}
Utl.soup("\noSheetPro.iS1FrmRow :" + oSheetPro.iS1FrmRow + "|\t iIndxRow " + iIndxRow
+ "\t hssfRow " + hssfRow + "|\toSheetPro.iS1FrmCol " + oSheetPro.iS1FrmCol);
for(i = 0; i< iXlsCols ;i++){
hssfCell = hssfRow.getCell((short) (oSheetPro.iS1FrmCol + i));
if (hssfCell ==null){
hssfCell = hssfRow.createCell((short) (oSheetPro.iS1FrmCol + i));
}
Utl.soup("\n i :" + i + "\t oColsInfo [i].getSqlColNumber() :" + oColsInfo [i].getSqlColNumber()
);
if(oColsInfo [i].isFormula() ){
}else{
hssfCell.setCellValue(oRsltStRowDat [oColsInfo [i].getSqlColNumber() -1 ].toString() );
}
}
}
/*HSSFCell hssfCell = hssfRow.getCell((short) oSheetPro.iS1FrmCol);
hssfCell.setCellFormula("b3*b4");
hssfCell = hssfRow.getCell((short) 3);
hssfCell.setCellValue(9);*/
oSheetPro.iJobNumber = oSheetPro.iJobNumber +1;