/** * return 108;//管理员更新成功 * return 109;//管理员更新失败 */ int AdminService::updateAdmin(Admin admin){ string sql = "update admin set a_name='"+ admin.getName() + "',a_psd='" + admin.getPsd() + "',a_priority='"+ admin.getPriority() +"' where u_id='"+admin.getId()+"'"; cout<<"AdminService::updateAdmin ---- update sql="<<sql<<endl; DBConn db; if(db.Execute_mysql(sql)==0){ db.Close_mysql(); return 108; }else{ db.Close_mysql(); return 109; } }
/** * return 103;//管理员添加成功 * return 104;//管理员添加失败 * return 105;//管理员添加失败:ID重复 */ int AdminService::addAdmin(Admin admin){ string sql="insert into admin(a_id,a_name,a_psd,a_priority)values('"+admin.getId()+"','" +admin.getName()+"','"+admin.getPsd()+"','"+admin.getPriority()+"')"; string sql1="update admin set a_loginState='0' where a_id='"+admin.getId()+"'"; cout<<"insert admin sql:"<<sql<<endl; int tmp = this->SelectAdminExist(admin.getId()); if(tmp==0){ DBConn db; if(db.Execute_mysql(sql)==0){ db.Execute_mysql(sql1); //添加成功一个admin,默认登录状况为未登录把loginState设置为“0” db.Close_mysql(); return 103; //添加成功 } db.Close_mysql(); return 104; //添加失败 }else{ return 105; //添加失败:ID重复 } }
int AdminService::AddAdmin(Admin admin){ string sql="insert into admin(a_id,a_name,a_psd,a_priority)values('"+admin.getId()+"','"+admin.getName()+"','"+admin.getPsd()+"','"+admin.getPriority()+"')"; }