Readdatabase.class
package JavaSMSProject;
import java.io.File;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.IOException;
import java.util.ArrayList;
import java.util.List;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.xssf.usermodel.XSSFRow;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
public class ReadDatabase {
public void writeToExcel(String fileName, String uid, String amount) throws IOException {
Integer cellValue = 0;
Integer cellAmount = 0;
Integer bal = 0;
Integer phoneNumber = 0;
FileInputStream fsIP= new FileInputStream(new File(fileName));
XSSFWorkbook workbook = new XSSFWorkbook(fsIP);
XSSFSheet sheet = workbook.getSheetAt(0);
int count = sheet.getPhysicalNumberOfRows();
System.out.println(count);
List<String> list = new ArrayList<String>();
/*int size = list.size();
*/
for(int i=0; i < count - 1; i++){
XSSFRow row1 = sheet.getRow(i + 1);
Cell cell1 = row1.getCell(0);
cellValue = (int)Math.round(cell1.getNumericCellValue());
System.out.println("UserId:" + cellValue);
String matchuid = cellValue.toString();
if(uid.equalsIgnoreCase(matchuid)){
Cell cell2 = row1.getCell(1);
cellAmount = (int)Math.round(cell2.getNumericCellValue());
System.out.println("Amount:" + cellAmount);
bal = cellAmount - Integer.parseInt(amount);
System.out.println("Bal remaning:" + bal);
Cell cell3 = row1.getCell(2);
phoneNumber = (int)Math.round(cell3.getNumericCellValue());
System.out.println("Phone number:" + phoneNumber);
cell2.setCellValue(bal.doubleValue());
CopyOfSMSclass sms = new CopyOfSMSclass();
sms.sendSMS(Integer.parseInt(amount), bal, phoneNumber.toString());
break;
}//if
//list.add(cell1.getStringCellValue());
}//for
System.out.println("Sorry no such user found");
fsIP.close();
try (FileOutputStream outputStream = new FileOutputStream(new File(fileName))) {
workbook.write(outputStream);
}
catch (FileNotFoundException e) {
e.printStackTrace();
}
}
}
