void DataConnect::borrowInsertNew(Borrower b)
{
QSqlDatabase mydb = QSqlDatabase::addDatabase("QSQLITE");
mydb.setDatabaseName("data.db");
if (mydb.open()) {
std::cout<<"Database is open\n";
} else {
std::cout<<"Database is not open\n";
}
QString name = QString::fromStdString(b.getName());
QString type = QString::fromStdString(b.getType());
QString department = QString::fromStdString(b.getDepartment());
QString mobile = QString::fromStdString(b.getMobileNumber());
int itemBorr = b.getItemBorr();
int itemLate = b.getItemLate();
QString itemString = QString::fromStdString(b.getItemString());
int id = b.getId();
QSqlQuery comman;
QString exc = QString("INSERT INTO borrowers (name , type, department,")
+QString("mobileNumber, itemBorr, itemLate ,itemString, id) VALUES ")
+QString("('")+ name +QString("','")+type+QString("','")+department
+QString("','")+ mobile +QString("',")+ QString::number(itemBorr) +QString(",")
+QString::number(itemLate)+QString(",'") +itemString+ QString("',")+ QString::number(id) +QString(");");
std::cout << exc.toStdString()<< std::endl;
if(comman.exec(exc)) {
std::cout <<"insert success borr!\n";
} else {
std::cout << "insert failure borr!\n";
}
mydb.close();
}
