/**
* 按条件删除数据
*
* @param conditions 删除条件
* @throws Exception
*/
public void deleteByConditions(String conditions) throws Exception {
DBManager dbManager = new DBManager();
BLLwBookUserAction blLwBookUserAction = new BLLwBookUserAction();
try {
dbManager.open("pssDataSource");
dbManager.beginTransaction();
// 按条件删除记录
blLwBookUserAction.deleteByConditions(dbManager, conditions);
dbManager.commitTransaction();
} catch (Exception exception) {
dbManager.rollbackTransaction();
throw exception;
} finally {
dbManager.close();
}
}
/**
* 按主键更新一条数据(主键本身无法变更)
*
* @param lwBookUserDto lwBookUserDto
* @throws Exception
*/
public void update(LwBookUserDto lwBookUserDto) throws Exception {
DBManager dbManager = new DBManager();
BLLwBookUserAction blLwBookUserAction = new BLLwBookUserAction();
try {
dbManager.open("pssDataSource");
dbManager.beginTransaction();
// 更新记录
blLwBookUserAction.update(dbManager, lwBookUserDto);
dbManager.commitTransaction();
} catch (Exception exception) {
dbManager.rollbackTransaction();
throw exception;
} finally {
dbManager.close();
}
}
/**
* 按主键删除一条数据
*
* @param bookNo 表本号
* @param userNo 用户代码
* @throws Exception
*/
public void delete(String bookNo, String userNo) throws Exception {
DBManager dbManager = new DBManager();
BLLwBookUserAction blLwBookUserAction = new BLLwBookUserAction();
try {
dbManager.open("pssDataSource");
dbManager.beginTransaction();
// 删除记录
blLwBookUserAction.delete(dbManager, bookNo, userNo);
dbManager.commitTransaction();
} catch (Exception exception) {
dbManager.rollbackTransaction();
throw exception;
} finally {
dbManager.close();
}
}
/**
* 按主键查找一条数据
*
* @param bookNo 表本号
* @param userNo 用户代码
* @return lwBookUserDto lwBookUserDto
* @throws Exception
*/
public LwBookUserDto findByPrimaryKey(String bookNo, String userNo) throws Exception {
DBManager dbManager = new DBManager();
BLLwBookUserAction blLwBookUserAction = new BLLwBookUserAction();
// 声明DTO
LwBookUserDto lwBookUserDto = null;
try {
dbManager.open("pssDataSource");
// 查询数据,赋值给DTO
lwBookUserDto = blLwBookUserAction.findByPrimaryKey(dbManager, bookNo, userNo);
} catch (Exception exception) {
throw exception;
} finally {
dbManager.close();
}
return lwBookUserDto;
}
/**
* 查询满足模糊查询条件的记录数
*
* @param conditions conditions
* @return 满足模糊查询条件的记录数
* @throws Exception
*/
public int getCount(String conditions) throws Exception {
int rowCount = 0;
if (conditions.trim().length() == 0) {
conditions = "1=1";
}
DBManager dbManager = new DBManager();
BLLwBookUserAction blLwBookUserAction = new BLLwBookUserAction();
try {
dbManager.open("pssDataSource");
rowCount = blLwBookUserAction.getCount(dbManager, conditions);
} catch (Exception exception) {
throw exception;
} finally {
dbManager.close();
}
return rowCount;
}
/**
* 按条件查询多条数据
*
* @param conditions 查询条件
* @return Collection 包含lwBookUserDto的集合
* @throws Exception
*/
public Collection findByConditions(String conditions) throws Exception {
Collection collection = new ArrayList();
if (conditions.trim().length() == 0) {
conditions = "1=1";
}
DBManager dbManager = new DBManager();
BLLwBookUserAction blLwBookUserAction = new BLLwBookUserAction();
try {
dbManager.open("pssDataSource");
collection = blLwBookUserAction.findByConditions(dbManager, conditions);
} catch (Exception exception) {
throw exception;
} finally {
dbManager.close();
}
return collection;
}
/**
* 按条件查询多条数据
*
* @param conditions 查询条件
* @param pageNo 页号
* @param rowsPerPage 每页的行数
* @return PageRecord 查询的一页的结果
* @throws Exception
*/
public PageRecord findByConditions(String conditions, int pageNo, int rowsPerPage)
throws Exception {
PageRecord pageRecord = new PageRecord(0, pageNo, 1, rowsPerPage, new ArrayList());
if (conditions.trim().length() == 0) {
conditions = "1=1";
}
DBManager dbManager = new DBManager();
BLLwBookUserAction blLwBookUserAction = new BLLwBookUserAction();
try {
dbManager.open("pssDataSource");
pageRecord = blLwBookUserAction.findByConditions(dbManager, conditions, pageNo, rowsPerPage);
} catch (Exception exception) {
throw exception;
} finally {
dbManager.close();
}
return pageRecord;
}
