/* 查询所有管理员*/
string AdminService::selectAllAdmin(){
	DBConn db;
	string res = db.Query_all_mysql(SELECT_ALL_ADMIN_SQL, "Admin");
cout<<"AdminService::selectAllAdmin(), res="<<res<<endl;
    db.Close_mysql();
    return res;
}
Exemple #2
0
string UserService::SelectAll(){
	DBConn db;
	string res=db.Query_all_mysql(SELECT_ALL_USER_SQL,"Users");
cout<<"i'm return back from Db.query_all_sql,result="<<res<<endl;
	db.Close_mysql();
cout<<"i'm in the UserService SelectAll:res="<<endl;
	return res;

}
string MeetroomService::SelectAll(){
	DBConn db;
	string res=db.Query_all_mysql(SELECT_ALL_MR_SQL,"Meetroom");
	db.Close_mysql();
	return res;
}
string FacilityService::SelectAll() {
    DBConn db;
    string sql = "select * from facility";
    string res = db.Query_all_mysql(sql, "Facility");
    return res;
}