Convert PowerBuilder to Java

 
	long		var1
	long		var2[]
	string		var3
	datetime	var4
	boolean		var5
	decimal		var6
	integer		var7
	any		var8
 

 
let var1: number = 0;
let var2: Array<number> = [];
let var3: string = '';
let var4: Date;
let var5: boolean = false;
let var6: number = 0;
let var7: number = 0;
let var8: any = null;
 

 
public function string sample_function();
return "end" 
//do logic
end function
 

 
function sampleFunction(): string {
  return 'end';
  //do logic
}
 

 
protected subroutine sample_sub (string v_app);
	v_app = ""
//do logic
end subroutine
 

 
function sampleSub(vApp: string) {
  vApp = '';
  //do logic
}
 

 
integer i
 
if true then i = 1 else i = 2
 
if true then 
    i = 3
end if
 

 
let i: number = 0;
 
if (true) {
  i = 1;
} else {
  i = 2;
}
 
if (true) {
  i = 3;
}
 

 
For lv_count = 1 to 10 
	lb_units[lv_count].Visible = TRUE
Next
 

 
for (lvCount = 1; lvCount < 10; lvCount++) {
  lvCount[lvCount].visible = true;
}
 

 
IDX = 0
do while true
	if IDX = 10 then exit
	IDX = IDX + 1
loop
 

 
idx = 0;
while (true) {
  if (idx === 10) {
    break;
  }
  idx = idx + 1;
}
 

 
try
	IDX = 1 / 0
catch (Exception ex )
	IDX = 100
FINALLY
	IDX = IDX * 2
end try
 

 
try {
  idx = 1 / 0;
} catch (ex) {
  idx = 100;
} finally {
  idx = idx * 2;
}
 

 
integer		some_id
boolean cond
 
CHOOSE CASE some_id
	Case IS < 0
		cond = False
	CASE 0 TO 2
		cond = True
		some_id = 200
	Case IS > 0
		cond = True
	CASE ELSE
		cond = False
		some_id = 0
END CHOOSE
 

 
let someId: number = 0;
let cond: boolean = false;
 
switch (true) {
  case someId < 0:
    cond = false;
    break;
  case someId >= 0 && someId <= 2:
    cond = true;
    someId = 200;
    break;
  case someId > 0:
    cond = true;
    break;
  default:
    cond = false;
    someId = 0;
    break;
}
 

 
global type s_2 from structure
    long        field_1
end type
s_2 param1[]
 
	INSERT INTO TAB1
	  (             
		COL1 , COL2           
	  )
	VALUES
	  (
		:param1[1].field_1,
		:param1[2].field_1
	);
 

 
Client (typescript):
export type s2 = {
  field1: number;
};
 
export class S2 {
  static create(): s2 {
    return {
      field1: 0,
    };
  }
}
 
let param1: Array<s2> = [];
 
await request({
  path: 'fileName/query1',
  body: {
    params: [param1[0].field1, param1[1].field1],
  },
  method: 'POST',
});
 
server (Java):
private String QUERY1 = "INSERT INTO TAB1 "+
	  "( "+ 
		"COL1 , COL2 "+
	  ") "+
	"VALUES "+
	  "( ?, ?) ";
 
    @PostMapping(value = "/query1")
    public @ResponseBody
    int  query1(@RequestBody Map<String, Object> body) throws Exception {
 
        return sqlService. jdbcUpdate (QUERY1, (List<Object>)body.get("params"));   
 }
 

 
String v_uname[]
Long v_unum[]
Int  v_count = 1
 
DECLARE c_unit CURSOR FOR
SELECT U_NAME, U_NUM
FROM UNT 
WHERE A_NUM = 10;
 
OPEN c_unit;
FETCH c_unit INTO :v_uname[v_count],:v_unum[v_count];
v_count ++
Do While SQLCA.SQLCode = 0
	FETCH c_unit INTO :v_uname[v_count],:v_unum[v_count];
	v_count ++
Loop
CLOSE c_unit;
 

 
Client(typescript) :
let vUname: Array<string> = [];
let vUnum: Array<number> = [];
let vCount: number = 1;
 
let rows = await request({
  path: 'fileName/query1',
  body: {
    params: [],
  },
  method: 'POST',
});
 
for (let i = 0; i < rows.length; i++) {
  vUname[v_count] = rows[i].U_NAME;
  vUnum[v_count] = rows[i].U_NUM;
  vCount++;
}   
 
server(Java):
private String QUERY1 = "SELECT U_NAME, U_NUM FROM UNT  WHERE A_NUM = 10 ";
 
    @PostMapping(value = "/query1")
    public @ResponseBody
    Object query1(@RequestBody Map<String, Object> body) throws Exception {
 
        Object values = sqlService.jdbcSelect(QUERY1, (List<Object>)body.get("params"));
        return ResponseEntity.ok(values);
    }