java-scan java-create-cursor java-scan-table

rs=null;
String format="S,S,S,D,S,I,S,S,S"; // add column 1/5 step
sqlString="select banker,bankerno,surname,"+
" salary+bonus+commission+allowance,contracttype, employeenumber,"+
" departmentName,mpfnumber,startdateofEmp from employee where status='A';"; // add column 2/5 step
result=sqlString;
String formats[]=format.split(",");
rs = stmt.executeQuery(sqlString);
while (rs.next()){String id=rs.getString(1);}rs.last(); //go bottom
int rowCount=rs.getRow(); //go recno
dRaws = new String[rowCount*12][];
rs.beforeFirst(); //go top
int iRecno=0;
String rD=""; // RowDelimiter
//SCAN
while (rs.next()){
//20131003 dRaws[iRecno] = new String [20];  //insert column
result=result+rD+"[";
String fD="";  // fD=fieldDelimiter
//dRaws[i][8] start date hire date
java.util.Date temp = new SimpleDateFormat("yyyy-MM-dd").parse(rs.getString(9));
Calendar cal = Calendar.getInstance();
cal.setTime(temp);
int year = cal.get(Calendar.YEAR);
int month = cal.get(Calendar.MONTH)+1;
int day = cal.get(Calendar.DAY_OF_MONTH);
int employeeNoMonth=year*12+month;
int RequireNoMonth = Integer.parseInt(mYear)*12+Integer.parseInt(mMth);
result=result+"EmployeeHireDate"+employeeNoMonth+"     "+RequireNoMonth;
for (int j2=employeeNoMonth;j2<=RequireNoMonth;j2++) {
dRaws[iRecno] = new String [20];  //insert column
for (int j=1; j<=formats.length; j++){
if (formats[j-1].equals("I")){
result=result+fD+Integer.toString(rs.getInt(j));
if (rs.getString(j).equals("No Value") || rs.getString(j).equals("null")){dRaws[iRecno][j-1]="0";}
else {dRaws[iRecno][j-1]=Integer.toString(rs.getInt(j));}}
if (formats[j-1].equals("D")){
result=result+fD+Double.toString(rs.getDouble(j));
dRaws[iRecno][j-1]=Double.toString(rs.getDouble(j));
}
if (formats[j-1].equals("L")){
result=result+fD+Long.toString(rs.getLong(j));
dRaws[iRecno][j-1]=Long.toString(rs.getLong(j));
}
if (formats[j-1].equals("S")){
result=result+fD+rs.getString(j);
dRaws[iRecno][j-1]=rs.getString(j);
}
dRaws[iRecno][18]=mYear; // 20131003
dRaws[iRecno][19]=mMth; // 20131003
int i0=j2/12;
int i1=j2%12;
String s0= Integer.toString(i0);
String s1= Integer.toString(i1);
dRaws[iRecno][18]=s0; // 20131003
dRaws[iRecno][19]=s1; // 20131003
//Integer.parseInt(Input[i][13])
result=result+"\nadding j2 year month == "+j2+" "+s0+"     "+s1+"\n";
fD=",";
}
//result=result+"\nadding j2 year month == "+j2+" "+dRaws[iRecno][18]+"     "+dRaws[iRecno][19]+"\n";
result=result+"]";
rD=",\n";
++iRecno;
}
//20131003 ++iRecno;
}  // endscan