Advertisement
shamiul93

sqlQueryGenerator

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