package com.sp2p.service.admin;
import java.sql.Connection;
import java.sql.SQLException;
import java.util.List;
import java.util.Map;
import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import com.shove.base.BaseService;
import com.shove.data.DataException;
import com.shove.data.dao.MySQL;
import com.sp2p.dao.admin.RightsDao;
public class RightsService extends BaseService {
private Log log = LogFactory.getLog(RightsService.class);
private RightsDao rightsDao;
/**
* 添加数据到bt_rights
* @param data
* @return Long
* @throws SQLException
*/
public Long importRights(String [][] data) throws SQLException{
Connection conn = MySQL.getConnection();
Long returnId = -1L;
try {
rightsDao.importRights(conn, data);
conn.commit();
} catch (SQLException e) {
log.error(e);
e.printStackTrace();
throw e;
}finally{
conn.close();
}
return returnId;
}
/**
* 查询权限集合
* @return
* @throws SQLException
* @throws DataException
*/
public List<Map<String,Object>> queryRightsList() throws SQLException, DataException{
Connection conn = connectionManager.getConnection();
List<Map<String,Object>> list = rightsDao.queryRightsList(conn);
conn.close();
return list;
}
/**
* 查询权限菜单
* @return
* @throws SQLException
* @throws DataException
*/
public List<Map<String,Object>> queryRightsMenuList() throws SQLException, DataException{
Connection conn = connectionManager.getConnection();
List<Map<String,Object>> list = rightsDao.queryRightsMenuList(conn);
conn.close();
return list;
}
public void setRightsDao(RightsDao rightsDao) {
this.rightsDao = rightsDao;
}
}