public boolean insertarMovimiento(Movimiento m) {
boolean resultado = true;
Connection cnn = null;
CallableStatement cstmt = null;
try {
cnn = BD.getConnection();
cnn.setAutoCommit(false);
String sql = "call spI_Movimiento(?,?,?,?,?,?,?,?,?);";
cstmt = cnn.prepareCall(sql);
cstmt.setInt(1, m.getUsuario_id());
cstmt.setString(2, m.getVar_concepto());
cstmt.setDouble(3, m.getDec_monto());
cstmt.setInt(4, m.getInt_tipoOperacion());
cstmt.setTimestamp(5, m.getDat_fecregistro());
cstmt.setInt(6, m.getInt_tipoComprobante());
cstmt.setString(7, m.getVar_numeroComprobante());
cstmt.setDouble(8, m.getDec_cantidad());
cstmt.setInt(9, m.getInt_proveedor());
cstmt.execute();
cnn.commit();
} catch (SQLException a) {
try {
cnn.rollback();
} catch (SQLException b) {
System.out.println("" + b.toString());
} finally {
resultado = false;
}
System.out.println("error al registrar movimiento " + a.toString());
} finally {
try {
cstmt.close();
cnn.close();
} catch (SQLException ex) {
System.out.println("" + ex.getMessage());
}
}
return resultado;
}
