private JdbcSession getSession(){
JdbcSession session=null;
try {
manager = PersistenceManager.getInstance("WMS");
session= manager.getJdbcSession();
} catch (DbException e) {
e.printStackTrace();
}
return session;
}
@Override
public int addBatch(String sql, SQLParameter[] parametersArray){
int rows=0;
try {
JdbcSession session = this.getSession();
session.setBatchSize(parametersArray.length);
session.addBatch(sql, parametersArray);
rows=session.executeBatch();
} catch (DbException e) {
e.printStackTrace();
}finally{
if(manager!=null){
manager.release();
}
}
return rows;
}