Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public String sqlQueryGenereator(String arr[]){
- String sql = "INSERT INTO `PROJECT`(`PROJECT_ID`, `PROJECT_NAME`, " +
- "`PROJECT_PURPOSE`, `PROJECT_DESC`, `APPROV_STATUS`, `YEAR`, " +
- "`FISCAL_YEAR`, `DIVISION_ID`, `DISTRICT_ID`, `CONSTITUENCY_ID`, " +
- "`SUB_DISTRICT_ID`, `TOTAL_ALLOCATION`, `MINISTRY_ID`, `SECTOR_ID`," +
- " `IMPL_ORG_ID`, `START_DATE`, `END_DATE`, `GOB`) VALUES ("+arr[0]+"," +
- arr[1]+","+arr[2]+","+arr[3]+","+arr[4]+","+arr[5]+","+arr[6]+","+arr[7]+"," +
- arr[8]+","+arr[9]+","+arr[10]+","+arr[11]+","+arr[12]+","+arr[13]+","+arr[14]+"," +
- arr[15]+","+arr[16]+","+arr[17]+")";
- return sql;
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement